13/06/2022 08:48:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 08:48:17 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' , '1895' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.90' , '30.25' , NOW() , NOW() ) 13/06/2022 08:48:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58736' 13/06/2022 08:48:17 am >> DELETE FROM ps_document_detail WHERE id_document = '58736' 13/06/2022 08:48: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 ( '58736' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '36.90' , '30.245901639344' , '22' , '0' , '36.90' ) 13/06/2022 08:48:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 13/06/2022 08:48:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 13/06/2022 09:15:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 09:15:19 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' , '1896' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.21' , NOW() , NOW() ) 13/06/2022 09:15:19 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 = '58737' 13/06/2022 09:15:19 am >> DELETE FROM ps_document_detail WHERE id_document = '58737' 13/06/2022 09:15:19 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 ( '58737' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 13/06/2022 09:15:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 13/06/2022 09:15:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 13/06/2022 09:15:19 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 ( '58737' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 13/06/2022 09:15:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 13/06/2022 09:15:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 13/06/2022 09:54:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 09:54:44 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' , '1897' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.20' , '52.98' , NOW() , NOW() ) 13/06/2022 09:54:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58738' 13/06/2022 09:54:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58738' 13/06/2022 09:54:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 13/06/2022 09:54:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 13/06/2022 09:54:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 13/06/2022 09:54:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '18907' , 'ANGELO MI DISSE - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 13/06/2022 09:54:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '18907' AND id_supplier = '' 13/06/2022 09:54:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18907' , '' , '1' ) 13/06/2022 09:54:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 13/06/2022 09:54:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 13/06/2022 09:54:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 13/06/2022 09:54:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15.99' , '15.99' , '0' , '0' , '15.99' ) 13/06/2022 09:54:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/06/2022 09:54:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/06/2022 09:58:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 09:58:20 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' , '1898' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.26' , '12.26' , NOW() , NOW() ) 13/06/2022 09:58:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58739' 13/06/2022 09:58:20 am >> DELETE FROM ps_document_detail WHERE id_document = '58739' 13/06/2022 09:58:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58739' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 13/06/2022 09:58:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '15227' AND id_supplier = '' 13/06/2022 09:58:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15227' , '' , '1' ) 13/06/2022 10:02:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1858' AND id_document != '58694' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-10') 13/06/2022 10:02:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1858', document_date = '2022-06-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '82.00', price_tax_excluded = '76.02', date_upd = NOW() WHERE id_document = '58694' 13/06/2022 10:02:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58694' 13/06/2022 10:02:05 am >> DELETE FROM ps_document_detail WHERE id_document = '58694' 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '15.20' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.9500' , '6.516393442623' , '22' , '0' , '15.90' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '19423' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19423' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19423' , '' , '1' ) 13/06/2022 10:02:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 13/06/2022 10:02:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '9996' AND id_supplier = '' 13/06/2022 10:02:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9996' , '' , '1' ) 13/06/2022 10:02:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1823' AND id_document != '58652' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-08') 13/06/2022 10:02:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1823', document_date = '2022-06-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.80', price_tax_excluded = '38.65', date_upd = NOW() WHERE id_document = '58652' 13/06/2022 10:02:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58652' 13/06/2022 10:02:35 am >> DELETE FROM ps_document_detail WHERE id_document = '58652' 13/06/2022 10:02:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58652' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 13/06/2022 10:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 13/06/2022 10:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 13/06/2022 10:02:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58652' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 13/06/2022 10:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/06/2022 10:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/06/2022 10:02:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58652' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 13/06/2022 10:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/06/2022 10:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/06/2022 10:03:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1858' AND id_document != '58694' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-10') 13/06/2022 10:03:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1858', document_date = '2022-06-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '82.00', price_tax_excluded = '76.02', date_upd = NOW() WHERE id_document = '58694' 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58694' 13/06/2022 10:03:06 am >> DELETE FROM ps_document_detail WHERE id_document = '58694' 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '7' , '-7' , '4' , '5.0000' , '5' , '0' , '5' , '33.25' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '15.20' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.9500' , '6.516393442623' , '22' , '0' , '15.90' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '19423' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19423' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19423' , '' , '1' ) 13/06/2022 10:03:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58694' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 13/06/2022 10:03:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 13/06/2022 10:03:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 13/06/2022 10:07:20 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '53970' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-03-30') 13/06/2022 10:07:20 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2022-03-30', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '226.00', price_tax_excluded = '186.33', date_upd = NOW() WHERE id_document = '53970' 13/06/2022 10:07:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53970' 13/06/2022 10:07:20 am >> DELETE FROM ps_document_detail WHERE id_document = '53970' 13/06/2022 10:07:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53970' , '16744' , 'MIA NOTTE NON CONOSCE TENEBRE - K. RAHNER' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 13/06/2022 10:07:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16744' AND id_supplier = '' 13/06/2022 10:07:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16744' , '' , '1' ) 13/06/2022 10:07:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53970' , '18131' , 'TAU MEDIO CM3 - T6' , '200' , '-200' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '200.00' ) 13/06/2022 10:07:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '' 13/06/2022 10:07:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '' , '1' ) 13/06/2022 10:07:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53970' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '20.00' ) 13/06/2022 10:07:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 13/06/2022 10:07:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 13/06/2022 10:13:02 am >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '58692' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-09') 13/06/2022 10:13:02 am >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2022-06-09', document_letter = 'A', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '58692' 13/06/2022 10:13:02 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 = '58692' 13/06/2022 10:13:02 am >> DELETE FROM ps_document_detail WHERE id_document = '58692' 13/06/2022 10:13:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58692' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 13/06/2022 10:13:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 13/06/2022 10:13:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 13/06/2022 10:13:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 10:13:31 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' , '1899' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 13/06/2022 10:13:31 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 = '58740' 13/06/2022 10:13:31 am >> DELETE FROM ps_document_detail WHERE id_document = '58740' 13/06/2022 10:13:31 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 ( '58740' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 13/06/2022 10:13:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 13/06/2022 10:13:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 13/06/2022 10:33:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1900' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 10:33:20 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' , '1900' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.19' , NOW() , NOW() ) 13/06/2022 10:33:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58741' 13/06/2022 10:33:20 am >> DELETE FROM ps_document_detail WHERE id_document = '58741' 13/06/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58741' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 13/06/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 13/06/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 13/06/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58741' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/06/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '6304' AND id_supplier = '' 13/06/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6304' , '' , '1' ) 13/06/2022 10:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58741' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.5' , '6.5' , '0' , '0' , '6.50' ) 13/06/2022 10:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/06/2022 10:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/06/2022 10:35:03 am >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '58692' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-09') 13/06/2022 10:35:03 am >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2022-06-09', document_letter = 'A', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', 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 = '56.00', price_tax_excluded = '45.90', date_upd = NOW() WHERE id_document = '58692' 13/06/2022 10:35:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58692' 13/06/2022 10:35:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58692' 13/06/2022 10:35:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58692' , '11726' , 'COPRI BENEDIZIONALE' , '1' , '-1' , '1' , '56' , '45.901639344262' , '22' , '0' , '56.00' ) 13/06/2022 10:35:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '11726' AND id_supplier = '' 13/06/2022 10:35:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11726' , '' , '1' ) 13/06/2022 10:57:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821594137' AND id_product != '370' AND ean13 != '' 13/06/2022 10:57:42 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/6', ean13 = '9788821594137', date_upd = NOW() WHERE id_product = '370' 13/06/2022 10:57:42 am >> UPDATE ps_product_lang SET name = 'ALBUM DELLA MIA PRIMA COMUNIONE', description = '' WHERE id_product = '370' 13/06/2022 10:57:42 am >> UPDATE ps_product SET wholesale_price = '6.44', on_sale = '0', price = '12.9' WHERE id_product = '370' 13/06/2022 10:57:42 am >> UPDATE ps_product_shop SET wholesale_price = '6.44', price = '12.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '370' 13/06/2022 10:57:42 am >> DELETE FROM ps_specific_price WHERE id_product = '370' 13/06/2022 12:10:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 12:10:11 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' , '1901' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 13/06/2022 12:10: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 = '58742' 13/06/2022 12:10:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58742' 13/06/2022 12:10: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 ( '58742' , '9539' , 'SANTANTONIO DA PADOVA - 41' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 13/06/2022 12:10:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9539' AND id_supplier = '' 13/06/2022 12:10:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9539' , '' , '1' ) 13/06/2022 12:10: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 ( '58742' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/06/2022 12:10:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/06/2022 12:10:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/06/2022 12:21:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 12:21: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' , '1902' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 13/06/2022 12:21: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 = '58743' 13/06/2022 12:21:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58743' 13/06/2022 12:21: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 ( '58743' , '19632' , 'CATECHETICA - L. MEDDI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 13/06/2022 12:21:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19632' AND id_supplier = '' 13/06/2022 12:21:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19632' , '' , '1' ) 13/06/2022 12:48:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1505' AND id_document != '57238' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-12') 13/06/2022 12:48:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1505', document_date = '2022-05-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.00', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '57238' 13/06/2022 12:48:33 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 = '57238' 13/06/2022 12:48:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '57238' 13/06/2022 12:48: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 ( '57238' , '18442' , 'NOVENA A SANTA VERONICA GIULIANI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 13/06/2022 12:48:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18442' AND id_supplier = '' 13/06/2022 12:48:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18442' , '' , '1' ) 13/06/2022 12:48: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 ( '57238' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 13/06/2022 12:48:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '' 13/06/2022 12:48:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '' , '1' ) 13/06/2022 02:48:31 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'oZvEQ56opB4o0eVW' , NOW() , NOW() ) 13/06/2022 02:48:31 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6971' , '1' ) 13/06/2022 02:48:31 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6971' , '2' ) 13/06/2022 02:48:31 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6971' , '3' ) 13/06/2022 02:49:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6971' 13/06/2022 02:49:53 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 ( '6971' , '10' , '185' , '' , 'CARBONI' , 'ANGELA' , 'VIALE LA MARMORA 20/A' , '' , '08030' , 'MEANA SARDO' , '' , '' , '3487762031' , '' , '' , NOW() , NOW() ) 13/06/2022 02:49:53 pm >> UPDATE ps_customer SET email = 'car.ange@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6971' 13/06/2022 02:51:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '30' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 02:51:02 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' , '30' , '2022-06-13' , '' , '6971' , '0' , '74680477' , 'VIALE LA MARMORA 20/A 08030 MEANA SARDO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '69.26' , '69.26' , NOW() , NOW() ) 13/06/2022 02:51:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5369' 13/06/2022 02:51:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '5369' 13/06/2022 02:51:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5369' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '25' , '-25' , '4' , '2.38' , '2.38' , '0' , '0' , '59.50' ) 13/06/2022 02:51:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5369' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '2' , '-2' , '4' , '1.43' , '1.43' , '0' , '0' , '2.86' ) 13/06/2022 02:55:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1176' AND id_document != '55309' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-19') 13/06/2022 02:55:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1176', document_date = '2022-04-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.70', price_tax_excluded = '56.50', date_upd = NOW() WHERE id_document = '55309' 13/06/2022 02:55: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 = '55309' 13/06/2022 02:55:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '55309' 13/06/2022 02:55: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 ( '55309' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 13/06/2022 02:55:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 13/06/2022 02:55:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 13/06/2022 02:55: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 ( '55309' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 13/06/2022 02:55:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '' 13/06/2022 02:55:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '' , '1' ) 13/06/2022 02:55: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 ( '55309' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 13/06/2022 02:55:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 13/06/2022 02:55:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 13/06/2022 02:55: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 ( '55309' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '2' , '-2' , '4' , '18.5000' , '18.5' , '0' , '5' , '35.16' ) 13/06/2022 02:55:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 13/06/2022 02:55:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 13/06/2022 02:55: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 ( '55309' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '-6' , '4' , '0.72' , '0.72' , '0' , '0' , '4.32' ) 13/06/2022 02:55:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/06/2022 02:55:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/06/2022 02:55:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1395' AND id_document != '56586' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 13/06/2022 02:55:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1395', 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 = '10.50', price_tax_excluded = '9.24', date_upd = NOW() WHERE id_document = '56586' 13/06/2022 02:55:53 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 = '56586' 13/06/2022 02:55:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '56586' 13/06/2022 02:55:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56586' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 13/06/2022 02:55:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 13/06/2022 02:55:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 13/06/2022 02:55:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56586' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 13/06/2022 02:55:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 13/06/2022 02:55:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 13/06/2022 02:57:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1284' AND id_document != '56461' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-28') 13/06/2022 02:57:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1284', document_date = '2022-04-28', 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 = '90.00', price_tax_excluded = '90.00', date_upd = NOW() WHERE id_document = '56461' 13/06/2022 02:57: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 = '56461' 13/06/2022 02:57:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '56461' 13/06/2022 02:57: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 ( '56461' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.18' , '14.18' , '0' , '0' , '14.18' ) 13/06/2022 02:57:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/06/2022 02:57:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/06/2022 02:57: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 ( '56461' , '19498' , 'VANGELI' , '1' , '-1' , '4' , '69.00' , '69' , '0' , '5' , '65.55' ) 13/06/2022 02:57:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19498' AND id_supplier = '' 13/06/2022 02:57:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19498' , '' , '1' ) 13/06/2022 02:57: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 ( '56461' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/06/2022 02:57:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '' 13/06/2022 02:57:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '' , '1' ) 13/06/2022 02:57: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 ( '56461' , '19567' , 'PAROLA E PREGHIERA - AGO 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 13/06/2022 02:57:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19567' AND id_supplier = '' 13/06/2022 02:57:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19567' , '' , '1' ) 13/06/2022 02:58:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1522' AND id_document != '57261' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-13') 13/06/2022 02:58:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1522', document_date = '2022-05-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 = '15.00', price_tax_excluded = '15.00', date_upd = NOW() WHERE id_document = '57261' 13/06/2022 02:58:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57261' 13/06/2022 02:58:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '57261' 13/06/2022 02:58:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57261' , '19630' , 'bernardette - a. maggi' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 13/06/2022 02:58:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19630' AND id_supplier = '' 13/06/2022 02:58:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19630' , '' , '1' ) 13/06/2022 02:59:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1614' AND id_document != '57878' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 13/06/2022 02:59:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1614', document_date = '2022-05-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '79.60', price_tax_excluded = '66.44', date_upd = NOW() WHERE id_document = '57878' 13/06/2022 02:59: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 = '57878' 13/06/2022 02:59:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '57878' 13/06/2022 02:59: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 ( '57878' , '7934' , 'PERGAMENE - CRESIMA MOD. B' , '100' , '-100' , '1' , '0.5000' , '0.40983606557377' , '22' , '10' , '45.00' ) 13/06/2022 02:59:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7934' AND id_supplier = '' 13/06/2022 02:59:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7934' , '' , '1' ) 13/06/2022 02:59: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 ( '57878' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.99' , '0.99' , '0' , '0' , '0.99' ) 13/06/2022 02:59:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 13/06/2022 02:59:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 13/06/2022 02:59: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 ( '57878' , '9230' , 'SANTA RITA DA CASCIA - 10 ' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 13/06/2022 02:59:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9230' AND id_supplier = '' 13/06/2022 02:59:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9230' , '' , '1' ) 13/06/2022 02:59: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 ( '57878' , '5111' , 'SANTA RITA DA CASCIA - 11 BIS' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 13/06/2022 02:59:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5111' AND id_supplier = '' 13/06/2022 02:59:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5111' , '' , '1' ) 13/06/2022 02:59: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 ( '57878' , '19636' , 'PREGHIAMO CON I SALMI' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 13/06/2022 02:59:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19636' AND id_supplier = '' 13/06/2022 02:59:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19636' , '' , '1' ) 13/06/2022 03:14:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 13/06/2022 03:14:03 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.00', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '50074' 13/06/2022 03:14:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '50074' 13/06/2022 03:14:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '50074' 13/06/2022 03:14:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 13/06/2022 03:14:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 13/06/2022 03:14:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 13/06/2022 03:50:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1903' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 03:50:07 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' , '1903' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.50' , '77.71' , NOW() , NOW() ) 13/06/2022 03:50:07 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 = '58744' 13/06/2022 03:50:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '58744' 13/06/2022 03:50: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 ( '58744' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '2' , '-2' , '4' , '39.00' , '39' , '0' , '5' , '74.10' ) 13/06/2022 03:50:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '' 13/06/2022 03:50:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '' , '1' ) 13/06/2022 03:50: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 ( '58744' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '4' , '-4' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '3.20' ) 13/06/2022 03:50:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 13/06/2022 03:50:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 13/06/2022 03:50: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 ( '58744' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 13/06/2022 03:50:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19298' AND id_supplier = '' 13/06/2022 03:50:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19298' , '' , '1' ) 13/06/2022 04:16:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1904' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 04:16:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1904' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 13/06/2022 04:16:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58745' 13/06/2022 04:16:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58745' 13/06/2022 04:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58745' , '19560' , 'PERGAMENA 17X25' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 13/06/2022 04:16:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19560' AND id_supplier = '' 13/06/2022 04:16:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19560' , '' , '1' ) 13/06/2022 04:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58745' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 13/06/2022 04:16:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19231' AND id_supplier = '' 13/06/2022 04:16:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19231' , '' , '1' ) 13/06/2022 04:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 04:26:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1905' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 13/06/2022 04:26:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58746' 13/06/2022 04:26:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58746' 13/06/2022 04:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58746' , '18748' , 'OSTIA MAGNA 125mm' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 13/06/2022 04:26:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '' 13/06/2022 04:26:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '' , '1' ) 13/06/2022 05:17:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 05:17: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' , '1906' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 13/06/2022 05:17: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 = '58747' 13/06/2022 05:17:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58747' 13/06/2022 05:17: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 ( '58747' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 13/06/2022 05:17:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14114' AND id_supplier = '' 13/06/2022 05:17:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14114' , '' , '1' ) 13/06/2022 05:30:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 05:30:53 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' , '1907' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 13/06/2022 05:30:53 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 = '58748' 13/06/2022 05:30:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58748' 13/06/2022 05:30:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58748' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '58.00' ) 13/06/2022 05:30:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8082' AND id_supplier = '' 13/06/2022 05:30:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8082' , '' , '1' ) 13/06/2022 05:32:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1908' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 05:32:00 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' , '1908' , '2022-06-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '18.73' , NOW() , NOW() ) 13/06/2022 05:32:00 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 = '58749' 13/06/2022 05:32:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '58749' 13/06/2022 05:32:00 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 ( '58749' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 13/06/2022 05:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/06/2022 05:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/06/2022 05:32:00 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 ( '58749' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 13/06/2022 05:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/06/2022 05:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/06/2022 05:32:00 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 ( '58749' , '9539' , 'SANTANTONIO DA PADOVA - 41' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/06/2022 05:32:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9539' AND id_supplier = '' 13/06/2022 05:32:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9539' , '' , '1' ) 13/06/2022 05:35:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1908' AND id_document != '58749' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 13/06/2022 05:35:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1908', document_date = '2022-06-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 = '20.00', price_tax_excluded = '18.73', date_upd = NOW() WHERE id_document = '58749' 13/06/2022 05:35: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 = '58749' 13/06/2022 05:35:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '58749' 13/06/2022 05:35: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 ( '58749' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 13/06/2022 05:35:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/06/2022 05:35:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/06/2022 05:35: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 ( '58749' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 13/06/2022 05:35:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/06/2022 05:35:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/06/2022 05:35: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 ( '58749' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/06/2022 05:35:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/06/2022 05:35:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' )