13/02/2023 09:11:32 am >> SELECT document_num FROM ps_document WHERE document_num = '495' AND id_document != '81331' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11') 13/02/2023 09:11:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '495', document_date = '2023-02-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 = '3.10', price_tax_excluded = '2.54', date_upd = NOW() WHERE id_document = '81331' 13/02/2023 09:11:32 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 = '81331' 13/02/2023 09:11:32 am >> DELETE FROM ps_document_detail WHERE id_document = '81331' 13/02/2023 09:11:32 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 ( '81331' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.1' , '2.5409836065574' , '22' , '0' , '3.10' ) 13/02/2023 09:12:53 am >> SELECT document_num FROM ps_document WHERE document_num = '496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 09:12: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' , '496' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 13/02/2023 09:12: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 = '81332' 13/02/2023 09:12:53 am >> DELETE FROM ps_document_detail WHERE id_document = '81332' 13/02/2023 09:12: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 ( '81332' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 13/02/2023 09:15:04 am >> SELECT document_num FROM ps_document WHERE document_num = '488' AND id_document != '81324' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11') 13/02/2023 09:15:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '488', document_date = '2023-02-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 = '10.00', price_tax_excluded = '8.74', date_upd = NOW() WHERE id_document = '81324' 13/02/2023 09:15: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 = '81324' 13/02/2023 09:15:04 am >> DELETE FROM ps_document_detail WHERE id_document = '81324' 13/02/2023 09:15:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81324' , '17941' , 'LOURDES - ISONZO 119 bis' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:15:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81324' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:15:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81324' , '19583' , 'ROSARIO AL SACRO CUORE - 8063' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 13/02/2023 09:15:33 am >> SELECT document_num FROM ps_document WHERE document_num = '491' AND id_document != '81327' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11') 13/02/2023 09:15:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '491', document_date = '2023-02-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 = '34.91', price_tax_excluded = '33.02', date_upd = NOW() WHERE id_document = '81327' 13/02/2023 09:15:33 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 = '81327' 13/02/2023 09:15:33 am >> DELETE FROM ps_document_detail WHERE id_document = '81327' 13/02/2023 09:15:33 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 ( '81327' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 13/02/2023 09:15:33 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 ( '81327' , '17941' , 'LOURDES - ISONZO 119 bis' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:15:33 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 ( '81327' , '20446' , 'PREFAZI E PREGHIERE EUCARISTICHE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 13/02/2023 09:15:33 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 ( '81327' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.8000' , '5.8' , '0' , '0' , '5.80' ) 13/02/2023 09:15:33 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 ( '81327' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/02/2023 09:15:33 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 ( '81327' , '15601' , 'RITO DEL BATTESIMO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 13/02/2023 09:15:33 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 ( '81327' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 13/02/2023 09:16:57 am >> SELECT document_num FROM ps_document WHERE document_num = '257' AND id_document != '80511' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 13/02/2023 09:16:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '257', document_date = '2023-01-24', 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 = '77.48', price_tax_excluded = '71.53', date_upd = NOW() WHERE id_document = '80511' 13/02/2023 09:16:57 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 = '80511' 13/02/2023 09:16:57 am >> DELETE FROM ps_document_detail WHERE id_document = '80511' 13/02/2023 09:16:57 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 ( '80511' , '10484' , 'TECA ALTA IHS' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 13/02/2023 09:16:57 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 ( '80511' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:16:57 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 ( '80511' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 13/02/2023 09:16:57 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 ( '80511' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 13/02/2023 09:16:57 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 ( '80511' , '17763' , 'MADONNA MI E CARA - M. MASINI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 13/02/2023 09:16:57 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 ( '80511' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 13/02/2023 09:16:57 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 ( '80511' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 13/02/2023 09:16:57 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 ( '80511' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 13/02/2023 09:16:57 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 ( '80511' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.8800' , '3.88' , '0' , '0' , '3.88' ) 13/02/2023 09:16:57 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 ( '80511' , '17941' , 'LOURDES - ISONZO 119 bis' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:17:29 am >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '78177' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 13/02/2023 09:17:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '43', document_date = '2023-01-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 = '8.00', price_tax_excluded = '6.56', date_upd = NOW() WHERE id_document = '78177' 13/02/2023 09:17:29 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 = '78177' 13/02/2023 09:17:30 am >> DELETE FROM ps_document_detail WHERE id_document = '78177' 13/02/2023 09:17:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78177' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 13/02/2023 09:17:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78177' , '6074' , 'MADONNA DI LOURDES - 120' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/02/2023 09:18:20 am >> SELECT document_num FROM ps_document WHERE document_num = '349' AND id_document != '81144' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-01') 13/02/2023 09:18:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '349', document_date = '2023-02-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '61.71', price_tax_excluded = '59.82', date_upd = NOW() WHERE id_document = '81144' 13/02/2023 09:18:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81144' 13/02/2023 09:18:21 am >> DELETE FROM ps_document_detail WHERE id_document = '81144' 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '5' , '37.05' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '15477' , 'CREDENTI NON PRATICANTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 13/02/2023 09:18:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81144' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:19:13 am >> SELECT document_num FROM ps_document WHERE document_num = '413' AND id_document != '81228' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04') 13/02/2023 09:19:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '413', document_date = '2023-02-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.70', price_tax_excluded = '8.77', date_upd = NOW() WHERE id_document = '81228' 13/02/2023 09:19:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81228' 13/02/2023 09:19:13 am >> DELETE FROM ps_document_detail WHERE id_document = '81228' 13/02/2023 09:19:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81228' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '3.90' ) 13/02/2023 09:19:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81228' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '3.30' ) 13/02/2023 09:19:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81228' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/02/2023 09:38:17 am >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 09:38: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 ( '24' , '7' , '2023-02-13' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3280.00' , '3280.00' , NOW() , NOW() ) 13/02/2023 09:38: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 = '81333' 13/02/2023 09:38:17 am >> DELETE FROM ps_document_detail WHERE id_document = '81333' 13/02/2023 09:38: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 ( '81333' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '800' , '-800' , '4' , '2.00' , '2' , '0' , '0' , '1600.00' ) 13/02/2023 09:38: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 ( '81333' , '4154' , 'FESTA DEL PERDONO' , '560' , '-560' , '4' , '3.00' , '3' , '0' , '0' , '1680.00' ) 13/02/2023 10:09:50 am >> UPDATE ps_document SET id_document_type = '33', document_num = '259263', document_date = '2021-09-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '174.50', price_tax_excluded = '174.50', date_upd = NOW() WHERE id_document = '33369' 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '33369' 13/02/2023 10:09:50 am >> DELETE FROM ps_document_detail WHERE id_document = '33369' 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '18505' , 'RITROVARE SE STESSI - C.M. MARTINI' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '18625' , 'PREGHIERA DI GESU AL GETSEMANI - MERCEDES/GARCIA' , '1' , '1' , '4' , '27.0000' , '27' , '0' , '0' , '27.00' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '8260' , 'PREGHIAMO INSIEME E DICIAMO - M. BARZIZZA' , '1' , '1' , '4' , '32.5000' , '32.5' , '0' , '0' , '32.50' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '18626' , 'NUOVO MESSALINO DEI BAMBINI' , '2' , '2' , '4' , '5.5000' , '5.5' , '0' , '0' , '11.00' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '18519' , 'STORIA DELLA SPIRITUALITA FRANCESCANA - VOL. 2' , '1' , '1' , '4' , '62.0000' , '62' , '0' , '0' , '62.00' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '14712' , 'VERGINE DEL SILENZIO - E. ANTENUCCI' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 13/02/2023 10:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '33369' , '18502' , 'CATERINA DA SIENA E LINTELLETTO - M. RONCORONI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 13/02/2023 10:19:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554473' AND id_product != '18923' AND ean13 != '' 13/02/2023 10:19:22 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788831554473', date_upd = NOW() WHERE id_product = '18923' 13/02/2023 10:19:23 am >> UPDATE ps_product_lang SET name = 'CI SARANNO SANTI TRA I BAMBINI', description = '' WHERE id_product = '18923' 13/02/2023 10:19:23 am >> UPDATE ps_product SET wholesale_price = '7.37', on_sale = '0', price = '11.0000' WHERE id_product = '18923' 13/02/2023 10:19:23 am >> UPDATE ps_product_shop SET wholesale_price = '7.37', price = '11.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18923' 13/02/2023 10:19:23 am >> DELETE FROM ps_specific_price WHERE id_product = '18923' 13/02/2023 10:22:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801063981' AND id_product != '13429' AND ean13 != '' 13/02/2023 10:22:07 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/4', ean13 = '9788801063981', date_upd = NOW() WHERE id_product = '13429' 13/02/2023 10:22:07 am >> UPDATE ps_product_lang SET name = 'DON BOSCO, UN GRANDE!', description = '' WHERE id_product = '13429' 13/02/2023 10:22:07 am >> UPDATE ps_product SET wholesale_price = '4.55', on_sale = '0', price = '7.0000' WHERE id_product = '13429' 13/02/2023 10:22:07 am >> UPDATE ps_product_shop SET wholesale_price = '4.55', price = '7.0000', id_tax_rules_group = '4', id_category_default = '19', 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 = '13429' 13/02/2023 10:22:07 am >> DELETE FROM ps_specific_price WHERE id_product = '13429' 13/02/2023 10:23:06 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4632' 13/02/2023 10:23:06 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '4632' 13/02/2023 10:24:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554039' AND id_product != '20532' AND ean13 != '' 13/02/2023 10:24:53 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/2', ean13 = '9788831554039', date_upd = NOW() WHERE id_product = '20532' 13/02/2023 10:24:53 am >> UPDATE ps_product_lang SET name = 'HO VISTO E UDITO - ILDEGARDA DI BINGEN', description = '' WHERE id_product = '20532' 13/02/2023 10:24:53 am >> UPDATE ps_product SET wholesale_price = '21.44', on_sale = '0', price = '32.0000' WHERE id_product = '20532' 13/02/2023 10:24:53 am >> UPDATE ps_product_shop SET wholesale_price = '21.44', price = '32.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20532' 13/02/2023 10:24:53 am >> DELETE FROM ps_specific_price WHERE id_product = '20532' 13/02/2023 10:26:52 am >> DELETE FROM ps_product WHERE id_product = '5983' 13/02/2023 10:26:52 am >> DELETE FROM ps_product_shop WHERE id_product = '5983' 13/02/2023 10:26:52 am >> DELETE FROM ps_product_lang WHERE id_product = '5983' 13/02/2023 10:26:52 am >> DELETE FROM ps_stock_available WHERE id_product = '5983' 13/02/2023 10:32:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872299456' AND id_product != '18114' AND ean13 != '' 13/02/2023 10:32:29 am >> UPDATE ps_product SET id_supplier = '47', reference = '6/1', ean13 = '9788872299456', date_upd = NOW() WHERE id_product = '18114' 13/02/2023 10:32:29 am >> UPDATE ps_product_lang SET name = 'MIA VITA - TERESA DI GESU\'', description = '' WHERE id_product = '18114' 13/02/2023 10:32:29 am >> UPDATE ps_product SET wholesale_price = '19.60', on_sale = '0', price = '28.0000' WHERE id_product = '18114' 13/02/2023 10:32:29 am >> UPDATE ps_product_shop SET wholesale_price = '19.60', price = '28.0000', id_tax_rules_group = '4', id_category_default = '128', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18114' 13/02/2023 10:32:29 am >> DELETE FROM ps_specific_price WHERE id_product = '18114' 13/02/2023 10:33:28 am >> SELECT document_num FROM ps_document WHERE document_num = '198' AND id_document != '79918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-19') 13/02/2023 10:33:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '198', document_date = '2023-01-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 = '7.00', price_tax_excluded = '7.00', date_upd = NOW() WHERE id_document = '79918' 13/02/2023 10:33:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79918' 13/02/2023 10:33:28 am >> DELETE FROM ps_document_detail WHERE id_document = '79918' 13/02/2023 10:33:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79918' , '8787' , 'RACCONTI DI UN PELLEGRINO RUSSO' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 13/02/2023 10:35:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801051742' AND id_product != '9479' AND ean13 != '' 13/02/2023 10:35:58 am >> UPDATE ps_product SET id_supplier = '7', reference = 'ESPOSITORE VELAR', ean13 = '9788801051742', date_upd = NOW() WHERE id_product = '9479' 13/02/2023 10:35:58 am >> UPDATE ps_product_lang SET name = 'SAN MATTEO APOSTOLO ED EVANGELISTA', description = '' WHERE id_product = '9479' 13/02/2023 10:35:58 am >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '3.5000' WHERE id_product = '9479' 13/02/2023 10:35:58 am >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '3.5000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9479' 13/02/2023 10:35:58 am >> DELETE FROM ps_specific_price WHERE id_product = '9479' 13/02/2023 10:37:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872982723' AND id_product != '18583' AND ean13 != '' 13/02/2023 10:37:20 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788872982723', date_upd = NOW() WHERE id_product = '18583' 13/02/2023 10:37:20 am >> UPDATE ps_product_lang SET name = 'SEMPLICITA\' CHE CI TRAVOLGE BERNADETTE S. - L. VERDONE', description = '' WHERE id_product = '18583' 13/02/2023 10:37:20 am >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '2.5000' WHERE id_product = '18583' 13/02/2023 10:37:20 am >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '2.5000', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18583' 13/02/2023 10:37:20 am >> DELETE FROM ps_specific_price WHERE id_product = '18583' 13/02/2023 10:38:13 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9873' 13/02/2023 10:38:13 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '9873' 13/02/2023 10:42:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872983836' AND id_product != '20306' AND ean13 != '' 13/02/2023 10:42:08 am >> UPDATE ps_product SET id_supplier = '7', reference = 'ESPOSITORE GIREVOLE', ean13 = '9788872983836', date_upd = NOW() WHERE id_product = '20306' 13/02/2023 10:42:08 am >> UPDATE ps_product_lang SET name = 'RAGGI DI LUCE - A. COMASTRI', description = '' WHERE id_product = '20306' 13/02/2023 10:42:08 am >> UPDATE ps_product SET wholesale_price = '5.60', on_sale = '0', price = '8.0000' WHERE id_product = '20306' 13/02/2023 10:42:08 am >> UPDATE ps_product_shop SET wholesale_price = '5.60', price = '8.0000', id_tax_rules_group = '4', id_category_default = '29', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20306' 13/02/2023 10:42:08 am >> DELETE FROM ps_specific_price WHERE id_product = '20306' 13/02/2023 10:42:45 am >> SELECT document_num FROM ps_document WHERE document_num = '497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 10:42:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '497' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.20' , '51.20' , NOW() , NOW() ) 13/02/2023 10:42:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81334' 13/02/2023 10:42:45 am >> DELETE FROM ps_document_detail WHERE id_document = '81334' 13/02/2023 10:42:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81334' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '1280' , '-1280' , '4' , '0.04' , '0.04' , '0' , '0' , '51.20' ) 13/02/2023 10:42:57 am >> SELECT document_num FROM ps_document WHERE document_num = '498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 10:42:57 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' , '498' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 13/02/2023 10:42:57 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 = '81335' 13/02/2023 10:42:57 am >> DELETE FROM ps_document_detail WHERE id_document = '81335' 13/02/2023 10:42:57 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 ( '81335' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 13/02/2023 10:43:36 am >> DELETE FROM ps_document WHERE id_document = '81236' 13/02/2023 10:43:36 am >> DELETE FROM ps_document_detail WHERE id_document = '81236' 13/02/2023 10:55:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240391' AND id_product != '20530' AND ean13 != '' 13/02/2023 10:55:36 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/1', ean13 = '9788892240391', date_upd = NOW() WHERE id_product = '20530' 13/02/2023 10:55:36 am >> UPDATE ps_product_lang SET name = 'ULTIME PAROLE - TERESA DI GESU\' BAMBINO', description = '' WHERE id_product = '20530' 13/02/2023 10:55:36 am >> UPDATE ps_product SET wholesale_price = '13.40', on_sale = '0', price = '20.0000' WHERE id_product = '20530' 13/02/2023 10:55:36 am >> UPDATE ps_product_shop SET wholesale_price = '13.40', price = '20.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20530' 13/02/2023 10:55:36 am >> DELETE FROM ps_specific_price WHERE id_product = '20530' 13/02/2023 11:18:49 am >> SELECT document_num FROM ps_document WHERE document_num = '499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 11:18:49 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' , '499' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 13/02/2023 11:18:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81336' 13/02/2023 11:18:49 am >> DELETE FROM ps_document_detail WHERE id_document = '81336' 13/02/2023 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81336' , '19879' , 'CROCE CM 21 ORO - 4974/836' , '1' , '-1' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '29.90' ) 13/02/2023 11:26:38 am >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '80462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 13/02/2023 11:26:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '223', document_date = '2023-01-21', 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 = '117.00', price_tax_excluded = '117.00', date_upd = NOW() WHERE id_document = '80462' 13/02/2023 11:26:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80462' 13/02/2023 11:26:38 am >> DELETE FROM ps_document_detail WHERE id_document = '80462' 13/02/2023 11:26: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 ( '80462' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 13/02/2023 11:26: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 ( '80462' , '12590' , 'VANGELO DI GIOVANNI - S. FAUSTI' , '1' , '-1' , '4' , '44.0000' , '44' , '0' , '5' , '41.80' ) 13/02/2023 11:26: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 ( '80462' , '12921' , 'BARTOLO LONGO DAL SALENTO A POMPEI - A. ILLIBATO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/02/2023 11:26: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 ( '80462' , '15308' , 'CHI E PAOLO - G. LAJOLO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 13/02/2023 11:26: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 ( '80462' , '17648' , 'ANDIAMO A SCUOLA DI AMORE - A. COMASTRI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 13/02/2023 11:26: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 ( '80462' , '9615' , 'SANTA TERESA DI LISIEUX - TERESA DI LISIEUX' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 13/02/2023 11:26: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 ( '80462' , '15898' , 'DAMMI LA SAPIENZA - C. DUMONT' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 13/02/2023 12:16:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '341' AND id_document != '81135' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 13/02/2023 12:16:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '341', document_date = '2023-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.50', price_tax_excluded = '9.50', date_upd = NOW() WHERE id_document = '81135' 13/02/2023 12: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 = '81135' 13/02/2023 12:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '81135' 13/02/2023 12: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 ( '81135' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 13/02/2023 12:17:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '78183' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 13/02/2023 12:17:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '49', document_date = '2023-01-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 = '2.70', price_tax_excluded = '2.43', date_upd = NOW() WHERE id_document = '78183' 13/02/2023 12:17:55 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 = '78183' 13/02/2023 12:17:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '78183' 13/02/2023 12:17:55 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 ( '78183' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/02/2023 12:17:55 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 ( '78183' , '15867' , 'LETTERA AI MINISTRI STRAORDINARI DELLA COMUNIONE - 8964' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 13/02/2023 12:21:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 12:21:01 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' , '8' , '2023-02-13' , '' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , 'RESA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '9' , '168.00' , '162.95' , NOW() , NOW() ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81337' 13/02/2023 12:21:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '81337' 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '15867' , 'LETTERA AI MINISTRI STRAORDINARI DELLA COMUNIONE - 8964' , '7' , '-7' , '4' , '1.50' , '1.5' , '0' , '0' , '10.50' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15867' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15867' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '5198' , 'IN TE MI RIFUGIO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5198' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5198' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '13503' , 'A BRACCIA APERTE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13503' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13503' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '0' , '20.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '19921' , 'AGENDA 2023 - 40809' , '4' , '-4' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '28.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19921' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19921' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '15802' , 'VITA DI GESU CRISTO - MEDITAZIONI VANGELI - COF. 2 VOL. - 8937' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '0' , '24.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15802' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15802' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '18438' , 'MADONNA APPARE A LOURDES' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18438' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18438' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '18322' , 'BAMBINI AIUTATE IL MIO CUORE A VINCERE - 8106' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 13/02/2023 12:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18322' AND id_supplier = '38' 13/02/2023 12:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18322' , '38' , '1' ) 13/02/2023 12:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81337' , '13996' , 'CORONA BIBLICA PER IL DONO DEI FIGLI - 8443' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13996' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13996' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '16592' , 'CORONCINA PER LE ANIME DEI SACERDOTI... 8195' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16592' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16592' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '2776' , 'CORONCINA E NOVENA AL PREZIOSISSIMO SANGUE' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2776' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2776' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '10726' , 'TREDICINA A SANTANTONIO DI PADOVA' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10726' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10726' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '8762' , 'QUINDICI GIOVEDÌ DI SANTA RITA - 8405' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8762' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8762' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '11886' , 'NOVENA E CORONCINA A GESU BAMBINO DI PRAGA - 8365' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11886' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11886' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '18320' , 'VANGELO DI LUCA - N. MARCONI - 8009' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18320' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18320' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '16444' , 'VANGELO DI MARCO - 8998' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16444' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16444' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '15579' , 'SONO RINATA - M. CALCAGNO - 8944' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15579' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15579' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '18321' , 'IO ROSA - 8022' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18321' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18321' , '38' , '1' ) 13/02/2023 12:21: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 ( '81337' , '18332' , 'NON LHO VISTO MA LHO INCONTRATO - D. CIPOLLONI - 8896' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 13/02/2023 12:21:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18332' AND id_supplier = '38' 13/02/2023 12:21:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18332' , '38' , '1' ) 13/02/2023 02:24:38 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/02/2023 02:24:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20744' , '1' , '' , 'nuovo-prodotto' ) 13/02/2023 02:24:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20744' , '1' , '1' , '2' , NOW() , NOW() ) 13/02/2023 02:24:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20744' , '0' , '1' , '0' , '0' ) 13/02/2023 02:26:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'F721000/75' AND id_product != '20744' AND ean13 != '' 13/02/2023 02:26:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'F721000/75', date_upd = NOW() WHERE id_product = '20744' 13/02/2023 02:26:15 pm >> UPDATE ps_product_lang SET name = 'CRISTO SIENA FIBRA DI VETRO 75/150', description = '' WHERE id_product = '20744' 13/02/2023 02:26:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '897.5409836065573' WHERE id_product = '20744' 13/02/2023 02:26:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '897.5409836065573', id_tax_rules_group = '1', id_category_default = '412', 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 = '20744' 13/02/2023 02:26:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20744' 13/02/2023 02:28:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 02:28: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 ( '11' , '500' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.31' , NOW() , NOW() ) 13/02/2023 02:28: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 = '81338' 13/02/2023 02:28:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '81338' 13/02/2023 02:28: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 ( '81338' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 13/02/2023 02:30:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'F721000/75' AND id_product != '20744' AND ean13 != '' 13/02/2023 02:30:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'F721000/75', date_upd = NOW() WHERE id_product = '20744' 13/02/2023 02:30:46 pm >> UPDATE ps_product_lang SET name = 'CRISTO SIENA FIBRA DI VETRO 75/150', description = '' WHERE id_product = '20744' 13/02/2023 02:30:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '897.5409836065573' WHERE id_product = '20744' 13/02/2023 02:30:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '897.5409836065573', id_tax_rules_group = '1', id_category_default = '412', 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 = '20744' 13/02/2023 02:30:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '20744' 13/02/2023 02:31:16 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' , '345-2023' , '2023-02-09' , '' , '0' , '98' , '4658882' , 'VIA CADEMIA, 20 39046 ORTISEI' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '629.52' , '516.00' , NOW() , NOW() ) 13/02/2023 02:31:16 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 = '81339' 13/02/2023 02:31:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '81339' 13/02/2023 02:31:16 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 ( '81339' , '20744' , 'CRISTO SIENA FIBRA DI VETRO 75/150' , '1' , '1' , '1' , '498' , '408.19672131148' , '22' , '0' , '607.5600' ) 13/02/2023 02:31:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20744' AND id_supplier = '98' 13/02/2023 02:31:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20744' , '98' , '1' ) 13/02/2023 03:18:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 03:18:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '501' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 13/02/2023 03:18: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 = '81340' 13/02/2023 03:18:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '81340' 13/02/2023 03:18:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81340' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 13/02/2023 03:56:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/02/2023 03:56:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20745' , '1' , '' , 'nuovo-prodotto' ) 13/02/2023 03:56:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20745' , '1' , '1' , '2' , NOW() , NOW() ) 13/02/2023 03:56:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20745' , '0' , '1' , '0' , '0' ) 13/02/2023 03:57:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817178457' AND id_product != '20745' AND ean13 != '' 13/02/2023 03:57:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788817178457', date_upd = NOW() WHERE id_product = '20745' 13/02/2023 03:57:56 pm >> UPDATE ps_product_lang SET name = 'SPERANZA CHE CERCHI - F. CRISTOFARO', description = '' WHERE id_product = '20745' 13/02/2023 03:57:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20745' 13/02/2023 03:57:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '239', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20745' 13/02/2023 03:57:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20745' 13/02/2023 03:57:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20745' 13/02/2023 03:57:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20746' , '1' , '' , 'nuovo-prodotto' ) 13/02/2023 03:57:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20746' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20745' 13/02/2023 03:57:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20746' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20745' 13/02/2023 03:58:33 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' , '1614' , '2023-02-13' , '' , '0' , '105' , '4668972' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '6.63' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '105.12' , '105.12' , NOW() , NOW() ) 13/02/2023 03:58: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 = '81341' 13/02/2023 03:58:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '81341' 13/02/2023 03:58: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 ( '81341' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '4' , '4' , '4' , '20.00' , '20' , '0' , '30' , '56.0000' ) 13/02/2023 03:58:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20642' AND id_supplier = '105' 13/02/2023 03:58:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20642' , '105' , '1' ) 13/02/2023 03:58: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 ( '81341' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 13/02/2023 03:58:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '105' 13/02/2023 03:58:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '105' , '1' ) 13/02/2023 03:58: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 ( '81341' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '2' , '2' , '4' , '16.90' , '16.9' , '0' , '30' , '23.6600' ) 13/02/2023 03:58:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '105' 13/02/2023 03:58:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '105' , '1' ) 13/02/2023 03:58: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 ( '81341' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/02/2023 03:58:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20745' AND id_supplier = '105' 13/02/2023 03:58:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20745' , '105' , '1' ) 13/02/2023 04:21:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '77503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 13/02/2023 04:21:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2022-12-23', document_letter = 'A', id_customer = '3843', id_supplier = '', id_address = '4673209', address1 = 'RIONE PIOMBINO 84080 PELLEZZANO', address2 = '', note = '12/01 € 300,00 + 07/02 € 250,00 -', 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 = '2750.00', price_tax_excluded = '2605.74', date_upd = NOW() WHERE id_document = '77503' 13/02/2023 04:21: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 = '77503' 13/02/2023 04:21:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '77503' 13/02/2023 04:21: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 ( '77503' , '15679' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '800.0000' , '655.73770491803' , '22' , '0' , '800.00' ) 13/02/2023 04:21: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 ( '77503' , '' , 'STOLA' , '1' , '-1' , '0' , '1950' , '1950' , '' , '0' , '1950.00' ) 13/02/2023 04:22:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '416' AND id_document != '81231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04') 13/02/2023 04:22:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '416', document_date = '2023-02-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 = '600.00', price_tax_excluded = '518.49', date_upd = NOW() WHERE id_document = '81231' 13/02/2023 04:22:10 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 = '81231' 13/02/2023 04:22:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '81231' 13/02/2023 04:22:10 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 ( '81231' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 13/02/2023 04:22:10 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 ( '81231' , '14000' , 'GALATEO IN CHIESA' , '15' , '-15' , '4' , '1.0000' , '1' , '0' , '0' , '15.00' ) 13/02/2023 04:22:10 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 ( '81231' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '36.00' ) 13/02/2023 04:22:10 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 ( '81231' , '2722' , 'COPRI AMBONE FIGLIOL PRODIGO' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 13/02/2023 04:22:10 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 ( '81231' , '13928' , 'COPRILEGGIO - 315/TP' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 13/02/2023 04:22:10 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 ( '81231' , '14214' , 'CASULA IN POLIESTERE ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 13/02/2023 04:22:10 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 ( '81231' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 13/02/2023 04:22:10 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 ( '81231' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '31' , '25.409836065574' , '22' , '0' , '31.00' ) 13/02/2023 05:16:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '502' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 05:16:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '502' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '9.60' , NOW() , NOW() ) 13/02/2023 05:16:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81342' 13/02/2023 05:16:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '81342' 13/02/2023 05:16: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 ( '81342' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.04' , '0.04' , '0' , '0' , '9.60' ) 13/02/2023 05:25:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 05:25:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '503' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '9.99' , NOW() , NOW() ) 13/02/2023 05:25: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 = '81343' 13/02/2023 05:25:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '81343' 13/02/2023 05:25: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 ( '81343' , '9517' , 'SAN VALENTINO - G. CASSIO' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 13/02/2023 05:25: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 ( '81343' , '9494' , 'SAN PASQUALE BAYLON - S.BRACCI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 13/02/2023 05:44:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 05:44:36 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' , '504' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '26.64' , NOW() , NOW() ) 13/02/2023 05:44:36 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 = '81344' 13/02/2023 05:44:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '81344' 13/02/2023 05:44:36 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 ( '81344' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 13/02/2023 05:44:36 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 ( '81344' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 13/02/2023 06:45:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 06:45:01 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' , '505' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 13/02/2023 06:45:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81345' 13/02/2023 06:45:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '81345' 13/02/2023 06:45:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81345' , '20075' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 13/02/2023 07:02:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 07:02:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '7' , '2023-02-13' , '' , '6949' , '0' , '51344707' , 'Via Pe Pretis , 2 38050 Roncegno Terme' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '956.90' , '956.90' , NOW() , NOW() ) 13/02/2023 07:02:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '10027' 13/02/2023 07:02:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '10027' 13/02/2023 07:02:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '10027' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '50' , '-50' , '4' , '2.00' , '2' , '0' , '5' , '95.00' ) 13/02/2023 07:02:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '10027' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '30' , '-30' , '4' , '30.00' , '30' , '0' , '5' , '855.00' ) 13/02/2023 07:09:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 13/02/2023 07:09:56 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' , '506' , '2023-02-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 13/02/2023 07:09:56 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 = '81346' 13/02/2023 07:09:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '81346' 13/02/2023 07:09:56 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 ( '81346' , '19593' , 'CUSTODIA BIBBIA GERUSALEMME ECO PELLE STUDIO' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 13/02/2023 07:13:14 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6949' 13/02/2023 07:13:14 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 ( '6949' , '10' , '221' , 'Parrocchia santi Pietro e Paolo' , 'Ferrari' , 'don Paolo' , 'Via De Pretis , 2' , '' , '38050' , 'Roncegno Terme' , '' , '' , '0461.764022' , '' , '90003970226' , NOW() , NOW() ) 13/02/2023 07:13:14 pm >> UPDATE ps_customer SET email = 'upsantipietropaolo@parrocchietn.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6949'