25/10/2022 09:12:16 am >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 25/10/2022 09:12:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '102.40', price_tax_excluded = '102.40', date_upd = NOW() WHERE id_document = '61794' 25/10/2022 09:12:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61794' 25/10/2022 09:12:16 am >> DELETE FROM ps_document_detail WHERE id_document = '61794' 25/10/2022 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 25/10/2022 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '' 25/10/2022 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '' , '1' ) 25/10/2022 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 25/10/2022 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19929' AND id_supplier = '' 25/10/2022 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19929' , '' , '1' ) 25/10/2022 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 25/10/2022 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20036' AND id_supplier = '' 25/10/2022 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20036' , '' , '1' ) 25/10/2022 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19125' , 'LETTERE DI SAN PAOLO - B. STANDAERT' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 25/10/2022 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19125' AND id_supplier = '' 25/10/2022 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19125' , '' , '1' ) 25/10/2022 09:12:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20209' , 'CHIESA CHE FAREMO - P. CURTAZ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 25/10/2022 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '20209' AND id_supplier = '' 25/10/2022 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20209' , '' , '1' ) 25/10/2022 09:12:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19741' , 'PARLARE CON DIO - J. MARTIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 25/10/2022 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19741' AND id_supplier = '' 25/10/2022 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19741' , '' , '1' ) 25/10/2022 09:12:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 25/10/2022 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '' 25/10/2022 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '' , '1' ) 25/10/2022 10:05:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3174' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:05:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3174' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 25/10/2022 10:05: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 = '68597' 25/10/2022 10:05:44 am >> DELETE FROM ps_document_detail WHERE id_document = '68597' 25/10/2022 10:05: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 ( '68597' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 25/10/2022 10:05:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 25/10/2022 10:05:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 25/10/2022 10:06:22 am >> DELETE FROM ps_document WHERE id_document = '68597' 25/10/2022 10:06:22 am >> DELETE FROM ps_document_detail WHERE id_document = '68597' 25/10/2022 10:06:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3174' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:06: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' , '3174' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 25/10/2022 10:06: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 = '68598' 25/10/2022 10:06:43 am >> DELETE FROM ps_document_detail WHERE id_document = '68598' 25/10/2022 10:06: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 ( '68598' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 25/10/2022 10:06:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 25/10/2022 10:06:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 25/10/2022 10:08:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:08:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3175' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '44.00' , NOW() , NOW() ) 25/10/2022 10:08:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68599' 25/10/2022 10:08:16 am >> DELETE FROM ps_document_detail WHERE id_document = '68599' 25/10/2022 10:08:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68599' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.95' , '16.95' , '0' , '0' , '16.95' ) 25/10/2022 10:08:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 25/10/2022 10:08:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 25/10/2022 10:08:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68599' , '15122' , 'PREGHIERE PER OGNI GIORNO DELLANNO - 8738' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 25/10/2022 10:08:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15122' AND id_supplier = '' 25/10/2022 10:08:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15122' , '' , '1' ) 25/10/2022 10:08:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68599' , '19745' , 'BUON COMPLEANNO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 25/10/2022 10:08:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19745' AND id_supplier = '' 25/10/2022 10:08:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19745' , '' , '1' ) 25/10/2022 10:08:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68599' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '100' , '0.00' ) 25/10/2022 10:08:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '9799' AND id_supplier = '' 25/10/2022 10:08:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9799' , '' , '1' ) 25/10/2022 10:08:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68599' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '17' , '17' , '0' , '0' , '17.00' ) 25/10/2022 10:08:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 25/10/2022 10:08:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 25/10/2022 10:10:41 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-10-17' WHERE id_order = '387' 25/10/2022 10:10:41 am >> DELETE FROM ps_document WHERE document_num = '387' AND id_document_type = '28' 25/10/2022 10:10:53 am >> UPDATE ps_orders SET current_state = '6', delivery_date = '2022-10-17' WHERE id_order = '388' 25/10/2022 10:14:06 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-10-18' WHERE id_order = '389' 25/10/2022 10:14:06 am >> DELETE FROM ps_document WHERE document_num = '389' AND id_document_type = '28' 25/10/2022 10:15:27 am >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:15:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '207' , '2022-10-25' , '' , '3949' , '' , '4676191' , 'Via PierSanti Mattarella , 3 95036 Randazzo ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '86.50' , '86.50' , NOW() , NOW() ) 25/10/2022 10:15:27 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 = '68600' 25/10/2022 10:15:27 am >> DELETE FROM ps_document_detail WHERE id_document = '68600' 25/10/2022 10:15:27 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 ( '68600' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 25/10/2022 10:15:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 25/10/2022 10:15:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 25/10/2022 10:15:27 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 ( '68600' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '5' , '30.40' ) 25/10/2022 10:15:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '9677' AND id_supplier = '' 25/10/2022 10:15:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9677' , '' , '1' ) 25/10/2022 10:15:27 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 ( '68600' , '11183' , 'VENITE CON ME - GUIDA' , '7' , '-7' , '4' , '6.0000' , '6' , '0' , '5' , '39.90' ) 25/10/2022 10:15:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 25/10/2022 10:15:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 25/10/2022 10:15:27 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 ( '68600' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '0' , '1' , '1' , '' , '5' , '7.60' ) 25/10/2022 10:15:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 25/10/2022 10:15:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 25/10/2022 10:15:27 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 ( '68600' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 25/10/2022 10:15:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 25/10/2022 10:15:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 25/10/2022 10:15:46 am >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '68600' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:15:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '207', document_date = '2022-10-25', document_letter = '', id_customer = '3949', id_supplier = '', id_address = '4676191', address1 = 'Via PierSanti Mattarella , 3 95036 Randazzo ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '86.50', price_tax_excluded = '86.50', date_upd = NOW() WHERE id_document = '68600' 25/10/2022 10:15:46 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 = '68600' 25/10/2022 10:15:46 am >> DELETE FROM ps_document_detail WHERE id_document = '68600' 25/10/2022 10:15:46 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 ( '68600' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 25/10/2022 10:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 25/10/2022 10:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 25/10/2022 10:15:46 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 ( '68600' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '5' , '30.40' ) 25/10/2022 10:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '9677' AND id_supplier = '' 25/10/2022 10:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9677' , '' , '1' ) 25/10/2022 10:15:46 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 ( '68600' , '11183' , 'VENITE CON ME - GUIDA' , '7' , '-7' , '4' , '6.0000' , '6' , '0' , '5' , '39.90' ) 25/10/2022 10:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 25/10/2022 10:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 25/10/2022 10:15:46 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 ( '68600' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '0' , '1.0000' , '1' , '0' , '5' , '7.60' ) 25/10/2022 10:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 25/10/2022 10:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 25/10/2022 10:15:46 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 ( '68600' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 25/10/2022 10:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 25/10/2022 10:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 25/10/2022 10:16:15 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-10-23' WHERE id_order = '390' 25/10/2022 10:16:15 am >> DELETE FROM ps_document WHERE document_num = '390' AND id_document_type = '28' 25/10/2022 10:16:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:16:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3176' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 25/10/2022 10:16:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68601' 25/10/2022 10:16:54 am >> DELETE FROM ps_document_detail WHERE id_document = '68601' 25/10/2022 10:16:54 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 ( '68601' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 25/10/2022 10:16:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 25/10/2022 10:16:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 25/10/2022 10:18:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/10/2022 10:18:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20237' , '1' , '' , 'nuovo-prodotto' ) 25/10/2022 10:18:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20237' , '1' , '1' , '2' , NOW() , NOW() ) 25/10/2022 10:18:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20237' , '0' , '1' , '0' , '0' ) 25/10/2022 10:19:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870246' AND id_product != '20237' AND ean13 != '' 25/10/2022 10:19:10 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788892870246', date_upd = NOW() WHERE id_product = '20237' 25/10/2022 10:19:10 am >> UPDATE ps_product_lang SET name = 'siate felici - papa francesco', description = '' WHERE id_product = '20237' 25/10/2022 10:19:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '20237' 25/10/2022 10:19:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '26', 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 = '20237' 25/10/2022 10:19:10 am >> DELETE FROM ps_specific_price WHERE id_product = '20237' 25/10/2022 10:19:11 am >> 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 = '20237' 25/10/2022 10:19:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20238' , '1' , '' , 'nuovo-prodotto' ) 25/10/2022 10:19:11 am >> 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 '20238' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20237' 25/10/2022 10:19:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20238' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20237' 25/10/2022 10:20:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881239665' AND id_product != '20238' AND ean13 != '' 25/10/2022 10:20:20 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788881239665', date_upd = NOW() WHERE id_product = '20238' 25/10/2022 10:20:20 am >> UPDATE ps_product_lang SET name = 'saranno testimoni - w. cazzaniga', description = '' WHERE id_product = '20238' 25/10/2022 10:20:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '20238' 25/10/2022 10:20:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '57', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20238' 25/10/2022 10:20:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20238' 25/10/2022 10:20:22 am >> 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 = '20238' 25/10/2022 10:20:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20239' , '1' , '' , 'nuovo-prodotto' ) 25/10/2022 10:20:22 am >> 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 '20239' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20238' 25/10/2022 10:20:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20239' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20238' 25/10/2022 10:21:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881239665' AND id_product != '20238' AND ean13 != '' 25/10/2022 10:21:11 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788881239665', date_upd = NOW() WHERE id_product = '20238' 25/10/2022 10:21:11 am >> UPDATE ps_product_lang SET name = 'SARANNO TESTIMONI - W. CAZZANIGA', description = '' WHERE id_product = '20238' 25/10/2022 10:21:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5000' WHERE id_product = '20238' 25/10/2022 10:21:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5000', id_tax_rules_group = '4', id_category_default = '57', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20238' 25/10/2022 10:21:11 am >> DELETE FROM ps_specific_price WHERE id_product = '20238' 25/10/2022 10:23:46 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 ( '33' , '612729' , '2022-10-25' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.83' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.54' , '135.54' , NOW() , NOW() ) 25/10/2022 10:23:46 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 = '68602' 25/10/2022 10:23:46 am >> DELETE FROM ps_document_detail WHERE id_document = '68602' 25/10/2022 10:23:46 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 ( '68602' , '20237' , 'siate felici - papa francesco' , '2' , '2' , '4' , '17.00' , '17' , '0' , '30' , '23.8000' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20237' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20237' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18064' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18064' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '20238' , 'SARANNO TESTIMONI - W. CAZZANIGA' , '2' , '2' , '4' , '8.50' , '8.5' , '0' , '30' , '11.9000' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20238' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20238' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '19741' , 'PARLARE CON DIO - J. MARTIN' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19741' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19741' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '19333' , 'LORO VOCE PERCORRE LA TERRA - A.M. CANOPI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19333' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19333' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '19931' , '100 IDEE PER IL CATECHISMO' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '30' , '10.4300' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19931' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19931' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '20104' , 'BIBBIA DA COLORARE' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20104' AND id_supplier = '7' 25/10/2022 10:23:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20104' , '7' , '1' ) 25/10/2022 10:23:46 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 ( '68602' , '10430' , 'TABOR' , '1' , '1' , '4' , '17.90' , '17.9' , '0' , '30' , '12.5300' ) 25/10/2022 10:23:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 25/10/2022 10:23:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 25/10/2022 10:23:47 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 ( '68602' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 25/10/2022 10:23:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 25/10/2022 10:23:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 25/10/2022 10:23:47 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 ( '68602' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 25/10/2022 10:23:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '7' 25/10/2022 10:23:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '7' , '1' ) 25/10/2022 10:25:34 am >> SELECT document_num FROM ps_document WHERE document_num = '208' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:25:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '208' , '2022-10-25' , '' , '1127' , '0' , '4672060' , 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '57.07' , '57.07' , NOW() , NOW() ) 25/10/2022 10:25: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 = '68603' 25/10/2022 10:25:34 am >> DELETE FROM ps_document_detail WHERE id_document = '68603' 25/10/2022 10:25: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 ( '68603' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.22' ) 25/10/2022 10:25: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 ( '68603' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 25/10/2022 10:25: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 ( '68603' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 25/10/2022 10:25: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 ( '68603' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 25/10/2022 10:25: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 ( '68603' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '15' , '-15' , '4' , '1.60' , '1.6' , '0' , '15' , '20.40' ) 25/10/2022 10:28:43 am >> SELECT document_num FROM ps_document WHERE document_num = '209' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:28: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 ( '21' , '209' , '2022-10-25' , '' , '1127' , '0' , '4672060' , 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.07' , '92.07' , NOW() , NOW() ) 25/10/2022 10:28: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 = '68604' 25/10/2022 10:28:43 am >> DELETE FROM ps_document_detail WHERE id_document = '68604' 25/10/2022 10:28: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 ( '68604' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 25/10/2022 10:28: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 ( '68604' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '5' , '20.90' ) 25/10/2022 10:28: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 ( '68604' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '15' , '8.50' ) 25/10/2022 10:28: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 ( '68604' , '11193' , 'VENITE CON ME CAT.' , '3' , '-3' , '4' , '5.50' , '5.5' , '0' , '5' , '15.67' ) 25/10/2022 10:28: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 ( '68604' , '11191' , 'VENITE CON ME 1 PARTE' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '15' , '8.50' ) 25/10/2022 10:28: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 ( '68604' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '4' , '-4' , '4' , '2.40' , '2.4' , '0' , '15' , '8.16' ) 25/10/2022 10:28: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 ( '68604' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '7' , '-7' , '4' , '1.60' , '1.6' , '0' , '15' , '9.52' ) 25/10/2022 10:44:36 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3501' 25/10/2022 10:44:36 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 ( '3501' , '10' , '210' , 'PARROCCHIA S. EUSTACHIO' , 'ROCA' , 'DON GIUSEPPE' , 'PIAZZA S. EUSTACCHIO' , '' , '84096' , 'MONTECORVINO ROVELLA' , '' , '' , '3938576296' , '' , '' , NOW() , NOW() ) 25/10/2022 10:44:36 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3501' 25/10/2022 10:45:21 am >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 10:45: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 ( '24' , '84/A' , '2022-10-25' , 'A' , '3501' , '0' , '4676192' , 'PIAZZA S. EUSTACCHIO 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '108.00' , NOW() , NOW() ) 25/10/2022 10:45: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 = '68605' 25/10/2022 10:45:21 am >> DELETE FROM ps_document_detail WHERE id_document = '68605' 25/10/2022 10:45: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 ( '68605' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '21' , '-21' , '4' , '2.7' , '2.7' , '0' , '' , '56.70' ) 25/10/2022 10:45: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 ( '68605' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '19' , '-19' , '4' , '2.7' , '2.7' , '0' , '0' , '51.30' ) 25/10/2022 11:28:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3177' AND id_document != '' AND id_document_type LIKE '15' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 11:28:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3177' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.10' , '55.10' , NOW() , NOW() ) 25/10/2022 11:28: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 = '68606' 25/10/2022 11:28:44 am >> DELETE FROM ps_document_detail WHERE id_document = '68606' 25/10/2022 11:28: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 ( '68606' , '16392' , 'ALLA SCUOLA DEL VANGELO DI MATTEO - ANNO A - D. PETTI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 25/10/2022 11:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16392' AND id_supplier = '' 25/10/2022 11:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16392' , '' , '1' ) 25/10/2022 11:28: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 ( '68606' , '18311' , 'ANDATE E FATE IN MODO ... ANNO A - E. DELLA CORTE' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '5' , '25.65' ) 25/10/2022 11:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '18311' AND id_supplier = '' 25/10/2022 11:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18311' , '' , '1' ) 25/10/2022 11:28: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 ( '68606' , '19084' , 'OMELIE E PREDICAZIONE - CAVOLO/SODI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/10/2022 11:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19084' AND id_supplier = '' 25/10/2022 11:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19084' , '' , '1' ) 25/10/2022 11:30:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 11:30: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' , '3178' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.80' , '63.50' , NOW() , NOW() ) 25/10/2022 11:30: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 = '68607' 25/10/2022 11:30:28 am >> DELETE FROM ps_document_detail WHERE id_document = '68607' 25/10/2022 11:30: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 ( '68607' , '19938' , 'AGENDA 2023 SAN PAOLO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 25/10/2022 11:30:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 25/10/2022 11:30:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 25/10/2022 11:30:29 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 ( '68607' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '100' , '0.00' ) 25/10/2022 11:30:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 25/10/2022 11:30:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 25/10/2022 11:30:29 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 ( '68607' , '16177' , 'ROSARIO PER I DEFUNTI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 25/10/2022 11:30:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16177' AND id_supplier = '' 25/10/2022 11:30:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16177' , '' , '1' ) 25/10/2022 11:30:29 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 ( '68607' , '6964' , 'NELLA CASA DEL PADRE - FEDELI' , '2' , '-2' , '4' , '8.90' , '8.9' , '0' , '5' , '16.92' ) 25/10/2022 11:30:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '6964' AND id_supplier = '' 25/10/2022 11:30:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6964' , '' , '1' ) 25/10/2022 11:30:29 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 ( '68607' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '-2' , '1' , '15.80' , '12.950819672131' , '22' , '0' , '31.60' ) 25/10/2022 11:30:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 25/10/2022 11:30:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 25/10/2022 11:33:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 11:33:00 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' , '3179' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.00' , '151.64' , NOW() , NOW() ) 25/10/2022 11:33:00 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 = '68608' 25/10/2022 11:33:00 am >> DELETE FROM ps_document_detail WHERE id_document = '68608' 25/10/2022 11:33:00 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 ( '68608' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '58.25' , '47.745901639344' , '22' , '0' , '58.25' ) 25/10/2022 11:33:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 25/10/2022 11:33:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 25/10/2022 11:33:00 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 ( '68608' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 25/10/2022 11:33:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '' 25/10/2022 11:33:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '' , '1' ) 25/10/2022 11:33:00 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 ( '68608' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 25/10/2022 11:33:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '18682' AND id_supplier = '' 25/10/2022 11:33:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18682' , '' , '1' ) 25/10/2022 11:33:00 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 ( '68608' , '2305' , 'CLERGY GRIGIO ML - COTONE 41 ' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '15' , '38.25' ) 25/10/2022 11:33:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '2305' AND id_supplier = '' 25/10/2022 11:33:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2305' , '' , '1' ) 25/10/2022 11:44:39 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '4aVXfumO6VwKbvU7' , NOW() , NOW() ) 25/10/2022 11:45:11 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'XCgJ431dGpt3X0F5' , NOW() , NOW() ) 25/10/2022 11:45:11 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3950' , '1' ) 25/10/2022 11:45:11 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3950' , '2' ) 25/10/2022 11:45:11 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3950' , '3' ) 25/10/2022 11:47:42 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3950' 25/10/2022 11:47:42 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 ( '3950' , '10' , '130' , 'PARR. S. MARIA MAGGIORE E S. MARCELLINO' , 'LORO' , 'P. TARCISIO ' , 'P. ZZA A. DE GASPERI ' , '' , '83040' , 'LUOGOSANO' , '' , '' , '3408295294' , '' , '' , NOW() , NOW() ) 25/10/2022 11:47:42 am >> UPDATE ps_customer SET email = 'tarcisio_loro@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3950' 25/10/2022 11:48:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3950' 25/10/2022 11:48:12 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 ( '3950' , '10' , '130' , 'PARR. S. MARIA MAGGIORE E S. MARCELLINO' , 'LORO' , 'P. TARCISIO ' , 'P. ZZA A. DE GASPERI ' , '' , '83040' , 'LUOGOSANO' , '' , '' , '3408295294' , '' , '92014980640' , NOW() , NOW() ) 25/10/2022 11:48:12 am >> UPDATE ps_customer SET email = 'tarcisio_loro@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3950' 25/10/2022 11:57:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 11:57:55 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' , '3180' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 25/10/2022 11:57: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 = '68609' 25/10/2022 11:57:55 am >> DELETE FROM ps_document_detail WHERE id_document = '68609' 25/10/2022 11:57: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 ( '68609' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 25/10/2022 11:57:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 25/10/2022 11:57:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 25/10/2022 12:02:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '210' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 12:02:04 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' , '210' , '2022-10-25' , '' , '3950' , '0' , '4676193' , 'P. ZZA A. DE GASPERI 83040 LUOGOSANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '167.99' , '167.99' , NOW() , NOW() ) 25/10/2022 12:02:04 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 = '68610' 25/10/2022 12:02:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '68610' 25/10/2022 12:02:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 25/10/2022 12:02:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 12:02:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 25/10/2022 12:02:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 12:02: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 ( '68610' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 12:02: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 ( '68610' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 25/10/2022 12:02: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 ( '68610' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '15' , '0.85' ) 25/10/2022 12:02: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 ( '68610' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '15' , '7.65' ) 25/10/2022 12:02: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 ( '68610' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '15' , '7.65' ) 25/10/2022 12:02: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 ( '68610' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '15' , '7.65' ) 25/10/2022 12:02: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 ( '68610' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 12:02: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 ( '68610' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '15' , '2.89' ) 25/10/2022 12:02: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 ( '68610' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '15' , '2.89' ) 25/10/2022 12:02: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 ( '68610' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 25/10/2022 12:02: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 ( '68610' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 25/10/2022 12:02: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 ( '68610' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 25/10/2022 12:02: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 ( '68610' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 25/10/2022 12:02: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 ( '68610' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 25/10/2022 12:02: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 ( '68610' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 12:02: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 ( '68610' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '6' , '-6' , '4' , '1.90' , '1.9' , '0' , '15' , '9.69' ) 25/10/2022 12:02: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 ( '68610' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '6' , '-6' , '4' , '0.90' , '0.9' , '0' , '15' , '4.59' ) 25/10/2022 12:02: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 ( '68610' , '475' , 'AMICO GESÙ - FIGURINE' , '60' , '-60' , '4' , '0.50' , '0.5' , '0' , '15' , '25.50' ) 25/10/2022 12:02: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 ( '68610' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 12:02: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 ( '68610' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 12:02: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 ( '68610' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 12:02: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 ( '68610' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '15' , '1.27' ) 25/10/2022 12:02: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 ( '68610' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '15' , '1.27' ) 25/10/2022 12:02: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 ( '68610' , '9815' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '15' , '1.27' ) 25/10/2022 12:02: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 ( '68610' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 12:02: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 ( '68610' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 25/10/2022 12:02: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 ( '68610' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 25/10/2022 12:02: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 ( '68610' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 25/10/2022 12:02: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 ( '68610' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 25/10/2022 12:02: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 ( '68610' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 25/10/2022 12:02: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 ( '68610' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 25/10/2022 12:02: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 ( '68610' , '14486' , 'SEMPRE CON TE ' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '15' , '12.75' ) 25/10/2022 12:02: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 ( '68610' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '-6' , '4' , '1.00' , '1' , '0' , '15' , '5.10' ) 25/10/2022 12:03:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 12:03:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3181' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.21' , '23.64' , NOW() , NOW() ) 25/10/2022 12:03:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68611' 25/10/2022 12:03:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '68611' 25/10/2022 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68611' , '13871' , 'IL SIGNORE E CON ME - CD' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '5' , '11.88' ) 25/10/2022 12:03:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13871' AND id_supplier = '' 25/10/2022 12:03:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13871' , '' , '1' ) 25/10/2022 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68611' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 25/10/2022 12:03:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18051' AND id_supplier = '' 25/10/2022 12:03:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18051' , '' , '1' ) 25/10/2022 12:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68611' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 25/10/2022 12:03:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 25/10/2022 12:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 25/10/2022 12:03:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68611' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/10/2022 12:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 25/10/2022 12:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 25/10/2022 12:05:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 12:05:03 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' , '3182' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 25/10/2022 12:05:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68612' 25/10/2022 12:05:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '68612' 25/10/2022 12:05: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 ( '68612' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 25/10/2022 12:05:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/10/2022 12:05:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/10/2022 12:41:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 12:41:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3183' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.27' , '51.84' , NOW() , NOW() ) 25/10/2022 12:41:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68613' 25/10/2022 12:41:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '68613' 25/10/2022 12:41:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68613' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '-2' , '4' , '2.25' , '2.25' , '0' , '0' , '4.50' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.25' , '2.25' , '0' , '0' , '4.50' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '5' , '19.00' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12849' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12849' , '' , '1' ) 25/10/2022 12:41: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 ( '68613' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 25/10/2022 12:41:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '' 25/10/2022 12:41:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '' , '1' ) 25/10/2022 12:42:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 12:42: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' , '3184' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 25/10/2022 12:42: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 = '68614' 25/10/2022 12:42:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '68614' 25/10/2022 12:42: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 ( '68614' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 25/10/2022 12:42:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 25/10/2022 12:42:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 25/10/2022 12:45:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3185' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 12:45:27 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' , '3185' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 25/10/2022 12:45:27 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 = '68615' 25/10/2022 12:45:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '68615' 25/10/2022 12:45:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68615' , '12858' , 'ANTONIO DI PADOVA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 25/10/2022 12:45:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12858' AND id_supplier = '' 25/10/2022 12:45:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12858' , '' , '1' ) 25/10/2022 12:45:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68615' , '18236' , 'SANTANTONIO DI PADOVA - G. SACINO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 25/10/2022 12:45:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18236' AND id_supplier = '' 25/10/2022 12:45:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18236' , '' , '1' ) 25/10/2022 03:04:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '209' AND id_document != '68604' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 03:04:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '209', document_date = '2022-10-25', document_letter = '', id_customer = '1127', id_supplier = '', id_address = '4672060', address1 = 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '92.07', price_tax_excluded = '92.07', date_upd = NOW() WHERE id_document = '68604' 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68604' 25/10/2022 03:04:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '68604' 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '15' , '8.50' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '11193' , 'VENITE CON ME CAT.' , '3' , '-3' , '4' , '5.5000' , '5.5' , '0' , '5' , '15.67' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '11191' , 'VENITE CON ME 1 PARTE' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '15' , '8.50' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '4' , '-4' , '4' , '2.4000' , '2.4' , '0' , '15' , '8.16' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 25/10/2022 03:04:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68604' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '7' , '-7' , '4' , '1.6000' , '1.6' , '0' , '15' , '9.52' ) 25/10/2022 03:04:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 25/10/2022 03:04:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 25/10/2022 03:30:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 03:30:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3186' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 25/10/2022 03:30:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68616' 25/10/2022 03:30:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '68616' 25/10/2022 03:30:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68616' , '18561' , 'FORMELLA SAGOMATA 26X26 - TENERO ABBRACCIO 1025130' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 25/10/2022 03:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18561' AND id_supplier = '' 25/10/2022 03:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18561' , '' , '1' ) 25/10/2022 03:30:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68616' , '17941' , 'LOURDES - ISONZO 119 bis' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 25/10/2022 03:30:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17941' AND id_supplier = '' 25/10/2022 03:30:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17941' , '' , '1' ) 25/10/2022 03:32:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3187' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 03:32: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' , '3187' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.21' , '69.21' , NOW() , NOW() ) 25/10/2022 03:32: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 = '68617' 25/10/2022 03:32:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '68617' 25/10/2022 03:32: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 ( '68617' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '19029' , 'BEATA COLEI CHE HA CREDUTO - G. MASPERO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19029' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19029' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '4.25' , '4.25' , '0' , '0' , '4.25' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '20110' , 'BRACE LEGNA SOFFIO - DOTTI/ALDEGANI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20110' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20110' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 25/10/2022 03:32:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 25/10/2022 03:32: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 ( '68617' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 25/10/2022 03:32:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 25/10/2022 03:32:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 25/10/2022 03:38:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 03:38: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' , '3188' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.50' , '160.25' , NOW() , NOW() ) 25/10/2022 03:38: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 = '68618' 25/10/2022 03:38:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '68618' 25/10/2022 03:38: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 ( '68618' , '15647' , 'CLERGY CELESTE - 100% - 42 - 160/10' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 25/10/2022 03:38:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15647' AND id_supplier = '' 25/10/2022 03:38:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15647' , '' , '1' ) 25/10/2022 03:38: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 ( '68618' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 25/10/2022 03:38:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 25/10/2022 03:38:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 25/10/2022 03:38: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 ( '68618' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 25/10/2022 03:38:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 25/10/2022 03:38:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 25/10/2022 03:38: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 ( '68618' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 25/10/2022 03:38:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19397' AND id_supplier = '' 25/10/2022 03:38:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19397' , '' , '1' ) 25/10/2022 03:38: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 ( '68618' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/10/2022 03:38:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 25/10/2022 03:38:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 25/10/2022 03:41:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '85/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 03:41:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '85/A' , '2022-10-25' , 'A' , '3812' , '0' , '4672633' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.40' , NOW() , NOW() ) 25/10/2022 03:41:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68619' 25/10/2022 03:41:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '68619' 25/10/2022 03:41:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68619' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 25/10/2022 03:51:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '210' AND id_document != '68610' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 03:51:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '210', document_date = '2022-10-25', document_letter = '', id_customer = '3950', id_supplier = '', id_address = '4676193', address1 = 'P. ZZA A. DE GASPERI 83040 LUOGOSANO', 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 = '167.99', price_tax_excluded = '167.99', date_upd = NOW() WHERE id_document = '68610' 25/10/2022 03:51:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68610' 25/10/2022 03:51:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '68610' 25/10/2022 03:51:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 03:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 25/10/2022 03:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 25/10/2022 03:51:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 03:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 25/10/2022 03:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 25/10/2022 03:51:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '15' , '0.85' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '15' , '7.65' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '15' , '7.65' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = '' 25/10/2022 03:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' ) 25/10/2022 03:51:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68610' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '15' , '7.65' ) 25/10/2022 03:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = '' 25/10/2022 03:51:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 03:51:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 25/10/2022 03:51:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 25/10/2022 03:51:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8510' AND id_supplier = '' 25/10/2022 03:51:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8510' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 25/10/2022 03:51:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8511' AND id_supplier = '' 25/10/2022 03:51:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8511' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 25/10/2022 03:51:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 25/10/2022 03:51:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 25/10/2022 03:51:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4479' AND id_supplier = '' 25/10/2022 03:51:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4479' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13956' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13956' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '6' , '-6' , '4' , '1.9000' , '1.9' , '0' , '15' , '9.69' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '6' , '-6' , '4' , '0.9000' , '0.9' , '0' , '15' , '4.59' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7824' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7824' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '475' , 'AMICO GESÙ - FIGURINE' , '60' , '-60' , '4' , '0.5000' , '0.5' , '0' , '15' , '25.50' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '475' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '475' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18597' AND id_supplier = '' 25/10/2022 03:51:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18597' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 03:51:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14145' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14145' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '15' , '1.27' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '15' , '1.27' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '9815' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '15' , '1.27' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9815' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9815' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16199' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16199' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 25/10/2022 03:51:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17350' AND id_supplier = '' 25/10/2022 03:51:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17350' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '15318' , 'PERDONAMI SIGNORE ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 25/10/2022 03:51:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15318' AND id_supplier = '' 25/10/2022 03:51:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15318' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 25/10/2022 03:51:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15602' AND id_supplier = '' 25/10/2022 03:51:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15602' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '14486' , 'SEMPRE CON TE ' , '6' , '-6' , '4' , '2.5000' , '2.5' , '0' , '15' , '12.75' ) 25/10/2022 03:51:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14486' AND id_supplier = '' 25/10/2022 03:51:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14486' , '' , '1' ) 25/10/2022 03:51: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 ( '68610' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '-6' , '4' , '1.0000' , '1' , '0' , '15' , '5.10' ) 25/10/2022 03:51:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 25/10/2022 03:51:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 25/10/2022 04:37:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 04:37:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3189' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 25/10/2022 04:37:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68620' 25/10/2022 04:37:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '68620' 25/10/2022 04:37:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68620' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 25/10/2022 04:37:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 25/10/2022 04:37:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 25/10/2022 05:15:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 05:15:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '33' , '2022-10-25' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5880.00' , '5663.61' , NOW() , NOW() ) 25/10/2022 05:15:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68621' 25/10/2022 05:15:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '68621' 25/10/2022 05:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68621' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '240' , '-240' , '4' , '3.50' , '3.5' , '0' , '0' , '840.00' ) 25/10/2022 05:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68621' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '800' , '-800' , '4' , '1.60' , '1.6' , '0' , '0' , '1280.00' ) 25/10/2022 05:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68621' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1200' , '-1200' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1200.00' ) 25/10/2022 05:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68621' , '13397' , 'MIO GESU\'' , '160' , '-160' , '4' , '3.50' , '3.5' , '0' , '0' , '560.00' ) 25/10/2022 05:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68621' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '200' , '-200' , '4' , '10.00' , '10' , '0' , '0' , '2000.00' ) 25/10/2022 05:15:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '68047' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-21') 25/10/2022 05:15:44 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '200', document_date = '2022-10-21', document_letter = '', id_customer = '2214', id_supplier = '', id_address = '4671715', address1 = 'P.ZZA S. FRANCESCO 84124 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '409.28', price_tax_excluded = '409.28', date_upd = NOW() WHERE id_document = '68047' 25/10/2022 05:15: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 = '68047' 25/10/2022 05:15:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '68047' 25/10/2022 05:15: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 ( '68047' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.5000' , '3.5' , '0' , '15' , '133.88' ) 25/10/2022 05:15:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 25/10/2022 05:15:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 25/10/2022 05:15: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 ( '68047' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '41' , '-41' , '4' , '3.5000' , '3.5' , '0' , '15' , '121.98' ) 25/10/2022 05:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 25/10/2022 05:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 25/10/2022 05:15:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '43' , '-43' , '4' , '3.5000' , '3.5' , '0' , '15' , '127.92' ) 25/10/2022 05:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 25/10/2022 05:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 25/10/2022 05:15:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 05:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 25/10/2022 05:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 25/10/2022 05:15:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 05:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 25/10/2022 05:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 25/10/2022 05:15:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 05:15:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 25/10/2022 05:15:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 25/10/2022 05:20:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '68047' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-21') 25/10/2022 05:20:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '200', document_date = '2022-10-21', document_letter = '', id_customer = '2214', id_supplier = '', id_address = '4671715', address1 = 'P.ZZA S. FRANCESCO 84124 SALERNO', 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 = '409.28', price_tax_excluded = '409.28', date_upd = NOW() WHERE id_document = '68047' 25/10/2022 05:20: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 = '68047' 25/10/2022 05:20:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '68047' 25/10/2022 05:20: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 ( '68047' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.5000' , '3.5' , '0' , '15' , '133.88' ) 25/10/2022 05:20:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 25/10/2022 05:20:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 25/10/2022 05:20: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 ( '68047' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '41' , '-41' , '4' , '3.5000' , '3.5' , '0' , '15' , '121.98' ) 25/10/2022 05:20:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 25/10/2022 05:20:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 25/10/2022 05:20: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 ( '68047' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '43' , '-43' , '4' , '3.5000' , '3.5' , '0' , '15' , '127.92' ) 25/10/2022 05:20:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 25/10/2022 05:20:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 25/10/2022 05:20: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 ( '68047' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 05:20:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 25/10/2022 05:20:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 25/10/2022 05:20:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 05:20:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 25/10/2022 05:20:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 25/10/2022 05:20:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 25/10/2022 05:20:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 25/10/2022 05:20:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 25/10/2022 05:23:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 05:23:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '13' , '2022-10-25' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2560.00' , '2560.00' , NOW() , NOW() ) 25/10/2022 05:23:18 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 = '7922' 25/10/2022 05:23:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '7922' 25/10/2022 05:23:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7922' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '560' , '-560' , '4' , '2.00' , '2' , '0' , '0' , '1120.00' ) 25/10/2022 05:23:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7922' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '48' , '-48' , '4' , '30.00' , '30' , '0' , '0' , '1440.00' ) 25/10/2022 06:05:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 06:05:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '86/A' , '2022-10-25' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '777.00' , '639.23' , NOW() , NOW() ) 25/10/2022 06:05:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68622' 25/10/2022 06:05:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '68622' 25/10/2022 06:05:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68622' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 25/10/2022 06:05:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68622' , '20146' , 'LETTERE DI BERLICCHE' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 25/10/2022 06:05:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68622' , '' , 'CANDELIERE' , '1' , '-1' , '1' , '750' , '614.75409836066' , '22' , '0' , '750.00' ) 25/10/2022 06:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-25') 25/10/2022 06:31:20 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' , '3190' , '2022-10-25' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 25/10/2022 06:31:20 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 = '68623' 25/10/2022 06:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '68623' 25/10/2022 06:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68623' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/10/2022 06:31:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 25/10/2022 06:31:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 25/10/2022 07:55:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400184860' AND id_product != '12919' AND ean13 != '' 25/10/2022 07:55:21 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400184860', date_upd = NOW() WHERE id_product = '12919' 25/10/2022 07:55:21 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE CARTONCINO CON BAMBINO - P422', description = '' WHERE id_product = '12919' 25/10/2022 07:55:21 pm >> UPDATE ps_product SET wholesale_price = '0.20', on_sale = '0', price = '0.4918032786885246' WHERE id_product = '12919' 25/10/2022 07:55:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.20', price = '0.4918032786885246', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12919' 25/10/2022 07:55:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '12919' 25/10/2022 07:55:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400282207' AND id_product != '16449' AND ean13 != '' 25/10/2022 07:55:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400282207', date_upd = NOW() WHERE id_product = '16449' 25/10/2022 07:55:43 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE CARTONCINO CON BAMBINO - P576', description = '' WHERE id_product = '16449' 25/10/2022 07:55:43 pm >> UPDATE ps_product SET wholesale_price = '0.18', on_sale = '0', price = '0.4918032786885246' WHERE id_product = '16449' 25/10/2022 07:55:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.18', price = '0.4918032786885246', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16449' 25/10/2022 07:55:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '16449' 25/10/2022 07:57:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000418' AND id_product != '939' AND ean13 != '' 25/10/2022 07:57:02 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000418', date_upd = NOW() WHERE id_product = '939' 25/10/2022 07:57:02 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 4 - CARNE - P1', description = '' WHERE id_product = '939' 25/10/2022 07:57:02 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '939' 25/10/2022 07:57:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '939' 25/10/2022 07:57:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '939' 25/10/2022 07:57:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000419' AND id_product != '940' AND ean13 != '' 25/10/2022 07:57:15 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000419', date_upd = NOW() WHERE id_product = '940' 25/10/2022 07:57:15 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 4 - FOSFORO - P1', description = '' WHERE id_product = '940' 25/10/2022 07:57:15 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '940' 25/10/2022 07:57:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '940' 25/10/2022 07:57:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '940'