17/11/2022 08:37:12 am >> SELECT document_num FROM ps_document WHERE document_num = '268' AND id_document != '72054' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-12') 17/11/2022 08:37:12 am >> UPDATE ps_document SET id_document_type = '21', document_num = '268', document_date = '2022-11-12', document_letter = '', id_customer = '2912', id_supplier = '', id_address = '4672779', address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO', 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 = '178.75', price_tax_excluded = '177.85', date_upd = NOW() WHERE id_document = '72054' 17/11/2022 08:37:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '72054' 17/11/2022 08:37:12 am >> DELETE FROM ps_document_detail WHERE id_document = '72054' 17/11/2022 08:37:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '35' , '-35' , '4' , '2.4000' , '2.4' , '0' , '15' , '71.40' ) 17/11/2022 08:37:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 17/11/2022 08:37:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 17/11/2022 08:37:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '12813' , 'MARIA MADRE NOSTRA' , '9' , '-9' , '4' , '3.0000' , '3' , '0' , '15' , '22.95' ) 17/11/2022 08:37:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '12813' AND id_supplier = '' 17/11/2022 08:37:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12813' , '' , '1' ) 17/11/2022 08:37:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '2679' , 'CONOSCERE GESU\'' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 17/11/2022 08:37:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 08:37:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 08:37:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '4120' , 'FEDE NELLO ZAINETTO' , '15' , '-15' , '4' , '5.0000' , '5' , '0' , '10' , '67.50' ) 17/11/2022 08:37:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 17/11/2022 08:37:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 17/11/2022 08:37:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 17/11/2022 08:37:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 17/11/2022 08:37:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 17/11/2022 09:30:47 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '59691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 17/11/2022 09:30:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2022-07-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA BATTIPAGLIA', 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 = '223.40', price_tax_excluded = '206.07', date_upd = NOW() WHERE id_document = '59691' 17/11/2022 09:30:47 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 = '59691' 17/11/2022 09:30:47 am >> DELETE FROM ps_document_detail WHERE id_document = '59691' 17/11/2022 09:30: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 ( '59691' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '0' , 'PREGHIERA DELL\'AMMALATO' , '200' , '-200' , '0' , '0.1000' , '0.1' , '0' , '0' , '20.00' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 17/11/2022 09:30:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 17/11/2022 09:30:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 17/11/2022 09:30: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 ( '59691' , '0' , 'LAMPADINE' , '50' , '-50' , '4' , '1.2000' , '1.2' , '0' , '0' , '60.00' ) 17/11/2022 09:30:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 17/11/2022 09:30:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 17/11/2022 09:30:48 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 ( '59691' , '5658' , 'LEGGIO PLEXIGLAS 26X36 ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 17/11/2022 09:30:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '5658' AND id_supplier = '' 17/11/2022 09:30:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5658' , '' , '1' ) 17/11/2022 09:30:48 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 ( '59691' , '16140' , 'NOVENA DELLIMMACOLATA - L. DABBRACCIO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 17/11/2022 09:30:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16140' AND id_supplier = '' 17/11/2022 09:30:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16140' , '' , '1' ) 17/11/2022 09:30:48 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 ( '59691' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '0' , '8.00' ) 17/11/2022 09:30:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 17/11/2022 09:30:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 17/11/2022 09:30:48 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 ( '59691' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 17/11/2022 09:30:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 17/11/2022 09:30:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 17/11/2022 09:35:46 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '59691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-15') 17/11/2022 09:35:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2022-07-15', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA BATTIPAGLIA', 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 = '233.40', price_tax_excluded = '216.07', date_upd = NOW() WHERE id_document = '59691' 17/11/2022 09:35: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 = '59691' 17/11/2022 09:35:46 am >> DELETE FROM ps_document_detail WHERE id_document = '59691' 17/11/2022 09:35: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 ( '59691' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 17/11/2022 09:35:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 17/11/2022 09:35:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 17/11/2022 09:35:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 17/11/2022 09:35:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 17/11/2022 09:35:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/11/2022 09:35:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 17/11/2022 09:35:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '0' , 'PREGHIERA DELL\'AMMALATO' , '300' , '-300' , '0' , '0.1000' , '0.1' , '' , '0' , '30.00' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '0' , 'LAMPADINE' , '50' , '-50' , '4' , '1.2000' , '1.2' , '0' , '0' , '60.00' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '5658' , 'LEGGIO PLEXIGLAS 26X36 ' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '0' , '28.00' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5658' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5658' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '16140' , 'NOVENA DELLIMMACOLATA - L. DABBRACCIO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16140' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16140' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '' , '1' ) 17/11/2022 09:35: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 ( '59691' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 17/11/2022 09:35:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 17/11/2022 09:35:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 17/11/2022 09:44:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 09:44:59 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' , '3484' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.00' , '71.50' , NOW() , NOW() ) 17/11/2022 09:44:59 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 = '73159' 17/11/2022 09:44:59 am >> DELETE FROM ps_document_detail WHERE id_document = '73159' 17/11/2022 09:44:59 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 ( '73159' , '20106' , 'GRIDIAMO IL VANGELO ANNO A - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 17/11/2022 09:44:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '20106' AND id_supplier = '' 17/11/2022 09:44:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20106' , '' , '1' ) 17/11/2022 09:44:59 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 ( '73159' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '58.25' , '47.745901639344' , '22' , '0' , '58.25' ) 17/11/2022 09:44:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 17/11/2022 09:44:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 17/11/2022 09:55:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 09:55: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 ( '11' , '3485' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.90' , '69.59' , NOW() , NOW() ) 17/11/2022 09:55: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 = '73160' 17/11/2022 09:55:34 am >> DELETE FROM ps_document_detail WHERE id_document = '73160' 17/11/2022 09:55: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 ( '73160' , '12527' , 'LAMPADA A SFERA VIOLA' , '4' , '-4' , '1' , '20' , '16.393442622951' , '22' , '0' , '80.00' ) 17/11/2022 09:55:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '12527' AND id_supplier = '' 17/11/2022 09:55:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12527' , '' , '1' ) 17/11/2022 09:55: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 ( '73160' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 17/11/2022 09:55:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/11/2022 09:55:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/11/2022 10:07:18 am >> SELECT document_num FROM ps_document WHERE document_num = '286' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 10:07:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '286' , '2022-11-17' , '' , '321' , '' , '4672782' , 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '237.16' , '237.16' , NOW() , NOW() ) 17/11/2022 10:07:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73161' 17/11/2022 10:07:18 am >> DELETE FROM ps_document_detail WHERE id_document = '73161' 17/11/2022 10:07:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73161' , '2679' , 'CONOSCERE GESU\'' , '24' , '-24' , '4' , '3.5000' , '3.5' , '0' , '15' , '71.40' ) 17/11/2022 10:07:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 10:07:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 10:07:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73161' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.5000' , '2.5' , '0' , '15' , '44.63' ) 17/11/2022 10:07:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 17/11/2022 10:07:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 17/11/2022 10:07:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73161' , '5458' , 'IO SONO CON VOI 2 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 17/11/2022 10:07:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 17/11/2022 10:07:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 17/11/2022 10:07:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73161' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 17/11/2022 10:07:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 17/11/2022 10:07:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 17/11/2022 10:07:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73161' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '15' , '53.13' ) 17/11/2022 10:07:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 17/11/2022 10:07:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 17/11/2022 10:07:30 am >> DELETE FROM ps_document WHERE id_document = '70325' 17/11/2022 10:07:30 am >> DELETE FROM ps_document_detail WHERE id_document = '70325' 17/11/2022 10:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 10:08:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3486' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '183.15' , '183.15' , NOW() , NOW() ) 17/11/2022 10:08:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73162' 17/11/2022 10:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '73162' 17/11/2022 10:08:08 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 ( '73162' , '5444' , 'IO SONO CON VOI - CAT.' , '21' , '-21' , '4' , '4.95' , '4.95' , '0' , '0' , '103.95' ) 17/11/2022 10:08:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 17/11/2022 10:08:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 17/11/2022 10:08:08 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 ( '73162' , '11193' , 'VENITE CON ME CAT.' , '16' , '-16' , '4' , '4.95' , '4.95' , '0' , '0' , '79.20' ) 17/11/2022 10:08:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 17/11/2022 10:08:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 17/11/2022 10:13:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 10:13:47 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' , '3487' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '9.90' , NOW() , NOW() ) 17/11/2022 10:13:47 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 = '73163' 17/11/2022 10:13:47 am >> DELETE FROM ps_document_detail WHERE id_document = '73163' 17/11/2022 10:13: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 ( '73163' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '4.95' , '4.95' , '0' , '0' , '9.90' ) 17/11/2022 10:13:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 17/11/2022 10:13:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 17/11/2022 10:38:20 am >> SELECT document_num FROM ps_document WHERE document_num = '286' AND id_document != '73161' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 10:38:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '286', document_date = '2022-11-17', document_letter = '', id_customer = '321', id_supplier = '', id_address = '4672782', address1 = 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.', 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 = '237.16', price_tax_excluded = '237.16', date_upd = NOW() WHERE id_document = '73161' 17/11/2022 10:38:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73161' 17/11/2022 10:38:20 am >> DELETE FROM ps_document_detail WHERE id_document = '73161' 17/11/2022 10:38:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73161' , '2679' , 'CONOSCERE GESU\'' , '24' , '-24' , '4' , '3.5000' , '3.5' , '0' , '15' , '71.40' ) 17/11/2022 10:38:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 10:38:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 10:38: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 ( '73161' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.5000' , '2.5' , '0' , '15' , '44.63' ) 17/11/2022 10:38:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 17/11/2022 10:38:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 17/11/2022 10:38: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 ( '73161' , '5458' , 'IO SONO CON VOI 2 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 17/11/2022 10:38:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 17/11/2022 10:38:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 17/11/2022 10:38: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 ( '73161' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 17/11/2022 10:38:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 17/11/2022 10:38:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 17/11/2022 10:38: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 ( '73161' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '15' , '53.13' ) 17/11/2022 10:38:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 17/11/2022 10:38:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 17/11/2022 10:38:57 am >> SELECT document_num FROM ps_document WHERE document_num = '287' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 10:38:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '287' , '2022-11-17' , '' , '3356' , '0' , '4671990' , 'VIA SALVATORE DE RENZI, 26 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.81' , '74.81' , NOW() , NOW() ) 17/11/2022 10:38:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73164' 17/11/2022 10:38:57 am >> DELETE FROM ps_document_detail WHERE id_document = '73164' 17/11/2022 10:38:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73164' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 17/11/2022 10:38:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73164' , '11191' , 'VENITE CON ME 1 PARTE' , '17' , '-17' , '4' , '2.50' , '2.5' , '0' , '15' , '36.13' ) 17/11/2022 11:04:20 am >> SELECT document_num FROM ps_document WHERE document_num = '283' AND id_document != '73144' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-16') 17/11/2022 11:04:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '283', document_date = '2022-11-16', document_letter = '', id_customer = '347', id_supplier = '', id_address = '4677186', address1 = 'VIA VARRONCELLE , 1 84040 ACQUAVELLA', 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 = '62.90', price_tax_excluded = '62.90', date_upd = NOW() WHERE id_document = '73144' 17/11/2022 11:04:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73144' 17/11/2022 11:04:20 am >> DELETE FROM ps_document_detail WHERE id_document = '73144' 17/11/2022 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73144' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 17/11/2022 11:04:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 17/11/2022 11:04:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 17/11/2022 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73144' , '2679' , 'CONOSCERE GESU\'' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 17/11/2022 11:04:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 11:04:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 11:32:41 am >> SELECT document_num FROM ps_document WHERE document_num = '287' AND id_document != '73164' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 11:32:41 am >> UPDATE ps_document SET id_document_type = '21', document_num = '287', document_date = '2022-11-17', document_letter = '', id_customer = '3356', id_supplier = '', id_address = '4671990', address1 = 'VIA SALVATORE DE RENZI, 26 84125 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 = '90.11', price_tax_excluded = '90.11', date_upd = NOW() WHERE id_document = '73164' 17/11/2022 11:32:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73164' 17/11/2022 11:32:41 am >> DELETE FROM ps_document_detail WHERE id_document = '73164' 17/11/2022 11:32:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73164' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 17/11/2022 11:32:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 11:32:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 11:32:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73164' , '11191' , 'VENITE CON ME 1 PARTE' , '17' , '-17' , '4' , '2.5000' , '2.5' , '0' , '15' , '36.13' ) 17/11/2022 11:32:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 17/11/2022 11:32:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 17/11/2022 11:32:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73164' , '7543' , 'PARABOLE DI GESÙ' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '15' , '15.30' ) 17/11/2022 11:32:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 17/11/2022 11:32:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 17/11/2022 11:33:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 11:33:47 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' , '3488' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.80' , NOW() , NOW() ) 17/11/2022 11:33:47 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 = '73165' 17/11/2022 11:33:47 am >> DELETE FROM ps_document_detail WHERE id_document = '73165' 17/11/2022 11:33: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 ( '73165' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 17/11/2022 11:33:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 17/11/2022 11:33:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 17/11/2022 11:35:00 am >> SELECT document_num FROM ps_document WHERE document_num = '287' AND id_document != '73164' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 11:35:00 am >> UPDATE ps_document SET id_document_type = '21', document_num = '287', document_date = '2022-11-17', document_letter = '', id_customer = '3356', id_supplier = '', id_address = '4671990', address1 = 'VIA SALVATORE DE RENZI, 26 84125 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 = '90.11', price_tax_excluded = '90.11', date_upd = NOW() WHERE id_document = '73164' 17/11/2022 11:35: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 = '73164' 17/11/2022 11:35:00 am >> DELETE FROM ps_document_detail WHERE id_document = '73164' 17/11/2022 11:35: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 ( '73164' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 17/11/2022 11:35:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 11:35:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 11:35: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 ( '73164' , '11191' , 'VENITE CON ME 1 PARTE' , '17' , '-17' , '4' , '2.5000' , '2.5' , '0' , '15' , '36.13' ) 17/11/2022 11:35:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 17/11/2022 11:35:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 17/11/2022 11:35: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 ( '73164' , '7543' , 'PARABOLE DI GESÙ' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '15' , '15.30' ) 17/11/2022 11:35:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 17/11/2022 11:35:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 17/11/2022 11:36:48 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/11/2022 11:36:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20401' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:36:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20401' , '1' , '1' , '2' , NOW() , NOW() ) 17/11/2022 11:36:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20401' , '0' , '1' , '0' , '0' ) 17/11/2022 11:38:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400000' AND id_product != '20401' AND ean13 != '' 17/11/2022 11:38:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400000', date_upd = NOW() WHERE id_product = '20401' 17/11/2022 11:38:18 am >> UPDATE ps_product_lang SET name = 'grande lessico del nuovo testamento 1', description = '' WHERE id_product = '20401' 17/11/2022 11:38:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20401' 17/11/2022 11:38:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20401' 17/11/2022 11:38:18 am >> DELETE FROM ps_specific_price WHERE id_product = '20401' 17/11/2022 11:38:18 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 = '20401' 17/11/2022 11:38:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20402' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:38:18 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 '20402' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20401' 17/11/2022 11:38:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20402' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20401' 17/11/2022 11:38:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400017' AND id_product != '20402' AND ean13 != '' 17/11/2022 11:38:43 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400017', date_upd = NOW() WHERE id_product = '20402' 17/11/2022 11:38:43 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 2', description = '' WHERE id_product = '20402' 17/11/2022 11:38:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20402' 17/11/2022 11:38:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20402' 17/11/2022 11:38:43 am >> DELETE FROM ps_specific_price WHERE id_product = '20402' 17/11/2022 11:38:45 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 = '20402' 17/11/2022 11:38:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20403' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:38:45 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 '20403' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20402' 17/11/2022 11:38:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20403' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20402' 17/11/2022 11:39:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400024' AND id_product != '20403' AND ean13 != '' 17/11/2022 11:39:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400024', date_upd = NOW() WHERE id_product = '20403' 17/11/2022 11:39:06 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 3', description = '' WHERE id_product = '20403' 17/11/2022 11:39:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20403' 17/11/2022 11:39:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20403' 17/11/2022 11:39:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20403' 17/11/2022 11:39:07 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 = '20403' 17/11/2022 11:39:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20404' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:39:07 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 '20404' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20403' 17/11/2022 11:39:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20404' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20403' 17/11/2022 11:39:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400031' AND id_product != '20404' AND ean13 != '' 17/11/2022 11:39:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400031', date_upd = NOW() WHERE id_product = '20404' 17/11/2022 11:39:29 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 4', description = '' WHERE id_product = '20404' 17/11/2022 11:39:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20404' 17/11/2022 11:39:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20404' 17/11/2022 11:39:29 am >> DELETE FROM ps_specific_price WHERE id_product = '20404' 17/11/2022 11:39:36 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 = '20404' 17/11/2022 11:39:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20405' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:39:36 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 '20405' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20404' 17/11/2022 11:39:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20405' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20404' 17/11/2022 11:44:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400048' AND id_product != '20405' AND ean13 != '' 17/11/2022 11:44:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400048', date_upd = NOW() WHERE id_product = '20405' 17/11/2022 11:44:12 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 5', description = '' WHERE id_product = '20405' 17/11/2022 11:44:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20405' 17/11/2022 11:44:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20405' 17/11/2022 11:44:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20405' 17/11/2022 11:44:13 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 = '20405' 17/11/2022 11:44:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20406' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:44:13 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 '20406' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20405' 17/11/2022 11:44:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20406' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20405' 17/11/2022 11:44:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400055' AND id_product != '20406' AND ean13 != '' 17/11/2022 11:44:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400055', date_upd = NOW() WHERE id_product = '20406' 17/11/2022 11:44:36 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 6', description = '' WHERE id_product = '20406' 17/11/2022 11:44:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20406' 17/11/2022 11:44:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20406' 17/11/2022 11:44:36 am >> DELETE FROM ps_specific_price WHERE id_product = '20406' 17/11/2022 11:44:37 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 = '20406' 17/11/2022 11:44:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20407' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:44:37 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 '20407' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20406' 17/11/2022 11:44:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20407' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20406' 17/11/2022 11:44:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400062' AND id_product != '20407' AND ean13 != '' 17/11/2022 11:44:56 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400062', date_upd = NOW() WHERE id_product = '20407' 17/11/2022 11:44:57 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 7', description = '' WHERE id_product = '20407' 17/11/2022 11:44:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20407' 17/11/2022 11:44:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20407' 17/11/2022 11:44:57 am >> DELETE FROM ps_specific_price WHERE id_product = '20407' 17/11/2022 11:44:57 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 = '20407' 17/11/2022 11:44:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20408' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:44:57 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 '20408' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20407' 17/11/2022 11:44:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20408' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20407' 17/11/2022 11:45:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400093' AND id_product != '20408' AND ean13 != '' 17/11/2022 11:45:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400093', date_upd = NOW() WHERE id_product = '20408' 17/11/2022 11:45:21 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 10', description = '' WHERE id_product = '20408' 17/11/2022 11:45:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20408' 17/11/2022 11:45:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20408' 17/11/2022 11:45:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20408' 17/11/2022 11:45: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 = '20408' 17/11/2022 11:45:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20409' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:45: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 '20409' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20408' 17/11/2022 11:45:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20409' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20408' 17/11/2022 11:45:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400116' AND id_product != '20409' AND ean13 != '' 17/11/2022 11:45:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400116', date_upd = NOW() WHERE id_product = '20409' 17/11/2022 11:45:44 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 12', description = '' WHERE id_product = '20409' 17/11/2022 11:45:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20409' 17/11/2022 11:45:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20409' 17/11/2022 11:45:44 am >> DELETE FROM ps_specific_price WHERE id_product = '20409' 17/11/2022 11:45:45 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 = '20409' 17/11/2022 11:45:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20410' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:45:45 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 '20410' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20409' 17/11/2022 11:45:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20410' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20409' 17/11/2022 11:46:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400123' AND id_product != '20410' AND ean13 != '' 17/11/2022 11:46:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400123', date_upd = NOW() WHERE id_product = '20410' 17/11/2022 11:46:06 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 13', description = '' WHERE id_product = '20410' 17/11/2022 11:46:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20410' 17/11/2022 11:46:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20410' 17/11/2022 11:46:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20410' 17/11/2022 11:46:07 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 = '20410' 17/11/2022 11:46:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20411' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:46:07 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 '20411' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20410' 17/11/2022 11:46:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20411' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20410' 17/11/2022 11:46:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400130' AND id_product != '20411' AND ean13 != '' 17/11/2022 11:46:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400130', date_upd = NOW() WHERE id_product = '20411' 17/11/2022 11:46:30 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 14', description = '' WHERE id_product = '20411' 17/11/2022 11:46:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20411' 17/11/2022 11:46:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20411' 17/11/2022 11:46:30 am >> DELETE FROM ps_specific_price WHERE id_product = '20411' 17/11/2022 11:46:30 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 = '20411' 17/11/2022 11:46:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20412' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:46:30 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 '20412' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20411' 17/11/2022 11:46:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20412' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20411' 17/11/2022 11:46:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839404220' AND id_product != '20412' AND ean13 != '' 17/11/2022 11:46:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839404220', date_upd = NOW() WHERE id_product = '20412' 17/11/2022 11:46:52 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 15', description = '' WHERE id_product = '20412' 17/11/2022 11:46:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20412' 17/11/2022 11:46:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20412' 17/11/2022 11:46:52 am >> DELETE FROM ps_specific_price WHERE id_product = '20412' 17/11/2022 11:46:54 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 = '20412' 17/11/2022 11:46:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20413' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:46:54 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 '20413' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20412' 17/11/2022 11:46:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20413' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20412' 17/11/2022 11:47:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839404848' AND id_product != '20413' AND ean13 != '' 17/11/2022 11:47:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839404848', date_upd = NOW() WHERE id_product = '20413' 17/11/2022 11:47:25 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 16 indici', description = '' WHERE id_product = '20413' 17/11/2022 11:47:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '136' WHERE id_product = '20413' 17/11/2022 11:47:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '136', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20413' 17/11/2022 11:47:25 am >> DELETE FROM ps_specific_price WHERE id_product = '20413' 17/11/2022 11:47:26 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 = '20413' 17/11/2022 11:47:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20414' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:47:26 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 '20414' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20413' 17/11/2022 11:47:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20414' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20413' 17/11/2022 11:47:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400079' AND id_product != '20414' AND ean13 != '' 17/11/2022 11:47:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400079', date_upd = NOW() WHERE id_product = '20414' 17/11/2022 11:47:48 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8', description = '' WHERE id_product = '20414' 17/11/2022 11:47:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20414' 17/11/2022 11:47:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20414' 17/11/2022 11:47:48 am >> DELETE FROM ps_specific_price WHERE id_product = '20414' 17/11/2022 11:47:49 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 = '20414' 17/11/2022 11:47:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20415' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:47:49 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 '20415' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20414' 17/11/2022 11:47:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20415' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20414' 17/11/2022 11:48:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400086' AND id_product != '20415' AND ean13 != '' 17/11/2022 11:48:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400086', date_upd = NOW() WHERE id_product = '20415' 17/11/2022 11:48:05 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 9', description = '' WHERE id_product = '20415' 17/11/2022 11:48:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20415' 17/11/2022 11:48:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20415' 17/11/2022 11:48:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20415' 17/11/2022 11:48:09 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 = '20415' 17/11/2022 11:48:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20416' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:48:09 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 '20416' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20415' 17/11/2022 11:48:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20416' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20415' 17/11/2022 11:48:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400109' AND id_product != '20416' AND ean13 != '' 17/11/2022 11:48:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400109', date_upd = NOW() WHERE id_product = '20416' 17/11/2022 11:48:24 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 11', description = '' WHERE id_product = '20416' 17/11/2022 11:48:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20416' 17/11/2022 11:48:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20416' 17/11/2022 11:48:24 am >> DELETE FROM ps_specific_price WHERE id_product = '20416' 17/11/2022 11:48:27 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 = '20416' 17/11/2022 11:48:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20417' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 11:48:27 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 '20417' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20416' 17/11/2022 11:48:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20417' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20416' 17/11/2022 11:50:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400000' AND id_product != '20401' AND ean13 != '' 17/11/2022 11:50:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400000', date_upd = NOW() WHERE id_product = '20401' 17/11/2022 11:50:21 am >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 1', description = '' WHERE id_product = '20401' 17/11/2022 11:50:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98.0000' WHERE id_product = '20401' 17/11/2022 11:50:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98.0000', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20401' 17/11/2022 11:50:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20401' 17/11/2022 11:52:29 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' , '2022000006466' , '2022-11-16' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '26.24' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '964.32' , '964.32' , NOW() , NOW() ) 17/11/2022 11:52:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73166' 17/11/2022 11:52:29 am >> DELETE FROM ps_document_detail WHERE id_document = '73166' 17/11/2022 11:52: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 ( '73166' , '20401' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 1' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20401' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20401' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20402' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 2' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20402' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20402' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20403' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 3' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20403' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20403' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20404' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 4' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20404' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20404' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20405' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 5' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20405' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20405' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20406' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 6' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20406' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20406' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20407' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 7' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20407' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20407' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20408' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 10' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20408' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20408' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20409' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 12' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20409' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20409' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20410' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 13' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20410' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20410' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20411' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 14' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20411' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20411' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20412' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 15' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20412' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20412' , '107' , '1' ) 17/11/2022 11:52: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 ( '73166' , '20413' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 16 indici' , '1' , '1' , '4' , '136.00' , '136' , '0' , '28.5' , '97.2400' ) 17/11/2022 11:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20413' AND id_supplier = '107' 17/11/2022 11:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20413' , '107' , '1' ) 17/11/2022 11:56:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 11:56:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3489' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 17/11/2022 11:56:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73167' 17/11/2022 11:56:45 am >> DELETE FROM ps_document_detail WHERE id_document = '73167' 17/11/2022 11:56:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73167' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/11/2022 11:56:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 17/11/2022 11:56:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 17/11/2022 12:04:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810565179' AND id_product != '20417' AND ean13 != '' 17/11/2022 12:04:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788810565179', date_upd = NOW() WHERE id_product = '20417' 17/11/2022 12:04:06 pm >> UPDATE ps_product_lang SET name = 'NON SARA\' SUBITO LA FINE - G. ZANCHI', description = '' WHERE id_product = '20417' 17/11/2022 12:04:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20417' 17/11/2022 12:04:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20417' 17/11/2022 12:04:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '20417' 17/11/2022 12:04:07 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20417' 17/11/2022 12:04:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20418' , '1' , '' , 'nuovo-prodotto' ) 17/11/2022 12:04:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20418' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20417' 17/11/2022 12:04:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20418' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20417' 17/11/2022 12:05:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '320782' , '2022-11-16' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '213.00' , '213.00' , NOW() , NOW() ) 17/11/2022 12:05: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 = '73168' 17/11/2022 12:05:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '73168' 17/11/2022 12:05: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 ( '73168' , '18936' , 'ENCHIRIDION VATICANUM VOL 30' , '1' , '1' , '4' , '49.00' , '49' , '0' , '0' , '49.00' ) 17/11/2022 12:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18936' AND id_supplier = '109' 17/11/2022 12:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18936' , '109' , '1' ) 17/11/2022 12:05: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 ( '73168' , '20417' , 'NON SARA SUBITO LA FINE - G. ZANCHI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 17/11/2022 12:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20417' AND id_supplier = '109' 17/11/2022 12:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20417' , '109' , '1' ) 17/11/2022 12:05: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 ( '73168' , '18875' , 'ENCHIRIDION VATICANUM 32' , '1' , '1' , '4' , '49.00' , '49' , '0' , '0' , '49.00' ) 17/11/2022 12:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18875' AND id_supplier = '109' 17/11/2022 12:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18875' , '109' , '1' ) 17/11/2022 12:05: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 ( '73168' , '20353' , 'STORIA DELLA CHIESA VOL 2' , '1' , '1' , '4' , '29.00' , '29' , '0' , '0' , '29.00' ) 17/11/2022 12:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20353' AND id_supplier = '109' 17/11/2022 12:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20353' , '109' , '1' ) 17/11/2022 12:05: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 ( '73168' , '18877' , 'ENCHIRIDION 29' , '1' , '1' , '4' , '49.00' , '49' , '0' , '0' , '49.00' ) 17/11/2022 12:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18877' AND id_supplier = '109' 17/11/2022 12:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18877' , '109' , '1' ) 17/11/2022 12:05: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 ( '73168' , '20354' , 'STORIA DELLA CHIESA VOL 4' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 17/11/2022 12:05:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20354' AND id_supplier = '109' 17/11/2022 12:05:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20354' , '109' , '1' ) 17/11/2022 12:33:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3488' AND id_document != '73165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 12:33:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3488', document_date = '2022-11-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2.80', price_tax_excluded = '2.80', date_upd = NOW() WHERE id_document = '73165' 17/11/2022 12:33:58 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 = '73165' 17/11/2022 12:33:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '73165' 17/11/2022 12:33:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73165' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.4' , '0.4' , '0' , '0' , '0.40' ) 17/11/2022 12:33:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 17/11/2022 12:33:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 17/11/2022 12:33:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73165' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.03' , '0.03' , '0' , '0' , '2.40' ) 17/11/2022 12:33:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 17/11/2022 12:33:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 17/11/2022 12:58:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 12:58:31 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' , '3490' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.65' , '40.26' , NOW() , NOW() ) 17/11/2022 12:58:31 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 = '73169' 17/11/2022 12:58:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '73169' 17/11/2022 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73169' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '20.00' ) 17/11/2022 12:58:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 17/11/2022 12:58:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 17/11/2022 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73169' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 17/11/2022 12:58:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12040' AND id_supplier = '' 17/11/2022 12:58:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12040' , '' , '1' ) 17/11/2022 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73169' , '6323' , 'MEDAGLIA MIRACOLOSA E CATERINA LABOURÈ - 8814' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 17/11/2022 12:58:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6323' AND id_supplier = '' 17/11/2022 12:58:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6323' , '' , '1' ) 17/11/2022 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73169' , '4969' , 'IMMAGINE IMMACOLATA CONCEZIONE ' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 17/11/2022 12:58:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4969' AND id_supplier = '' 17/11/2022 12:58:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4969' , '' , '1' ) 17/11/2022 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73169' , '17940' , 'MIRACOLOSA - ISONZO 152bis' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 17/11/2022 12:58:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17940' AND id_supplier = '' 17/11/2022 12:58:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17940' , '' , '1' ) 17/11/2022 03:04:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 03:04:42 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 ( '26' , '2' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9050.00' , '7418.03' , NOW() , NOW() ) 17/11/2022 03:04:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73170' 17/11/2022 03:04:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '73170' 17/11/2022 03:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73170' , '' , 'Realizzazione nuovo modello “UNICO” Statua S. Vito cm 160 in vetroresina finitura bianca o bronzata per esterno N.B. Gli accessori saranno acquistati in ottone per poi essere rifiniti con una resina adatta all’esposizione all’esterno, si anticipa che non saranno identici ma simili, nel caso si vogliano identici eventualmente potete provvedere voi N.B.: le misure delle statue sono indicative e s’intendono di base ed eventuale corona o mitra vescovile compresa.' , '1' , '0' , '1' , '9050' , '7418.0327868852' , '22' , '0' , '9050.00' ) 17/11/2022 03:04:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 17/11/2022 03:04:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 17/11/2022 03:05:05 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '9mqBSh1KjhtgUKdh' , NOW() , NOW() ) 17/11/2022 03:05:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3977' , '1' ) 17/11/2022 03:05:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3977' , '2' ) 17/11/2022 03:05:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3977' , '3' ) 17/11/2022 03:08:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3491' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 03:08: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' , '3491' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 17/11/2022 03:08: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 = '73171' 17/11/2022 03:08:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '73171' 17/11/2022 03:08: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 ( '73171' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 17/11/2022 03:08:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 17/11/2022 03:08:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 17/11/2022 03:10:55 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3977' 17/11/2022 03:10:55 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3977' , '10' , '210' , 'COMUNE DI BUCCINO' , '' , '' , 'P. ZZA MUNICIPIO 1 ' , '' , '84021' , 'BUCCINO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 17/11/2022 03:10:55 pm >> UPDATE ps_customer SET email = '', sdi = 'U72W87', pec = 'protocollo@pec.comune.buccino.sa.it', date_upd = NOW() WHERE id_customer = '3977' 17/11/2022 03:11:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '73170' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 03:11:21 pm >> UPDATE ps_document SET id_document_type = '26', document_num = '2', document_date = '2022-11-17', document_letter = '', id_customer = '3977', id_supplier = '0', id_address = '4677189', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9050.00', price_tax_excluded = '7418.03', date_upd = NOW() WHERE id_document = '73170' 17/11/2022 03:11:21 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 = '73170' 17/11/2022 03:11:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '73170' 17/11/2022 03:11:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73170' , '0' , 'Realizzazione nuovo modello “UNICO” Statua S. Vito cm 160 in vetroresina finitura bianca o bronzata ' , '1' , '0' , '1' , '9050.0000' , '7418.0327868852' , '22' , '0' , '9050.00' ) 17/11/2022 03:14:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '73170' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 03:14:24 pm >> UPDATE ps_document SET id_document_type = '26', document_num = '2', document_date = '2022-11-17', document_letter = '', id_customer = '3977', id_supplier = '', id_address = '4677189', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9050.00', price_tax_excluded = '7418.03', date_upd = NOW() WHERE id_document = '73170' 17/11/2022 03:14:24 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 = '73170' 17/11/2022 03:14:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '73170' 17/11/2022 03:14:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73170' , '0' , 'Realizzazione nuovo modello “UNICO” Statua S. Vito cm 160 in vetroresina finitura bianca o bronzata per esterno' , '1' , '0' , '1' , '9050.0000' , '7418.0327868852' , '22' , '0' , '9050.00' ) 17/11/2022 03:14:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 17/11/2022 03:14:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 17/11/2022 03:14:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73170' , '' , 'N.B. Gli accessori saranno acquistati in ottone per poi essere rifiniti con una resina adatta all’esposizione all’esterno, si anticipa che non saranno identici ma simili, nel caso si vogliano identici eventualmente potete provvedere voi' , '0' , '0' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 17/11/2022 03:14:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 17/11/2022 03:14:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 17/11/2022 03:14:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73170' , '' , 'N.B.: le misure delle statue sono indicative e s’intendono di base ed eventuale corona o mitra vescovile compresa' , '0' , '0' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 17/11/2022 03:14:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 17/11/2022 03:14:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 17/11/2022 03:31:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3492' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 03:31: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' , '3492' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.80' , '113.24' , NOW() , NOW() ) 17/11/2022 03:31: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 = '73172' 17/11/2022 03:31:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '73172' 17/11/2022 03:31: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 ( '73172' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 17/11/2022 03:31:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 17/11/2022 03:31:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 17/11/2022 03:31: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 ( '73172' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 17/11/2022 03:31:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 17/11/2022 03:31:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 17/11/2022 03:31: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 ( '73172' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '3.5' , '3.5' , '0' , '0' , '35.00' ) 17/11/2022 03:31:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 17/11/2022 03:31:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 17/11/2022 03:31: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 ( '73172' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 17/11/2022 03:31:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 17/11/2022 03:31:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 17/11/2022 03:31:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3493' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 03:31:35 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' , '3493' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 17/11/2022 03:31:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73173' 17/11/2022 03:31:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '73173' 17/11/2022 03:31:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73173' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 17/11/2022 03:31:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 17/11/2022 03:31:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 17/11/2022 03:31:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73173' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 17/11/2022 03:31:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18962' AND id_supplier = '' 17/11/2022 03:31:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18962' , '' , '1' ) 17/11/2022 04:25:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810613733' AND id_product != '1416' AND ean13 != '' 17/11/2022 04:25:39 pm >> UPDATE ps_product SET id_supplier = '109', reference = '2/1', ean13 = '9788810613733', date_upd = NOW() WHERE id_product = '1416' 17/11/2022 04:25:39 pm >> UPDATE ps_product_lang SET name = 'BUONA NOTIZIA TODAY 3 SUS - SARTOR/CIUCCI', description = '' WHERE id_product = '1416' 17/11/2022 04:25:39 pm >> UPDATE ps_product SET wholesale_price = '2.54', on_sale = '0', price = '4' WHERE id_product = '1416' 17/11/2022 04:25:39 pm >> UPDATE ps_product_shop SET wholesale_price = '2.54', price = '4', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '171', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1416' 17/11/2022 04:25:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '1416' 17/11/2022 04:44:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 04:44:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '288' , '2022-11-17' , '' , '3799' , '0' , '4672355' , 'VIA SAN NICOLA 84084 FISCIANO - CARPINETO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '332.96' , '332.96' , NOW() , NOW() ) 17/11/2022 04:44:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73174' 17/11/2022 04:44:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '73174' 17/11/2022 04:44: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 ( '73174' , '2679' , 'CONOSCERE GESU\'' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 17/11/2022 04:44: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 ( '73174' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 17/11/2022 04:44: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 ( '73174' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 17/11/2022 04:44: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 ( '73174' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 17/11/2022 04:44: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 ( '73174' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 17/11/2022 04:44: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 ( '73174' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '33' , '-33' , '4' , '2.4000' , '2.4' , '0' , '15' , '67.32' ) 17/11/2022 04:44: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 ( '73174' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 17/11/2022 04:44: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 ( '73174' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 17/11/2022 04:45:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '73174' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 04:45:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '288', document_date = '2022-11-17', document_letter = '', id_customer = '3799', id_supplier = '', id_address = '4672355', address1 = 'VIA SAN NICOLA 84084 FISCIANO - CARPINETO', 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 = '332.96', price_tax_excluded = '332.96', date_upd = NOW() WHERE id_document = '73174' 17/11/2022 04:45: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 = '73174' 17/11/2022 04:45:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '73174' 17/11/2022 04:45: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 ( '73174' , '2679' , 'CONOSCERE GESU\'' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 17/11/2022 04:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 17/11/2022 04:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 17/11/2022 04:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 17/11/2022 04:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 17/11/2022 04:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 17/11/2022 04:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 17/11/2022 04:45:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 17/11/2022 04:45:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 17/11/2022 04:45:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 17/11/2022 04:45:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '33' , '-33' , '4' , '2.4000' , '2.4' , '0' , '15' , '67.32' ) 17/11/2022 04:45:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 17/11/2022 04:45:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 17/11/2022 04:45:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 17/11/2022 04:45:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 17/11/2022 04:45: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 ( '73174' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 17/11/2022 04:45:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 17/11/2022 04:45:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 17/11/2022 04:47:25 pm >> DELETE FROM ps_document WHERE id_document = '68061' 17/11/2022 04:47:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '68061' 17/11/2022 06:16:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '' AND id_document_type LIKE '25' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 06:16:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '117' , '2022-11-17' , '' , '3347' , '0' , '4669949' , 'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE' , '' , 'RESA ' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 17/11/2022 06:16: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 = '8707' 17/11/2022 06:16:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '8707' 17/11/2022 06:16: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 ( '8707' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '5' , '5' , '4' , '18.00' , '18' , '0' , '0' , '90.00' ) 17/11/2022 06:17:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '' AND id_document_type LIKE '25' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 06:17:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '118' , '2022-11-17' , '' , '3350' , '0' , '4669953' , 'VIA RISORGIMENTO, 2 37068 VIGASIO ' , '' , 'RESA' , '4.9' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 17/11/2022 06:17: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 = '8708' 17/11/2022 06:17:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '8708' 17/11/2022 06:17: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 ( '8708' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 17/11/2022 06:18:01 pm >> DELETE FROM ps_document WHERE id_document = '8708' 17/11/2022 06:18:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '8708' 17/11/2022 06:18:03 pm >> DELETE FROM ps_document WHERE id_document = '8707' 17/11/2022 06:18:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '8707' 17/11/2022 06:19:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '5406' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-01') 17/11/2022 06:19:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2022-09-01', document_letter = '', id_customer = '3347', id_supplier = '', id_address = '4669949', address1 = 'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '2.50', price_tax_excluded = '2.50', date_upd = NOW() WHERE id_document = '5406' 17/11/2022 06:19:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5406' 17/11/2022 06:19:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '5406' 17/11/2022 06:19:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5406' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 17/11/2022 06:19:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '35' AND id_supplier = '' 17/11/2022 06:19:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '35' , '' , '1' ) 17/11/2022 06:19:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '5406' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-01') 17/11/2022 06:19:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2022-09-01', document_letter = '', id_customer = '3347', id_supplier = '', id_address = '4669949', address1 = 'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE', 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 = '2.50', price_tax_excluded = '2.50', date_upd = NOW() WHERE id_document = '5406' 17/11/2022 06:19:31 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 = '5406' 17/11/2022 06:19:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '5406' 17/11/2022 06:19:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5406' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 17/11/2022 06:19:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '35' AND id_supplier = '' 17/11/2022 06:19:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '35' , '' , '1' ) 17/11/2022 06:20:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '5406' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-01') 17/11/2022 06:20:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2022-09-01', document_letter = '', id_customer = '4716', id_supplier = '0', id_address = '4673030', address1 = 'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE', 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 = '2.50', price_tax_excluded = '2.50', date_upd = NOW() WHERE id_document = '5406' 17/11/2022 06:20:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5406' 17/11/2022 06:20:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '5406' 17/11/2022 06:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5406' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 17/11/2022 06:21:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '5407' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-01') 17/11/2022 06:21:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '52', document_date = '2022-09-01', document_letter = '', id_customer = '4024', id_supplier = '0', id_address = '9339919', address1 = 'VIA RISORGIMENTO, 2 37068 VIGASIO ', address2 = '', note = '', price_shipping = '0', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '1.50', price_tax_excluded = '1.50', date_upd = NOW() WHERE id_document = '5407' 17/11/2022 06:21:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5407' 17/11/2022 06:21:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '5407' 17/11/2022 06:21:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5407' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 17/11/2022 07:45:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3494' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 17/11/2022 07:45:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3494' , '2022-11-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 17/11/2022 07:45:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73175' 17/11/2022 07:45:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '73175' 17/11/2022 07:45:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '1.20' ) 17/11/2022 07:45:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 17/11/2022 07:45:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 17/11/2022 07:45:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 17/11/2022 07:45:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/11/2022 07:45:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/11/2022 07:45:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '1' , '-1' , '1' , '4.40' , '3.6065573770492' , '22' , '0' , '4.40' ) 17/11/2022 07:45:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14957' AND id_supplier = '' 17/11/2022 07:45:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14957' , '' , '1' ) 17/11/2022 07:45:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/11/2022 07:45:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 17/11/2022 07:45:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )