05/05/2022 09:13:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 09:13:53 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' , '1406' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 05/05/2022 09:13:53 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 = '56605' 05/05/2022 09:13:53 am >> DELETE FROM ps_document_detail WHERE id_document = '56605' 05/05/2022 09:13:53 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 ( '56605' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 05/05/2022 09:13:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9126' AND id_supplier = '' 05/05/2022 09:13:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9126' , '' , '1' ) 05/05/2022 09:38:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 09:38:07 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' , '1407' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.34' , '37.34' , NOW() , NOW() ) 05/05/2022 09:38:07 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 = '56606' 05/05/2022 09:38:07 am >> DELETE FROM ps_document_detail WHERE id_document = '56606' 05/05/2022 09:38:07 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 ( '56606' , '5444' , 'IO SONO CON VOI - CAT.' , '3' , '-3' , '4' , '5.50' , '5.5' , '0' , '5' , '15.69' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 05/05/2022 09:38:07 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 ( '56606' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 05/05/2022 09:38:07 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 ( '56606' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '10' , '2.25' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 05/05/2022 09:38:07 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 ( '56606' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '10' , '4.50' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 05/05/2022 09:38:07 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 ( '56606' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '10' , '2.25' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 05/05/2022 09:38:07 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 ( '56606' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 05/05/2022 09:38:07 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 ( '56606' , '19275' , 'AMEN - MAG. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 05/05/2022 09:38:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = '' 05/05/2022 09:38:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' ) 05/05/2022 09:42:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 09:42:54 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' , '1408' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.06' , '55.06' , NOW() , NOW() ) 05/05/2022 09:42:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56607' 05/05/2022 09:42:54 am >> DELETE FROM ps_document_detail WHERE id_document = '56607' 05/05/2022 09:42:55 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 ( '56607' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 05/05/2022 09:42:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/05/2022 09:42:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/05/2022 09:42:55 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 ( '56607' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '44.00' , '44' , '0' , '5' , '41.80' ) 05/05/2022 09:42:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '1147' AND id_supplier = '' 05/05/2022 09:42:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1147' , '' , '1' ) 05/05/2022 09:42:55 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 ( '56607' , '3631' , 'DON BOSCO - T. BOSCO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 05/05/2022 09:42:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '3631' AND id_supplier = '' 05/05/2022 09:42:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3631' , '' , '1' ) 05/05/2022 09:42:55 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 ( '56607' , '19336' , 'VANGELO ROSSO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 05/05/2022 09:42:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19336' AND id_supplier = '' 05/05/2022 09:42:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19336' , '' , '1' ) 05/05/2022 10:17:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 10:17: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' , '1409' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '69.93' , NOW() , NOW() ) 05/05/2022 10:17: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 = '56608' 05/05/2022 10:17:37 am >> DELETE FROM ps_document_detail WHERE id_document = '56608' 05/05/2022 10:17: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 ( '56608' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 05/05/2022 10:17:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '1749' AND id_supplier = '' 05/05/2022 10:17:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1749' , '' , '1' ) 05/05/2022 10:17: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 ( '56608' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 05/05/2022 10:17:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 05/05/2022 10:17:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 05/05/2022 10:17: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 ( '56608' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '3.3' , '3.3' , '0' , '0' , '33.00' ) 05/05/2022 10:17:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/05/2022 10:17:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/05/2022 10:17: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 ( '56608' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '1.70' , '1.6346153846154' , '4' , '0' , '11.90' ) 05/05/2022 10:17:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 05/05/2022 10:17:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 05/05/2022 10:24:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 10:24:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1410' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.50' , '43.03' , NOW() , NOW() ) 05/05/2022 10:24:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56609' 05/05/2022 10:24:41 am >> DELETE FROM ps_document_detail WHERE id_document = '56609' 05/05/2022 10:24:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56609' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '15' , '-15' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '15.00' ) 05/05/2022 10:24:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 05/05/2022 10:24:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 05/05/2022 10:24:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56609' , '7202' , 'ARTICOLI RELIGIOSI' , '15' , '-15' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '37.50' ) 05/05/2022 10:24:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/05/2022 10:24:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/05/2022 10:46:16 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 ( '32' , '34' , '2022-04-30' , '' , '0' , '160' , '4673832' , 'VIA TIRABOSCHI 13 24017 SERINA ' , '' , '' , '' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '681.36' , '558.49' , NOW() , NOW() ) 05/05/2022 10:46:16 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 = '56610' 05/05/2022 10:46:16 am >> DELETE FROM ps_document_detail WHERE id_document = '56610' 05/05/2022 10:46:16 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 ( '56610' , '19454' , 'CAMICIONE MISTO COTONE - ONE0M18' , '2' , '0' , '1' , '104.54' , '85.688524590164' , '22' , '0' , '255.0776' ) 05/05/2022 10:46:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19454' AND id_supplier = '160' 05/05/2022 10:46:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19454' , '160' , '1' ) 05/05/2022 10:46:16 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 ( '56610' , '19455' , 'CAMICE MISTO COTONE - CAM0m29' , '1' , '0' , '1' , '231.0500' , '189.3852' , '22' , '0' , '281.88' ) 05/05/2022 10:46:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19455' AND id_supplier = '160' 05/05/2022 10:46:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19455' , '160' , '1' ) 05/05/2022 10:46:16 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 ( '56610' , '19456' , 'STOLA - STO0M03' , '1' , '0' , '1' , '102.8600' , '84.311475409836' , '22' , '0' , '125.4892' ) 05/05/2022 10:46:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19456' AND id_supplier = '160' 05/05/2022 10:46:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19456' , '160' , '1' ) 05/05/2022 10:46:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56610' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '1' , '15.5' , '12.704918032787' , '22' , '0' , '18.9100' ) 05/05/2022 10:46:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '160' 05/05/2022 10:46:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '160' , '1' ) 05/05/2022 10:47:51 am >> UPDATE ps_document SET id_document_type = '33', document_num = '47', document_date = '2022-04-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4673832', address1 = 'VIA TIRABOSCHI 13 24017 SERINA ', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '662.45', price_tax_excluded = '542.99', date_upd = NOW() WHERE id_document = '54616' 05/05/2022 10:47:51 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 = '54616' 05/05/2022 10:47:51 am >> DELETE FROM ps_document_detail WHERE id_document = '54616' 05/05/2022 10:47:51 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 ( '54616' , '19454' , 'CAMICIONE MISTO COTONE - ONE0M18' , '2' , '2' , '1' , '104.54' , '85.688524590164' , '22' , '0' , '255.0776' ) 05/05/2022 10:47:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19454' AND id_supplier = '' 05/05/2022 10:47:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19454' , '' , '1' ) 05/05/2022 10:47:51 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 ( '54616' , '19455' , 'CAMICE MISTO COTONE - CAM0M29' , '1' , '1' , '1' , '231.05' , '189.38524590164' , '22' , '0' , '281.8810' ) 05/05/2022 10:47:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19455' AND id_supplier = '' 05/05/2022 10:47:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19455' , '' , '1' ) 05/05/2022 10:47:51 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 ( '54616' , '19456' , 'STOLA - STO0M03' , '1' , '1' , '1' , '102.86' , '84.311475409836' , '22' , '0' , '125.4892' ) 05/05/2022 10:47:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19456' AND id_supplier = '' 05/05/2022 10:47:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19456' , '' , '1' ) 05/05/2022 10:59:36 am >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '51992' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-03-01') 05/05/2022 10:59:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2022-03-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = 'RESA - N.C. RICEVUTA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '532.50', price_tax_excluded = '532.50', date_upd = NOW() WHERE id_document = '51992' 05/05/2022 10:59:36 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 = '51992' 05/05/2022 10:59:36 am >> DELETE FROM ps_document_detail WHERE id_document = '51992' 05/05/2022 10:59:36 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 ( '51992' , '5779' , 'LEZIONARIO QUOTIDIANO 3' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 05/05/2022 10:59:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5779' AND id_supplier = '' 05/05/2022 10:59:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5779' , '' , '1' ) 05/05/2022 10:59:36 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 ( '51992' , '5780' , 'LEZIONARIO QUOTIDIANO 4' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 05/05/2022 10:59:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5780' AND id_supplier = '' 05/05/2022 10:59:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5780' , '' , '1' ) 05/05/2022 10:59:36 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 ( '51992' , '5777' , 'LEZIONARIO QUOTIDIANO 1' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 05/05/2022 10:59:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5777' AND id_supplier = '' 05/05/2022 10:59:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5777' , '' , '1' ) 05/05/2022 10:59:36 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 ( '51992' , '5778' , 'LEZIONARIO QUOTIDIANO 2' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 05/05/2022 10:59:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5778' AND id_supplier = '' 05/05/2022 10:59:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5778' , '' , '1' ) 05/05/2022 10:59:36 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 ( '51992' , '18341' , 'NASCONDIGLIO DI CRISTO - L. PARENTE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/05/2022 10:59:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '18341' AND id_supplier = '' 05/05/2022 10:59:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18341' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '17477' , 'PARABOLE DEL REGNO - M. SULLIVAN' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17477' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17477' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '18088' , 'COLUI CHE DEVE VENIRE - J. FITZMYER' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18088' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18088' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '15212' , 'FORZA DELLA VOCAZIONE - PAPA FRANCESCO' , '2' , '-2' , '4' , '9.5000' , '9.5' , '0' , '0' , '19.00' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '15212' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15212' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '17615' , 'CANTO DI NATALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17615' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17615' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '16103' , 'SI FA SERA E IL GIORNO VOLGE .... - R. SARAH' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16103' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16103' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '4328' , 'GENDER - G.M.CARBONE' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '4328' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4328' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '16167' , 'ULTIMA BATTAGLIA - A.M. VALLI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 05/05/2022 10:59:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '16167' AND id_supplier = '' 05/05/2022 10:59:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16167' , '' , '1' ) 05/05/2022 10:59: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 ( '51992' , '17130' , 'CHIAMATI A LIBERTA - S. FAUSTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17130' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17130' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '17331' , 'VORREI AIUTARE GLI ALTRI A VEDERE CON OCCHI NUOVI - R. SARAH' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17331' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17331' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18592' , 'SU MISURA PER TE - 3/5 ANNI' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18592' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18592' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18462' , 'QUESTIONE DI SGUARDI - ADULTI' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18462' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18462' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18588' , 'NON VE NE ACCORGETE? GIOVANI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18588' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18588' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18793' , 'FISSI SU DI LUI' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18793' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18793' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18587' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18587' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18587' , '' , '1' ) 05/05/2022 10:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18590' , 'SU MISURA PER TE - 6/8 ANNI' , '2' , '-2' , '4' , '15.5000' , '15.5' , '0' , '0' , '31.00' ) 05/05/2022 10:59:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18590' AND id_supplier = '' 05/05/2022 10:59:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18590' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '16919' , 'ALTRO MONDO - ABBE PIERRE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16919' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16919' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '16192' , 'GIACOMO BIFFI LALTRO CARDINALE - A. TESTI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16192' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16192' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18356' , 'NOTIZIA ECCEZIONALE!' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18356' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18356' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '12432' , 'GRAZIE A TE IL CIELO - S. FRANCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12432' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12432' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '14427' , 'PADRE NOSTRO - M. MUNARI' , '2' , '-2' , '4' , '4.9000' , '4.9' , '0' , '0' , '9.80' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14427' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14427' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '14701' , 'AMORE SALVATO - A. DIRIART' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14701' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14701' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18506' , 'UN GIORNO UNA PAROLA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18506' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18506' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '18479' , 'AGENDA 2022 - LAUDATO SI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18479' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18479' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '17254' , 'PADRE NOSTRO PER I PICCOLI - M. BALDACCI' , '1' , '-1' , '4' , '13.9000' , '13.9' , '0' , '0' , '13.90' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '17254' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17254' , '' , '1' ) 05/05/2022 10:59:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51992' , '14839' , 'GIOCA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 05/05/2022 10:59:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '14839' AND id_supplier = '' 05/05/2022 10:59:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14839' , '' , '1' ) 05/05/2022 11:24: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 ( '31' , '164' , '2022-04-30' , '' , '0' , '53' , '2648' , 'VIA T. PRUDENZA, 12 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '2331.98' , '2242.29' , NOW() , NOW() ) 05/05/2022 11:24: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 = '56611' 05/05/2022 11:24:40 am >> DELETE FROM ps_document_detail WHERE id_document = '56611' 05/05/2022 11:24: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 ( '56611' , '13397' , 'MIO GESU\'' , '2500' , '2500' , '3' , '0.684' , '0.65769230769231' , '4' , '0' , '1778.4000' ) 05/05/2022 11:24:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '53' 05/05/2022 11:24:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '53' , '1' ) 05/05/2022 11:24: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 ( '56611' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '150' , '150' , '3' , '3.5486' , '3.4121153846154' , '4' , '0' , '553.5816' ) 05/05/2022 11:24:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19391' AND id_supplier = '53' 05/05/2022 11:24:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19391' , '53' , '1' ) 05/05/2022 11:47:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 11:47: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' , '1411' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.50' , '90.08' , NOW() , NOW() ) 05/05/2022 11:47: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 = '56612' 05/05/2022 11:47:15 am >> DELETE FROM ps_document_detail WHERE id_document = '56612' 05/05/2022 11:47: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 ( '56612' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '40' , '-40' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '72.00' ) 05/05/2022 11:47:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 05/05/2022 11:47:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 05/05/2022 11:47: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 ( '56612' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 05/05/2022 11:47:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/05/2022 11:47:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/05/2022 11:47: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 ( '56612' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 05/05/2022 11:47:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 11:47:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 12:03:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 12:03:39 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' , '1412' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 05/05/2022 12:03:39 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 = '56613' 05/05/2022 12:03:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '56613' 05/05/2022 12:03:39 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 ( '56613' , '11688' , 'CORONA ROSARIO MISERICORDIOSO - 740' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 05/05/2022 12:03:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11688' AND id_supplier = '' 05/05/2022 12:03:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11688' , '' , '1' ) 05/05/2022 12:03:39 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 ( '56613' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '10' , '-10' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '3.00' ) 05/05/2022 12:03:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 05/05/2022 12:03:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 05/05/2022 12:17:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 12:17:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1413' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '262.00' , '240.54' , NOW() , NOW() ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56614' 05/05/2022 12:17:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '56614' 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '12528' , 'LAMPADA A SFERA BLU' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12528' AND id_supplier = '' 05/05/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12528' , '' , '1' ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '100' , '-100' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '25.00' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 05/05/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '54.00' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.00' , '140' , '0' , '5' , '133.00' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '' 05/05/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '' , '1' ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 05/05/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15318' AND id_supplier = '' 05/05/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15318' , '' , '1' ) 05/05/2022 12:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '6257' , 'MARIA OSTENSORIO DEL CORPO DI CRISTO - M. GOBBIN' , '1' , '-1' , '4' , '1.30' , '1.3' , '0' , '0' , '1.30' ) 05/05/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6257' AND id_supplier = '' 05/05/2022 12:17:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6257' , '' , '1' ) 05/05/2022 12:17:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '13885' , 'NOVENA PER CHIEDERE I DONI DELLO SPIRITO SANTO - U. TERRINONI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 05/05/2022 12:17:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13885' AND id_supplier = '' 05/05/2022 12:17:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13885' , '' , '1' ) 05/05/2022 12:17:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '2552' , 'COMUNIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/05/2022 12:17:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2552' AND id_supplier = '' 05/05/2022 12:17:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2552' , '' , '1' ) 05/05/2022 12:17:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56614' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' ) 05/05/2022 12:17:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 05/05/2022 12:17:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 05/05/2022 12:17:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 12:17:39 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' , '1414' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 05/05/2022 12:17:39 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 = '56615' 05/05/2022 12:17:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '56615' 05/05/2022 12:17:39 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 ( '56615' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '60' , '-60' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '15.00' ) 05/05/2022 12:17:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 05/05/2022 12:17:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 05/05/2022 12:43:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400310061' AND id_product != '16450' AND ean13 != '' 05/05/2022 12:43:37 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400310061', date_upd = NOW() WHERE id_product = '16450' 05/05/2022 12:43:37 pm >> UPDATE ps_product_lang SET name = 'ANGELO SUONANTE IN RESINA CM 18,5 - 4127', description = '' WHERE id_product = '16450' 05/05/2022 12:43:37 pm >> UPDATE ps_product SET wholesale_price = '8.58', on_sale = '0', price = '22.54098360655738' WHERE id_product = '16450' 05/05/2022 12:43:37 pm >> UPDATE ps_product_shop SET wholesale_price = '8.58', price = '22.54098360655738', id_tax_rules_group = '1', id_category_default = '95', 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 = '16450' 05/05/2022 12:43:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '16450' 05/05/2022 12:46:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263145' AND id_product != '13549' AND ean13 != '' 05/05/2022 12:46:36 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263145', date_upd = NOW() WHERE id_product = '13549' 05/05/2022 12:46:36 pm >> UPDATE ps_product_lang SET name = 'COLLANINA ARGENTATA ALBERO DELLA VITA - 1984/J97', description = '' WHERE id_product = '13549' 05/05/2022 12:46:36 pm >> UPDATE ps_product SET wholesale_price = '1.19', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '13549' 05/05/2022 12:46:36 pm >> UPDATE ps_product_shop SET wholesale_price = '1.19', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '13549' 05/05/2022 12:46:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '13549' 05/05/2022 12:46:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263152' AND id_product != '13550' AND ean13 != '' 05/05/2022 12:46:43 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263152', date_upd = NOW() WHERE id_product = '13550' 05/05/2022 12:46:43 pm >> UPDATE ps_product_lang SET name = 'COLLANINA ARGENTATA ORME DELLA SABBIA - 1984/J98', description = '' WHERE id_product = '13550' 05/05/2022 12:46:43 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '13550' 05/05/2022 12:46:43 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '13550' 05/05/2022 12:46:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '13550' 05/05/2022 12:46:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263138' AND id_product != '13845' AND ean13 != '' 05/05/2022 12:46:51 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263138', date_upd = NOW() WHERE id_product = '13845' 05/05/2022 12:46:51 pm >> UPDATE ps_product_lang SET name = 'COLLANINA IN ACCIAIO ANGELO - 1984/A48', description = '' WHERE id_product = '13845' 05/05/2022 12:46:51 pm >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '13845' 05/05/2022 12:46:51 pm >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '13845' 05/05/2022 12:46:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '13845' 05/05/2022 12:47:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263121' AND id_product != '13844' AND ean13 != '' 05/05/2022 12:47:01 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263121', date_upd = NOW() WHERE id_product = '13844' 05/05/2022 12:47:01 pm >> UPDATE ps_product_lang SET name = 'COLLANINA IN ACCIAIO MADONNA - 1984/M14', description = '' WHERE id_product = '13844' 05/05/2022 12:47:01 pm >> UPDATE ps_product SET wholesale_price = '1.47', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '13844' 05/05/2022 12:47:01 pm >> UPDATE ps_product_shop SET wholesale_price = '1.47', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '13844' 05/05/2022 12:47:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '13844' 05/05/2022 12:48:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400180466' AND id_product != '15088' AND ean13 != '' 05/05/2022 12:48:40 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400180466', date_upd = NOW() WHERE id_product = '15088' 05/05/2022 12:48:40 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA - MIRACOLOSA - 2952', description = '' WHERE id_product = '15088' 05/05/2022 12:48:40 pm >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '15088' 05/05/2022 12:48:40 pm >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '15088' 05/05/2022 12:48:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '15088' 05/05/2022 12:48:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400182705' AND id_product != '17779' AND ean13 != '' 05/05/2022 12:48:48 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400182705', date_upd = NOW() WHERE id_product = '17779' 05/05/2022 12:48:48 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA - S. GIUSEPPE - 2952/S40', description = '' WHERE id_product = '17779' 05/05/2022 12:48:48 pm >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '17779' 05/05/2022 12:48:48 pm >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '17779' 05/05/2022 12:48:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '17779' 05/05/2022 12:48:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400174717' AND id_product != '16130' AND ean13 != '' 05/05/2022 12:48:55 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400174717', date_upd = NOW() WHERE id_product = '16130' 05/05/2022 12:48:55 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO PIETRA - SAN MICHELE- 2952/S0063', description = '' WHERE id_product = '16130' 05/05/2022 12:48:55 pm >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '16130' 05/05/2022 12:48:55 pm >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', 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 = '16130' 05/05/2022 12:48:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '16130' 05/05/2022 02:28:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400197174' AND id_product != '12040' AND ean13 != '' 05/05/2022 02:28:25 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400197174', date_upd = NOW() WHERE id_product = '12040' 05/05/2022 02:28:25 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058', description = '' WHERE id_product = '12040' 05/05/2022 02:28:25 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '11.065573770491804' WHERE id_product = '12040' 05/05/2022 02:28:25 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '95', 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 = '12040' 05/05/2022 02:28:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '12040' 05/05/2022 02:29:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/05/2022 02:29:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19530' , '1' , '' , 'nuovo-prodotto' ) 05/05/2022 02:29:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19530' , '1' , '1' , '2' , NOW() , NOW() ) 05/05/2022 02:29:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19530' , '0' , '1' , '0' , '0' ) 05/05/2022 02:30:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '3007/K184' AND id_product != '19530' AND ean13 != '' 05/05/2022 02:30:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '3007/K184', date_upd = NOW() WHERE id_product = '19530' 05/05/2022 02:30:39 pm >> UPDATE ps_product_lang SET name = 'PERGAMENA COMUNIONE 18X24', description = '' WHERE id_product = '19530' 05/05/2022 02:30:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '19530' 05/05/2022 02:30:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '95', 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 = '19530' 05/05/2022 02:30:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19530' 05/05/2022 02:31:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/05/2022 02:31:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19531' , '1' , '' , 'nuovo-prodotto' ) 05/05/2022 02:31:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19531' , '1' , '1' , '2' , NOW() , NOW() ) 05/05/2022 02:31:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19531' , '0' , '1' , '0' , '0' ) 05/05/2022 02:34:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001989' AND id_product != '19531' AND ean13 != '' 05/05/2022 02:34:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001989', date_upd = NOW() WHERE id_product = '19531' 05/05/2022 02:34:34 pm >> UPDATE ps_product_lang SET name = 'COLOMBA DA COLLO - 735', description = '' WHERE id_product = '19531' 05/05/2022 02:34:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.0655737704918034' WHERE id_product = '19531' 05/05/2022 02:34:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.0655737704918034', id_tax_rules_group = '1', id_category_default = '95', 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 = '19531' 05/05/2022 02:34:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '19531' 05/05/2022 02:35:23 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' , 'A1746' , '2022-05-05' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '199.69' , '163.68' , NOW() , NOW() ) 05/05/2022 02:35:23 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 = '56616' 05/05/2022 02:35:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '56616' 05/05/2022 02:35:23 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 ( '56616' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '24' , '24' , '1' , '1.47' , '1.2049180327869' , '22' , '0' , '43.0416' ) 05/05/2022 02:35:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13844' AND id_supplier = '28' 05/05/2022 02:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13844' , '28' , '1' ) 05/05/2022 02:35:23 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 ( '56616' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '12' , '12' , '1' , '1.33' , '1.0901639344262' , '22' , '0' , '19.4712' ) 05/05/2022 02:35:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '28' 05/05/2022 02:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '28' , '1' ) 05/05/2022 02:35:23 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 ( '56616' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '6' , '6' , '1' , '4.74' , '3.8852459016393' , '22' , '0' , '34.6968' ) 05/05/2022 02:35:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12040' AND id_supplier = '28' 05/05/2022 02:35:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12040' , '28' , '1' ) 05/05/2022 02:35:23 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 ( '56616' , '15088' , 'QUADRETTO EFFETTO PIETRA - MIRACOLOSA - 2952' , '5' , '5' , '1' , '1.46' , '1.1967213114754' , '22' , '0' , '8.9060' ) 05/05/2022 02:35:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15088' AND id_supplier = '28' 05/05/2022 02:35:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15088' , '28' , '1' ) 05/05/2022 02:35: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 ( '56616' , '16450' , 'ANGELO SUONANTE IN RESINA CM 18,5 - 4127' , '2' , '2' , '1' , '10.6' , '8.6885245901639' , '22' , '0' , '25.8640' ) 05/05/2022 02:35:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16450' AND id_supplier = '28' 05/05/2022 02:35:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16450' , '28' , '1' ) 05/05/2022 02:35: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 ( '56616' , '19530' , 'PERGAMENA COMUNIONE 18X24' , '100' , '100' , '1' , '0.29' , '0.23770491803279' , '22' , '0' , '35.3800' ) 05/05/2022 02:35:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19530' AND id_supplier = '28' 05/05/2022 02:35:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19530' , '28' , '1' ) 05/05/2022 02:35: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 ( '56616' , '19531' , 'COLOMBA DA COLLO - 735' , '50' , '50' , '1' , '0.53' , '0.4344262295082' , '22' , '0' , '32.3300' ) 05/05/2022 02:35:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19531' AND id_supplier = '28' 05/05/2022 02:35:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19531' , '28' , '1' ) 05/05/2022 02:59:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000891' AND id_product != '7673' AND ean13 != '' 05/05/2022 02:59:09 pm >> UPDATE ps_product SET id_supplier = '11', reference = '2016', ean13 = '000891', date_upd = NOW() WHERE id_product = '7673' 05/05/2022 02:59:09 pm >> UPDATE ps_product_lang SET name = 'PARTICOLE MM38', description = '' WHERE id_product = '7673' 05/05/2022 02:59:09 pm >> UPDATE ps_product SET wholesale_price = '1.70', on_sale = '0', price = '3.3653846153846154' WHERE id_product = '7673' 05/05/2022 02:59:09 pm >> UPDATE ps_product_shop SET wholesale_price = '1.70', price = '3.3653846153846154', id_tax_rules_group = '3', id_category_default = '221', 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 = '7673' 05/05/2022 02:59:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '7673' 05/05/2022 02:59:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PTC38' AND id_product != '16163' AND ean13 != '' 05/05/2022 02:59:29 pm >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = 'PTC38', date_upd = NOW() WHERE id_product = '16163' 05/05/2022 02:59:29 pm >> UPDATE ps_product_lang SET name = 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA', description = '' WHERE id_product = '16163' 05/05/2022 02:59:29 pm >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.3653846153846154' WHERE id_product = '16163' 05/05/2022 02:59:29 pm >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.3653846153846154', id_tax_rules_group = '3', id_category_default = '342', 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 = '16163' 05/05/2022 02:59:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '16163' 05/05/2022 02:59:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829100109' AND id_product != '7311' AND ean13 != '' 05/05/2022 02:59:47 pm >> UPDATE ps_product SET id_supplier = '22', reference = '2014', ean13 = '8057829100109', date_upd = NOW() WHERE id_product = '7311' 05/05/2022 02:59:47 pm >> UPDATE ps_product_lang SET name = 'OSTIA SOTTILE 74MM', description = '' WHERE id_product = '7311' 05/05/2022 02:59:47 pm >> UPDATE ps_product SET wholesale_price = '1.02', on_sale = '0', price = '1.8269230769230769' WHERE id_product = '7311' 05/05/2022 02:59:47 pm >> UPDATE ps_product_shop SET wholesale_price = '1.02', price = '1.8269230769230769', id_tax_rules_group = '3', id_category_default = '342', 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 = '7311' 05/05/2022 02:59:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '7311' 05/05/2022 03:05:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829100338' AND id_product != '16691' AND ean13 != '' 05/05/2022 03:05:57 pm >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = '8057829100338', date_upd = NOW() WHERE id_product = '16691' 05/05/2022 03:05:57 pm >> UPDATE ps_product_lang SET name = 'PARTICOLE PER CELIACI 25pz', description = '' WHERE id_product = '16691' 05/05/2022 03:05:57 pm >> UPDATE ps_product SET wholesale_price = '1.70', on_sale = '0', price = '3.846153846153846' WHERE id_product = '16691' 05/05/2022 03:05:57 pm >> UPDATE ps_product_shop SET wholesale_price = '1.70', price = '3.846153846153846', id_tax_rules_group = '3', id_category_default = '342', id_argoment_default = '10', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16691' 05/05/2022 03:05:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '16691' 05/05/2022 03:10:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8005788003016' AND id_product != '1914' AND ean13 != '' 05/05/2022 03:10:55 pm >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '8005788003016', date_upd = NOW() WHERE id_product = '1914' 05/05/2022 03:10:55 pm >> UPDATE ps_product_lang SET name = 'CERA DELLA LITURGIA', description = '' WHERE id_product = '1914' 05/05/2022 03:10:55 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '3.9344262295081966' WHERE id_product = '1914' 05/05/2022 03:10:55 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '3.9344262295081966', id_tax_rules_group = '1', id_category_default = '205', 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 = '1914' 05/05/2022 03:10:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '1914' 05/05/2022 03:16:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0160681/S' AND id_product != '5903' AND ean13 != '' 05/05/2022 03:16:04 pm >> UPDATE ps_product SET id_supplier = '36', reference = '2015', ean13 = '0160681/S', date_upd = NOW() WHERE id_product = '5903' 05/05/2022 03:16:04 pm >> UPDATE ps_product_lang SET name = 'LITURGICO ART. 60LT ROSSO SUPER', description = '' WHERE id_product = '5903' 05/05/2022 03:16:04 pm >> UPDATE ps_product SET wholesale_price = '1.48', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '5903' 05/05/2022 03:16:04 pm >> UPDATE ps_product_shop SET wholesale_price = '1.48', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '205', 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 = '5903' 05/05/2022 03:16:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '5903' 05/05/2022 03:16:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0160682/S' AND id_product != '13049' AND ean13 != '' 05/05/2022 03:16:14 pm >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '0160682/S', date_upd = NOW() WHERE id_product = '13049' 05/05/2022 03:16:14 pm >> UPDATE ps_product_lang SET name = 'LITURGICO ART. 60LT BIANCO SUPER', description = '' WHERE id_product = '13049' 05/05/2022 03:16:14 pm >> UPDATE ps_product SET wholesale_price = '1.48', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '13049' 05/05/2022 03:16:14 pm >> UPDATE ps_product_shop SET wholesale_price = '1.48', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '205', 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 = '13049' 05/05/2022 03:16:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '13049' 05/05/2022 03:17:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000542' AND id_product != '1951' AND ean13 != '' 05/05/2022 03:17:02 pm >> UPDATE ps_product SET id_supplier = '73', reference = '2014', ean13 = '000542', date_upd = NOW() WHERE id_product = '1951' 05/05/2022 03:17:02 pm >> UPDATE ps_product_lang SET name = 'CERONI S.S. T60 - CARTA ROSSO', description = '' WHERE id_product = '1951' 05/05/2022 03:17:02 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '1951' 05/05/2022 03:17:02 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '227', 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 = '1951' 05/05/2022 03:17:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '1951' 05/05/2022 03:17:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001916' AND id_product != '19151' AND ean13 != '' 05/05/2022 03:17:15 pm >> UPDATE ps_product SET id_supplier = '73', reference = '', ean13 = '001916', date_upd = NOW() WHERE id_product = '19151' 05/05/2022 03:17:15 pm >> UPDATE ps_product_lang SET name = 'CERONI S.S. T60 - CARTA BIANCO', description = '' WHERE id_product = '19151' 05/05/2022 03:17:15 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '19151' 05/05/2022 03:17:15 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '227', 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 = '19151' 05/05/2022 03:17:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '19151' 05/05/2022 03:18:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000539' AND id_product != '1626' AND ean13 != '' 05/05/2022 03:18:07 pm >> UPDATE ps_product SET id_supplier = '73', reference = '2014', ean13 = '000539', date_upd = NOW() WHERE id_product = '1626' 05/05/2022 03:18:07 pm >> UPDATE ps_product_lang SET name = 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ', description = '' WHERE id_product = '1626' 05/05/2022 03:18:07 pm >> UPDATE ps_product SET wholesale_price = '30.00', on_sale = '0', price = '49.18032786885246' WHERE id_product = '1626' 05/05/2022 03:18:07 pm >> UPDATE ps_product_shop SET wholesale_price = '30.00', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '227', 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 = '1626' 05/05/2022 03:18:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '1626' 05/05/2022 04:13:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 05/05/2022 04:13:32 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 125,00+300,00 8/4/22', 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 = '252.00', price_tax_excluded = '206.56', date_upd = NOW() WHERE id_document = '29452' 05/05/2022 04:13:32 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 = '29452' 05/05/2022 04:13:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 05/05/2022 04:13:32 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 ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 05/05/2022 04:13:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:13:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:13:33 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 ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 05/05/2022 04:13:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:13:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:16:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 04:16: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 ( '24' , '34/A' , '2022-05-05' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , 'ACCONTI 50,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2725.00' , '2233.61' , NOW() , NOW() ) 05/05/2022 04:16: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 = '56617' 05/05/2022 04:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 05/05/2022 04:16: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 ( '56617' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '875' , '717.2131147541' , '22' , '0' , '875.00' ) 05/05/2022 04:16: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850' , '1516.393442623' , '22' , '0' , '1850.00' ) 05/05/2022 04:20:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 05/05/2022 04:20:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '567.00', price_tax_excluded = '521.56', date_upd = NOW() WHERE id_document = '29452' 05/05/2022 04:20: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 = '29452' 05/05/2022 04:20:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 05/05/2022 04:20: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 ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 05/05/2022 04:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:20: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 ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 05/05/2022 04:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:20: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 ( '29452' , '' , 'FATIMA CM 27' , '2' , '-2' , '0' , '25' , '25' , '' , '0' , '50.00' ) 05/05/2022 04:20:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 05/05/2022 04:20:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 05/05/2022 04:20:07 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 ( '29452' , '' , 'FATIMA CM 35' , '2' , '-2' , '0' , '35' , '35' , '' , '0' , '70.00' ) 05/05/2022 04:20:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 05/05/2022 04:20:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 05/05/2022 04:20:07 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 ( '29452' , '' , 'FATIMA CM 55' , '1' , '-1' , '0' , '75' , '75' , '' , '0' , '75.00' ) 05/05/2022 04:20:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 05/05/2022 04:20:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 05/05/2022 04:20:07 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 ( '29452' , '' , 'FATIMA CM 70' , '1' , '-1' , '0' , '120' , '120' , '' , '0' , '120.00' ) 05/05/2022 04:20:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 05/05/2022 04:20:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 05/05/2022 04:21:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 05/05/2022 04:21:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '567.00', price_tax_excluded = '521.56', date_upd = NOW() WHERE id_document = '29452' 05/05/2022 04:21:11 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 = '29452' 05/05/2022 04:21:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 05/05/2022 04:21:11 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 ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 05/05/2022 04:21:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:21:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:21:11 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 ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 05/05/2022 04:21:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:21:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:21:11 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 ( '29452' , '0' , 'FATIMA CM 27' , '2' , '-2' , '0' , '25.0000' , '25' , '0' , '0' , '50.00' ) 05/05/2022 04:21:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 04:21:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 04:21:11 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 ( '29452' , '0' , 'FATIMA CM 35' , '2' , '-2' , '0' , '35.0000' , '35' , '0' , '0' , '70.00' ) 05/05/2022 04:21:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 04:21:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 04:21:11 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 ( '29452' , '0' , 'FATIMA CM 55' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 05/05/2022 04:21:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 04:21:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 04:21:11 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 ( '29452' , '0' , 'FATIMA CM 70' , '1' , '-1' , '0' , '120.0000' , '120' , '0' , '0' , '120.00' ) 05/05/2022 04:21:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 04:21:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 04:22:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1390' AND id_document != '56581' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 05/05/2022 04:22:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1390', document_date = '2022-05-04', 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 = '18.80', price_tax_excluded = '16.64', date_upd = NOW() WHERE id_document = '56581' 05/05/2022 04:22: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 = '56581' 05/05/2022 04:22:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '56581' 05/05/2022 04:22: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 ( '56581' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '160' , '-160' , '4' , '0.0300' , '0.03' , '0' , '0' , '4.80' ) 05/05/2022 04:22:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 05/05/2022 04:22:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 05/05/2022 04:22: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 ( '56581' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/05/2022 04:22:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 05/05/2022 04:22:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 05/05/2022 04:22: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 ( '56581' , '16898' , 'PREGHIERE E DEVOZIONI - FATIMA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/05/2022 04:22:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16898' AND id_supplier = '' 05/05/2022 04:22:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16898' , '' , '1' ) 05/05/2022 04:22:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1224' AND id_document != '55880' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 05/05/2022 04:22:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1224', document_date = '2022-04-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 = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '55880' 05/05/2022 04:22: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 = '55880' 05/05/2022 04:22:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '55880' 05/05/2022 04:22: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 ( '55880' , '19504' , 'ROSARIO ALLA MADONNA DI FATIMA - 8062' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 05/05/2022 04:22:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19504' AND id_supplier = '' 05/05/2022 04:22:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19504' , '' , '1' ) 05/05/2022 04:23:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1311' AND id_document != '56492' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 05/05/2022 04:23:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1311', document_date = '2022-04-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.89', price_tax_excluded = '174.02', date_upd = NOW() WHERE id_document = '56492' 05/05/2022 04:23:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56492' 05/05/2022 04:23:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '56492' 05/05/2022 04:23:48 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 ( '56492' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 05/05/2022 04:23:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = '' 05/05/2022 04:23:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '' , '1' ) 05/05/2022 04:23:48 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 ( '56492' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 05/05/2022 04:23:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 05/05/2022 04:23:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 05/05/2022 04:23:48 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 ( '56492' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '15' , '-15' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '42.00' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '2663' , 'CONFEZIONE CON LIBRETTO E CROCE - 2324/K04' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2663' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2663' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '4' , '-4' , '4' , '1.9000' , '1.9' , '0' , '5' , '7.24' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '4.80' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7928' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7928' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '24.00' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7919' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. C' , '15' , '-15' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '7.20' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7919' AND id_supplier = '' 05/05/2022 04:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7919' , '' , '1' ) 05/05/2022 04:23:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56492' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 05/05/2022 04:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/05/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/05/2022 04:23:50 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 ( '56492' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 05/05/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 05/05/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 05/05/2022 04:23:50 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 ( '56492' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 05/05/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 05/05/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 05/05/2022 04:23:50 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 ( '56492' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/05/2022 04:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 05/05/2022 04:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 05/05/2022 04:24:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1088' AND id_document != '54694' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-11') 05/05/2022 04:24:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1088', document_date = '2022-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '156.90', price_tax_excluded = '129.94', date_upd = NOW() WHERE id_document = '54694' 05/05/2022 04:24:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54694' 05/05/2022 04:24:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '54694' 05/05/2022 04:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54694' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '144.00' ) 05/05/2022 04:24:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 04:24:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 04:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54694' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3' , '2.8846153846154' , '4' , '0' , '6.00' ) 05/05/2022 04:24:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 05/05/2022 04:24:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 05/05/2022 04:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54694' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '3.40' ) 05/05/2022 04:24:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 05/05/2022 04:24:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 05/05/2022 04:24:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54694' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 05/05/2022 04:24:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '' 05/05/2022 04:24:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' ) 05/05/2022 04:26:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1383' AND id_document != '56574' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 05/05/2022 04:26:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1383', document_date = '2022-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 = '3', id_causal = '0', price_tax_included = '1000.00', price_tax_excluded = '819.67', date_upd = NOW() WHERE id_document = '56574' 05/05/2022 04:26: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 = '56574' 05/05/2022 04:26:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '56574' 05/05/2022 04:26: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 ( '56574' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 05/05/2022 04:26:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 05/05/2022 04:26:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 05/05/2022 04:26: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 ( '56574' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 05/05/2022 04:26:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 05/05/2022 04:26:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 05/05/2022 04:39:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 04:39:15 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' , '1415' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '120.91' , NOW() , NOW() ) 05/05/2022 04:39:15 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 = '56618' 05/05/2022 04:39:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '56618' 05/05/2022 04:39:15 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 ( '56618' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/05/2022 04:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17127' AND id_supplier = '' 05/05/2022 04:39:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17127' , '' , '1' ) 05/05/2022 04:39:15 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 ( '56618' , '14354' , 'CAMICE BENEDETTINO LINO' , '1' , '-1' , '1' , '133.6' , '109.50819672131' , '22' , '0' , '133.60' ) 05/05/2022 04:39:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '' 05/05/2022 04:39:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '' , '1' ) 05/05/2022 05:42:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 05:42:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1416' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '7.20' , NOW() , NOW() ) 05/05/2022 05:42:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56619' 05/05/2022 05:42:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '56619' 05/05/2022 05:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56619' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.03' , '0.03' , '0' , '0' , '7.20' ) 05/05/2022 05:42:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 05/05/2022 05:42:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 05/05/2022 06:01:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 05/05/2022 06:01:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '584.00', price_tax_excluded = '535.49', date_upd = NOW() WHERE id_document = '29452' 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '29452' 05/05/2022 06:01:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 27' , '2' , '-2' , '0' , '25.0000' , '25' , '0' , '0' , '50.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 35' , '2' , '-2' , '0' , '35.0000' , '35' , '0' , '0' , '70.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 55' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 70' , '1' , '-1' , '0' , '120.0000' , '120' , '0' , '0' , '120.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 05/05/2022 06:01:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 05/05/2022 06:01:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1752' AND id_supplier = '' 05/05/2022 06:01:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1752' , '' , '1' ) 05/05/2022 06:01:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1249' AND id_document != '56421' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-26') 05/05/2022 06:01:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1249', document_date = '2022-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE', 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.05', date_upd = NOW() WHERE id_document = '56421' 05/05/2022 06:01: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 = '56421' 05/05/2022 06:01:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '56421' 05/05/2022 06:01: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 ( '56421' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 05/05/2022 06:01:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 05/05/2022 06:01:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 05/05/2022 06:02:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1113' AND id_document != '54726' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-13') 05/05/2022 06:02:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1113', document_date = '2022-04-13', 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.05', date_upd = NOW() WHERE id_document = '54726' 05/05/2022 06:02: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 = '54726' 05/05/2022 06:02:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '54726' 05/05/2022 06:02: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 ( '54726' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 05/05/2022 06:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 05/05/2022 06:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 05/05/2022 06:10:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1083' 05/05/2022 06:10:01 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1083' , '10' , '130' , 'PARR. SAN MICHELE ARC.' , 'PICARDO ' , 'DON ROCCO' , 'VIA CREMONA, 1' , '' , '83020' , 'S. MICHELE DI SERINO' , '' , '0825/595284' , '3382760783' , '' , '92012180649' , NOW() , NOW() ) 05/05/2022 06:10:01 pm >> UPDATE ps_customer SET email = 'rpicardo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1083' 05/05/2022 06:10:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 06:10:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '77' , '2022-05-05' , '' , '1083' , '0' , '4674059' , 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '89.25' , '89.25' , NOW() , NOW() ) 05/05/2022 06:10:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56620' 05/05/2022 06:10:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '56620' 05/05/2022 06:10:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56620' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 05/05/2022 06:31:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1417' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 06:31:42 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' , '1417' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 05/05/2022 06:31: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 = '56621' 05/05/2022 06:31:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '56621' 05/05/2022 06:31:42 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 ( '56621' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 05/05/2022 06:31:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6417' AND id_supplier = '' 05/05/2022 06:31:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6417' , '' , '1' ) 05/05/2022 06:31:42 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 ( '56621' , '19023' , 'CATECHISMO DELLA CHIESA CATTOLICA COMMENTATO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 05/05/2022 06:31:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19023' AND id_supplier = '' 05/05/2022 06:31:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19023' , '' , '1' ) 05/05/2022 06:33:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 05/05/2022 06:33: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' , '1418' , '2022-05-05' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 05/05/2022 06:33: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 = '56622' 05/05/2022 06:33:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '56622' 05/05/2022 06: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 ( '56622' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '1' , '-1' , '1' , '46' , '37.704918032787' , '22' , '0' , '46.00' ) 05/05/2022 06:33:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 05/05/2022 06:33:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' )