23/06/2023 09:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 09:48:15 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' , '2163' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 23/06/2023 09:48:15 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 = '86474' 23/06/2023 09:48:15 am >> DELETE FROM ps_document_detail WHERE id_document = '86474' 23/06/2023 09:48:15 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 ( '86474' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/06/2023 10:05:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 10:05: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' , '2164' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 23/06/2023 10:05: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 = '86475' 23/06/2023 10:05:37 am >> DELETE FROM ps_document_detail WHERE id_document = '86475' 23/06/2023 10:05: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 ( '86475' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '29.90' ) 23/06/2023 10:05: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 ( '86475' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70.3' , '57.622950819672' , '22' , '0' , '70.30' ) 23/06/2023 10:05: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 ( '86475' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 23/06/2023 10:05: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 ( '86475' , '20982' , 'POLO MM VISCOSA 100%' , '2' , '-2' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '79.80' ) 23/06/2023 10:22:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2164' AND id_document != '86475' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 10:22:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2164', document_date = '2023-06-23', 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 = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '86475' 23/06/2023 10:22:08 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 = '86475' 23/06/2023 10:22:08 am >> DELETE FROM ps_document_detail WHERE id_document = '86475' 23/06/2023 10:22:08 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 ( '86475' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.9000' , '24.508196721311' , '22' , '0' , '29.90' ) 23/06/2023 10:22:08 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 ( '86475' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90.3' , '74.016393442623' , '22' , '0' , '90.30' ) 23/06/2023 10:22:08 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 ( '86475' , '20982' , 'POLO MM VISCOSA 100%' , '2' , '-2' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '79.80' ) 23/06/2023 10:54:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2165' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 10:54: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' , '2165' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 23/06/2023 10:54: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 = '86476' 23/06/2023 10:54:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86476' 23/06/2023 10:54: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 ( '86476' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 23/06/2023 10:54: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 ( '86476' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 23/06/2023 10:56:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1276' AND id_document != '82844' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-17') 23/06/2023 10:56:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1276', document_date = '2023-04-17', 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 = '2.50', price_tax_excluded = '2.50', date_upd = NOW() WHERE id_document = '82844' 23/06/2023 10:56:22 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 = '82844' 23/06/2023 10:56:22 am >> DELETE FROM ps_document_detail WHERE id_document = '82844' 23/06/2023 10:56:22 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 ( '82844' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 23/06/2023 10:56:22 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 ( '82844' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 23/06/2023 10:58:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2165' AND id_document != '86476' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 10:58:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2165', document_date = '2023-06-23', 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 = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '86476' 23/06/2023 10:58:22 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 = '86476' 23/06/2023 10:58:22 am >> DELETE FROM ps_document_detail WHERE id_document = '86476' 23/06/2023 10:58:22 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 ( '86476' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 23/06/2023 10:58:22 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 ( '86476' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 23/06/2023 11:11:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2166' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 11:11: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' , '2166' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.60' , '11.15' , NOW() , NOW() ) 23/06/2023 11:11: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 = '86477' 23/06/2023 11:11:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86477' 23/06/2023 11:11: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 ( '86477' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 23/06/2023 11:11: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 ( '86477' , '16312' , 'DECINA LEGNO CHIARO' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' ) 23/06/2023 11:44:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2167' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 11:44:05 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' , '2167' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '20.57' , NOW() , NOW() ) 23/06/2023 11:44:05 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 = '86478' 23/06/2023 11:44:05 am >> DELETE FROM ps_document_detail WHERE id_document = '86478' 23/06/2023 11:44:05 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 ( '86478' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 23/06/2023 11:44:05 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 ( '86478' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 23/06/2023 11:44:05 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 ( '86478' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/06/2023 11:44:05 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 ( '86478' , '538' , 'AMPOLLA RICAMBIO PER ART. 501/5 - 70' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 23/06/2023 11:44:05 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 ( '86478' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '3.70' ) 23/06/2023 12:01:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2168' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 12:01:43 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' , '2168' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 23/06/2023 12:01:43 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 = '86479' 23/06/2023 12:01:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '86479' 23/06/2023 12:01:43 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 ( '86479' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 23/06/2023 12:03:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 12:03: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' , '2169' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.95' , '38.95' , NOW() , NOW() ) 23/06/2023 12:03: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 = '86480' 23/06/2023 12:03:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '86480' 23/06/2023 12:03: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 ( '86480' , '21118' , 'MARIA MADRE DELLEUCARISTIA - D. RUOTOLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 23/06/2023 12:03: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 ( '86480' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 23/06/2023 12:30:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 12:30:25 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' , '2170' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 23/06/2023 12:30:25 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 = '86481' 23/06/2023 12:30:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '86481' 23/06/2023 12:30:25 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 ( '86481' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 23/06/2023 12:34:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 12:34:14 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' , '2171' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 23/06/2023 12:34:14 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 = '86482' 23/06/2023 12:34:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '86482' 23/06/2023 12:34:14 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 ( '86482' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 23/06/2023 12:45:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '844' AND id_document != '82300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 23/06/2023 12:45:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '844', document_date = '2023-03-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '€ 360 CON BONIFICO', 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 = '950.00', price_tax_excluded = '778.69', date_upd = NOW() WHERE id_document = '82300' 23/06/2023 12:45:08 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 = '82300' 23/06/2023 12:45:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '82300' 23/06/2023 12:45:08 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 ( '82300' , '19656' , 'VIA CRUCIS 15 STAZIONI - 37X28' , '1' , '-1' , '1' , '950' , '778.68852459016' , '22' , '0' , '950.00' ) 23/06/2023 12:45:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '835' AND id_document != '82290' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 23/06/2023 12:45:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '835', document_date = '2023-03-14', 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 = '352.00', price_tax_excluded = '301.54', date_upd = NOW() WHERE id_document = '82290' 23/06/2023 12:45:27 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 = '82290' 23/06/2023 12:45:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82290' 23/06/2023 12:45:27 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 ( '82290' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 23/06/2023 12:45:27 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 ( '82290' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '12.8000' , '10.491803278689' , '22' , '0' , '12.80' ) 23/06/2023 12:45:27 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 ( '82290' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '2' , '-2' , '4' , '38.0000' , '38' , '0' , '5' , '72.20' ) 23/06/2023 12:45:27 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 ( '82290' , '19905' , 'MOZZETTA ' , '1' , '-1' , '1' , '260' , '213.11475409836' , '22' , '0' , '260.00' ) 23/06/2023 12:46:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2155' AND id_document != '86464' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 23/06/2023 12:46:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2155', document_date = '2023-06-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', 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 = '960.00', price_tax_excluded = '960.00', date_upd = NOW() WHERE id_document = '86464' 23/06/2023 12:46:40 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 = '86464' 23/06/2023 12:46:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '86464' 23/06/2023 12:46:40 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 ( '86464' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '960' , '960' , '0' , '0' , '960.00' ) 23/06/2023 12:49:53 pm >> DELETE FROM ps_document WHERE id_document = '82467' 23/06/2023 12:49:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '82467' 23/06/2023 12:51:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2155' AND id_document != '86464' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 23/06/2023 12:51:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2155', document_date = '2023-06-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', 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 = '960.00', price_tax_excluded = '960.00', date_upd = NOW() WHERE id_document = '86464' 23/06/2023 12:51:14 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 = '86464' 23/06/2023 12:51:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '86464' 23/06/2023 12:51:14 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 ( '86464' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '447' , '447' , '0' , '0' , '447.00' ) 23/06/2023 12:51:14 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 ( '86464' , '20719' , 'CORONA DELL’ADDOLORATA' , '300' , '-300' , '4' , '1.80' , '1.8' , '0' , '5' , '513.00' ) 23/06/2023 03:04:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2172' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 03:04:40 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' , '2172' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.40' , '9.27' , NOW() , NOW() ) 23/06/2023 03:04:40 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 = '86483' 23/06/2023 03:04:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '86483' 23/06/2023 03:04:40 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 ( '86483' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 23/06/2023 03:04:40 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 ( '86483' , '529' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 23/06/2023 03:04:40 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 ( '86483' , '5570' , 'LAUDATO SÌ ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 23/06/2023 03:04:40 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 ( '86483' , '15580' , 'CHRISTUS VIVIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 23/06/2023 03:06:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 03:06:54 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' , '2173' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.15' , NOW() , NOW() ) 23/06/2023 03:06:54 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 = '86484' 23/06/2023 03:06:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '86484' 23/06/2023 03:06:54 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 ( '86484' , '18274' , 'BRACCIALE A NODI - 2610' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 23/06/2023 04:04:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2174' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 04:04:08 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' , '2174' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '12.43' , NOW() , NOW() ) 23/06/2023 04:04:08 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 = '86485' 23/06/2023 04:04:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '86485' 23/06/2023 04:04:08 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 ( '86485' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 23/06/2023 04:04:08 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 ( '86485' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/06/2023 04:04:08 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 ( '86485' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 23/06/2023 04:05:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 04:05: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' , '2175' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 23/06/2023 04:05: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 = '86486' 23/06/2023 04:05:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '86486' 23/06/2023 04:05: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 ( '86486' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 23/06/2023 04:26:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000095' AND id_product != '6728' AND ean13 != '' 23/06/2023 04:26:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000095', date_upd = NOW() WHERE id_product = '6728' 23/06/2023 04:26:26 pm >> UPDATE ps_product_lang SET name = 'MIRACOLOSA - CM 20 - 326', description = '' WHERE id_product = '6728' 23/06/2023 04:26:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.868852459016395' WHERE id_product = '6728' 23/06/2023 04:26:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6728' 23/06/2023 04:26:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '6728' 23/06/2023 04:45:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 04:45:24 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' , '2176' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.30' , '16.13' , NOW() , NOW() ) 23/06/2023 04:45:24 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 = '86487' 23/06/2023 04:45:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '86487' 23/06/2023 04:45:24 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 ( '86487' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 23/06/2023 04:45:24 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 ( '86487' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '' , '12.00' ) 23/06/2023 04:46:55 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/06/2023 04:46:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21188' , '1' , '' , 'nuovo-prodotto' ) 23/06/2023 04:46:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21188' , '1' , '1' , '2' , NOW() , NOW() ) 23/06/2023 04:46:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21188' , '0' , '1' , '0' , '0' ) 23/06/2023 04:47:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002158' AND id_product != '21188' AND ean13 != '' 23/06/2023 04:47:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002158', date_upd = NOW() WHERE id_product = '21188' 23/06/2023 04:47:52 pm >> UPDATE ps_product_lang SET name = 'SANTA RITA CM 33 - 601', description = '' WHERE id_product = '21188' 23/06/2023 04:47:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '42.622950819672134' WHERE id_product = '21188' 23/06/2023 04:47:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21188' 23/06/2023 04:47:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21188' 23/06/2023 04:48:00 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 = '21188' 23/06/2023 04:48:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21189' , '1' , '' , 'nuovo-prodotto' ) 23/06/2023 04:48:00 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 '21189' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21188' 23/06/2023 04:48:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21189' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21188' 23/06/2023 04:48:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002159' AND id_product != '21189' AND ean13 != '' 23/06/2023 04:48:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002159', date_upd = NOW() WHERE id_product = '21189' 23/06/2023 04:48:39 pm >> UPDATE ps_product_lang SET name = 'SAN CHARBEL CM 40 - 807', description = '' WHERE id_product = '21189' 23/06/2023 04:48:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '89.34426229508198' WHERE id_product = '21189' 23/06/2023 04:48:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '89.34426229508198', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21189' 23/06/2023 04:48:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '21189' 23/06/2023 04:48:40 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 = '21189' 23/06/2023 04:48:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21190' , '1' , '' , 'nuovo-prodotto' ) 23/06/2023 04:48:40 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 '21190' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21189' 23/06/2023 04:48:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21190' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21189' 23/06/2023 04:49:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002160' AND id_product != '21190' AND ean13 != '' 23/06/2023 04:49:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002160', date_upd = NOW() WHERE id_product = '21190' 23/06/2023 04:49:26 pm >> UPDATE ps_product_lang SET name = 'SANTA RITA CM 50 - 901', description = '' WHERE id_product = '21190' 23/06/2023 04:49:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '114.75409836065575' WHERE id_product = '21190' 23/06/2023 04:49:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '114.75409836065575', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21190' 23/06/2023 04:49:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '21190' 23/06/2023 04:49:32 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/06/2023 04:49:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21191' , '1' , '' , 'nuovo-prodotto' ) 23/06/2023 04:49:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21191' , '1' , '1' , '2' , NOW() , NOW() ) 23/06/2023 04:49:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21191' , '0' , '1' , '0' , '0' ) 23/06/2023 04:50:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000110' AND id_product != '3179' AND ean13 != '' 23/06/2023 04:50:33 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '000110', date_upd = NOW() WHERE id_product = '3179' 23/06/2023 04:50:33 pm >> UPDATE ps_product_lang SET name = 'CROCIFISSO - CM 40 - 1003', description = '' WHERE id_product = '3179' 23/06/2023 04:50:33 pm >> UPDATE ps_product SET wholesale_price = '16.87', on_sale = '0', price = '40.16393442622951' WHERE id_product = '3179' 23/06/2023 04:50:33 pm >> UPDATE ps_product_shop SET wholesale_price = '16.87', price = '40.16393442622951', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3179' 23/06/2023 04:50:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '3179' 23/06/2023 05:06:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 05:06:45 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' , '2177' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.33' , NOW() , NOW() ) 23/06/2023 05:06:45 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 = '86488' 23/06/2023 05:06:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '86488' 23/06/2023 05:06:45 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 ( '86488' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '6.50' ) 23/06/2023 05:06:45 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 ( '86488' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 23/06/2023 05:11:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 05:11:57 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' , '2178' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 23/06/2023 05:11:57 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 = '86489' 23/06/2023 05:11:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '86489' 23/06/2023 05:11:57 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 ( '86489' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 23/06/2023 05:17:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 05:17:41 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' , '2179' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 23/06/2023 05:17:41 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 = '86490' 23/06/2023 05:17:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '86490' 23/06/2023 05:17:41 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 ( '86490' , '17734' , 'VANGELO E ATTI BAMBINI' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '5' , '28.50' ) 23/06/2023 05:23:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002159' AND id_product != '21189' AND ean13 != '' 23/06/2023 05:23:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002159', date_upd = NOW() WHERE id_product = '21189' 23/06/2023 05:23:35 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN CHARBEL CM 40 - 807', description = '' WHERE id_product = '21189' 23/06/2023 05:23:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '89.3443' WHERE id_product = '21189' 23/06/2023 05:23:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '89.3443', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21189' 23/06/2023 05:23:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '21189' 23/06/2023 05:23:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002158' AND id_product != '21188' AND ean13 != '' 23/06/2023 05:23:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002158', date_upd = NOW() WHERE id_product = '21188' 23/06/2023 05:23:48 pm >> UPDATE ps_product_lang SET name = 'STATUA SANTA RITA CM 33 - 601', description = '' WHERE id_product = '21188' 23/06/2023 05:23:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '42.6230' WHERE id_product = '21188' 23/06/2023 05:23:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '42.6230', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21188' 23/06/2023 05:23:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21188' 23/06/2023 05:24:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002160' AND id_product != '21190' AND ean13 != '' 23/06/2023 05:24:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002160', date_upd = NOW() WHERE id_product = '21190' 23/06/2023 05:24:01 pm >> UPDATE ps_product_lang SET name = 'STATUA SANTA RITA CM 50 - 901', description = '' WHERE id_product = '21190' 23/06/2023 05:24:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '114.7541' WHERE id_product = '21190' 23/06/2023 05:24:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '114.7541', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21190' 23/06/2023 05:24:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '21190' 23/06/2023 05:24:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000382' AND id_product != '15666' AND ean13 != '' 23/06/2023 05:24:14 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '000382', date_upd = NOW() WHERE id_product = '15666' 23/06/2023 05:24:14 pm >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA CM 60 - PA602', description = '' WHERE id_product = '15666' 23/06/2023 05:24:14 pm >> UPDATE ps_product SET wholesale_price = '79.94', on_sale = '0', price = '168.0328' WHERE id_product = '15666' 23/06/2023 05:24:14 pm >> UPDATE ps_product_shop SET wholesale_price = '79.94', price = '168.0328', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15666' 23/06/2023 05:24:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '15666' 23/06/2023 05:24:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001583' AND id_product != '17400' AND ean13 != '' 23/06/2023 05:24:23 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001583', date_upd = NOW() WHERE id_product = '17400' 23/06/2023 05:24:23 pm >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA CM 40 - 805', description = '' WHERE id_product = '17400' 23/06/2023 05:24:23 pm >> UPDATE ps_product SET wholesale_price = '30.78', on_sale = '0', price = '68.0328' WHERE id_product = '17400' 23/06/2023 05:24:23 pm >> UPDATE ps_product_shop SET wholesale_price = '30.78', price = '68.0328', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17400' 23/06/2023 05:24:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '17400' 23/06/2023 05:24:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001528' AND id_product != '17078' AND ean13 != '' 23/06/2023 05:24:33 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001528', date_upd = NOW() WHERE id_product = '17078' 23/06/2023 05:24:33 pm >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA CM 40 - 803', description = '' WHERE id_product = '17078' 23/06/2023 05:24:33 pm >> UPDATE ps_product SET wholesale_price = '30.78', on_sale = '0', price = '64.7541' WHERE id_product = '17078' 23/06/2023 05:24:33 pm >> UPDATE ps_product_shop SET wholesale_price = '30.78', price = '64.7541', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17078' 23/06/2023 05:24:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '17078' 23/06/2023 05:24:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000095' AND id_product != '6728' AND ean13 != '' 23/06/2023 05:24:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000095', date_upd = NOW() WHERE id_product = '6728' 23/06/2023 05:24:46 pm >> UPDATE ps_product_lang SET name = 'STATUA MIRACOLOSA - CM 20 - 326', description = '' WHERE id_product = '6728' 23/06/2023 05:24:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.8689' WHERE id_product = '6728' 23/06/2023 05:24:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.8689', id_tax_rules_group = '1', id_category_default = '165', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6728' 23/06/2023 05:24:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '6728' 23/06/2023 05:26: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 ( '31' , '231/2023' , '2023-06-22' , '2023' , '0' , '130' , '4670548' , 'VIA CARRAIA,4/6/8 55025 COREGLIA ANTELMINELLI' , '' , '' , '36' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '472.37' , '387.19' , NOW() , NOW() ) 23/06/2023 05:26: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 = '86491' 23/06/2023 05:26:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86491' 23/06/2023 05:26: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 ( '86491' , '21189' , 'STATUA SAN CHARBEL CM 40 - 807' , '1' , '1' , '1' , '45' , '36.885245901639' , '22' , '5' , '52.1550' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21189' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21189' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '21188' , 'STATUA SANTA RITA CM 33 - 601' , '1' , '1' , '1' , '21.48' , '17.606557377049' , '22' , '5' , '24.8953' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21188' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21188' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '21190' , 'STATUA SANTA RITA CM 50 - 901' , '1' , '1' , '1' , '57.60' , '47.213114754098' , '22' , '5' , '66.7584' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21190' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21190' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '3179' , 'CROCIFISSO - CM 40 - 1003' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '5' , '23.1800' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3179' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3179' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '20232' , 'STATUA ADDOLORATA CM 28 - 608' , '1' , '1' , '1' , '24' , '19.672131147541' , '22' , '5' , '27.8160' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20232' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20232' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '19657' , 'STATUA ADDOLORATA CM 20 - 355' , '1' , '1' , '1' , '17.64' , '14.459016393443' , '22' , '5' , '20.4448' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19657' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19657' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '1' , '1' , '84.15' , '68.975409836066' , '22' , '5' , '97.5299' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '130' 23/06/2023 05:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '130' , '1' ) 23/06/2023 05:26: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 ( '86491' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '1' , '1' , '1' , '32.40' , '26.55737704918' , '22' , '5' , '37.5516' ) 23/06/2023 05:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17400' AND id_supplier = '130' 23/06/2023 05:26:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17400' , '130' , '1' ) 23/06/2023 05:26:14 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 ( '86491' , '17078' , 'STATUA MIRACOLOSA CM 40 - 803' , '1' , '1' , '1' , '31.40' , '25.737704918033' , '22' , '5' , '36.3926' ) 23/06/2023 05:26:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17078' AND id_supplier = '130' 23/06/2023 05:26:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17078' , '130' , '1' ) 23/06/2023 05:26:14 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 ( '86491' , '6728' , 'STATUA MIRACOLOSA - CM 20 - 326' , '1' , '1' , '1' , '14' , '11.475409836066' , '22' , '5' , '16.2260' ) 23/06/2023 05:26:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6728' AND id_supplier = '130' 23/06/2023 05:26:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6728' , '130' , '1' ) 23/06/2023 05:26:14 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 ( '86491' , '20233' , 'STATUA BEATO CARLO ACUTIS CM 28 - 425' , '1' , '1' , '1' , '22' , '18.032786885246' , '22' , '5' , '25.4980' ) 23/06/2023 05:26:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20233' AND id_supplier = '130' 23/06/2023 05:26:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20233' , '130' , '1' ) 23/06/2023 07:00:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 23/06/2023 07:00:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', 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 = '93.80', price_tax_excluded = '93.80', date_upd = NOW() WHERE id_document = '81317' 23/06/2023 07:00:28 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 = '81317' 23/06/2023 07:00:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 23/06/2023 07:00:28 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 ( '81317' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 23/06/2023 07:00:28 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 ( '81317' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 23/06/2023 07:00:28 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 ( '81317' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 23/06/2023 07:00:28 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 ( '81317' , '21077' , 'ROSARIO UN VIAGGIO CHE CAMBIA LA VITA - SUOR E. MAILLARD' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 23/06/2023 07:00:28 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 ( '81317' , '21115' , 'PAROLA E PREGHIERA - AGO. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 23/06/2023 07:00:28 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 ( '81317' , '21113' , 'VIVI PER QUALCOSA DI GRANDE - C. AMIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 23/06/2023 07:00:28 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 ( '81317' , '21125' , 'CUORE EUCARISTICO DI GESU - S. LONGOBARDI' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 23/06/2023 07:00:28 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 ( '81317' , '16528' , 'ANTONIO SEGRETO - N. VEGRO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 23/06/2023 07:00:28 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 ( '81317' , '21159' , 'DON MILANI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 23/06/2023 07:01:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 23/06/2023 07:01:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', 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 = '3.90', price_tax_excluded = '3.90', date_upd = NOW() WHERE id_document = '81317' 23/06/2023 07:01:03 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 = '81317' 23/06/2023 07:01:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 23/06/2023 07:01:03 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 ( '81317' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 23/06/2023 07:04:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1969' AND id_document != '85728' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 23/06/2023 07:04:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1969', document_date = '2023-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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '85728' 23/06/2023 07:04:01 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 = '85728' 23/06/2023 07:04:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '85728' 23/06/2023 07:04:01 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 ( '85728' , '21159' , 'DON MILANI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 23/06/2023 07:04:01 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 ( '85728' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/06/2023 07:04:01 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 ( '85728' , '21077' , 'ROSARIO UN VIAGGIO CHE CAMBIA LA VITA - SUOR E. MAILLARD' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/06/2023 07:04:01 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 ( '85728' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.19' , '5.19' , '0' , '0' , '5.19' ) 23/06/2023 07:17:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 07:17:58 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' , '2180' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 23/06/2023 07:17:58 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 = '86492' 23/06/2023 07:17:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '86492' 23/06/2023 07:17:58 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 ( '86492' , '20982' , 'POLO MM VISCOSA 100%' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 23/06/2023 07:19:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 07:19:19 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' , '2181' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.52' , '5.52' , NOW() , NOW() ) 23/06/2023 07:19:19 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 = '86493' 23/06/2023 07:19:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '86493' 23/06/2023 07:19:19 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 ( '86493' , '21115' , 'PAROLA E PREGHIERA - AGO. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/06/2023 07:19:19 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 ( '86493' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/06/2023 07:25:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 07:25:30 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' , '2182' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 23/06/2023 07:25:30 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 = '86494' 23/06/2023 07:25:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '86494' 23/06/2023 07:25:30 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 ( '86494' , '18557' , 'MADRE TERESA BABY - 023 MT/ 9 BB' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/06/2023 07:25:30 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 ( '86494' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '30' , '-30' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '7.50' ) 23/06/2023 07:31:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2127' AND id_document != '86435' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 23/06/2023 07:31:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2127', document_date = '2023-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 = '27.80', price_tax_excluded = '26.00', date_upd = NOW() WHERE id_document = '86435' 23/06/2023 07:31:02 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 = '86435' 23/06/2023 07:31:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '86435' 23/06/2023 07:31:02 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 ( '86435' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 23/06/2023 07:31:02 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 ( '86435' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '' , '4.00' ) 23/06/2023 07:31:02 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 ( '86435' , '12255' , 'IN CAMMINO CON GESU' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '' , '3.80' ) 23/06/2023 07:31:02 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 ( '86435' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 23/06/2023 07:31:02 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 ( '86435' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/06/2023 07:32:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1744' AND id_document != '84430' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-19') 23/06/2023 07:32:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1744', document_date = '2023-05-19', 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 = '102.47', price_tax_excluded = '102.47', date_upd = NOW() WHERE id_document = '84430' 23/06/2023 07:32:18 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 = '84430' 23/06/2023 07:32:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '84430' 23/06/2023 07:32:18 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 ( '84430' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.0000' , '45' , '0' , '5' , '42.75' ) 23/06/2023 07:32:18 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 ( '84430' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 23/06/2023 07:32:18 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 ( '84430' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 23/06/2023 07:32:18 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 ( '84430' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 23/06/2023 07:32:18 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 ( '84430' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 23/06/2023 07:32:18 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 ( '84430' , '19156' , 'CARMEN HERNANDEZ - A. CAYUELA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 23/06/2023 07:33:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2019' AND id_document != '85791' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-09') 23/06/2023 07:33:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2019', document_date = '2023-06-09', 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 = '15.40', price_tax_excluded = '15.40', date_upd = NOW() WHERE id_document = '85791' 23/06/2023 07:33: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 = '85791' 23/06/2023 07:33:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '85791' 23/06/2023 07:33: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 ( '85791' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.1' , '2.1' , '0' , '0' , '2.10' ) 23/06/2023 07:33: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 ( '85791' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '5' , '13.30' ) 23/06/2023 07:33:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2075' AND id_document != '86378' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-15') 23/06/2023 07:33:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2075', document_date = '2023-06-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 = '5.60', price_tax_excluded = '5.13', date_upd = NOW() WHERE id_document = '86378' 23/06/2023 07:33:42 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 = '86378' 23/06/2023 07:33:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '86378' 23/06/2023 07:33:43 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 ( '86378' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/06/2023 07:33:43 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 ( '86378' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '1.10' ) 23/06/2023 07:33:43 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 ( '86378' , '21115' , 'PAROLA E PREGHIERA - AGO. 23' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 23/06/2023 07:34:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1985' AND id_document != '85749' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-07') 23/06/2023 07:34:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1985', document_date = '2023-06-07', 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 = '12.00', price_tax_excluded = '12.00', date_upd = NOW() WHERE id_document = '85749' 23/06/2023 07:34: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 = '85749' 23/06/2023 07:34:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '85749' 23/06/2023 07:34: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 ( '85749' , '21113' , 'VIVI PER QUALCOSA DI GRANDE - C. AMIRANTE' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 23/06/2023 07:34:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1967' AND id_document != '85726' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 23/06/2023 07:34:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1967', document_date = '2023-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 = '14.30', price_tax_excluded = '13.61', date_upd = NOW() WHERE id_document = '85726' 23/06/2023 07:34:41 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 = '85726' 23/06/2023 07:34:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '85726' 23/06/2023 07:34:41 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 ( '85726' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 23/06/2023 07:34:41 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 ( '85726' , '21125' , 'CUORE EUCARISTICO DI GESU - S. LONGOBARDI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 23/06/2023 07:34:41 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 ( '85726' , '21008' , 'GIONA E LA BALENA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2023 07:34:41 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 ( '85726' , '21009' , 'DANIELE E I LEONI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2023 07:34:41 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 ( '85726' , '21016' , 'DAVIDE E GOLIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2023 07:34:41 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 ( '85726' , '21004' , 'CREAZIONE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2023 07:34:41 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 ( '85726' , '21005' , 'ARCA DI NOE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 23/06/2023 07:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1462' AND id_document != '84096' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-03') 23/06/2023 07:35:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1462', document_date = '2023-05-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 = '26.80', price_tax_excluded = '26.80', date_upd = NOW() WHERE id_document = '84096' 23/06/2023 07:35:20 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 = '84096' 23/06/2023 07:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '84096' 23/06/2023 07:35:20 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 ( '84096' , '16528' , 'ANTONIO SEGRETO - N. VEGRO' , '50' , '-50' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 23/06/2023 07:35:20 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 ( '84096' , '6629' , 'MIA PREGHIERA' , '2' , '-2' , '4' , '0.9000' , '0.9' , '0' , '0' , '1.80' ) 23/06/2023 07:54:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-23') 23/06/2023 07:54:25 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' , '2183' , '2023-06-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 23/06/2023 07:54:25 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 = '86495' 23/06/2023 07:54:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '86495' 23/06/2023 07:54:25 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 ( '86495' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )