05/09/2024 08:48:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2582' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 08:48:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2582' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 05/09/2024 08:48:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93005' 05/09/2024 08:48:23 am >> DELETE FROM ps_document_detail WHERE id_document = '93005' 05/09/2024 08:48:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93005' , '16955' , 'STOLA MARIANA - 8005' , '1' , '-1' , '1' , '155.00' , '127.04918032787' , '22' , '0' , '155.00' ) 05/09/2024 08:48:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93005' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 05/09/2024 09:24:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2583' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 09:24:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2583' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 05/09/2024 09:24:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93006' 05/09/2024 09:24:50 am >> DELETE FROM ps_document_detail WHERE id_document = '93006' 05/09/2024 09:24:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93006' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 05/09/2024 09:43:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2419' AND id_document != '92813' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-05') 05/09/2024 09:43:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2419', document_date = '2024-08-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '92813' 05/09/2024 09:43:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92813' 05/09/2024 09:43:44 am >> DELETE FROM ps_document_detail WHERE id_document = '92813' 05/09/2024 09:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/09/2024 09:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/09/2024 09:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 05/09/2024 09:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.1' , '5.8196721311475' , '22' , '0' , '7.10' ) 05/09/2024 09:45:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2265' AND id_document != '92622' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-15') 05/09/2024 09:45:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2265', document_date = '2024-07-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '41.00', price_tax_excluded = '39.42', date_upd = NOW() WHERE id_document = '92622' 05/09/2024 09:45:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92622' 05/09/2024 09:45:02 am >> DELETE FROM ps_document_detail WHERE id_document = '92622' 05/09/2024 09:45:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92622' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 05/09/2024 09:45:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92622' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.75' , '1.6826923076923' , '4' , '0' , '3.50' ) 05/09/2024 09:45:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92622' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/09/2024 09:48:27 am >> DELETE FROM ps_document WHERE id_document = '92900' 05/09/2024 09:48:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92900' 05/09/2024 09:50:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2344' AND id_document != '92717' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 05/09/2024 09:50:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2344', document_date = '2024-07-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '260.00', price_tax_excluded = '213.11', date_upd = NOW() WHERE id_document = '92717' 05/09/2024 09:50:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92717' 05/09/2024 09:50:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92717' 05/09/2024 09:50:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92717' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 05/09/2024 09:50:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92717' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 05/09/2024 09:50:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92717' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '30' , '-30' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '45.00' ) 05/09/2024 09:50:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2273' AND id_document != '92631' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-16') 05/09/2024 09:50:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2273', document_date = '2024-07-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '66.25', price_tax_excluded = '54.30', date_upd = NOW() WHERE id_document = '92631' 05/09/2024 09:50:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92631' 05/09/2024 09:50:39 am >> DELETE FROM ps_document_detail WHERE id_document = '92631' 05/09/2024 09:50:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92631' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '65' , '-65' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '16.25' ) 05/09/2024 09:50:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92631' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/09/2024 09:51:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2184' AND id_document != '92530' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 05/09/2024 09:51:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2184', document_date = '2024-07-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '35.25', date_upd = NOW() WHERE id_document = '92530' 05/09/2024 09:51:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92530' 05/09/2024 09:51:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92530' 05/09/2024 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92530' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 05/09/2024 09:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92530' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2' , '1.6393442622951' , '22' , '0' , '40.00' ) 05/09/2024 09:52:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 09:52:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2584' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 05/09/2024 09:52:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93007' 05/09/2024 09:52:35 am >> DELETE FROM ps_document_detail WHERE id_document = '93007' 05/09/2024 09:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93007' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 05/09/2024 09:52:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93007' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 05/09/2024 09:54:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 09:54:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2585' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/09/2024 09:54:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93008' 05/09/2024 09:54:18 am >> DELETE FROM ps_document_detail WHERE id_document = '93008' 05/09/2024 09:54:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93008' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2024 09:55:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2134' AND id_document != '92470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-29') 05/09/2024 09:55:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2134', document_date = '2024-06-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA NAZIONALE DELLE CALABRIE, 3 84131 FUORNI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '152.45', price_tax_excluded = '133.79', date_upd = NOW() WHERE id_document = '92470' 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92470' 05/09/2024 09:55:54 am >> DELETE FROM ps_document_detail WHERE id_document = '92470' 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '1.40' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '1' , '-1' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '17.50' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '10475' , 'TEALIGHTS X 50 ' , '2' , '-2' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '7.80' ) 05/09/2024 09:55:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92470' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '38' , '-38' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '45.60' ) 05/09/2024 10:03:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2373' AND id_document != '92755' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 05/09/2024 10:03:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2373', document_date = '2024-07-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '305.00', price_tax_excluded = '270.17', date_upd = NOW() WHERE id_document = '92755' 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92755' 05/09/2024 10:03:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92755' 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '8.60' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '40.00' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '1090' , 'BIBBIA' , '10' , '-10' , '4' , '7' , '7' , '0' , '0' , '70.00' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '57.0000' , '46.72131147541' , '22' , '0' , '57.00' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 05/09/2024 10:03:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92755' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '36.8000' , '30.16393442623' , '22' , '0' , '36.80' ) 05/09/2024 10:04:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2463' AND id_document != '92868' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-26') 05/09/2024 10:04:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2463', document_date = '2024-08-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '71.25', price_tax_excluded = '71.25', date_upd = NOW() WHERE id_document = '92868' 05/09/2024 10:04:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92868' 05/09/2024 10:04:24 am >> DELETE FROM ps_document_detail WHERE id_document = '92868' 05/09/2024 10:04:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92868' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '1.25' , '1.25' , '0' , '0' , '1.25' ) 05/09/2024 10:04:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92868' , '1090' , 'BIBBIA' , '10' , '-10' , '4' , '7' , '7' , '0' , '0' , '70.00' ) 05/09/2024 10:07:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2488' AND id_document != '92897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-28') 05/09/2024 10:07:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2488', document_date = '2024-08-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA TORINO 84092 BELLIZZI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '250.70', price_tax_excluded = '213.71', date_upd = NOW() WHERE id_document = '92897' 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92897' 05/09/2024 10:07:04 am >> DELETE FROM ps_document_detail WHERE id_document = '92897' 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92897' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '21.50' ) 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92897' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92897' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92897' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92897' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '30.00' ) 05/09/2024 10:07:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92897' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '3' , '1.32' , '1.2692307692308' , '4' , '0' , '26.40' ) 05/09/2024 10:15:56 am >> DELETE FROM ps_document WHERE id_document = '92845' 05/09/2024 10:15:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92845' 05/09/2024 10:16:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1790' AND id_document != '92052' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-29') 05/09/2024 10:16:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1790', document_date = '2024-05-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '107.00', price_tax_excluded = '87.70', date_upd = NOW() WHERE id_document = '92052' 05/09/2024 10:16:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92052' 05/09/2024 10:16:30 am >> DELETE FROM ps_document_detail WHERE id_document = '92052' 05/09/2024 10:16:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92052' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '2' , '-2' , '1' , '53.5' , '43.852459016393' , '22' , '0' , '107.00' ) 05/09/2024 10:17:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1828' AND id_document != '92096' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-31') 05/09/2024 10:17:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1828', document_date = '2024-05-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '92096' 05/09/2024 10:17:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92096' 05/09/2024 10:17:38 am >> DELETE FROM ps_document_detail WHERE id_document = '92096' 05/09/2024 10:17:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92096' , '14921' , 'CASULA - POLIESTERE' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 05/09/2024 10:17:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92096' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 05/09/2024 10:18:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1887' AND id_document != '92175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/09/2024 10:18:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1887', document_date = '2024-06-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '92175' 05/09/2024 10:18:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92175' 05/09/2024 10:18:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92175' 05/09/2024 10:18:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92175' , '802' , 'ASTUCCIO VASETTI DORATI - 958' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 05/09/2024 10:18:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92175' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 05/09/2024 10:19:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1894' AND id_document != '92182' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-06') 05/09/2024 10:19:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1894', document_date = '2024-06-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '229.70', price_tax_excluded = '195.27', date_upd = NOW() WHERE id_document = '92182' 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92182' 05/09/2024 10:19:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92182' 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '23' , '18.852459016393' , '22' , '0' , '23.00' ) 05/09/2024 10:19:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '6927' , 'NAVETTA PER INCENSO - DIAM. 11 - 697' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 05/09/2024 10:19:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2042' AND id_document != '92352' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-20') 05/09/2024 10:19:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2042', document_date = '2024-06-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '155.00', price_tax_excluded = '127.05', date_upd = NOW() WHERE id_document = '92352' 05/09/2024 10:19:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92352' 05/09/2024 10:19:59 am >> DELETE FROM ps_document_detail WHERE id_document = '92352' 05/09/2024 10:19:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92352' , '21905' , 'CROCIFISSO CON CROCE - 59/55' , '1' , '-1' , '1' , '155' , '127.04918032787' , '22' , '0' , '155.00' ) 05/09/2024 10:20:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2349' AND id_document != '92722' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 05/09/2024 10:20:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2349', document_date = '2024-07-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '35.80', price_tax_excluded = '30.54', date_upd = NOW() WHERE id_document = '92722' 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92722' 05/09/2024 10:20:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92722' 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92722' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '10' , '-10' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '7.00' ) 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92722' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92722' , '1849' , 'CATEQUIZ MARIA 10 DOMANDE E RISPOSTE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92722' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92722' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 05/09/2024 10:20:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92722' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 05/09/2024 10:25:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1887' AND id_document != '92175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-05') 05/09/2024 10:25:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1887', document_date = '2024-06-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '92175' 05/09/2024 10:25:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92175' 05/09/2024 10:25:58 am >> DELETE FROM ps_document_detail WHERE id_document = '92175' 05/09/2024 10:25:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92175' , '19044' , 'VELO OMERALE - KWL018-05' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 05/09/2024 10:26:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2172' AND id_document != '92514' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-03') 05/09/2024 10:26:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2172', document_date = '2024-07-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '92514' 05/09/2024 10:26:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92514' 05/09/2024 10:26:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92514' 05/09/2024 10:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92514' , '13111' , 'FATIMA BABY - 023 FAT 9 BB' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/09/2024 10:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92514' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 05/09/2024 10:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92514' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '89' , '72.950819672131' , '22' , '0' , '89.00' ) 05/09/2024 10:26:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2097' AND id_document != '92421' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 05/09/2024 10:26:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2097', document_date = '2024-06-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '61.48', date_upd = NOW() WHERE id_document = '92421' 05/09/2024 10:26:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92421' 05/09/2024 10:26:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92421' 05/09/2024 10:26:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92421' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 05/09/2024 10:27:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2320' AND id_document != '92686' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-22') 05/09/2024 10:27:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2320', document_date = '2024-07-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '92686' 05/09/2024 10:27:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92686' 05/09/2024 10:27:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92686' 05/09/2024 10:27:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92686' , '802' , 'ASTUCCIO VASETTI DORATI - 958' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 05/09/2024 10:28:56 am >> DELETE FROM ps_document WHERE id_document = '92976' 05/09/2024 10:28:56 am >> DELETE FROM ps_document_detail WHERE id_document = '92976' 05/09/2024 10:35:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1908' AND id_document != '92199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-06') 05/09/2024 10:35:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1908', document_date = '2024-06-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '113.00', price_tax_excluded = '92.62', date_upd = NOW() WHERE id_document = '92199' 05/09/2024 10:35:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92199' 05/09/2024 10:35:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92199' 05/09/2024 10:35:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92199' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 05/09/2024 10:35:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92199' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '15.00' ) 05/09/2024 10:35:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92199' , '20437' , 'LUMINO BIANCO 10BTS000' , '240' , '-240' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '96.00' ) 05/09/2024 10:38:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2015' AND id_document != '92321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-18') 05/09/2024 10:38:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2015', document_date = '2024-06-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '113.50', price_tax_excluded = '93.03', date_upd = NOW() WHERE id_document = '92321' 05/09/2024 10:38:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92321' 05/09/2024 10:38:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92321' 05/09/2024 10:38:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92321' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '7' , '-7' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '1.40' ) 05/09/2024 10:38:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92321' , '20081' , 'BRACCIALE ARGENTO' , '1' , '-1' , '1' , '23.5000' , '19.262295081967' , '22' , '0' , '23.50' ) 05/09/2024 10:38:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92321' , '20437' , 'LUMINO BIANCO 10BTS000' , '144' , '-144' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '57.60' ) 05/09/2024 10:38:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92321' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/09/2024 10:38:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92321' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7' , '5.7377049180328' , '22' , '0' , '21.00' ) 05/09/2024 10:39:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1894' AND id_document != '92182' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-06') 05/09/2024 10:39:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1894', document_date = '2024-06-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '229.70', price_tax_excluded = '195.27', date_upd = NOW() WHERE id_document = '92182' 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92182' 05/09/2024 10:39:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92182' 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '6927' , 'NAVETTA PER INCENSO - DIAM. 11 - 697' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 05/09/2024 10:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92182' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7' , '5.7377049180328' , '22' , '0' , '21.00' ) 05/09/2024 10:40:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2243' AND id_document != '92598' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-11') 05/09/2024 10:40:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2243', document_date = '2024-07-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '92598' 05/09/2024 10:40:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92598' 05/09/2024 10:40:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92598' 05/09/2024 10:40:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92598' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 05/09/2024 10:40:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92598' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '54.00' ) 05/09/2024 10:47:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 10:47:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2586' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 05/09/2024 10:47:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93009' 05/09/2024 10:47:45 am >> DELETE FROM ps_document_detail WHERE id_document = '93009' 05/09/2024 10:47:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93009' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 05/09/2024 10:53:06 am >> SELECT document_num FROM ps_document WHERE document_num = '94/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 10:53:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '94/A' , '2024-09-05' , 'A' , '3553' , '0' , '4679105' , 'VIALE ITALIA 83100 AVELLINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 05/09/2024 10:53:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93010' 05/09/2024 10:53:06 am >> DELETE FROM ps_document_detail WHERE id_document = '93010' 05/09/2024 10:53:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 05/09/2024 10:53:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 05/09/2024 10:53:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 05/09/2024 10:53:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 05/09/2024 10:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '94/A' AND id_document != '93010' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 10:53:54 am >> UPDATE ps_document SET id_document_type = '24', document_num = '94/A', document_date = '2024-09-05', document_letter = 'A', id_customer = '3553', id_supplier = '', id_address = '4679105', address1 = 'VIALE ITALIA 83100 AVELLINO', address2 = '', note = 'CONTO VISIONE - FUCCI DON ANTONIO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '93010' 05/09/2024 10:53:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93010' 05/09/2024 10:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '93010' 05/09/2024 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/09/2024 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/09/2024 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/09/2024 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93010' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/09/2024 11:03:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 11:03:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2587' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.00' , '118.81' , NOW() , NOW() ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93011' 05/09/2024 11:03:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93011' 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '1114' , 'BIBBIA DEGLI SPOSI' , '3' , '-3' , '4' , '25.00' , '25' , '0' , '5' , '71.25' ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '21587' , 'PERDONATI - GUIDA' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '21441' , 'AMATI - AGENDA DEL CATECHISTA' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '21646' , 'PERDONATI - R. SCOLLA' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '21442' , 'AMATI - QUADERNO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '5104' , 'SANTA MADRE TERESA - 310' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/09/2024 11:03:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93011' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.63' , '16.090163934426' , '22' , '0' , '19.63' ) 05/09/2024 11:15:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 11:15:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2588' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 05/09/2024 11:15:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93012' 05/09/2024 11:15:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93012' 05/09/2024 11:15:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93012' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 05/09/2024 11:18:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2147' AND id_document != '92489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-01') 05/09/2024 11:18:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2147', document_date = '2024-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '82.00', price_tax_excluded = '72.18', date_upd = NOW() WHERE id_document = '92489' 05/09/2024 11:18:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92489' 05/09/2024 11:18:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92489' 05/09/2024 11:18:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92489' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '16.5000' , '13.524590163934' , '22' , '0' , '16.50' ) 05/09/2024 11:18:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92489' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 05/09/2024 11:18:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92489' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.8000' , '6.3934426229508' , '22' , '0' , '15.60' ) 05/09/2024 11:18:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92489' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '14.9000' , '12.213114754098' , '22' , '0' , '14.90' ) 05/09/2024 11:18:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92489' , '7311' , 'OSTIA SOTTILE 74MM' , '16' , '-16' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '32.00' ) 05/09/2024 11:45:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 11:45:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2589' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '87.88' , NOW() , NOW() ) 05/09/2024 11:45:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93013' 05/09/2024 11:45:37 am >> DELETE FROM ps_document_detail WHERE id_document = '93013' 05/09/2024 11:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '39.00' ) 05/09/2024 11:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/09/2024 11:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 05/09/2024 11:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '18391' , 'CATENINA ACCIAIO 10 ESSENZE' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 05/09/2024 11:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93013' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '21' , '21' , '0' , '0' , '21.00' ) 05/09/2024 11:56:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 11:56:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2590' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.25' , '90.25' , NOW() , NOW() ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93014' 05/09/2024 11:56:41 am >> DELETE FROM ps_document_detail WHERE id_document = '93014' 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '22507' , 'SPES NON CONFUNDIT' , '6' , '-6' , '4' , '2.00' , '2' , '0' , '5' , '11.40' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '22817' , 'POSSESSIONI DIABOLICHE ED ESORCISMO - F. BAMONTE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '22387' , 'GIUSEPPE - D. BUFFONE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '22762' , 'SAN CHARBEL IL MISTERO DEL CORPO INTATTO - P. CATTANEO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '19504' , 'ROSARIO ALLA MADONNA DI FATIMA - 8062' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '17717' , 'MARIA MADRE DELLA SPERANZA - A. SPINA - 8255' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 05/09/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93014' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 05/09/2024 03:04:14 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/09/2024 03:04:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22850' , '1' , '' , 'nuovo-prodotto' ) 05/09/2024 03:04:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22850' , '1' , '1' , '2' , NOW() , NOW() ) 05/09/2024 03:04:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22850' , '0' , '1' , '0' , '0' ) 05/09/2024 03:05:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832049695' AND id_product != '22850' AND ean13 != '' 05/09/2024 03:05:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832049695', date_upd = NOW() WHERE id_product = '22850' 05/09/2024 03:05:14 pm >> UPDATE ps_product_lang SET name = 'uppo 2025 - calendario', description = '' WHERE id_product = '22850' 05/09/2024 03:05:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22850' 05/09/2024 03:05:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '465', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22850' 05/09/2024 03:05:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '22850' 05/09/2024 03:05:17 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22850' 05/09/2024 03:05:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22851' , '1' , '' , 'nuovo-prodotto' ) 05/09/2024 03:05:17 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22851' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22850' 05/09/2024 03:05:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22851' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22850' 05/09/2024 03:05:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9999932049671' AND id_product != '22851' AND ean13 != '' 05/09/2024 03:05:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9999932049671', date_upd = NOW() WHERE id_product = '22851' 05/09/2024 03:05:51 pm >> UPDATE ps_product_lang SET name = 'uppo 2025 - agenda', description = '' WHERE id_product = '22851' 05/09/2024 03:05:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.967213114754099' WHERE id_product = '22851' 05/09/2024 03:05:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.967213114754099', id_tax_rules_group = '1', id_category_default = '465', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22851' 05/09/2024 03:05:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '22851' 05/09/2024 03:05:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22851' 05/09/2024 03:05:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22852' , '1' , '' , 'nuovo-prodotto' ) 05/09/2024 03:05:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22852' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22851' 05/09/2024 03:05:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22852' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22851' 05/09/2024 03:07:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830813823' AND id_product != '22852' AND ean13 != '' 05/09/2024 03:07:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788830813823', date_upd = NOW() WHERE id_product = '22852' 05/09/2024 03:07:02 pm >> UPDATE ps_product_lang SET name = 'esegesi anticotestamentaria - g. braulik', description = '' WHERE id_product = '22852' 05/09/2024 03:07:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.5' WHERE id_product = '22852' 05/09/2024 03:07:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.5', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22852' 05/09/2024 03:07:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22852' 05/09/2024 03:07:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22852' 05/09/2024 03:07:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22853' , '1' , '' , 'nuovo-prodotto' ) 05/09/2024 03:07:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22853' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22852' 05/09/2024 03:07:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22853' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22852' 05/09/2024 03:08:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832049695' AND id_product != '22850' AND ean13 != '' 05/09/2024 03:08:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832049695', date_upd = NOW() WHERE id_product = '22850' 05/09/2024 03:08:14 pm >> UPDATE ps_product_lang SET name = 'UPPO 2025 - CALENDARIO', description = '' WHERE id_product = '22850' 05/09/2024 03:08:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.0000' WHERE id_product = '22850' 05/09/2024 03:08:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.0000', id_tax_rules_group = '4', id_category_default = '465', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22850' 05/09/2024 03:08:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '22850' 05/09/2024 03:08:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9999932049671' AND id_product != '22851' AND ean13 != '' 05/09/2024 03:08:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9999932049671', date_upd = NOW() WHERE id_product = '22851' 05/09/2024 03:08:39 pm >> UPDATE ps_product_lang SET name = 'UPPO 2025 - AGENDA', description = '' WHERE id_product = '22851' 05/09/2024 03:08:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9672' WHERE id_product = '22851' 05/09/2024 03:08:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9672', id_tax_rules_group = '1', id_category_default = '465', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22851' 05/09/2024 03:08:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '22851' 05/09/2024 03:09:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830813823' AND id_product != '22852' AND ean13 != '' 05/09/2024 03:09:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788830813823', date_upd = NOW() WHERE id_product = '22852' 05/09/2024 03:09:06 pm >> UPDATE ps_product_lang SET name = 'ESEGESI ANTICOTESTAMENTARIA - G. BRAULIK', description = '' WHERE id_product = '22852' 05/09/2024 03:09:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.5000' WHERE id_product = '22852' 05/09/2024 03:09:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.5000', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22852' 05/09/2024 03:09:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '22852' 05/09/2024 03:10:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000004277' , '2024-09-04' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.16' , '53.85' , NOW() , NOW() ) 05/09/2024 03:10:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93015' 05/09/2024 03:10:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93015' 05/09/2024 03:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93015' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 05/09/2024 03:10:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22042' AND id_supplier = '107' 05/09/2024 03:10:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22042' , '107' , '1' ) 05/09/2024 03:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93015' , '22850' , 'UPPO 2025 - CALENDARIO' , '2' , '2' , '4' , '3.00' , '3' , '0' , '30' , '4.2000' ) 05/09/2024 03:10:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22850' AND id_supplier = '107' 05/09/2024 03:10:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22850' , '107' , '1' ) 05/09/2024 03:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93015' , '22851' , 'UPPO 2025 - AGENDA' , '1' , '1' , '1' , '8.50' , '6.9672131147541' , '22' , '30' , '7.2590' ) 05/09/2024 03:10:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22851' AND id_supplier = '107' 05/09/2024 03:10:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22851' , '107' , '1' ) 05/09/2024 03:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93015' , '22852' , 'ESEGESI ANTICOTESTAMENTARIA - G. BRAULIK' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '35' , '12.6750' ) 05/09/2024 03:10:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22852' AND id_supplier = '107' 05/09/2024 03:10:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22852' , '107' , '1' ) 05/09/2024 03:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93015' , '22806' , 'SENSO DI COLPA E COSCIENZA DI PECCATO - A. GRANDI' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '35' , '12.0250' ) 05/09/2024 03:10:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22806' AND id_supplier = '107' 05/09/2024 03:10:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22806' , '107' , '1' ) 05/09/2024 03:21:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 03:21:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2591' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.95' , '0.78' , NOW() , NOW() ) 05/09/2024 03:21:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93016' 05/09/2024 03:21:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93016' 05/09/2024 03:21:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93016' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.95' , '0.77868852459016' , '22' , '0' , '0.95' ) 05/09/2024 03:49:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 03:49:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2592' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.67' , '69.00' , NOW() , NOW() ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93017' 05/09/2024 03:49:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93017' 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '15580' , 'CHRISTUS VIVIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 05/09/2024 03:49:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 05/09/2024 03:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 05/09/2024 03:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93017' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 05/09/2024 03:55:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 03:55:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2593' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.30' , '5.16' , NOW() , NOW() ) 05/09/2024 03:55:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93018' 05/09/2024 03:55:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93018' 05/09/2024 03:55:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93018' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 05/09/2024 03:55:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93018' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 05/09/2024 04:18:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 04:18:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2594' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/09/2024 04:18:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93019' 05/09/2024 04:18:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93019' 05/09/2024 04:18:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93019' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2024 04:20:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 04:20:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2595' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.95' , '21.95' , NOW() , NOW() ) 05/09/2024 04:20:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93020' 05/09/2024 04:20:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '93020' 05/09/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93020' , '22852' , 'ESEGESI ANTICOTESTAMENTARIA - G. BRAULIK' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 05/09/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93020' , '22775' , 'INSIEME NELLA MESSA - OTT 24' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 05/09/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93020' , '22824' , 'INSIEME NELLA MESSA - NOV 24' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 05/09/2024 04:22:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 04:22:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2596' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.21' , NOW() , NOW() ) 05/09/2024 04:22:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93021' 05/09/2024 04:22:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93021' 05/09/2024 04:22:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93021' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/09/2024 04:22:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93021' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/09/2024 04:30:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 04:30:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2597' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 05/09/2024 04:30:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93022' 05/09/2024 04:30:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93022' 05/09/2024 04:30:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93022' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/09/2024 04:41:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 04:41:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2598' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 05/09/2024 04:41:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93023' 05/09/2024 04:41:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93023' 05/09/2024 04:41:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93023' , '21422' , 'STOLA ROMANA IN RASO BIANCO - 7336S' , '1' , '-1' , '1' , '400' , '327.86885245902' , '22' , '0' , '400.00' ) 05/09/2024 05:15:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 05:15:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2599' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '30.74' , NOW() , NOW() ) 05/09/2024 05:15:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93024' 05/09/2024 05:15:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93024' 05/09/2024 05:15:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93024' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '25' , '-25' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '37.50' ) 05/09/2024 05:43:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 05:43:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2600' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/09/2024 05:43:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93025' 05/09/2024 05:43:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93025' 05/09/2024 05:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93025' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2024 06:43:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 06:43:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2601' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 05/09/2024 06:43:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93026' 05/09/2024 06:43:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93026' 05/09/2024 06:43:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93026' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2024 06:43:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93026' , '22845' , 'SULLA TUA PAROLA - NOV. DIC. 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2024 07:47:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 05/09/2024 07:47:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2602' , '2024-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 05/09/2024 07:47:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93027' 05/09/2024 07:47:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93027' 05/09/2024 07:47:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93027' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2024 07:47:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93027' , '22845' , 'SULLA TUA PAROLA - NOV. DIC. 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )