12/12/2022 09:17:18 am >> SELECT document_num FROM ps_document WHERE document_num = '334' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 09:17:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '334' , '2022-12-12' , '' , '3991' , '' , '4677900' , 'Via Giuseppe Giusti , 68 74028 Sava ' , '' , '' , '5.00' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 12/12/2022 09:17:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77214' 12/12/2022 09:17:18 am >> DELETE FROM ps_document_detail WHERE id_document = '77214' 12/12/2022 09:17:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77214' , '13506' , 'SANTO ROSARIO' , '17' , '-17' , '0' , '0.3000' , '0.3' , '' , '0' , '5.10' ) 12/12/2022 09:17:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 12/12/2022 09:17:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 12/12/2022 09:17:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77214' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 12/12/2022 09:17:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 12/12/2022 09:17:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 12/12/2022 09:17:34 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-12-11' WHERE id_order = '408' 12/12/2022 09:17:34 am >> DELETE FROM ps_document WHERE document_num = '408' AND id_document_type = '28' 12/12/2022 09:17:42 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-12-11' WHERE id_order = '409' 12/12/2022 09:17:42 am >> DELETE FROM ps_document WHERE document_num = '409' AND id_document_type = '28' 12/12/2022 09:17:47 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-12-11' WHERE id_order = '410' 12/12/2022 09:17:47 am >> DELETE FROM ps_document WHERE document_num = '410' AND id_document_type = '28' 12/12/2022 09:18:14 am >> SELECT document_num FROM ps_document WHERE document_num = '334' AND id_document != '77214' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 09:18:14 am >> UPDATE ps_document SET id_document_type = '21', document_num = '334', document_date = '2022-12-12', document_letter = '', id_customer = '3991', id_supplier = '', id_address = '4677900', address1 = 'Via Giuseppe Giusti , 68 74028 Sava ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '13.00', price_tax_excluded = '13.00', date_upd = NOW() WHERE id_document = '77214' 12/12/2022 09:18:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77214' 12/12/2022 09:18:15 am >> DELETE FROM ps_document_detail WHERE id_document = '77214' 12/12/2022 09:18:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77214' , '13506' , 'SANTO ROSARIO' , '17' , '-17' , '0' , '0.3000' , '0.3' , '0' , '0' , '5.10' ) 12/12/2022 09:18:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 12/12/2022 09:18:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 12/12/2022 09:18:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77214' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 12/12/2022 09:18:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 12/12/2022 09:18:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 12/12/2022 09:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 09:48:14 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' , '3824' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.80' , '80.80' , NOW() , NOW() ) 12/12/2022 09:48:14 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 = '77215' 12/12/2022 09:48:14 am >> DELETE FROM ps_document_detail WHERE id_document = '77215' 12/12/2022 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77215' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/12/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 12/12/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 12/12/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77215' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 12/12/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/12/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/12/2022 09:48:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77215' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 12/12/2022 09:48:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/12/2022 09:48:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/12/2022 10:01:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 10:01:22 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' , '3825' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.90' , '52.30' , NOW() , NOW() ) 12/12/2022 10:01:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77216' 12/12/2022 10:01:22 am >> DELETE FROM ps_document_detail WHERE id_document = '77216' 12/12/2022 10:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77216' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '33.00' ) 12/12/2022 10:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 12/12/2022 10:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 12/12/2022 10:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77216' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 12/12/2022 10:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 12/12/2022 10:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 12/12/2022 10:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77216' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 12/12/2022 10:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/12/2022 10:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/12/2022 10:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77216' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 12/12/2022 10:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 12/12/2022 10:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 12/12/2022 10:01:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77216' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 12/12/2022 10:01:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 12/12/2022 10:01:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 12/12/2022 10:24:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3826' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 10:24:12 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' , '3826' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 12/12/2022 10:24:12 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 = '77217' 12/12/2022 10:24:12 am >> DELETE FROM ps_document_detail WHERE id_document = '77217' 12/12/2022 10:24:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77217' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 12/12/2022 10:24:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/12/2022 10:24:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/12/2022 11:00:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 11:00:08 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' , '3827' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 12/12/2022 11:00:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77218' 12/12/2022 11:00:08 am >> DELETE FROM ps_document_detail WHERE id_document = '77218' 12/12/2022 11:00:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77218' , '19998' , 'GESU BAMBINO CM 20 - BJ142-28E' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 12/12/2022 11:00:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19998' AND id_supplier = '' 12/12/2022 11:00:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19998' , '' , '1' ) 12/12/2022 11:03:28 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'bEyLhkXT3YP2bl6F' , NOW() , NOW() ) 12/12/2022 11:03:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7021' , '1' ) 12/12/2022 11:03:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7021' , '2' ) 12/12/2022 11:03:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7021' , '3' ) 12/12/2022 11:04:41 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7021' 12/12/2022 11:04:41 am >> 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 ( '7021' , '10' , '124' , 'PARROCCHIA SANT\'ANDREA AP' , 'PEPE' , 'DON GRAZIANO' , 'VIA PELUCCHI 2' , '' , '15060' , 'BASALUZZO' , '' , '' , '3284036305' , '' , '' , NOW() , NOW() ) 12/12/2022 11:04:41 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7021' 12/12/2022 11:06:11 am >> SELECT document_num FROM ps_document WHERE document_num = '136' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 11:06:11 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 ( '21' , '136' , '2022-12-12' , '' , '7021' , '0' , '107350748' , 'VIA PELUCCHI 2 15060 BASALUZZO' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '85.50' , '85.50' , NOW() , NOW() ) 12/12/2022 11:06:11 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 = '9241' 12/12/2022 11:06:11 am >> DELETE FROM ps_document_detail WHERE id_document = '9241' 12/12/2022 11:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9241' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '5' , '-5' , '4' , '18.00' , '18' , '0' , '5' , '85.50' ) 12/12/2022 11:06:22 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7021' 12/12/2022 11:06:22 am >> 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 ( '7021' , '10' , '124' , 'PARROCCHIA SANT\'ANDREA AP' , 'PEPE' , 'DON GRAZIANO' , 'VIA PELUCCHI 2' , '' , '15060' , 'BASALUZZO' , '' , '' , '3284036305' , '' , '' , NOW() , NOW() ) 12/12/2022 11:06:22 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7021' 12/12/2022 11:17:25 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Bt12QMSgS4putxPR' , NOW() , NOW() ) 12/12/2022 11:17:25 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7022' , '1' ) 12/12/2022 11:17:25 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7022' , '2' ) 12/12/2022 11:17:25 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7022' , '3' ) 12/12/2022 11:20:15 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7022' 12/12/2022 11:20:15 am >> 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 ( '7022' , '10' , '139' , 'PARR. S. MARIA IMMACOLATA DI LUGANA' , 'MODENA' , 'DON MANUELE' , 'PIAZZA CASAGRANDE 4' , '' , '25019' , 'SIRMIONE' , '' , '' , '' , '' , '' , NOW() , NOW() ) 12/12/2022 11:20:15 am >> UPDATE ps_customer SET email = 'modenamanuele94@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7022' 12/12/2022 11:23:03 am >> SELECT document_num FROM ps_document WHERE document_num = '137' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 11:23:03 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 ( '21' , '137' , '2022-12-12' , '' , '7022' , '0' , '107350750' , 'PIAZZA CASAGRANDE 4 25019 SIRMIONE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '369.00' , '369.00' , NOW() , NOW() ) 12/12/2022 11:23: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 = '9242' 12/12/2022 11:23:03 am >> DELETE FROM ps_document_detail WHERE id_document = '9242' 12/12/2022 11:23: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 ( '9242' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '25' , '-25' , '4' , '2.00' , '2' , '0' , '10' , '45.00' ) 12/12/2022 11:23: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 ( '9242' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '12' , '-12' , '4' , '30.00' , '30' , '0' , '10' , '324.00' ) 12/12/2022 11:26:34 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '5xbmswaFi3PE3LFa' , NOW() , NOW() ) 12/12/2022 11:26:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7023' , '1' ) 12/12/2022 11:26:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7023' , '2' ) 12/12/2022 11:26:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7023' , '3' ) 12/12/2022 11:27:29 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7023' 12/12/2022 11:27:29 am >> 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 ( '7023' , '10' , '124' , '' , 'CRAVERA' , 'GIANCARLO' , 'VIA SETTE FRATELLI CERVI 16' , '' , '15040' , 'PECETTO DI VALENZA' , '' , '' , '3669329218' , '' , '' , NOW() , NOW() ) 12/12/2022 11:27:29 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7023' 12/12/2022 11:28:03 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7023' 12/12/2022 11:28:03 am >> 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 ( '7023' , '10' , '124' , '' , 'CRAVERA' , 'GIANCARLO' , 'VIA SETTE FRATELLI CERVI 16' , '' , '15040' , 'PECETTO DI VALENZA' , '' , '' , '3669329218' , '' , '' , NOW() , NOW() ) 12/12/2022 11:28:03 am >> UPDATE ps_customer SET email = 'graziacravera@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7023' 12/12/2022 11:28:45 am >> SELECT document_num FROM ps_document WHERE document_num = '138' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 11:28: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 ( '21' , '138' , '2022-12-12' , '' , '7023' , '0' , '107350752' , 'VIA SETTE FRATELLI CERVI 16 15040 PECETTO DI VALENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '68.40' , '68.40' , NOW() , NOW() ) 12/12/2022 11:28: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 = '9243' 12/12/2022 11:28:45 am >> DELETE FROM ps_document_detail WHERE id_document = '9243' 12/12/2022 11:28: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 ( '9243' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '4' , '-4' , '4' , '18.00' , '18' , '0' , '5' , '68.40' ) 12/12/2022 11:38:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 11:38:11 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' , '3828' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 12/12/2022 11:38:11 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 = '77219' 12/12/2022 11:38:11 am >> DELETE FROM ps_document_detail WHERE id_document = '77219' 12/12/2022 11:38:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77219' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 12/12/2022 11:38:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 12/12/2022 11:38:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 12/12/2022 12:14:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3829' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 12:14: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' , '3829' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '620.00' , '508.20' , NOW() , NOW() ) 12/12/2022 12:14: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 = '77220' 12/12/2022 12:14:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '77220' 12/12/2022 12:14: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 ( '77220' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '620.00' , '508.19672131148' , '22' , '0' , '620.00' ) 12/12/2022 12:14:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19448' AND id_supplier = '' 12/12/2022 12:14:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19448' , '' , '1' ) 12/12/2022 12:15:08 pm >> DELETE FROM ps_document WHERE id_document = '32723' 12/12/2022 12:15:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '32723' 12/12/2022 12:19:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 12/12/2022 12:19:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 50,00+ 40,00+ 80,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 = '192.10', price_tax_excluded = '170.40', date_upd = NOW() WHERE id_document = '57793' 12/12/2022 12:19: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 = '57793' 12/12/2022 12:19:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '57793' 12/12/2022 12:19: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 ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '13' , '-13' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '24.70' ) 12/12/2022 12:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/12/2022 12:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/12/2022 12:19: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 ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 12/12/2022 12:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 12/12/2022 12:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 12/12/2022 12:19: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 ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/12/2022 12:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 12/12/2022 12:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 12/12/2022 12:19: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 ( '57793' , '7673' , 'PARTICOLE MM38' , '19' , '-19' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '66.50' ) 12/12/2022 12:19:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 12/12/2022 12:19:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 12/12/2022 12:19: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 ( '57793' , '11384' , 'VINO BIANCO DOLCE - 102' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 12/12/2022 12:19:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 12/12/2022 12:19:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 12/12/2022 12:19: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 ( '57793' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 12/12/2022 12:19:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/12/2022 12:19:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/12/2022 12:25:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3830' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 12:25:29 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' , '3830' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.20' , '152.86' , NOW() , NOW() ) 12/12/2022 12:25:29 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 = '77221' 12/12/2022 12:25:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '77221' 12/12/2022 12:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 12/12/2022 12:25:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/12/2022 12:25:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/12/2022 12:25:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 12/12/2022 12:25:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 12/12/2022 12:25:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 12/12/2022 12:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '11151' , 'LIBRI' , '19' , '-19' , '4' , '3.5' , '3.5' , '0' , '0' , '66.50' ) 12/12/2022 12:25:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 12/12/2022 12:25:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 12/12/2022 12:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/12/2022 12:25:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 12/12/2022 12:25:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 12/12/2022 12:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '4.50' ) 12/12/2022 12:25:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 12/12/2022 12:25:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 12/12/2022 12:25:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77221' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 12/12/2022 12:25:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/12/2022 12:25:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/12/2022 12:26:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 12/12/2022 12:26:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2022-05-16', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = 'acconto € 50,00+ 40,00+ 80,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 = '20.90', price_tax_excluded = '20.10', date_upd = NOW() WHERE id_document = '57793' 12/12/2022 12:26:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57793' 12/12/2022 12:26:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '57793' 12/12/2022 12:26:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '11' , '-11' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '20.90' ) 12/12/2022 12:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 12/12/2022 12:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 12/12/2022 12:28:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3831' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 12:28:38 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' , '3831' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 12/12/2022 12:28:38 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 = '77222' 12/12/2022 12:28:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '77222' 12/12/2022 12:28:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77222' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 12/12/2022 12:28:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 12/12/2022 12:28:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 12/12/2022 12:38:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 12:38:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3832' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 12/12/2022 12:38:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77223' 12/12/2022 12:38:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '77223' 12/12/2022 12:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77223' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 12/12/2022 12:38:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 12/12/2022 12:38:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 12/12/2022 12:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77223' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 12/12/2022 12:38:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16494' AND id_supplier = '' 12/12/2022 12:38:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16494' , '' , '1' ) 12/12/2022 12:49:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '137' AND id_document != '9242' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 12:49:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '137', document_date = '2022-12-12', document_letter = '', id_customer = '7022', id_supplier = '', id_address = '107350750', address1 = 'PIAZZA CASAGRANDE 4 25019 SIRMIONE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '366.50', price_tax_excluded = '366.50', date_upd = NOW() WHERE id_document = '9242' 12/12/2022 12:49:26 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 = '9242' 12/12/2022 12:49:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '9242' 12/12/2022 12:49:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9242' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '25' , '-25' , '4' , '2.0000' , '2' , '0' , '15' , '42.50' ) 12/12/2022 12:49:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '57' AND id_supplier = '' 12/12/2022 12:49:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '57' , '' , '1' ) 12/12/2022 12:49:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9242' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '12' , '-12' , '4' , '30.0000' , '30' , '0' , '10' , '324.00' ) 12/12/2022 12:49:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '58' AND id_supplier = '' 12/12/2022 12:49:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '58' , '' , '1' ) 12/12/2022 12:49:36 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7022' 12/12/2022 12:49:36 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 ( '7022' , '10' , '139' , 'PARR. S. MARIA IMMACOLATA DI LUGANA' , 'MODENA' , 'DON MANUELE' , 'PIAZZA CASAGRANDE 4' , '' , '25019' , 'SIRMIONE' , '' , '' , '' , '' , '84001270176' , NOW() , NOW() ) 12/12/2022 12:49:36 pm >> UPDATE ps_customer SET email = 'modenamanuele94@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7022' 12/12/2022 12:49:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '137' AND id_document != '9242' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 12:49:59 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '137', document_date = '2022-12-12', document_letter = '', id_customer = '7022', id_supplier = '0', id_address = '107350753', address1 = 'PIAZZA CASAGRANDE 4 25019 SIRMIONE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '366.50', price_tax_excluded = '366.50', date_upd = NOW() WHERE id_document = '9242' 12/12/2022 12:49:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '9242' 12/12/2022 12:49:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '9242' 12/12/2022 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9242' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '25' , '-25' , '4' , '2.0000' , '2' , '0' , '15' , '42.50' ) 12/12/2022 12:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9242' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '12' , '-12' , '4' , '30.0000' , '30' , '0' , '10' , '324.00' ) 12/12/2022 02:19:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2668' AND id_document != '61716' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-07') 12/12/2022 02:19:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2668', document_date = '2022-09-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '61716' 12/12/2022 02:19:34 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 = '61716' 12/12/2022 02:19:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '61716' 12/12/2022 02:19:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61716' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 12/12/2022 02:19:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1544' AND id_supplier = '' 12/12/2022 02:19:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1544' , '' , '1' ) 12/12/2022 03:24:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 03:24:47 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' , '3833' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 12/12/2022 03:24:47 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 = '77224' 12/12/2022 03:24:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '77224' 12/12/2022 03:24:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77224' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '20.00' ) 12/12/2022 03:24:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 12/12/2022 03:24:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 12/12/2022 04:21:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 04:21:10 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' , '3834' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '166.00' , '136.07' , NOW() , NOW() ) 12/12/2022 04:21: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 = '77225' 12/12/2022 04:21:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '77225' 12/12/2022 04:21: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 ( '77225' , '16314' , 'BAMBINO CM 6' , '30' , '-30' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '45.00' ) 12/12/2022 04:21:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 12/12/2022 04:21:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 12/12/2022 04:21: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 ( '77225' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 12/12/2022 04:21:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9464' AND id_supplier = '' 12/12/2022 04:21:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9464' , '' , '1' ) 12/12/2022 04:21: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 ( '77225' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '22' , '18.032786885246' , '22' , '0' , '88.00' ) 12/12/2022 04:21:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/12/2022 04:21:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/12/2022 04:21: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 ( '77225' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 12/12/2022 04:21:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/12/2022 04:21:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/12/2022 04:25:20 pm >> DELETE FROM ps_document WHERE id_document = '68007' 12/12/2022 04:25:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '68007' 12/12/2022 04:28:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '112/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 04:28:17 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' , '112/A' , '2022-12-12' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '75.00' , NOW() , NOW() ) 12/12/2022 04:28:17 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 = '77226' 12/12/2022 04:28:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '77226' 12/12/2022 04:28:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77226' , '' , 'miracolosa oro' , '1' , '-1' , '0' , '75' , '75' , '' , '0' , '75.00' ) 12/12/2022 05:27:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 05:27:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3835' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.43' , '30.99' , NOW() , NOW() ) 12/12/2022 05:27: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 = '77227' 12/12/2022 05:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '77227' 12/12/2022 05:27: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 ( '77227' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/12/2022 05:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 12/12/2022 05:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 12/12/2022 05:27: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 ( '77227' , '20057' , 'CINQUE PANI DORZO 2023' , '3' , '-3' , '4' , '6.90' , '6.9' , '0' , '5' , '19.68' ) 12/12/2022 05:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '' 12/12/2022 05:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '' , '1' ) 12/12/2022 05:27: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 ( '77227' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 12/12/2022 05:27:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19074' AND id_supplier = '' 12/12/2022 05:27:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19074' , '' , '1' ) 12/12/2022 05:48:07 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '6405' 12/12/2022 05:48:07 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '6405' 12/12/2022 05:48:17 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '6405' 12/12/2022 05:48:17 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '6405' 12/12/2022 05:48:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000164' AND id_product != '6405' AND ean13 != '' 12/12/2022 05:48:25 pm >> UPDATE ps_product SET id_supplier = '31', reference = '2013', ean13 = '000164', date_upd = NOW() WHERE id_product = '6405' 12/12/2022 05:48:25 pm >> UPDATE ps_product_lang SET name = 'MENSA DIAM 40X250 - M4025', description = '' WHERE id_product = '6405' 12/12/2022 05:48:25 pm >> UPDATE ps_product SET wholesale_price = '1.35', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '6405' 12/12/2022 05:48:26 pm >> UPDATE ps_product_shop SET wholesale_price = '1.35', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '169', 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 = '6405' 12/12/2022 05:48:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '6405' 12/12/2022 05:51:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000646' AND id_product != '1936' AND ean13 != '' 12/12/2022 05:51:01 pm >> UPDATE ps_product SET id_supplier = '31', reference = '2014', ean13 = '000646', date_upd = NOW() WHERE id_product = '1936' 12/12/2022 05:51:02 pm >> UPDATE ps_product_lang SET name = 'CERETTI DIAM 26X700 ART. 400', description = '' WHERE id_product = '1936' 12/12/2022 05:51:02 pm >> UPDATE ps_product SET wholesale_price = '1.71', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '1936' 12/12/2022 05:51:02 pm >> UPDATE ps_product_shop SET wholesale_price = '1.71', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '169', 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 = '1936' 12/12/2022 05:51:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '1936' 12/12/2022 05:55:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '22FVEN4117' , '2022-12-07' , '' , '0' , '31' , '2626' , 'ZONA IND.LE PIAN DI LAURA 56043 LORENZANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '621.04' , '509.05' , NOW() , NOW() ) 12/12/2022 05:55:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77228' 12/12/2022 05:55:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '77228' 12/12/2022 05:55:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77228' , '6405' , 'MENSA DIAM 40X250 - M4025' , '150' , '150' , '1' , '3.34' , '2.7377049180328' , '22' , '50+10+3' , '266.7975' ) 12/12/2022 05:55:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6405' AND id_supplier = '31' 12/12/2022 05:55:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6405' , '31' , '1' ) 12/12/2022 05:55:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77228' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '60' , '60' , '1' , '3.42' , '2.8032786885246' , '22' , '50+10+3' , '109.2752' ) 12/12/2022 05:55:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1936' AND id_supplier = '31' 12/12/2022 05:55:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1936' , '31' , '1' ) 12/12/2022 05:55:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77228' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '300' , '300' , '1' , '1.38' , '1.1311475409836' , '22' , '50+3' , '244.9638' ) 12/12/2022 05:55:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '31' 12/12/2022 05:55:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '31' , '1' ) 12/12/2022 05:57:03 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'j7A20UNfCzzwMPrj' , NOW() , NOW() ) 12/12/2022 05:57:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3992' , '1' ) 12/12/2022 05:57:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3992' , '2' ) 12/12/2022 05:57:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3992' , '3' ) 12/12/2022 05:58:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3992' 12/12/2022 05:58:01 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3992' , '10' , '210' , 'PARR. S. TECLA ' , '' , '' , 'VIA CHIESA ' , '' , '84090' , 'MONTECORVINO PUGLIANO' , '' , '' , '' , '' , '95022040653' , NOW() , NOW() ) 12/12/2022 05:58:01 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3992' 12/12/2022 05:58:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '328' AND id_document != '76116' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-06') 12/12/2022 05:58:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '328', document_date = '2022-12-06', document_letter = '', id_customer = '3992', id_supplier = '0', id_address = '4677901', address1 = 'P. ZZA GIUSEPPE D\\\'AIUTOLO 2 84090 MONTECORVINO PUGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '100.56', price_tax_excluded = '100.56', date_upd = NOW() WHERE id_document = '76116' 12/12/2022 05:58: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 = '76116' 12/12/2022 05:58:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '76116' 12/12/2022 05:58: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 ( '76116' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 12/12/2022 05:58: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 ( '76116' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 12/12/2022 05:58: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 ( '76116' , '11191' , 'VENITE CON ME 1 PARTE' , '12' , '-12' , '4' , '2.5000' , '2.5' , '0' , '15' , '25.50' ) 12/12/2022 05:58: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 ( '76116' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '12' , '-12' , '4' , '2.4000' , '2.4' , '0' , '15' , '24.48' ) 12/12/2022 05:58: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 ( '76116' , '13397' , 'MIO GESU\'' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 12/12/2022 06:21:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '164' AND id_document != '65798' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-12') 12/12/2022 06:21:35 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '164', document_date = '2022-10-12', document_letter = '', id_customer = '3932', id_supplier = '', id_address = '4675595', address1 = 'CONTRADA TORRE VARANO 13 71010 FOCE VARANO - ISCHITELLA', address2 = '', note = '', price_shipping = '0.99', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '120.00', date_upd = NOW() WHERE id_document = '65798' 12/12/2022 06:21:35 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 = '65798' 12/12/2022 06:21:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '65798' 12/12/2022 06:21:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65798' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 12/12/2022 06:21:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 12/12/2022 06:21:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 12/12/2022 06:21:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65798' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 12/12/2022 06:21:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 12/12/2022 06:21:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 12/12/2022 06:21:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65798' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 12/12/2022 06:21:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 12/12/2022 06:21:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 12/12/2022 06:35:51 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '22V600968', document_date = '2022-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '17.34', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '605.87', price_tax_excluded = '605.87', date_upd = NOW() WHERE id_document = '52002' 12/12/2022 06:35:51 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 = '52002' 12/12/2022 06:35:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '52002' 12/12/2022 06:35:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '17032' , 'DARSI PACE - M. GUZZI' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '33' , '9.05' ) 12/12/2022 06:35:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17032' AND id_supplier = '' 12/12/2022 06:35:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17032' , '' , '1' ) 12/12/2022 06:35:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '19125' , 'LETTERE DI SAN PAOLO - B. STANDAERT' , '2' , '0' , '4' , '29.0000' , '29' , '0' , '33' , '38.86' ) 12/12/2022 06:35:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19125' AND id_supplier = '' 12/12/2022 06:35:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19125' , '' , '1' ) 12/12/2022 06:35:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '19171' , 'QUEL CRETINO DI UN CRISTIANO - M. BOTTA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 12/12/2022 06:35:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19171' AND id_supplier = '' 12/12/2022 06:35:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19171' , '' , '1' ) 12/12/2022 06:35:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '6263' , 'MARIA, DONNA DEI GIORNI NOSTRI - T.BELLO' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '13.40' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6263' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6263' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '19176' , 'CANTI NUOVI - TUROLDO/ RAVASI' , '1' , '0' , '4' , '28.0000' , '28' , '0' , '33' , '18.76' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19176' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19176' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '10430' , 'TABOR' , '1' , '0' , '4' , '17.9000' , '17.9' , '0' , '30' , '12.53' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10060' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10060' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '17753' , 'CAMMINANDO SUI PASSI DEL RISORTO - L. EPICOCO' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '33' , '6.70' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17753' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17753' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '19223' , 'vangelo' , '1' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '1.94' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19223' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19223' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '19235' , 'LA FORMAZIONE DEI CATECHISTI - F. CENTRELLA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 12/12/2022 06:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19235' AND id_supplier = '' 12/12/2022 06:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19235' , '' , '1' ) 12/12/2022 06:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52002' , '19236' , 'CATECHESI BIBLICHE SUI MISTERI DEL SANTO ROSARIO - M. ROMANO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19236' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19236' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19237' , 'PERCORSI DI FRATERNITA' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '30' , '21.00' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19237' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19237' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19238' , 'GESU IL BUON PASTORE - E, DI DANIELE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19238' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19238' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19239' , 'CAMMINO DELLA CROCE IN FAMIGLIA' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '8.40' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19239' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19239' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '2' , '0' , '4' , '39.0000' , '39' , '0' , '33' , '52.26' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '13596' , 'PREGHIERE COL GREMBIULE - TONINO BELLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13596' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13596' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19264' , 'UN PAPA PER TUTTI' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '35' , '4.88' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19264' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19264' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19265' , 'GIOIA DI ESSERE TESTIMONI' , '3' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '7.35' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19265' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19265' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19266' , 'VOLGERANNO LO SGUARDO' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '30' , '7.00' ) 12/12/2022 06:35:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19266' AND id_supplier = '' 12/12/2022 06:35:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19266' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19267' , 'SULLE ORME DEL CROCIFISSO - M. DAGOSTINO' , '3' , '0' , '4' , '5.5000' , '5.5' , '0' , '33' , '11.06' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19267' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19267' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19269' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '0' , '4' , '6.5000' , '6.5' , '0' , '33' , '4.36' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19269' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19269' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19268' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '0' , '4' , '6.5000' , '6.5' , '0' , '33' , '4.36' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19268' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19268' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19270' , 'VOCAZIONE NELLA BIBBIA - G. DE VIRGILIO' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '30' , '11.90' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19270' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19270' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19271' , 'SIGNORE MI CONDUSSE - G. SALONIA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19271' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19271' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19272' , 'BATTESIMO E IDENTITA CRISTIANA - R. PENNA' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19272' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19272' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19273' , 'ANSELM GRUN UNA SPIRITUALITA PER IL NOSTRO TEMPO- G. CAPURSO' , '1' , '0' , '4' , '8.9000' , '8.9' , '0' , '35' , '5.79' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19273' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19273' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19274' , 'CONDIVIDIAMO LA CROCE DI GESU - U. DE VANNA' , '12' , '0' , '4' , '1.8000' , '1.8' , '0' , '30' , '15.12' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19274' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19274' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19274' , 'CONDIVIDIAMO LA CROCE DI GESU - U. DE VANNA' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '100' , '0.00' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19274' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19274' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19275' , 'AMEN - MAG. 2022' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19275' , 'AMEN - MAG. 2022' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = '' 12/12/2022 06:35:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19276' , 'PAROLA E PREGHIERA - MAG. 2022' , '5' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '9.72' ) 12/12/2022 06:35:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19276' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19276' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19277' , 'INSIEME NELLA MESSA - MAG. 2022' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19277' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19277' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19278' , 'COLORIAMO LA PASQUA' , '1' , '0' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19278' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19278' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19279' , 'COLORIAMO LE PARABOLE' , '1' , '0' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19279' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19279' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19281' , 'SE IL CHICCO DI GRANO - VIA CRUCIS' , '5' , '0' , '4' , '2.8000' , '2.8' , '0' , '30' , '9.80' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19281' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19281' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '15032' , 'ABBRACCIO BENEDICENTE - H. NOUWEN' , '2' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '18.20' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15032' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15032' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '8725' , 'QUARESIMA LECTIO BREVIS' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '30' , '9.45' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8725' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8725' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '10532' , 'TEMPO PASQUALE - LECTIO BREVIS - TEMPO DI PASQUA' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '30' , '9.45' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10532' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10532' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18373' AND id_supplier = '' 12/12/2022 06:35:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18373' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19282' , 'TERRA CHE GUARISCE - P. CATTANEO' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '33' , '6.37' ) 12/12/2022 06:35:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19282' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19282' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19290' , 'PER UNA CULTURA DELLA CURA E DELLE PROTEZIONI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '33' , '8.71' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19290' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19290' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19291' , 'VENGELO DELLA PRIMA COMUNIONE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19291' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19291' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19292' , 'PRIMA COMUNIONE' , '12' , '0' , '4' , '2.9000' , '2.9' , '0' , '35' , '22.62' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19292' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19292' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19292' , 'PRIMA COMUNIONE' , '1' , '0' , '4' , '2.9000' , '2.9' , '0' , '100' , '0.00' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19292' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19292' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19293' , '10 OTTIMI MOTIVI PER CONFESSARSI - A. COMASTRI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19293' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19293' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19294' , 'SCOPRIAMO INSIEME IL VANGELO' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19294' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19294' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19295' , 'DETTI E FATTI DEI PADRI DEL DESERTO' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '30' , '4.90' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19295' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19295' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19296' , 'TUTTI IN CAMPO ' , '1' , '0' , '4' , '13.9000' , '13.9' , '0' , '30' , '9.73' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19296' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19296' , '' , '1' ) 12/12/2022 06:35: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 ( '52002' , '19297' , 'CARLO MARIA MARTINI RITRATTO SPIRITUALE - G. VIGINI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 12/12/2022 06:35:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19297' AND id_supplier = '' 12/12/2022 06:35:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19297' , '' , '1' ) 12/12/2022 06:40:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3836' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 06:40:34 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' , '3836' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 12/12/2022 06:40:34 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 = '77229' 12/12/2022 06:40:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77229' 12/12/2022 06:40:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77229' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/12/2022 06:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 12/12/2022 06:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 12/12/2022 06:45:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3837' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 06:45: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' , '3837' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.60' , '3.77' , NOW() , NOW() ) 12/12/2022 06:45: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 = '77230' 12/12/2022 06:45:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '77230' 12/12/2022 06:45: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 ( '77230' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 12/12/2022 06:45:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17276' AND id_supplier = '' 12/12/2022 06:45:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17276' , '' , '1' ) 12/12/2022 07:00:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 07:00:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3838' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '415.00' , '340.16' , NOW() , NOW() ) 12/12/2022 07:00: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 = '77231' 12/12/2022 07:00:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '77231' 12/12/2022 07:00: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 ( '77231' , '15533' , 'COMPLETO MESSA LINO 100%' , '1' , '-1' , '1' , '255.00' , '209.01639344262' , '22' , '0' , '255.00' ) 12/12/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15533' AND id_supplier = '' 12/12/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15533' , '' , '1' ) 12/12/2022 07:00: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 ( '77231' , '16964' , 'PALLA IN S/MOIRE - 7885M' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 12/12/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16964' AND id_supplier = '' 12/12/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16964' , '' , '1' ) 12/12/2022 07:00:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77231' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 12/12/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/12/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/12/2022 07:05:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3838' AND id_document != '77231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 07:05:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3838', document_date = '2022-12-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 = '415.00', price_tax_excluded = '340.16', date_upd = NOW() WHERE id_document = '77231' 12/12/2022 07:05:26 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 = '77231' 12/12/2022 07:05:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '77231' 12/12/2022 07:05:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77231' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '255' , '209.01639344262' , '22' , '0' , '255.00' ) 12/12/2022 07:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19709' AND id_supplier = '' 12/12/2022 07:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19709' , '' , '1' ) 12/12/2022 07:05:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77231' , '16964' , 'PALLA IN S/MOIRE - 7885M' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 12/12/2022 07:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16964' AND id_supplier = '' 12/12/2022 07:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16964' , '' , '1' ) 12/12/2022 07:05:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77231' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 12/12/2022 07:05:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 12/12/2022 07:05:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 12/12/2022 07:37:41 pm >> DELETE FROM ps_product WHERE id_product = '5510' 12/12/2022 07:37:41 pm >> DELETE FROM ps_product_shop WHERE id_product = '5510' 12/12/2022 07:37:41 pm >> DELETE FROM ps_product_lang WHERE id_product = '5510' 12/12/2022 07:37:41 pm >> DELETE FROM ps_stock_available WHERE id_product = '5510' 12/12/2022 07:42:21 pm >> DELETE FROM ps_product WHERE id_product = '7696' 12/12/2022 07:42:21 pm >> DELETE FROM ps_product_shop WHERE id_product = '7696' 12/12/2022 07:42:21 pm >> DELETE FROM ps_product_lang WHERE id_product = '7696' 12/12/2022 07:42:21 pm >> DELETE FROM ps_stock_available WHERE id_product = '7696' 12/12/2022 07:45:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-12') 12/12/2022 07:45:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3839' , '2022-12-12' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 12/12/2022 07:45:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77232' 12/12/2022 07:45:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '77232' 12/12/2022 07:45:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77232' , '19252' , 'CROCE MURANO FIOCCO ROSA CM 21' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 12/12/2022 07:45:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19252' AND id_supplier = '' 12/12/2022 07:45:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19252' , '' , '1' ) 12/12/2022 07:45:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77232' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/12/2022 07:45:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 12/12/2022 07:45:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' )