14/10/2022 08:45:33 am >> SELECT document_num FROM ps_document WHERE document_num = '168' AND id_document != '66335' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 14/10/2022 08:45:33 am >> UPDATE ps_document SET id_document_type = '21', document_num = '168', document_date = '2022-10-13', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '4672061', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', 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 = '119.00', price_tax_excluded = '119.00', date_upd = NOW() WHERE id_document = '66335' 14/10/2022 08:45:34 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 = '66335' 14/10/2022 08:45:34 am >> DELETE FROM ps_document_detail WHERE id_document = '66335' 14/10/2022 08:45:34 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 ( '66335' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '40' , '-40' , '4' , '3.5000' , '3.5' , '0' , '15' , '119.00' ) 14/10/2022 08:45:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 14/10/2022 08:45:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 14/10/2022 08:47:26 am >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '66332' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-13') 14/10/2022 08:47:26 am >> UPDATE ps_document SET id_document_type = '21', document_num = '167', document_date = '2022-10-13', document_letter = '', id_customer = '2787', id_supplier = '', id_address = '4670997', address1 = 'VIALE KENNEDY, 19 71013 S. GIOVANNI ROTONDO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '180.21', price_tax_excluded = '180.21', date_upd = NOW() WHERE id_document = '66332' 14/10/2022 08:47:26 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 = '66332' 14/10/2022 08:47:26 am >> DELETE FROM ps_document_detail WHERE id_document = '66332' 14/10/2022 08:47:26 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 ( '66332' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '80' , '-80' , '4' , '2.4000' , '2.4' , '0' , '15' , '163.20' ) 14/10/2022 08:47:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 14/10/2022 08:47:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 14/10/2022 08:47:26 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 ( '66332' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 14/10/2022 08:47:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 14/10/2022 08:47:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 14/10/2022 08:47:26 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 ( '66332' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 14/10/2022 08:47:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 14/10/2022 08:47:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 14/10/2022 09:12:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2915' AND id_document != '63599' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 14/10/2022 09:12:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2915', document_date = '2022-10-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.51', price_tax_excluded = '43.45', date_upd = NOW() WHERE id_document = '63599' 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63599' 14/10/2022 09:12:41 am >> DELETE FROM ps_document_detail WHERE id_document = '63599' 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' ) 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '19805' , 'DESIDERIO DESIDERAVI' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '5' , '5.70' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '13460' , 'VERITATIS GAUDIUM' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '13460' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13460' , '' , '1' ) 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '17342' , 'SCRIPTURAE SACRAE AFFECTUS ' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17342' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17342' , '' , '1' ) 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17583' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17583' , '' , '1' ) 14/10/2022 09:12:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63599' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 14/10/2022 09:12:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 14/10/2022 09:12:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 14/10/2022 09:14:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2985' AND id_document != '65751' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-10') 14/10/2022 09:14:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2985', document_date = '2022-10-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.89', price_tax_excluded = '5.89', date_upd = NOW() WHERE id_document = '65751' 14/10/2022 09:14:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65751' 14/10/2022 09:14:03 am >> DELETE FROM ps_document_detail WHERE id_document = '65751' 14/10/2022 09:14: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 ( '65751' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.94' , '2.94' , '0' , '0' , '2.94' ) 14/10/2022 09:14:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 14/10/2022 09:14:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 14/10/2022 09:14: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 ( '65751' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '2.95' , '2.95' , '0' , '0' , '2.95' ) 14/10/2022 09:14:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 14/10/2022 09:14:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 14/10/2022 09:15:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2763' AND id_document != '61837' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-17') 14/10/2022 09:15:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2763', document_date = '2022-09-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.15', price_tax_excluded = '8.07', date_upd = NOW() WHERE id_document = '61837' 14/10/2022 09:15:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61837' 14/10/2022 09:15:44 am >> DELETE FROM ps_document_detail WHERE id_document = '61837' 14/10/2022 09:15:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61837' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 14/10/2022 09:15:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 14/10/2022 09:15:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' ) 14/10/2022 09:15:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61837' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 14/10/2022 09:15:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '' 14/10/2022 09:15:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '' , '1' ) 14/10/2022 09:15:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61837' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 14/10/2022 09:15:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 14/10/2022 09:15:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 14/10/2022 09:16:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3035' AND id_document != '66338' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 14/10/2022 09:16:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3035', document_date = '2022-10-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '25.69', price_tax_excluded = '25.33', date_upd = NOW() WHERE id_document = '66338' 14/10/2022 09:16:42 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 = '66338' 14/10/2022 09:16:42 am >> DELETE FROM ps_document_detail WHERE id_document = '66338' 14/10/2022 09:16:42 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 ( '66338' , '14322' , 'RELIGIOCANDO - SACRAMENTI E MIRACOLI' , '1' , '-1' , '4' , '8.6000' , '8.6' , '0' , '5' , '8.17' ) 14/10/2022 09:16:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '14322' AND id_supplier = '' 14/10/2022 09:16:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14322' , '' , '1' ) 14/10/2022 09:16:42 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 ( '66338' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 14/10/2022 09:16:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 14/10/2022 09:16:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 14/10/2022 09:16:42 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 ( '66338' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '5' , '2.28' ) 14/10/2022 09:16:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 14/10/2022 09:16:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 14/10/2022 09:16:42 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 ( '66338' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '5.64' , '5.64' , '0' , '0' , '5.64' ) 14/10/2022 09:16:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 14/10/2022 09:16:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 14/10/2022 09:16:42 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 ( '66338' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 09:16:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 14/10/2022 09:16:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 14/10/2022 09:16:42 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 ( '66338' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 14/10/2022 09:16:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 14/10/2022 09:16:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 14/10/2022 10:28:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 10:28:09 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' , '3044' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.80' , '85.92' , NOW() , NOW() ) 14/10/2022 10:28:09 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 = '66347' 14/10/2022 10:28:09 am >> DELETE FROM ps_document_detail WHERE id_document = '66347' 14/10/2022 10:28: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 ( '66347' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '3' , '-3' , '4' , '12.00' , '12' , '0' , '5' , '34.20' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18704' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18704' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '18691' , 'IN_SEGUENDO GESU - QUADERNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15.3' , '15.3' , '0' , '0' , '15.30' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '19921' , 'AGENDA 2023 - 40809' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '5' , '6.65' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19921' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19921' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '19.00' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 14/10/2022 10:28: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 ( '66347' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 14/10/2022 10:28:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 14/10/2022 10:28:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 14/10/2022 10:32:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 10:32:42 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' , '3045' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.75' , '18.25' , NOW() , NOW() ) 14/10/2022 10:32:42 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 = '66348' 14/10/2022 10:32:42 am >> DELETE FROM ps_document_detail WHERE id_document = '66348' 14/10/2022 10:32:42 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 ( '66348' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '11' , '-11' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.75' ) 14/10/2022 10:32:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '9797' AND id_supplier = '' 14/10/2022 10:32:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9797' , '' , '1' ) 14/10/2022 10:32:42 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 ( '66348' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 14/10/2022 10:32:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/10/2022 10:32:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/10/2022 10:34:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 10:34:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3046' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 14/10/2022 10:34:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66349' 14/10/2022 10:34:05 am >> DELETE FROM ps_document_detail WHERE id_document = '66349' 14/10/2022 10:34:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66349' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '20' , '-20' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '6.00' ) 14/10/2022 10:34:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 14/10/2022 10:34:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 14/10/2022 10:52:09 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '357' 14/10/2022 10:52:09 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 ( '357' , '10' , '210' , 'PARROCCHIA S. MARIA AD MARTIRES' , '' , '' , 'VIA TORRIONE' , '' , '84100' , 'SALERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 14/10/2022 10:52:09 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '357' 14/10/2022 10:59:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3047' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 10:59:28 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' , '3047' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 14/10/2022 10:59:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66350' 14/10/2022 10:59:28 am >> DELETE FROM ps_document_detail WHERE id_document = '66350' 14/10/2022 10:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66350' , '20106' , 'GRIDIAMO IL VANGELO ANNO A - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 14/10/2022 10:59:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20106' AND id_supplier = '' 14/10/2022 10:59:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20106' , '' , '1' ) 14/10/2022 11:01:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 11:01:35 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' , '3048' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '229.00' , '228.10' , NOW() , NOW() ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66351' 14/10/2022 11:01:35 am >> DELETE FROM ps_document_detail WHERE id_document = '66351' 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '15763' , 'YOUCAT FOR KIDS' , '8' , '-8' , '4' , '14.90' , '14.9' , '0' , '5' , '113.28' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '15763' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15763' , '' , '1' ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '1883' , 'CELEBRAZIONI PER LANNO PASTORALE' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '40.42' , '40.42' , '0' , '0' , '40.42' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '10' , '-10' , '4' , '1.20' , '1.2' , '0' , '5' , '11.40' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '18610' , 'CON PAROLE AMOREVOLI - D. DE ROSA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18610' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18610' , '' , '1' ) 14/10/2022 11:01:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66351' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/10/2022 11:01:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 14/10/2022 11:01:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 14/10/2022 11:10:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 11:10:21 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' , '3049' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '21.50' , NOW() , NOW() ) 14/10/2022 11:10:21 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 = '66352' 14/10/2022 11:10:21 am >> DELETE FROM ps_document_detail WHERE id_document = '66352' 14/10/2022 11:10:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66352' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 14/10/2022 11:10:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 14/10/2022 11:10:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 14/10/2022 11:10:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66352' , '17624' , 'ADORIAMO IL SS SACRAMENTO - AVVENTO E NATALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/10/2022 11:10:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '17624' AND id_supplier = '' 14/10/2022 11:10:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17624' , '' , '1' ) 14/10/2022 11:10:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66352' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 14/10/2022 11:10:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '' 14/10/2022 11:10:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '' , '1' ) 14/10/2022 11:27:54 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '61817' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 14/10/2022 11:27:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA SAN LEONARDO', 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 = '299.59', price_tax_excluded = '272.95', date_upd = NOW() WHERE id_document = '61817' 14/10/2022 11:27:55 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 = '61817' 14/10/2022 11:27:55 am >> DELETE FROM ps_document_detail WHERE id_document = '61817' 14/10/2022 11:27:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/10/2022 11:27:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 14/10/2022 11:27:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 14/10/2022 11:27:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 14/10/2022 11:27:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 14/10/2022 11:27:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 14/10/2022 11:27:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 14/10/2022 11:27:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 14/10/2022 11:27:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 14/10/2022 11:27:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '12192' , 'CROCE BIANCA CM 11,5 - GAY MATTIOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 14/10/2022 11:27:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '12192' AND id_supplier = '' 14/10/2022 11:27:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12192' , '' , '1' ) 14/10/2022 11:27:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.95' ) 14/10/2022 11:27:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '8254' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8254' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '0' , '13/10/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '15.00' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '13103' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13103' , '' , '1' ) 14/10/2022 11:27:56 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 ( '61817' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 14/10/2022 11:27:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 14/10/2022 11:27:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 14/10/2022 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 14/10/2022 11:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 14/10/2022 11:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 14/10/2022 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19926' , 'AMEN - DIC. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 14/10/2022 11:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 14/10/2022 11:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 14/10/2022 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '0' , 'LAMPADINE' , '47' , '-47' , '4' , '1.2000' , '1.2' , '0' , '0' , '56.40' ) 14/10/2022 11:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 14/10/2022 11:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 14/10/2022 11:27:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61817' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 14/10/2022 11:27:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 14/10/2022 11:27:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 14/10/2022 11:51:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 11:51:43 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' , '3050' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.85' , '70.08' , NOW() , NOW() ) 14/10/2022 11:51:43 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 = '66353' 14/10/2022 11:51:43 am >> DELETE FROM ps_document_detail WHERE id_document = '66353' 14/10/2022 11:51:43 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 ( '66353' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '3' , '-3' , '4' , '1.40' , '1.4' , '0' , '0' , '4.20' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9586' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9586' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '28.5' , '28.5' , '0' , '0' , '28.50' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '3438' , 'DIECI COMANDAMENTI SPIEGATI AI RAGAZZI - BOCCI VALERIO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '3438' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3438' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '4168' , 'FIGLI DEL VENTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '4168' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4168' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '' , '1' ) 14/10/2022 11:51:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66353' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 14/10/2022 11:51:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 14/10/2022 11:51:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 14/10/2022 12:15:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3051' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 12:15:49 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' , '3051' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 14/10/2022 12:15:49 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 = '66354' 14/10/2022 12:15:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '66354' 14/10/2022 12:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66354' , '5929' , 'LODI E VESPRI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 14/10/2022 12:15:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5929' AND id_supplier = '' 14/10/2022 12:15:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5929' , '' , '1' ) 14/10/2022 12:22:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3052' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 12:22:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3052' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.60' , '82.62' , NOW() , NOW() ) 14/10/2022 12:22:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66355' 14/10/2022 12:22:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '66355' 14/10/2022 12:22: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 ( '66355' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '5' , '26.60' ) 14/10/2022 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20043' AND id_supplier = '' 14/10/2022 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20043' , '' , '1' ) 14/10/2022 12:22: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 ( '66355' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 14/10/2022 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20137' AND id_supplier = '' 14/10/2022 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20137' , '' , '1' ) 14/10/2022 12:22: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 ( '66355' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 14/10/2022 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 14/10/2022 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 14/10/2022 12:22: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 ( '66355' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 14/10/2022 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 14/10/2022 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 14/10/2022 12:22: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 ( '66355' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 14/10/2022 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 14/10/2022 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 14/10/2022 12:25:39 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/10/2022 12:25:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20138' , '1' , '' , 'nuovo-prodotto' ) 14/10/2022 12:25:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20138' , '1' , '1' , '2' , NOW() , NOW() ) 14/10/2022 12:25:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20138' , '0' , '1' , '0' , '0' ) 14/10/2022 12:26:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788837236717' AND id_product != '20138' AND ean13 != '' 14/10/2022 12:26:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '8/2', ean13 = '9788837236717', date_upd = NOW() WHERE id_product = '20138' 14/10/2022 12:26:24 pm >> UPDATE ps_product_lang SET name = 'SPIRITO DELLA LITURGIA - R. GUARDINI', description = '' WHERE id_product = '20138' 14/10/2022 12:26:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '20138' 14/10/2022 12:26:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '161', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20138' 14/10/2022 12:26:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '20138' 14/10/2022 12:26:24 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20138' 14/10/2022 12:26:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20139' , '1' , '' , 'nuovo-prodotto' ) 14/10/2022 12:26:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20139' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20138' 14/10/2022 12:26:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20139' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20138' 14/10/2022 12:27:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '280388' , '2022-10-14' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.50' , '195.50' , NOW() , NOW() ) 14/10/2022 12:27:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66356' 14/10/2022 12:27:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '66356' 14/10/2022 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66356' , '20138' , 'SPIRITO DELLA LITURGIA - R. GUARDINI' , '2' , '2' , '4' , '19.00' , '19' , '0' , '0' , '38.0000' ) 14/10/2022 12:27:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20138' AND id_supplier = '109' 14/10/2022 12:27:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20138' , '109' , '1' ) 14/10/2022 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66356' , '12353' , 'VERITA E SINTETICA - M. GAGLIARDI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 14/10/2022 12:27:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12353' AND id_supplier = '109' 14/10/2022 12:27:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12353' , '109' , '1' ) 14/10/2022 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66356' , '20024' , 'PER LETERNITA - R. SARAH' , '1' , '1' , '4' , '23.00' , '23' , '0' , '0' , '23.00' ) 14/10/2022 12:27:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20024' AND id_supplier = '109' 14/10/2022 12:27:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20024' , '109' , '1' ) 14/10/2022 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66356' , '8260' , 'PREGHIAMO INSIEME E DICIAMO - M. BARZIZZA' , '2' , '2' , '4' , '32.50' , '32.5' , '0' , '0' , '65.0000' ) 14/10/2022 12:27:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8260' AND id_supplier = '109' 14/10/2022 12:27:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8260' , '109' , '1' ) 14/10/2022 12:27:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66356' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '1' , '4' , '39.50' , '39.5' , '0' , '0' , '39.50' ) 14/10/2022 12:27:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 14/10/2022 12:27:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 14/10/2022 01:10:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3053' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 01:10:05 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' , '3053' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.78' , '77.86' , NOW() , NOW() ) 14/10/2022 01:10:05 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 = '66357' 14/10/2022 01:10:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '66357' 14/10/2022 01:10:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66357' , '1545' , 'CAMICE RAGLAN - CM. 160 - ART.54' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 14/10/2022 01:10:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1545' AND id_supplier = '' 14/10/2022 01:10:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1545' , '' , '1' ) 14/10/2022 01:10:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66357' , '1136' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' , '34.50' , '34.5' , '0' , '5' , '32.78' ) 14/10/2022 01:10:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1136' AND id_supplier = '' 14/10/2022 01:10:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1136' , '' , '1' ) 14/10/2022 02:42:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898264995' AND id_product != '20139' AND ean13 != '' 14/10/2022 02:42:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788898264995', date_upd = NOW() WHERE id_product = '20139' 14/10/2022 02:42:29 pm >> UPDATE ps_product_lang SET name = 'BANALITA\' DEL MALE - V. SERPE', description = '' WHERE id_product = '20139' 14/10/2022 02:42:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20139' 14/10/2022 02:42:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '174', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20139' 14/10/2022 02:42:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '20139' 14/10/2022 02:42:30 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20139' 14/10/2022 02:42:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20140' , '1' , '' , 'nuovo-prodotto' ) 14/10/2022 02:42:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20140' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20139' 14/10/2022 02:42:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20140' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20139' 14/10/2022 02:43:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2022000005531' , '2022-10-13' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.36' , '62.36' , NOW() , NOW() ) 14/10/2022 02:43:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66358' 14/10/2022 02:43:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '66358' 14/10/2022 02:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66358' , '18700' , 'DIO CAPOVOLTO - B. MAGGIONI' , '1' , '1' , '4' , '23.90' , '23.9' , '0' , '35' , '15.5350' ) 14/10/2022 02:43:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18700' AND id_supplier = '107' 14/10/2022 02:43:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18700' , '107' , '1' ) 14/10/2022 02:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66358' , '5868' , 'LINEAMENTI DI PATROLOGIA - L. DATTRINO' , '1' , '1' , '4' , '22.00' , '22' , '0' , '35' , '14.3000' ) 14/10/2022 02:43:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5868' AND id_supplier = '107' 14/10/2022 02:43:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5868' , '107' , '1' ) 14/10/2022 02:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66358' , '20139' , 'BANALITA DEL MALE - V. SERPE' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 14/10/2022 02:43:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20139' AND id_supplier = '107' 14/10/2022 02:43:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20139' , '107' , '1' ) 14/10/2022 02:43:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66358' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '24' , '24' , '4' , '1.20' , '1.2' , '0' , '35' , '18.7200' ) 14/10/2022 02:43:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 14/10/2022 02:43:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 14/10/2022 02:43:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66358' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '2' , '2' , '4' , '1.20' , '1.2' , '0' , '100' , '0.0000' ) 14/10/2022 02:43:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 14/10/2022 02:43:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 14/10/2022 02:44:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2022000005540' , '2022-10-13' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.18' , '11.18' , NOW() , NOW() ) 14/10/2022 02:44:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66359' 14/10/2022 02:44:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '66359' 14/10/2022 02:44:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66359' , '14322' , 'RELIGIOCANDO - SACRAMENTI E MIRACOLI' , '2' , '2' , '4' , '8.60' , '8.6' , '0' , '35' , '11.1800' ) 14/10/2022 02:44:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14322' AND id_supplier = '107' 14/10/2022 02:44:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14322' , '107' , '1' ) 14/10/2022 02:46:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '5530/00' , '2022-10-13' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.00' , '225.00' , NOW() , NOW() ) 14/10/2022 02:46:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7913' 14/10/2022 02:46:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '7913' 14/10/2022 02:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7913' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '10' , '10' , '4' , '10.50' , '10.5' , '0' , '0' , '105.0000' ) 14/10/2022 02:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7913' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '20' , '20' , '4' , '2.50' , '2.5' , '0' , '0' , '50.0000' ) 14/10/2022 02:46:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7913' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '20' , '20' , '4' , '1.50' , '1.5' , '0' , '0' , '30.0000' ) 14/10/2022 02:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7913' , '82' , 'LAUDATO SI' , '20' , '20' , '4' , '2.00' , '2' , '0' , '0' , '40.0000' ) 14/10/2022 03:04:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3054' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 03:04:59 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' , '3054' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 14/10/2022 03:04: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 = '66360' 14/10/2022 03:04:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '66360' 14/10/2022 03:04: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 ( '66360' , '20138' , 'SPIRITO DELLA LITURGIA - R. GUARDINI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 14/10/2022 03:04:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20138' AND id_supplier = '' 14/10/2022 03:04:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20138' , '' , '1' ) 14/10/2022 04:46:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3055' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 04:46:44 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' , '3055' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.52' , NOW() , NOW() ) 14/10/2022 04:46:44 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 = '66361' 14/10/2022 04:46:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '66361' 14/10/2022 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66361' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 14/10/2022 04:46:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 14/10/2022 04:46:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 14/10/2022 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66361' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 14/10/2022 04:46:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '' 14/10/2022 04:46:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '' , '1' ) 14/10/2022 04:46:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66361' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 14/10/2022 04:46:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10965' AND id_supplier = '' 14/10/2022 04:46:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10965' , '' , '1' ) 14/10/2022 05:20:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3056' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 05:20:44 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' , '3056' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '292.80' , '240.00' , NOW() , NOW() ) 14/10/2022 05:20:44 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 = '66362' 14/10/2022 05:20:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '66362' 14/10/2022 05:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66362' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 14/10/2022 05:20:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 14/10/2022 05:20:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 14/10/2022 05:20:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66362' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 14/10/2022 05:20:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 14/10/2022 05:20:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 14/10/2022 05:32:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3057' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 05:32:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3057' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.60' , '143.60' , NOW() , NOW() ) 14/10/2022 05:32:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66363' 14/10/2022 05:32:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '66363' 14/10/2022 05:32:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66363' , '1090' , 'BIBBIA' , '14' , '-14' , '4' , '8.9' , '8.9' , '0' , '0' , '124.60' ) 14/10/2022 05:32:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '' 14/10/2022 05:32:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '' , '1' ) 14/10/2022 05:32:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66363' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/10/2022 05:32:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '' 14/10/2022 05:32:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '' , '1' ) 14/10/2022 05:32:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66363' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2022 05:32:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 14/10/2022 05:32:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 14/10/2022 05:37:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3058' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 05:37: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' , '3058' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '297.00' , '243.44' , NOW() , NOW() ) 14/10/2022 05:37: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 = '66364' 14/10/2022 05:37:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '66364' 14/10/2022 05:37: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 ( '66364' , '1914' , 'CERA DELLA LITURGIA' , '66' , '-66' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '297.00' ) 14/10/2022 05:37:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 14/10/2022 05:37:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 14/10/2022 06:11:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3059' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 06:11: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' , '3059' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 14/10/2022 06:11: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 = '66365' 14/10/2022 06:11:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '66365' 14/10/2022 06:11: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 ( '66365' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 14/10/2022 06:11:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = '' 14/10/2022 06:11:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '' , '1' ) 14/10/2022 06:31:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2842' AND id_document != '61945' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-26') 14/10/2022 06:31:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2842', document_date = '2022-09-26', 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 = '95.00', price_tax_excluded = '95.00', date_upd = NOW() WHERE id_document = '61945' 14/10/2022 06:31:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61945' 14/10/2022 06:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '61945' 14/10/2022 06:31: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 ( '61945' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15927' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15927' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '1' , '-1' , '4' , '14.25' , '14.25' , '0' , '' , '14.25' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20043' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20043' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '' 14/10/2022 06:31:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 06:31:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '' 14/10/2022 06:31:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 06:31:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 14/10/2022 06:31:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 14/10/2022 06:31: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 ( '61945' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/10/2022 06:31:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '' 14/10/2022 06:31:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '' , '1' ) 14/10/2022 06:31:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3060' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 06:31:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3060' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.30' , '8.30' , NOW() , NOW() ) 14/10/2022 06:31:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66366' 14/10/2022 06:31:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '66366' 14/10/2022 06:31: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 ( '66366' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 14/10/2022 06:31:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20137' AND id_supplier = '' 14/10/2022 06:31:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20137' , '' , '1' ) 14/10/2022 06:31: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 ( '66366' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 14/10/2022 06:31:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 14/10/2022 06:31:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 14/10/2022 06:40:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 06:40:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3061' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 14/10/2022 06:40: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 = '66367' 14/10/2022 06:40:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '66367' 14/10/2022 06:40: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 ( '66367' , '13164' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 41' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 14/10/2022 06:40:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13164' AND id_supplier = '' 14/10/2022 06:40:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13164' , '' , '1' ) 14/10/2022 06:40: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 ( '66367' , '18239' , 'SERVIZIO MESSA - MARIANO m/l - 7051' , '1' , '-1' , '1' , '63.00' , '51.639344262295' , '22' , '0' , '63.00' ) 14/10/2022 06:40:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '' 14/10/2022 06:40:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '' , '1' ) 14/10/2022 06:44:49 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'FI85LjTJhKFdljOe' , NOW() , NOW() ) 14/10/2022 06:44:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6995' , '1' ) 14/10/2022 06:44:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6995' , '2' ) 14/10/2022 06:44:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6995' , '3' ) 14/10/2022 06:46:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6995' 14/10/2022 06:46:23 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 ( '6995' , '10' , '197' , 'PARROCCHIA DI CASALE MARITTIMO' , 'GIOVANNINI' , 'DON GIULIANO' , 'VIA DEL CASTELLO' , '' , '56040' , 'CASALE MARITTIMO' , '' , '' , '3315339009' , '' , '83003410509' , NOW() , NOW() ) 14/10/2022 06:46:23 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6995' 14/10/2022 06:46:54 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6995' 14/10/2022 06:46:54 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 ( '6995' , '10' , '197' , 'PARROCCHIA DI CASALE MARITTIMO' , 'GIOVANNINI' , 'DON GIULIANO' , 'VIA DEL CASTELLO' , '' , '56040' , 'CASALE MARITTIMO' , '' , '' , '3315339009' , '' , '83003410509' , NOW() , NOW() ) 14/10/2022 06:46:54 pm >> UPDATE ps_customer SET email = 'dengiuliano@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6995' 14/10/2022 06:48:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 06:48:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '97' , '2022-10-14' , '' , '6995' , '0' , '88682001' , 'VIA DEL CASTELLO 56040 CASALE MARITTIMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.25' , '38.25' , NOW() , NOW() ) 14/10/2022 06:48:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7914' 14/10/2022 06:48:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '7914' 14/10/2022 06:48: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 ( '7914' , '75' , 'IL SEGNO DELLA CROCE' , '10' , '-10' , '4' , '1.50' , '1.5' , '0' , '15' , '12.75' ) 14/10/2022 06:48: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 ( '7914' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '-10' , '4' , '1.50' , '1.5' , '0' , '15' , '12.75' ) 14/10/2022 06:48: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 ( '7914' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '10' , '-10' , '4' , '1.50' , '1.5' , '0' , '15' , '12.75' ) 14/10/2022 07:24:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 14/10/2022 07:24:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3062' , '2022-10-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.55' , '25.55' , NOW() , NOW() ) 14/10/2022 07:24:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66368' 14/10/2022 07:24:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '66368' 14/10/2022 07:24:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66368' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 14/10/2022 07:24:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '' 14/10/2022 07:24:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '' , '1' ) 14/10/2022 07:24:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66368' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 14/10/2022 07:24:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 14/10/2022 07:24:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 14/10/2022 07:24:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66368' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 14/10/2022 07:24:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 14/10/2022 07:24:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 14/10/2022 07:24:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66368' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 14/10/2022 07:24:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 14/10/2022 07:24:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 14/10/2022 07:24:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66368' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 14/10/2022 07:24:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 14/10/2022 07:24:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 14/10/2022 07:41:46 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3409' 14/10/2022 07:41:46 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 ( '3409' , '10' , '232' , '' , 'DON GIUSEPPE' , 'PERNIGOTTI' , 'VIA VALLE DEI PRINCIPI 9' , '' , '01034' , 'FABRICA DI ROMA' , '' , '' , '3392466613' , '' , '90015920565 ' , NOW() , NOW() ) 14/10/2022 07:41:46 pm >> UPDATE ps_customer SET email = 'pernigotti43@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3409' 14/10/2022 07:43:59 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3409' 14/10/2022 07:43:59 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 ( '3409' , '10' , '232' , '' , 'DON GIUSEPPE' , 'PERNIGOTTI' , 'VIA VALLE DEI PRINCIPI 9' , '' , '01034' , 'FABRICA DI ROMA' , '' , '' , '3392466613' , '' , '90015920565 ' , NOW() , NOW() ) 14/10/2022 07:43:59 pm >> UPDATE ps_customer SET email = 'pernigotti43@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3409'