22/10/2022 09:25:30 am >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 09:25:30 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' , '201' , '2022-10-22' , '' , '541' , '0' , '4671522' , 'VIA GALLIANO 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.08' , '59.08' , NOW() , NOW() ) 22/10/2022 09:25:30 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 = '68051' 22/10/2022 09:25:30 am >> DELETE FROM ps_document_detail WHERE id_document = '68051' 22/10/2022 09:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '9' , '-9' , '4' , '3.50' , '3.5' , '0' , '15' , '26.78' ) 22/10/2022 09:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 22/10/2022 09:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 22/10/2022 09:25:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68051' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 22/10/2022 09:57:24 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1213' 22/10/2022 09:57:24 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 ( '1213' , '10' , '130' , 'PARROCCHIA MARIA SS DEL CARMINE E SAN FELICE' , 'GIARLETTA ' , 'DON ENRICO' , 'VIA M. PIRONTI' , '' , '83020' , 'MONTORO INFERIORE' , '' , '3334397973' , '' , '' , '' , NOW() , NOW() ) 22/10/2022 09:57:24 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1213' 22/10/2022 10:01:16 am >> SELECT document_num FROM ps_document WHERE document_num = '202' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:01:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '202' , '2022-10-22' , '' , '1213' , '0' , '1213' , 'VIA M. PIRONTI 83020 MONTORO INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.00' , '81.00' , NOW() , NOW() ) 22/10/2022 10:01:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68052' 22/10/2022 10:01:16 am >> DELETE FROM ps_document_detail WHERE id_document = '68052' 22/10/2022 10:01:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68052' , '6629' , 'MIA PREGHIERA' , '100' , '-100' , '4' , '0.90' , '0.9' , '0' , '10' , '81.00' ) 22/10/2022 10:04:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:04:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3151' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 22/10/2022 10:04:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68053' 22/10/2022 10:04:46 am >> DELETE FROM ps_document_detail WHERE id_document = '68053' 22/10/2022 10:04:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68053' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/10/2022 10:04:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 22/10/2022 10:04:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 22/10/2022 10:04:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68053' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 22/10/2022 10:04:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 22/10/2022 10:04:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 22/10/2022 10:08:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:08:01 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' , '3152' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.10' , '51.41' , NOW() , NOW() ) 22/10/2022 10:08:01 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 = '68054' 22/10/2022 10:08:01 am >> DELETE FROM ps_document_detail WHERE id_document = '68054' 22/10/2022 10:08:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68054' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 22/10/2022 10:08:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '6404' AND id_supplier = '' 22/10/2022 10:08:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6404' , '' , '1' ) 22/10/2022 10:08:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68054' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 22/10/2022 10:08:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 22/10/2022 10:08:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 22/10/2022 10:08:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68054' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 22/10/2022 10:08:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 22/10/2022 10:08:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 22/10/2022 10:08:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68054' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 22/10/2022 10:08:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 22/10/2022 10:08:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 22/10/2022 10:29:59 am >> SELECT document_num FROM ps_document WHERE document_num = '203' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:29:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '203' , '2022-10-22' , '' , '1151' , '0' , '4669498' , 'VIA XXV LUGLIO, 216 84013 CAVA DE\\\' TIRRENI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.68' , '38.68' , NOW() , NOW() ) 22/10/2022 10:29:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68055' 22/10/2022 10:29:59 am >> DELETE FROM ps_document_detail WHERE id_document = '68055' 22/10/2022 10:29:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68055' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 22/10/2022 10:33:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:33:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3153' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 22/10/2022 10:33:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68056' 22/10/2022 10:33:16 am >> DELETE FROM ps_document_detail WHERE id_document = '68056' 22/10/2022 10:33:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68056' , '13549' , 'COLLANINA ARGENTATA ALBERO DELLA VITA - 1984/J97' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 22/10/2022 10:33:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '13549' AND id_supplier = '' 22/10/2022 10:33:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13549' , '' , '1' ) 22/10/2022 10:33:46 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/10/2022 10:33:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20222' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:33:46 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20222' , '1' , '1' , '2' , NOW() , NOW() ) 22/10/2022 10:33:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20222' , '0' , '1' , '0' , '0' ) 22/10/2022 10:36:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001650' AND id_product != '20222' AND ean13 != '' 22/10/2022 10:36:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001650', date_upd = NOW() WHERE id_product = '20222' 22/10/2022 10:36:40 am >> UPDATE ps_product_lang SET name = 'BAMBINO IN GESSO CM 20 - IE76/20', description = '' WHERE id_product = '20222' 22/10/2022 10:36:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '106.55737704918033' WHERE id_product = '20222' 22/10/2022 10:36:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '106.55737704918033', id_tax_rules_group = '1', id_category_default = '461', 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 = '20222' 22/10/2022 10:36:40 am >> DELETE FROM ps_specific_price WHERE id_product = '20222' 22/10/2022 10:36:42 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 = '20222' 22/10/2022 10:36:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20223' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:36:42 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 '20223' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20222' 22/10/2022 10:36:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20223' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20222' 22/10/2022 10:38:21 am >> SELECT document_num FROM ps_document WHERE document_num = '204' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:38:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '204' , '2022-10-22' , '' , '3134' , '0' , '4674903' , 'VIA MICHELANGELO, 2 94013 LEONFORTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '75.80' , '75.80' , NOW() , NOW() ) 22/10/2022 10:38:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68057' 22/10/2022 10:38:21 am >> DELETE FROM ps_document_detail WHERE id_document = '68057' 22/10/2022 10:38:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68057' , '5444' , 'IO SONO CON VOI - CAT.' , '8' , '-8' , '4' , '5.50' , '5.5' , '0' , '5' , '41.80' ) 22/10/2022 10:38:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68057' , '5457' , 'IO SONO CON VOI 1 PARTE' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '15' , '17.00' ) 22/10/2022 10:38:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68057' , '5458' , 'IO SONO CON VOI 2 PARTE' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '15' , '17.00' ) 22/10/2022 10:39:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:39:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3154' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '11.14' , NOW() , NOW() ) 22/10/2022 10:39:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68058' 22/10/2022 10:39:16 am >> DELETE FROM ps_document_detail WHERE id_document = '68058' 22/10/2022 10:39:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68058' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/10/2022 10:39:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 22/10/2022 10:39:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 22/10/2022 10:39:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68058' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 22/10/2022 10:39:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 22/10/2022 10:39:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 22/10/2022 10:46:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001649' AND id_product != '20223' AND ean13 != '' 22/10/2022 10:46:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001649', date_upd = NOW() WHERE id_product = '20223' 22/10/2022 10:46:30 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO IN GESSO CM 50 - J202OA/50', description = '' WHERE id_product = '20223' 22/10/2022 10:46:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '241.80327868852459' WHERE id_product = '20223' 22/10/2022 10:46:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '241.80327868852459', id_tax_rules_group = '1', id_category_default = '461', 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 = '20223' 22/10/2022 10:46:30 am >> DELETE FROM ps_specific_price WHERE id_product = '20223' 22/10/2022 10:46:31 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 = '20223' 22/10/2022 10:46:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20224' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:46:31 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 '20224' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20223' 22/10/2022 10:46:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20224' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20223' 22/10/2022 10:47:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001648' AND id_product != '20224' AND ean13 != '' 22/10/2022 10:47:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001648', date_upd = NOW() WHERE id_product = '20224' 22/10/2022 10:47:20 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO GESSO CM 30 - J202OA/30', description = '' WHERE id_product = '20224' 22/10/2022 10:47:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '121.31147540983606' WHERE id_product = '20224' 22/10/2022 10:47:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '121.31147540983606', id_tax_rules_group = '1', id_category_default = '461', 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 = '20224' 22/10/2022 10:47:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20224' 22/10/2022 10:47:22 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20224' 22/10/2022 10:47:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20225' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:47:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20225' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20224' 22/10/2022 10:47:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20225' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20224' 22/10/2022 10:48:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001647' AND id_product != '20225' AND ean13 != '' 22/10/2022 10:48:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001647', date_upd = NOW() WHERE id_product = '20225' 22/10/2022 10:48:18 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO GESSO CM 40 - J202/40', description = '' WHERE id_product = '20225' 22/10/2022 10:48:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '195.9016393442623' WHERE id_product = '20225' 22/10/2022 10:48:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '195.9016393442623', id_tax_rules_group = '1', id_category_default = '461', 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 = '20225' 22/10/2022 10:48:18 am >> DELETE FROM ps_specific_price WHERE id_product = '20225' 22/10/2022 10:48:26 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20225' 22/10/2022 10:48:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20226' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:48:26 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20226' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20225' 22/10/2022 10:48:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20226' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20225' 22/10/2022 10:49:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001646' AND id_product != '20226' AND ean13 != '' 22/10/2022 10:49:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001646', date_upd = NOW() WHERE id_product = '20226' 22/10/2022 10:49:26 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO IN GESSO CM 50 STILE ANTICO - J202/50', description = '' WHERE id_product = '20226' 22/10/2022 10:49:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '303.27868852459017' WHERE id_product = '20226' 22/10/2022 10:49:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '303.27868852459017', id_tax_rules_group = '1', id_category_default = '461', 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 = '20226' 22/10/2022 10:49:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20226' 22/10/2022 10:49:27 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20226' 22/10/2022 10:49:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20227' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:49:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20227' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20226' 22/10/2022 10:49:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20227' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20226' 22/10/2022 10:50:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001645' AND id_product != '20227' AND ean13 != '' 22/10/2022 10:50:29 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001645', date_upd = NOW() WHERE id_product = '20227' 22/10/2022 10:50:29 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40', description = '' WHERE id_product = '20227' 22/10/2022 10:50:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '200' WHERE id_product = '20227' 22/10/2022 10:50:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '200', id_tax_rules_group = '1', id_category_default = '461', 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 = '20227' 22/10/2022 10:50:29 am >> DELETE FROM ps_specific_price WHERE id_product = '20227' 22/10/2022 10:50:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20227' 22/10/2022 10:50:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20228' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:50:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20228' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20227' 22/10/2022 10:50:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20228' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20227' 22/10/2022 10:51:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001644' AND id_product != '20228' AND ean13 != '' 22/10/2022 10:51:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001644', date_upd = NOW() WHERE id_product = '20228' 22/10/2022 10:51:24 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO IN GESSO CM 30 STILE ANTICO - J202/30', description = '' WHERE id_product = '20228' 22/10/2022 10:51:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '150.81967213114754' WHERE id_product = '20228' 22/10/2022 10:51:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '150.81967213114754', id_tax_rules_group = '1', id_category_default = '461', 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 = '20228' 22/10/2022 10:51:25 am >> DELETE FROM ps_specific_price WHERE id_product = '20228' 22/10/2022 10:51:25 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 = '20228' 22/10/2022 10:51:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20229' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:51:25 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 '20229' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20228' 22/10/2022 10:51:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20229' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20228' 22/10/2022 10:52:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001643' AND id_product != '20229' AND ean13 != '' 22/10/2022 10:52:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001643', date_upd = NOW() WHERE id_product = '20229' 22/10/2022 10:52:38 am >> UPDATE ps_product_lang SET name = 'BAMBINELLO PASTA DI LEGNO CM 50 - AC289E/50', description = '' WHERE id_product = '20229' 22/10/2022 10:52:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '684.4262295081967' WHERE id_product = '20229' 22/10/2022 10:52:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '684.4262295081967', id_tax_rules_group = '1', id_category_default = '461', 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 = '20229' 22/10/2022 10:52:39 am >> DELETE FROM ps_specific_price WHERE id_product = '20229' 22/10/2022 10:52: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 = '20229' 22/10/2022 10:52:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20230' , '1' , '' , 'nuovo-prodotto' ) 22/10/2022 10:52: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 '20230' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20229' 22/10/2022 10:52:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20230' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20229' 22/10/2022 10:55:26 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' , '340' , '2022-10-12' , '' , '0' , '136' , '4670814' , 'VIA LIBERO GRASSI, 6b 40036 RIOVEGGIO - MONZUNO' , '' , '' , '40.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1234.35' , '1011.77' , NOW() , NOW() ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68059' 22/10/2022 10:55:26 am >> DELETE FROM ps_document_detail WHERE id_document = '68059' 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20222' , 'BAMBINO IN GESSO CM 20 - IE76/20' , '1' , '1' , '1' , '53.3' , '43.688524590164' , '22' , '5' , '61.7747' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20222' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20222' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20223' , 'BAMBINELLO IN GESSO CM 50 - J202OA/50' , '1' , '1' , '1' , '121' , '99.180327868852' , '22' , '5' , '140.2390' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20223' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20223' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20224' , 'BAMBINELLO GESSO CM 30 - J202OA/30' , '1' , '1' , '1' , '61' , '50' , '22' , '5' , '70.6990' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20224' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20224' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20225' , 'BAMBINELLO GESSO CM 40 - J202/40' , '1' , '1' , '1' , '98' , '80.327868852459' , '22' , '5' , '113.5820' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20225' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20225' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20226' , 'BAMBINELLO IN GESSO CM 50 STILE ANTICO - J202/50' , '1' , '1' , '1' , '152' , '124.59016393443' , '22' , '5' , '176.1680' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20226' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20226' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '1' , '1' , '100' , '81.967213114754' , '22' , '5' , '115.9000' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20227' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20227' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20228' , 'BAMBINELLO IN GESSO CM 30 STILE ANTICO - J202/30' , '1' , '1' , '1' , '75.6' , '61.967213114754' , '22' , '5' , '87.6204' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20228' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20228' , '136' , '1' ) 22/10/2022 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68059' , '20229' , 'BAMBINELLO PASTA DI LEGNO CM 50 - AC289E/50' , '1' , '1' , '1' , '362' , '296.72131147541' , '22' , '5' , '419.5580' ) 22/10/2022 10:55:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20229' AND id_supplier = '136' 22/10/2022 10:55:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20229' , '136' , '1' ) 22/10/2022 10:58:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3155' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 10:58:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3155' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 22/10/2022 10:58:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68060' 22/10/2022 10:58:28 am >> DELETE FROM ps_document_detail WHERE id_document = '68060' 22/10/2022 10:58:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68060' , '19975' , 'POSTINO DI DIO - A. LUCIANI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 22/10/2022 10:58:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19975' AND id_supplier = '' 22/10/2022 10:58:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19975' , '' , '1' ) 22/10/2022 11:01:25 am >> SELECT document_num FROM ps_document WHERE document_num = '203' AND id_document != '68055' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 11:01:25 am >> UPDATE ps_document SET id_document_type = '21', document_num = '203', document_date = '2022-10-22', document_letter = '', id_customer = '1151', id_supplier = '', id_address = '4669498', address1 = 'VIA XXV LUGLIO, 216 84013 CAVA DE\\\' TIRRENI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '38.68', price_tax_excluded = '38.68', date_upd = NOW() WHERE id_document = '68055' 22/10/2022 11:01:25 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 = '68055' 22/10/2022 11:01:25 am >> DELETE FROM ps_document_detail WHERE id_document = '68055' 22/10/2022 11:01:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68055' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 22/10/2022 11:01:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 22/10/2022 11:01:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 22/10/2022 11:10:27 am >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 11:10: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 ( '24' , '83/A' , '2022-10-22' , 'A' , '3799' , '0' , '4672355' , 'VIA SAN NICOLA 84084 FISCIANO - CARPINETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '328.71' , '328.71' , NOW() , NOW() ) 22/10/2022 11:10: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 = '68061' 22/10/2022 11:10:27 am >> DELETE FROM ps_document_detail WHERE id_document = '68061' 22/10/2022 11:10: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 ( '68061' , '2679' , 'CONOSCERE GESU\'' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 22/10/2022 11:10: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 ( '68061' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.50' , '3.5' , '0' , '15' , '50.58' ) 22/10/2022 11:10: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 ( '68061' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 22/10/2022 11:10: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 ( '68061' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '15' , '47.60' ) 22/10/2022 11:10: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 ( '68061' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '17' , '-17' , '4' , '3.50' , '3.5' , '0' , '15' , '50.58' ) 22/10/2022 11:10: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 ( '68061' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '33' , '-33' , '4' , '2.40' , '2.4' , '0' , '15' , '67.32' ) 22/10/2022 11:10: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 ( '68061' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 22/10/2022 11:10:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 11:10:37 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' , '3156' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 22/10/2022 11:10:37 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 = '68062' 22/10/2022 11:10:37 am >> DELETE FROM ps_document_detail WHERE id_document = '68062' 22/10/2022 11:10:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68062' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 22/10/2022 11:10:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 22/10/2022 11:10:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 22/10/2022 11:12:00 am >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '68061' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 11:12:00 am >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2022-10-22', document_letter = 'A', id_customer = '3799', id_supplier = '', id_address = '4672355', address1 = 'VIA SAN NICOLA 84084 FISCIANO - CARPINETO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '332.96', price_tax_excluded = '332.96', date_upd = NOW() WHERE id_document = '68061' 22/10/2022 11:12: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 = '68061' 22/10/2022 11:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '68061' 22/10/2022 11:12: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 ( '68061' , '2679' , 'CONOSCERE GESU\'' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '33' , '-33' , '4' , '2.4000' , '2.4' , '0' , '15' , '67.32' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 22/10/2022 11:12: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 ( '68061' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 22/10/2022 11:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 22/10/2022 11:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 22/10/2022 11:13:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 11:13:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3157' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.41' , '28.41' , NOW() , NOW() ) 22/10/2022 11:13:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68063' 22/10/2022 11:13:42 am >> DELETE FROM ps_document_detail WHERE id_document = '68063' 22/10/2022 11:13:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68063' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 22/10/2022 11:13:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '' 22/10/2022 11:13:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' ) 22/10/2022 11:13:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68063' , '20018' , 'VITA DI GESU - A. TORNIELLI' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.01' ) 22/10/2022 11:13:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '20018' AND id_supplier = '' 22/10/2022 11:13:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20018' , '' , '1' ) 22/10/2022 11:28:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 11:28:32 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' , '3158' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.65' , '75.49' , NOW() , NOW() ) 22/10/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 = '68064' 22/10/2022 11:28:32 am >> DELETE FROM ps_document_detail WHERE id_document = '68064' 22/10/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 ( '68064' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/10/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 22/10/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 22/10/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 ( '68064' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 22/10/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20089' AND id_supplier = '' 22/10/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20089' , '' , '1' ) 22/10/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 ( '68064' , '13083' , 'PREGHIERA PER I DEFUNTI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/10/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '13083' AND id_supplier = '' 22/10/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13083' , '' , '1' ) 22/10/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 ( '68064' , '8387' , 'PREGHIERE PER LE ANIME DEI DEFUNTI - 8147' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/10/2022 11:28:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '8387' AND id_supplier = '' 22/10/2022 11:28:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8387' , '' , '1' ) 22/10/2022 11:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 22/10/2022 11:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '16980' AND id_supplier = '' 22/10/2022 11:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16980' , '' , '1' ) 22/10/2022 11:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/10/2022 11:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20009' AND id_supplier = '' 22/10/2022 11:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20009' , '' , '1' ) 22/10/2022 11:28:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68064' , '14991' , 'PRESEPE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/10/2022 11:28:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '14991' AND id_supplier = '' 22/10/2022 11:28:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14991' , '' , '1' ) 22/10/2022 12:23:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '68047' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-21') 22/10/2022 12:23:10 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '200', document_date = '2022-10-21', document_letter = '', id_customer = '2214', id_supplier = '', id_address = '4671715', address1 = 'P.ZZA S. FRANCESCO 84124 SALERNO', address2 = '', note = 'GUIDE CONSEGNATE ACCONTO € 25,50', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '409.28', price_tax_excluded = '409.28', date_upd = NOW() WHERE id_document = '68047' 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68047' 22/10/2022 12:23:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '68047' 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '45' , '-45' , '4' , '3.5000' , '3.5' , '0' , '15' , '133.88' ) 22/10/2022 12:23:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 22/10/2022 12:23:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '41' , '-41' , '4' , '3.5000' , '3.5' , '0' , '15' , '121.98' ) 22/10/2022 12:23:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 22/10/2022 12:23:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '43' , '-43' , '4' , '3.5000' , '3.5' , '0' , '15' , '127.92' ) 22/10/2022 12:23:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 22/10/2022 12:23:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 22/10/2022 12:23:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 22/10/2022 12:23:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 22/10/2022 12:23:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 22/10/2022 12:23:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 22/10/2022 12:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68047' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 22/10/2022 12:23:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 22/10/2022 12:23:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 22/10/2022 12:34:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 12:34:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3159' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/10/2022 12:34:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68065' 22/10/2022 12:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '68065' 22/10/2022 12:34: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 ( '68065' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/10/2022 12:34:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 22/10/2022 12:34:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 22/10/2022 12:38:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-22') 22/10/2022 12:38:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3160' , '2022-10-22' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.30' , '14.30' , NOW() , NOW() ) 22/10/2022 12:38:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '68066' 22/10/2022 12:38:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '68066' 22/10/2022 12:38:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '68066' , '18357' , 'MIE PREGHIERINE N.E.' , '10' , '-10' , '4' , '1.50' , '1.5' , '0' , '5' , '14.30' ) 22/10/2022 12:38:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 22/10/2022 12:38:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' )