04/11/2022 08:23:56 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/11/2022 08:23:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20263' , '1' , '' , 'nuovo-prodotto' ) 04/11/2022 08:23:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20263' , '1' , '1' , '2' , NOW() , NOW() ) 04/11/2022 08:23:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20263' , '0' , '1' , '0' , '0' ) 04/11/2022 08:25:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002060' AND id_product != '20263' AND ean13 != '' 04/11/2022 08:25:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002060', date_upd = NOW() WHERE id_product = '20263' 04/11/2022 08:25:00 am >> UPDATE ps_product_lang SET name = 'PIZZO IHS UVA - PIZ0M420', description = '' WHERE id_product = '20263' 04/11/2022 08:25:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '118.85245901639344' WHERE id_product = '20263' 04/11/2022 08:25:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '118.85245901639344', id_tax_rules_group = '1', id_category_default = '494', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20263' 04/11/2022 08:25:00 am >> DELETE FROM ps_specific_price WHERE id_product = '20263' 04/11/2022 08:25:01 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 = '20263' 04/11/2022 08:25:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20264' , '1' , '' , 'nuovo-prodotto' ) 04/11/2022 08:25:01 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 '20264' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20263' 04/11/2022 08:25:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20264' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20263' 04/11/2022 08:26:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002061' AND id_product != '20264' AND ean13 != '' 04/11/2022 08:26:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002061', date_upd = NOW() WHERE id_product = '20264' 04/11/2022 08:26:47 am >> UPDATE ps_product_lang SET name = 'PIZZO MARIANO - PIZ0M419 - M 3,10', description = '' WHERE id_product = '20264' 04/11/2022 08:26:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '159.8360655737705' WHERE id_product = '20264' 04/11/2022 08:26:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '159.8360655737705', id_tax_rules_group = '1', id_category_default = '494', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20264' 04/11/2022 08:26:48 am >> DELETE FROM ps_specific_price WHERE id_product = '20264' 04/11/2022 08:26: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 = '20264' 04/11/2022 08:26:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20265' , '1' , '' , 'nuovo-prodotto' ) 04/11/2022 08:26: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 '20265' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20264' 04/11/2022 08:26:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20265' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20264' 04/11/2022 08:28:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '110' , '2022-10-31' , '' , '0' , '160' , '4673832' , 'VIA TIRABOSCHI 13 24017 SERINA ' , '' , '' , '10.78' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '917.06' , '751.69' , NOW() , NOW() ) 04/11/2022 08:28: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 = '70347' 04/11/2022 08:28:00 am >> DELETE FROM ps_document_detail WHERE id_document = '70347' 04/11/2022 08:28: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 ( '70347' , '20263' , 'PIZZO IHS UVA - PIZ0M420' , '8.6' , '8.6' , '1' , '65.71' , '53.860655737705' , '22' , '0' , '689.4293' ) 04/11/2022 08:28:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '20263' AND id_supplier = '160' 04/11/2022 08:28:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20263' , '160' , '1' ) 04/11/2022 08:28: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 ( '70347' , '20264' , 'PIZZO MARIANO - PIZ0M419 - M 3,10' , '2' , '2' , '1' , '87.9' , '72.049180327869' , '22' , '0' , '214.4760' ) 04/11/2022 08:28:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '20264' AND id_supplier = '160' 04/11/2022 08:28:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20264' , '160' , '1' ) 04/11/2022 09:10:40 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1656' 04/11/2022 09:10:40 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1656' , '10' , '210' , '' , 'MARONE ' , ' DON LUIGI' , 'v' , '' , '84060' , 'OMIGNANO SCALO' , '' , '333 3078088' , '' , '' , '' , NOW() , NOW() ) 04/11/2022 09:10:40 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1656' 04/11/2022 09:37:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 09:37:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3323' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.10' , '0.90' , NOW() , NOW() ) 04/11/2022 09:37:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70348' 04/11/2022 09:37:55 am >> DELETE FROM ps_document_detail WHERE id_document = '70348' 04/11/2022 09:37:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70348' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 04/11/2022 09:37:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 04/11/2022 09:37:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 04/11/2022 09:42:37 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Jo9L0Vd3UsDP0MMu' , NOW() , NOW() ) 04/11/2022 09:42:37 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7004' , '1' ) 04/11/2022 09:42:37 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7004' , '2' ) 04/11/2022 09:42:37 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7004' , '3' ) 04/11/2022 09:44:49 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7004' 04/11/2022 09:44:49 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7004' , '10' , '183' , 'PARROCCHIA SAN MICHELE ARC' , 'NAZARO' , 'DON CIRO' , 'RIONE SANICELLE' , '' , '80021' , 'AFRAGOLA' , 'DA SPEDIRE : SIG. MANNA MARCO - VIA BENEDETTO CROCE, 35 - TEL 3516188052' , '' , '' , '' , '' , NOW() , NOW() ) 04/11/2022 09:44:49 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7004' 04/11/2022 09:46:27 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7004' 04/11/2022 09:46:27 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7004' , '10' , '183' , 'PARROCCHIA SAN MICHELE ARC' , 'NAZARO' , 'DON CIRO' , 'RIONE SANICELLE' , '' , '80021' , 'AFRAGOLA' , 'DA SPEDIRE : SIG. MANNA MARCO - VIA BENEDETTO CROCE, 35 - TEL 3516188052' , '' , '' , '' , '' , NOW() , NOW() ) 04/11/2022 09:46:27 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7004' 04/11/2022 09:49:18 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '5jLAa6wOfm9mnSkC' , NOW() , NOW() ) 04/11/2022 09:49:18 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3956' , '1' ) 04/11/2022 09:49:18 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3956' , '2' ) 04/11/2022 09:49:18 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3956' , '3' ) 04/11/2022 09:53:55 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3956' 04/11/2022 09:53:55 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3956' , '10' , '183' , 'PARROCCHIA SAN MICHELE ARC' , 'NAZARO' , 'DON CIRO' , 'RIONE SANICELLE' , '' , '80021' , 'AFRAGOLA ' , 'DA SPEDIRE : SIG. MANNA MARCO - VIA BENEDETTO CROCE, 35 - TEL 3516188052' , '' , '' , '' , '' , NOW() , NOW() ) 04/11/2022 09:53:55 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3956' 04/11/2022 09:54:56 am >> SELECT document_num FROM ps_document WHERE document_num = '241' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 09:54:56 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' , '241' , '2022-11-04' , '' , '3956' , '0' , '4676362' , 'RIONE SANICELLE 80021 AFRAGOLA ' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '34.50' , NOW() , NOW() ) 04/11/2022 09:54:56 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 = '70349' 04/11/2022 09:54:56 am >> DELETE FROM ps_document_detail WHERE id_document = '70349' 04/11/2022 09:54:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70349' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/11/2022 09:54:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70349' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '5' , '9.50' ) 04/11/2022 09:54:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70349' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 04/11/2022 10:01:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:01:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3324' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.03' , '82.59' , NOW() , NOW() ) 04/11/2022 10:01:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70350' 04/11/2022 10:01:11 am >> DELETE FROM ps_document_detail WHERE id_document = '70350' 04/11/2022 10:01:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70350' , '7202' , 'ARTICOLI RELIGIOSI' , '15' , '-15' , '1' , '2.7' , '2.2131147540984' , '22' , '0' , '40.50' ) 04/11/2022 10:01:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/11/2022 10:01:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/11/2022 10:01:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70350' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 04/11/2022 10:01:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 04/11/2022 10:01:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 04/11/2022 10:01: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 ( '70350' , '16909' , 'CUORE A CUORE CON GESU - 8134' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 04/11/2022 10:01:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '16909' AND id_supplier = '' 04/11/2022 10:01:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16909' , '' , '1' ) 04/11/2022 10:01: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 ( '70350' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '-2' , '1' , '9.6' , '7.8688524590164' , '22' , '0' , '19.20' ) 04/11/2022 10:01:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19213' AND id_supplier = '' 04/11/2022 10:01:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19213' , '' , '1' ) 04/11/2022 10:01: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 ( '70350' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' ) 04/11/2022 10:01:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 04/11/2022 10:01:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 04/11/2022 10:01: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 ( '70350' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 04/11/2022 10:01:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 04/11/2022 10:01:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 04/11/2022 10:20:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:20:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3325' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 04/11/2022 10:20:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70351' 04/11/2022 10:20:27 am >> DELETE FROM ps_document_detail WHERE id_document = '70351' 04/11/2022 10:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70351' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 04/11/2022 10:20:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 04/11/2022 10:20:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 04/11/2022 10:25:20 am >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:25:20 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' , '242' , '2022-11-04' , '' , '3936' , '0' , '4675877' , 'via bitetto , 34 70020 Bitritto' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '65.60' , '65.60' , NOW() , NOW() ) 04/11/2022 10:25: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 = '70352' 04/11/2022 10:25:20 am >> DELETE FROM ps_document_detail WHERE id_document = '70352' 04/11/2022 10:25: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 ( '70352' , '8408' , 'PRENDETE E MANGIATE' , '22' , '-22' , '4' , '3.00' , '3' , '0' , '5' , '62.70' ) 04/11/2022 10:25: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 ( '70352' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 04/11/2022 10:25:56 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3936' 04/11/2022 10:25:56 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3936' , '10' , '131' , '' , 'lasaracina' , 'anna' , 'via bitetto , 34' , '' , '70020' , 'Bitritto' , '' , '' , '3491511714' , '' , '' , NOW() , NOW() ) 04/11/2022 10:25:56 am >> UPDATE ps_customer SET email = 'annavito2003@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3936' 04/11/2022 10:26:20 am >> SELECT document_num FROM ps_document WHERE document_num = '241' AND id_document != '70349' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:26:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '241', document_date = '2022-11-04', document_letter = '', id_customer = '3956', id_supplier = '', id_address = '4676362', address1 = 'RIONE SANICELLE 80021 AFRAGOLA ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '34.50', price_tax_excluded = '34.50', date_upd = NOW() WHERE id_document = '70349' 04/11/2022 10:26: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 = '70349' 04/11/2022 10:26:20 am >> DELETE FROM ps_document_detail WHERE id_document = '70349' 04/11/2022 10:26: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 ( '70349' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/11/2022 10:26:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 04/11/2022 10:26:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 04/11/2022 10:26: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 ( '70349' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10' , '-10' , '4' , '1.0000' , '1' , '0' , '5' , '9.50' ) 04/11/2022 10:26:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16665' AND id_supplier = '' 04/11/2022 10:26:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16665' , '' , '1' ) 04/11/2022 10:26: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 ( '70349' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/11/2022 10:26:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 04/11/2022 10:26:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 04/11/2022 10:27:51 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'BsXhSXIe8Q7Se0ak' , NOW() , NOW() ) 04/11/2022 10:27:51 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3957' , '1' ) 04/11/2022 10:27:51 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3957' , '2' ) 04/11/2022 10:27:51 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3957' , '3' ) 04/11/2022 10:29:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3957' 04/11/2022 10:29:44 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3957' , '10' , '179' , 'PARROCCHIA MARIA SS DI TORTORICI' , 'CAMPANA' , 'PADRE SIMONE' , 'PIAZZA DUOMO' , '' , '98078' , 'TORTORICI' , '' , '' , '3291489297' , '' , '' , NOW() , NOW() ) 04/11/2022 10:29:44 am >> UPDATE ps_customer SET email = 'campana.simone88@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3957' 04/11/2022 10:32:50 am >> SELECT document_num FROM ps_document WHERE document_num = '243' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:32:50 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' , '243' , '2022-11-04' , '' , '3957' , '0' , '4676364' , 'PIAZZA DUOMO 98078 TORTORICI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '243.03' , '243.03' , NOW() , NOW() ) 04/11/2022 10:32:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70353' 04/11/2022 10:32:50 am >> DELETE FROM ps_document_detail WHERE id_document = '70353' 04/11/2022 10:32:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70353' , '4154' , 'FESTA DEL PERDONO' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 04/11/2022 10:32:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70353' , '8408' , 'PRENDETE E MANGIATE' , '35' , '-35' , '4' , '3.00' , '3' , '0' , '15' , '89.25' ) 04/11/2022 10:32:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70353' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 04/11/2022 10:32:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70353' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 04/11/2022 10:33:08 am >> SELECT document_num FROM ps_document WHERE document_num = '243' AND id_document != '70353' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:33:08 am >> UPDATE ps_document SET id_document_type = '21', document_num = '243', document_date = '2022-11-04', document_letter = '', id_customer = '3957', id_supplier = '', id_address = '4676364', address1 = 'PIAZZA DUOMO 98078 TORTORICI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '243.03', price_tax_excluded = '243.03', date_upd = NOW() WHERE id_document = '70353' 04/11/2022 10:33: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 = '70353' 04/11/2022 10:33:08 am >> DELETE FROM ps_document_detail WHERE id_document = '70353' 04/11/2022 10:33: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 ( '70353' , '4154' , 'FESTA DEL PERDONO' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 04/11/2022 10:33:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 04/11/2022 10:33:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 04/11/2022 10:33: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 ( '70353' , '8408' , 'PRENDETE E MANGIATE' , '35' , '-35' , '4' , '3.0000' , '3' , '0' , '15' , '89.25' ) 04/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 04/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 04/11/2022 10:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70353' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 04/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 04/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 04/11/2022 10:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70353' , '0' , 'contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/11/2022 10:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 04/11/2022 10:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 04/11/2022 10:37:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3326' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:37:51 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' , '3326' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '9.75' , NOW() , NOW() ) 04/11/2022 10:37:51 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 = '70354' 04/11/2022 10:37:51 am >> DELETE FROM ps_document_detail WHERE id_document = '70354' 04/11/2022 10:37:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70354' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 04/11/2022 10:37:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 04/11/2022 10:37:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 04/11/2022 10:37:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70354' , '9102' , 'ROSARIO DIVINA MISERICORDIA - VETRO ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/11/2022 10:37:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '9102' AND id_supplier = '' 04/11/2022 10:37:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9102' , '' , '1' ) 04/11/2022 10:37:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70354' , '13545' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 1968' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 04/11/2022 10:37:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '13545' AND id_supplier = '' 04/11/2022 10:37:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13545' , '' , '1' ) 04/11/2022 10:37:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70354' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 04/11/2022 10:37:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 04/11/2022 10:37:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 04/11/2022 10:41:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3327' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 10:41:15 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' , '3327' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.40' , '12.33' , NOW() , NOW() ) 04/11/2022 10:41:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70355' 04/11/2022 10:41:15 am >> DELETE FROM ps_document_detail WHERE id_document = '70355' 04/11/2022 10:41:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70355' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 04/11/2022 10:41:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/11/2022 10:41:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/11/2022 10:41:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70355' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 04/11/2022 10:41:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/11/2022 10:41:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/11/2022 11:28:32 am >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '68029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-21') 04/11/2022 11:28:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2022-10-21', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '139.60', price_tax_excluded = '119.57', date_upd = NOW() WHERE id_document = '68029' 04/11/2022 11:28:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68029' 04/11/2022 11:28:32 am >> DELETE FROM ps_document_detail WHERE id_document = '68029' 04/11/2022 11:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '20.30' ) 04/11/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 04/11/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 04/11/2022 11:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 04/11/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 04/11/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 04/11/2022 11:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 04/11/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 04/11/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 04/11/2022 11:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '6019' , 'LUMINO ROSSO - 10B' , '192' , '-192' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '76.80' ) 04/11/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '' 04/11/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '' , '1' ) 04/11/2022 11:42:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254711132' AND id_product != '20265' AND ean13 != '' 04/11/2022 11:42:08 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9791254711132', date_upd = NOW() WHERE id_product = '20265' 04/11/2022 11:42:08 am >> UPDATE ps_product_lang SET name = 'VANGELO SULLA STRADA - V. PAGLIA', description = '' WHERE id_product = '20265' 04/11/2022 11:42:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20265' 04/11/2022 11:42:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20265' 04/11/2022 11:42:08 am >> DELETE FROM ps_specific_price WHERE id_product = '20265' 04/11/2022 11:42:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882720070' AND id_product != '5823' AND ean13 != '' 04/11/2022 11:42:42 am >> UPDATE ps_product SET id_supplier = '61', reference = '13/5', ean13 = '9788882720070', date_upd = NOW() WHERE id_product = '5823' 04/11/2022 11:42:42 am >> UPDATE ps_product_lang SET name = 'LIBRO D\'ORO', description = '' WHERE id_product = '5823' 04/11/2022 11:42:42 am >> UPDATE ps_product SET wholesale_price = '0.35', on_sale = '0', price = '0.6' WHERE id_product = '5823' 04/11/2022 11:42:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.35', price = '0.6', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5823' 04/11/2022 11:42:42 am >> DELETE FROM ps_specific_price WHERE id_product = '5823' 04/11/2022 11:43:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/11/2022 11:43:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20266' , '1' , '' , 'nuovo-prodotto' ) 04/11/2022 11:43:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20266' , '1' , '1' , '2' , NOW() , NOW() ) 04/11/2022 11:43:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20266' , '0' , '1' , '0' , '0' ) 04/11/2022 11:44:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259622235' AND id_product != '20266' AND ean13 != '' 04/11/2022 11:44:39 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9791259622235', date_upd = NOW() WHERE id_product = '20266' 04/11/2022 11:44:39 am >> UPDATE ps_product_lang SET name = 'MISTICA CITTA\' DI DIO DI MARIA DI GESU\' D\'AGREDA - S. SCIORIO', description = '' WHERE id_product = '20266' 04/11/2022 11:44:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '20266' 04/11/2022 11:44:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20266' 04/11/2022 11:44:39 am >> DELETE FROM ps_specific_price WHERE id_product = '20266' 04/11/2022 11:44:40 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 = '20266' 04/11/2022 11:44:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20267' , '1' , '' , 'nuovo-prodotto' ) 04/11/2022 11:44:40 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 '20267' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20266' 04/11/2022 11:44:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20267' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20266' 04/11/2022 11:44: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 ( '33' , '304664' , '2022-11-03' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '234.50' , '234.50' , NOW() , NOW() ) 04/11/2022 11:44: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 = '70356' 04/11/2022 11:44:57 am >> DELETE FROM ps_document_detail WHERE id_document = '70356' 04/11/2022 11:44: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 ( '70356' , '20265' , 'VANGELO SULLA STRADA - V. PAGLIA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 04/11/2022 11:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20265' AND id_supplier = '109' 04/11/2022 11:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20265' , '109' , '1' ) 04/11/2022 11:44: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 ( '70356' , '5823' , 'LIBRO DORO' , '50' , '50' , '4' , '0.60' , '0.6' , '0' , '0' , '30.0000' ) 04/11/2022 11:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 04/11/2022 11:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 04/11/2022 11:44: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 ( '70356' , '20266' , 'MISTICA CITTA DI DIO DI MARIA DI GESU DAGREDA - S. SCIORIO' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 04/11/2022 11:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20266' AND id_supplier = '109' 04/11/2022 11:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20266' , '109' , '1' ) 04/11/2022 11:44: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 ( '70356' , '4460' , 'GESÙ IL SIGNORE' , '3' , '3' , '4' , '53.50' , '53.5' , '0' , '0' , '160.5000' ) 04/11/2022 11:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '4460' AND id_supplier = '109' 04/11/2022 11:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4460' , '109' , '1' ) 04/11/2022 12:02:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3328' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:02:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3328' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 04/11/2022 12:02:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70357' 04/11/2022 12:02:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '70357' 04/11/2022 12:02:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70357' , '8248' , 'PREGATE, PREGATE, PREGATE - CART. - 8101' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '' , '10.00' ) 04/11/2022 12:02:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8248' AND id_supplier = '' 04/11/2022 12:02:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8248' , '' , '1' ) 04/11/2022 12:07:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:07:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3329' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.11' , '74.11' , NOW() , NOW() ) 04/11/2022 12:07:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70358' 04/11/2022 12:07:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '70358' 04/11/2022 12:07:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/11/2022 12:07:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 04/11/2022 12:07:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 04/11/2022 12:07:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '6302' , 'MATTEO' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 04/11/2022 12:07:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6302' AND id_supplier = '' 04/11/2022 12:07:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6302' , '' , '1' ) 04/11/2022 12:07:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/11/2022 12:07:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 04/11/2022 12:07:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 04/11/2022 12:07:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '1143' , 'BIBBIA DI GERUSALEMME - TASCABILE' , '1' , '-1' , '4' , '21.90' , '21.9' , '0' , '5' , '20.81' ) 04/11/2022 12:07:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1143' AND id_supplier = '' 04/11/2022 12:07:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1143' , '' , '1' ) 04/11/2022 12:09:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:09:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3330' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.80' , '62.95' , NOW() , NOW() ) 04/11/2022 12:09:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70359' 04/11/2022 12:09:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '70359' 04/11/2022 12:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70359' , '6019' , 'LUMINO ROSSO - 10B' , '192' , '-192' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '76.80' ) 04/11/2022 12:09:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6019' AND id_supplier = '' 04/11/2022 12:09:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6019' , '' , '1' ) 04/11/2022 12:09:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:09:39 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' , '3331' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 04/11/2022 12:09:39 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 = '70360' 04/11/2022 12:09:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '70360' 04/11/2022 12:09:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70360' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 04/11/2022 12:09:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '' 04/11/2022 12:09:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '' , '1' ) 04/11/2022 12:10:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '68029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-21') 04/11/2022 12:10:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2022-10-21', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '62.80', price_tax_excluded = '56.61', date_upd = NOW() WHERE id_document = '68029' 04/11/2022 12:10:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68029' 04/11/2022 12:10:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '68029' 04/11/2022 12:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '20.30' ) 04/11/2022 12:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 04/11/2022 12:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 04/11/2022 12:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 04/11/2022 12:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 04/11/2022 12:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 04/11/2022 12:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68029' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 04/11/2022 12:10:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 04/11/2022 12:10:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 04/11/2022 12:11:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:11:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3332' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/11/2022 12:11:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70361' 04/11/2022 12:11:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '70361' 04/11/2022 12:11:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70361' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/11/2022 12:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 04/11/2022 12:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 04/11/2022 12:24:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3333' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:24:46 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' , '3333' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 04/11/2022 12:24:46 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 = '70362' 04/11/2022 12:24:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '70362' 04/11/2022 12:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70362' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/11/2022 12:24:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3104' AND id_supplier = '' 04/11/2022 12:24:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3104' , '' , '1' ) 04/11/2022 12:40:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607696' AND id_product != '20267' AND ean13 != '' 04/11/2022 12:40:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826607696', date_upd = NOW() WHERE id_product = '20267' 04/11/2022 12:40:59 pm >> UPDATE ps_product_lang SET name = 'CRISTO SI E\' FATTO POVERO', description = '' WHERE id_product = '20267' 04/11/2022 12:40:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '20267' 04/11/2022 12:40:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20267' 04/11/2022 12:40:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '20267' 04/11/2022 12:41:00 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 = '20267' 04/11/2022 12:41:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20268' , '1' , '' , 'nuovo-prodotto' ) 04/11/2022 12:41:00 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 '20268' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20267' 04/11/2022 12:41:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20268' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20267' 04/11/2022 12:41:57 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' , '003190' , '2022-11-03' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '344.15' , '344.15' , NOW() , NOW() ) 04/11/2022 12:41:57 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 = '70363' 04/11/2022 12:41:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '70363' 04/11/2022 12:41:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70363' , '20267' , 'CRISTO SI E FATTO POVERO' , '150' , '150' , '4' , '2.50' , '2.5' , '0' , '45' , '206.2500' ) 04/11/2022 12:41:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20267' AND id_supplier = '79' 04/11/2022 12:41:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20267' , '79' , '1' ) 04/11/2022 12:41:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70363' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 04/11/2022 12:41:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 04/11/2022 12:41:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 04/11/2022 12:41:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70363' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '1' , '4' , '60.00' , '60' , '0' , '30' , '42.0000' ) 04/11/2022 12:41:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 04/11/2022 12:41:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 04/11/2022 12:41:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70363' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '1' , '4' , '27.00' , '27' , '0' , '30' , '18.9000' ) 04/11/2022 12:41:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 04/11/2022 12:41:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 04/11/2022 12:54:10 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'EpGdmOEs9vGBUmd9' , NOW() , NOW() ) 04/11/2022 12:54:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7005' , '1' ) 04/11/2022 12:54:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7005' , '2' ) 04/11/2022 12:54:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7005' , '3' ) 04/11/2022 12:57:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7005' 04/11/2022 12:57:12 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 ( '7005' , '10' , '211' , 'PARROCCHIA MATER ECCLESIAE' , 'SALIS' , 'DON MASSIMILIANO ' , 'VIA LUNA E SOLE 1' , '' , '07100' , 'SASSARI' , '' , '' , '3471574669' , '' , '80008290902' , NOW() , NOW() ) 04/11/2022 12:57:12 pm >> UPDATE ps_customer SET email = 'parrocchiamecclesiae@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7005' 04/11/2022 12:57:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:57:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '107' , '2022-11-04' , '' , '7005' , '0' , '93349186' , 'VIA LUNA E SOLE 1 07100 SASSARI' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.90' , '141.90' , NOW() , NOW() ) 04/11/2022 12:57:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8437' 04/11/2022 12:57:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '8437' 04/11/2022 12:57:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8437' , '125' , 'MIE PREGHIERINE - N. E.' , '100' , '-100' , '4' , '1.50' , '1.5' , '0' , '10' , '135.00' ) 04/11/2022 12:58:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '8437' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 12:58:18 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '107', document_date = '2022-11-04', document_letter = '', id_customer = '7005', id_supplier = '', id_address = '93349186', address1 = 'VIA LUNA E SOLE 1 07100 SASSARI', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '141.90', price_tax_excluded = '141.90', date_upd = NOW() WHERE id_document = '8437' 04/11/2022 12:58:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '8437' 04/11/2022 12:58:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '8437' 04/11/2022 12:58:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '8437' , '125' , 'MIE PREGHIERINE - N. E.' , '100' , '-100' , '4' , '1.5000' , '1.5' , '0' , '10' , '135.00' ) 04/11/2022 12:58:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '' 04/11/2022 12:58:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '' , '1' ) 04/11/2022 03:17:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 03:17:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3334' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/11/2022 03:17:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70364' 04/11/2022 03:17:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '70364' 04/11/2022 03:17:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70364' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/11/2022 03:17:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 04/11/2022 03:17:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 04/11/2022 03:51:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 03:51:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3335' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '284.00' , '260.65' , NOW() , NOW() ) 04/11/2022 03:51:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70365' 04/11/2022 03:51:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '70365' 04/11/2022 03:51:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/11/2022 03:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '' 04/11/2022 03:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '' , '1' ) 04/11/2022 03:51:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/11/2022 03:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '' 04/11/2022 03:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '' , '1' ) 04/11/2022 03:51:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/11/2022 03:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '' 04/11/2022 03:51:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '' , '1' ) 04/11/2022 03:51:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/11/2022 03:51:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 04/11/2022 03:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 04/11/2022 03:51:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 04/11/2022 03:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 04/11/2022 03:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 04/11/2022 03:51:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '127.8' , '104.75409836066' , '22' , '0' , '127.80' ) 04/11/2022 03:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/11/2022 03:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/11/2022 03:51:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70365' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/11/2022 03:51:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20247' AND id_supplier = '' 04/11/2022 03:51:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20247' , '' , '1' ) 04/11/2022 05:03:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801050356' AND id_product != '5161' AND ean13 != '' 04/11/2022 05:03:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788801050356', date_upd = NOW() WHERE id_product = '5161' 04/11/2022 05:03:13 pm >> UPDATE ps_product_lang SET name = 'IN CAMMINO VERSO L\'EUCARISTIA', description = '' WHERE id_product = '5161' 04/11/2022 05:03:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '5161' 04/11/2022 05:03:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5161' 04/11/2022 05:03:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '5161' 04/11/2022 05:25:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 05:25:07 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' , '3336' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.00' , '113.11' , NOW() , NOW() ) 04/11/2022 05:25:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70366' 04/11/2022 05:25:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '70366' 04/11/2022 05:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70366' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' , '-1' , '1' , '48.80' , '40' , '22' , '0' , '48.80' ) 04/11/2022 05:25:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = '' 04/11/2022 05:25:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' ) 04/11/2022 05:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70366' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '59.2' , '48.524590163934' , '22' , '0' , '59.20' ) 04/11/2022 05:25:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/11/2022 05:25:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/11/2022 05:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70366' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '3' , '2.4590163934426' , '22' , '0' , '30.00' ) 04/11/2022 05:25:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/11/2022 05:25:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/11/2022 05:39:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '292' 04/11/2022 05:39:04 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 ( '292' , '10' , '210' , 'PARROCCHIA S. ANTONIO' , 'CASTALDI ' , 'DON PAOLO' , 'VIA IONIO 8/A' , '' , '84091' , 'BATTIPAGLIA' , '' , '0828 370087' , '' , '' , '91006970650' , NOW() , NOW() ) 04/11/2022 05:39:04 pm >> UPDATE ps_customer SET email = 'parr_santonio@libero.it', sdi = '0000000', pec = 'parr_santonio@pec.libero.it', date_upd = NOW() WHERE id_customer = '292' 04/11/2022 05:39:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/L' AND id_document != '70300' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-02') 04/11/2022 05:39:19 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '11/L', document_date = '2022-11-02', document_letter = 'L', id_customer = '292', id_supplier = '0', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1571.00', price_tax_excluded = '1571.00', date_upd = NOW() WHERE id_document = '70300' 04/11/2022 05:39: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 = '70300' 04/11/2022 05:39:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '70300' 04/11/2022 05:39: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 ( '70300' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 04/11/2022 05:39: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 ( '70300' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 04/11/2022 05:39: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 ( '70300' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '6' , '-6' , '4' , '13.5000' , '13.5' , '0' , '0' , '81.00' ) 04/11/2022 05:39: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 ( '70300' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '8' , '-8' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 04/11/2022 05:39: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 ( '70300' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 05:39: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 ( '70300' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 05:39: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 ( '70300' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 05:39: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 ( '70300' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '55' , '-55' , '4' , '4.5000' , '4.5' , '0' , '0' , '247.50' ) 04/11/2022 05:39: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 ( '70300' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 04/11/2022 05:39: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 ( '70300' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '10' , '-10' , '4' , '4.5000' , '4.5' , '0' , '0' , '45.00' ) 04/11/2022 05:39:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '-25' , '4' , '4.5000' , '4.5' , '0' , '0' , '112.50' ) 04/11/2022 05:39:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '30' , '-30' , '4' , '4.5000' , '4.5' , '0' , '0' , '135.00' ) 04/11/2022 05:39:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '14530' , 'PANE E VINO - GUIDA 3' , '8' , '-8' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 04/11/2022 05:39:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '60' , '-60' , '4' , '4.5000' , '4.5' , '0' , '0' , '270.00' ) 04/11/2022 05:45:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/L' AND id_document != '70300' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-02') 04/11/2022 05:45:51 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '11/L', document_date = '2022-11-02', document_letter = 'L', id_customer = '292', id_supplier = '0', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1571.00', price_tax_excluded = '1571.00', date_upd = NOW() WHERE id_document = '70300' 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70300' 04/11/2022 05:45:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '70300' 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '6' , '-6' , '4' , '13.5000' , '13.5' , '0' , '0' , '81.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '8' , '-8' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '55' , '-55' , '4' , '4.5000' , '4.5' , '0' , '0' , '247.50' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '10' , '-10' , '4' , '4.5000' , '4.5' , '0' , '0' , '45.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '-25' , '4' , '4.5000' , '4.5' , '0' , '0' , '112.50' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '30' , '-30' , '4' , '4.5000' , '4.5' , '0' , '0' , '135.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '14530' , 'PANE E VINO - GUIDA 3' , '8' , '-8' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 04/11/2022 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '60' , '-60' , '4' , '4.5000' , '4.5' , '0' , '0' , '270.00' ) 04/11/2022 05:49:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801065947' AND id_product != '15926' AND ean13 != '' 04/11/2022 05:49:14 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788801065947', date_upd = NOW() WHERE id_product = '15926' 04/11/2022 05:49:14 pm >> UPDATE ps_product_lang SET name = 'COMUNITA\': SEGNI DI BELLEZZA - 4 QUADERNO', description = '' WHERE id_product = '15926' 04/11/2022 05:49:14 pm >> UPDATE ps_product SET wholesale_price = '3.25', on_sale = '0', price = '5.0000' WHERE id_product = '15926' 04/11/2022 05:49:14 pm >> UPDATE ps_product_shop SET wholesale_price = '3.25', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15926' 04/11/2022 05:49:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '15926' 04/11/2022 06:24:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 06:24:26 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' , '3337' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '502.00' , '502.00' , NOW() , NOW() ) 04/11/2022 06:24:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70367' 04/11/2022 06:24:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '70367' 04/11/2022 06:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70367' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '4' , '-4' , '4' , '87' , '87' , '0' , '0' , '348.00' ) 04/11/2022 06:24:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20151' AND id_supplier = '' 04/11/2022 06:24:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20151' , '' , '1' ) 04/11/2022 06:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70367' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '-1' , '4' , '39.50' , '39.5' , '0' , '5' , '37.53' ) 04/11/2022 06:24:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '' 04/11/2022 06:24:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '' , '1' ) 04/11/2022 06:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70367' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '14.97' , '14.97' , '0' , '' , '14.97' ) 04/11/2022 06:24:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20247' AND id_supplier = '' 04/11/2022 06:24:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20247' , '' , '1' ) 04/11/2022 06:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70367' , '4460' , 'GESÙ IL SIGNORE' , '2' , '-2' , '4' , '50.5' , '50.5' , '0' , '0' , '101.00' ) 04/11/2022 06:24:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4460' AND id_supplier = '' 04/11/2022 06:24:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4460' , '' , '1' ) 04/11/2022 06:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70367' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 04/11/2022 06:24:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 04/11/2022 06:24:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 04/11/2022 06:24:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3338' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 06:24: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 ( '11' , '3338' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '348.00' , '348.00' , NOW() , NOW() ) 04/11/2022 06:24: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 = '70368' 04/11/2022 06:24:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '70368' 04/11/2022 06:24: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 ( '70368' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '4' , '-4' , '4' , '87' , '87' , '0' , '0' , '348.00' ) 04/11/2022 06:24:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20151' AND id_supplier = '' 04/11/2022 06:24:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20151' , '' , '1' ) 04/11/2022 06:25:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 06:25: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' , '3339' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 04/11/2022 06:25: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 = '70369' 04/11/2022 06:25:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '70369' 04/11/2022 06:25: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 ( '70369' , '20199' , 'PAROLA DI DIO OGNI GIORNO 2023 - V. PAGLIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 04/11/2022 06:25:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20199' AND id_supplier = '' 04/11/2022 06:25:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20199' , '' , '1' ) 04/11/2022 06:34:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 06:34:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3340' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 04/11/2022 06:34:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70370' 04/11/2022 06:34:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '70370' 04/11/2022 06:34:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70370' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 04/11/2022 06:34:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '' 04/11/2022 06:34:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' ) 04/11/2022 07:12:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 07:12:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3341' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 04/11/2022 07:12:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70371' 04/11/2022 07:12:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '70371' 04/11/2022 07:12:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70371' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 04/11/2022 07:12:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 04/11/2022 07:12:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 04/11/2022 07:14:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 07:14:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3342' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '10.96' , NOW() , NOW() ) 04/11/2022 07:14:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70372' 04/11/2022 07:14:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '70372' 04/11/2022 07:14:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70372' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 04/11/2022 07:14:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/11/2022 07:14:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/11/2022 07:15:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0210482' AND id_product != '6014' AND ean13 != '' 04/11/2022 07:15:02 pm >> UPDATE ps_product SET id_supplier = '36', reference = '2016', ean13 = '0210482', date_upd = NOW() WHERE id_product = '6014' 04/11/2022 07:15:02 pm >> UPDATE ps_product_lang SET name = 'LUMINO BIANCO - 10B', description = '' WHERE id_product = '6014' 04/11/2022 07:15:02 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.36885245901639346' WHERE id_product = '6014' 04/11/2022 07:15:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.36885245901639346', id_tax_rules_group = '1', id_category_default = '205', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6014' 04/11/2022 07:15:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '6014' 04/11/2022 07:15:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0210481' AND id_product != '6019' AND ean13 != '' 04/11/2022 07:15:38 pm >> UPDATE ps_product SET id_supplier = '36', reference = '2016', ean13 = '0210481', date_upd = NOW() WHERE id_product = '6019' 04/11/2022 07:15:38 pm >> UPDATE ps_product_lang SET name = 'LUMINO ROSSO - 10B', description = '' WHERE id_product = '6019' 04/11/2022 07:15:38 pm >> UPDATE ps_product SET wholesale_price = '0.16', on_sale = '0', price = '0.36885245901639346' WHERE id_product = '6019' 04/11/2022 07:15:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.16', price = '0.36885245901639346', id_tax_rules_group = '1', id_category_default = '205', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6019' 04/11/2022 07:15:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '6019' 04/11/2022 07:18:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 07:18:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3343' , '2022-11-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.20' , '13.17' , NOW() , NOW() ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70373' 04/11/2022 07:18:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '70373' 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '6014' , 'LUMINO BIANCO - 10B' , '6' , '-6' , '1' , '0.45' , '0.36885245901639' , '22' , '0' , '2.70' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6014' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6014' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15030' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15030' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18619' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18619' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '7134' , 'NOZIONI E PRECI' , '1' , '-1' , '4' , '1.30' , '1.3' , '0' , '0' , '1.30' ) 04/11/2022 07:18:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7134' AND id_supplier = '' 04/11/2022 07:18:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7134' , '' , '1' ) 04/11/2022 07:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70373' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/11/2022 07:18:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '' 04/11/2022 07:18:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '' , '1' ) 04/11/2022 07:18: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 ( '70373' , '6663' , 'MIE PREGHIERE - 8783' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/11/2022 07:18:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6663' AND id_supplier = '' 04/11/2022 07:18:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6663' , '' , '1' ) 04/11/2022 07:39:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/L' AND id_document != '70300' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-02') 04/11/2022 07:39:04 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '11/L', document_date = '2022-11-02', document_letter = 'L', id_customer = '292', id_supplier = '0', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1571.00', price_tax_excluded = '1571.00', date_upd = NOW() WHERE id_document = '70300' 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70300' 04/11/2022 07:39:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '70300' 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '6620' , 'MIA IMPRONTA È TUA- GUIDA' , '6' , '-6' , '4' , '13.5000' , '13.5' , '0' , '0' , '81.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '8' , '-8' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '55' , '-55' , '4' , '4.5000' , '4.5' , '0' , '0' , '247.50' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '10' , '-10' , '4' , '4.5000' , '4.5' , '0' , '0' , '45.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '-25' , '4' , '4.5000' , '4.5' , '0' , '0' , '112.50' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '30' , '-30' , '4' , '4.5000' , '4.5' , '0' , '0' , '135.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '14530' , 'PANE E VINO - GUIDA 3' , '8' , '-8' , '4' , '13.5000' , '13.5' , '0' , '0' , '108.00' ) 04/11/2022 07:39:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70300' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '60' , '-60' , '4' , '4.5000' , '4.5' , '0' , '0' , '270.00' ) 04/11/2022 07:58:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3336' AND id_document != '70366' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 07:58:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3336', document_date = '2022-11-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '138.00', price_tax_excluded = '113.11', date_upd = NOW() WHERE id_document = '70366' 04/11/2022 07:58:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70366' 04/11/2022 07:58:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '70366' 04/11/2022 07:58:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70366' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' , '-1' , '1' , '48.8000' , '40' , '22' , '0' , '48.80' ) 04/11/2022 07:58:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = '' 04/11/2022 07:58:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' ) 04/11/2022 07:58:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70366' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '59.2000' , '48.524590163934' , '22' , '0' , '59.20' ) 04/11/2022 07:58:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/11/2022 07:58:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/11/2022 07:58:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70366' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '10' , '-10' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '30.00' ) 04/11/2022 07:58:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20219' AND id_supplier = '' 04/11/2022 07:58:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20219' , '' , '1' ) 04/11/2022 08:03:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3329' AND id_document != '70358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-04') 04/11/2022 08:03:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3329', document_date = '2022-11-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '74.11', price_tax_excluded = '74.11', date_upd = NOW() WHERE id_document = '70358' 04/11/2022 08:03:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70358' 04/11/2022 08:03:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '70358' 04/11/2022 08:03:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 04/11/2022 08:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 04/11/2022 08:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 04/11/2022 08:03:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '6302' , 'MATTEO' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '5' , '36.10' ) 04/11/2022 08:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6302' AND id_supplier = '' 04/11/2022 08:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6302' , '' , '1' ) 04/11/2022 08:03:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 04/11/2022 08:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 04/11/2022 08:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 04/11/2022 08:03:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70358' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20.81' , '20.81' , '0' , '0' , '20.81' ) 04/11/2022 08:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/11/2022 08:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )