19/03/2024 09:07:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/03/2024 09:07:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22307' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 09:07:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22307' , '1' , '1' , '2' , NOW() , NOW() ) 19/03/2024 09:07:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22307' , '0' , '1' , '0' , '0' ) 19/03/2024 09:09:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793088' AND id_product != '22307' AND ean13 != '' 19/03/2024 09:09:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793088', date_upd = NOW() WHERE id_product = '22307' 19/03/2024 09:09:48 am >> UPDATE ps_product_lang SET name = 'MESSA E MEDITAZIONE - LUG AGO ', description = '' WHERE id_product = '22307' 19/03/2024 09:09:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '22307' 19/03/2024 09:09:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22307' 19/03/2024 09:09:48 am >> DELETE FROM ps_specific_price WHERE id_product = '22307' 19/03/2024 09:09:57 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22307' 19/03/2024 09:09:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22308' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 09:09:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22308' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22307' 19/03/2024 09:09:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22308' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22307' 19/03/2024 09:10:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793071' AND id_product != '22308' AND ean13 != '' 19/03/2024 09:10:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793071', date_upd = NOW() WHERE id_product = '22308' 19/03/2024 09:10:26 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - MAG GIU ', description = '' WHERE id_product = '22308' 19/03/2024 09:10:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '22308' 19/03/2024 09:10:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22308' 19/03/2024 09:10:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22308' 19/03/2024 09:14:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878793071' AND id_product != '22308' AND ean13 != '' 19/03/2024 09:14:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788878793071', date_upd = NOW() WHERE id_product = '22308' 19/03/2024 09:14:41 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - MAG GIU ', description = '' WHERE id_product = '22308' 19/03/2024 09:14:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '22308' 19/03/2024 09:14:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '271', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22308' 19/03/2024 09:14:41 am >> DELETE FROM ps_specific_price WHERE id_product = '22308' 19/03/2024 09:15: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 ( '31' , '123/24' , '2024-03-14' , '24' , '0' , '40' , '2635' , 'VIA VIRGINIA AGNELLI, 100 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '86.40' , '86.40' , NOW() , NOW() ) 19/03/2024 09:15: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 = '90822' 19/03/2024 09:15:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90822' 19/03/2024 09:15: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 ( '90822' , '22308' , 'MESSA MEDITAZIONE - MAG GIU ' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 19/03/2024 09:15:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22308' AND id_supplier = '40' 19/03/2024 09:15:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22308' , '40' , '1' ) 19/03/2024 09:15:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90822' , '22307' , 'MESSA E MEDITAZIONE - LUG AGO ' , '9' , '9' , '4' , '8.00' , '8' , '0' , '40' , '43.2000' ) 19/03/2024 09:15:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22307' AND id_supplier = '40' 19/03/2024 09:15:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22307' , '40' , '1' ) 19/03/2024 09:16:09 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/03/2024 09:16:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22309' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 09:16:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22309' , '1' , '1' , '2' , NOW() , NOW() ) 19/03/2024 09:16:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22309' , '0' , '1' , '0' , '0' ) 19/03/2024 09:18:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946746' AND id_product != '22309' AND ean13 != '' 19/03/2024 09:18:26 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788868946746', date_upd = NOW() WHERE id_product = '22309' 19/03/2024 09:18:26 am >> UPDATE ps_product_lang SET name = 'MI INDICHERAI IL SENTIERO DELLA VITA ', description = '' WHERE id_product = '22309' 19/03/2024 09:18:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '22309' 19/03/2024 09:18:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22309' 19/03/2024 09:18:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22309' 19/03/2024 09:18:29 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 = '22309' 19/03/2024 09:18:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22310' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 09:18:29 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 '22310' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22309' 19/03/2024 09:18:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22310' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22309' 19/03/2024 09:19:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946739' AND id_product != '22310' AND ean13 != '' 19/03/2024 09:19:08 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788868946739', date_upd = NOW() WHERE id_product = '22310' 19/03/2024 09:19:08 am >> UPDATE ps_product_lang SET name = 'VIA VAI ORATORIO ESTIVO', description = '' WHERE id_product = '22310' 19/03/2024 09:19:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22310' 19/03/2024 09:19:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '217', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22310' 19/03/2024 09:19:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22310' 19/03/2024 09:21:22 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' , '659491' , '2024-03-15' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.82' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.85' , '97.85' , NOW() , NOW() ) 19/03/2024 09:21:22 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 = '90823' 19/03/2024 09:21:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90823' 19/03/2024 09:21:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90823' , '19158' , 'SETTIMANA SANTA - N.E.' , '24' , '24' , '4' , '5.00' , '5' , '0' , '33' , '80.4000' ) 19/03/2024 09:21:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19158' AND id_supplier = '7' 19/03/2024 09:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19158' , '7' , '1' ) 19/03/2024 09:21:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90823' , '19158' , 'SETTIMANA SANTA - N.E.' , '2' , '2' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 19/03/2024 09:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19158' AND id_supplier = '7' 19/03/2024 09:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19158' , '7' , '1' ) 19/03/2024 09:21:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90823' , '22310' , 'VIA VAI ORATORIO ESTIVO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 19/03/2024 09:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22310' AND id_supplier = '7' 19/03/2024 09:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22310' , '7' , '1' ) 19/03/2024 09:21:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90823' , '22309' , 'MI INDICHERAI IL SENTIERO DELLA VITA ' , '1' , '1' , '4' , '2.90' , '2.9' , '0' , '30' , '2.0300' ) 19/03/2024 09:21:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22309' AND id_supplier = '7' 19/03/2024 09:21:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22309' , '7' , '1' ) 19/03/2024 09:36:42 am >> SELECT document_num FROM ps_document WHERE document_num = '804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 09:36: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' , '804' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 19/03/2024 09:36: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 = '90824' 19/03/2024 09:36:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90824' 19/03/2024 09:36: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 ( '90824' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 19/03/2024 09:42:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/03/2024 09:42:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22311' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 09:42:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22311' , '1' , '1' , '2' , NOW() , NOW() ) 19/03/2024 09:42:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22311' , '0' , '1' , '0' , '0' ) 19/03/2024 09:43:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002244' AND id_product != '22311' AND ean13 != '' 19/03/2024 09:43:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002244', date_upd = NOW() WHERE id_product = '22311' 19/03/2024 09:43:44 am >> UPDATE ps_product_lang SET name = 'CAMICE BENEDETTINO POL. - 70/000015', description = '' WHERE id_product = '22311' 19/03/2024 09:43:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '147.54098360655738' WHERE id_product = '22311' 19/03/2024 09:43:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '147.54098360655738', id_tax_rules_group = '1', id_category_default = '468', 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 = '22311' 19/03/2024 09:43:44 am >> DELETE FROM ps_specific_price WHERE id_product = '22311' 19/03/2024 09:43:45 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22311' 19/03/2024 09:43:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22312' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 09:43:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22312' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22311' 19/03/2024 09:43:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22312' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22311' 19/03/2024 09:44:48 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' , '113' , '2024-03-19' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '500.58' , '410.31' , NOW() , NOW() ) 19/03/2024 09:44:48 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 = '90825' 19/03/2024 09:44:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90825' 19/03/2024 09:44:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90825' , '17408' , 'CAMICE MISTO COT. 70/001035' , '2' , '2' , '1' , '70' , '57.377049180328' , '22' , '3' , '165.6760' ) 19/03/2024 09:44:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '143' 19/03/2024 09:44:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '143' , '1' ) 19/03/2024 09:44:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90825' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '1' , '1' , '61' , '50' , '22' , '3' , '72.1874' ) 19/03/2024 09:44:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '143' 19/03/2024 09:44:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '143' , '1' ) 19/03/2024 09:44:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90825' , '22311' , 'CAMICE BENEDETTINO POL. - 70/000015' , '3' , '3' , '1' , '74' , '60.655737704918' , '22' , '3' , '262.7148' ) 19/03/2024 09:44:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22311' AND id_supplier = '143' 19/03/2024 09:44:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22311' , '143' , '1' ) 19/03/2024 10:05:45 am >> SELECT document_num FROM ps_document WHERE document_num = '805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 10:05:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '805' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 19/03/2024 10:05:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90826' 19/03/2024 10:05:45 am >> DELETE FROM ps_document_detail WHERE id_document = '90826' 19/03/2024 10:05:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90826' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 19/03/2024 10:09:52 am >> SELECT document_num FROM ps_document WHERE document_num = '806' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 10:09:52 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' , '806' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 19/03/2024 10:09:52 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 = '90827' 19/03/2024 10:09:52 am >> DELETE FROM ps_document_detail WHERE id_document = '90827' 19/03/2024 10:09: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 ( '90827' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 19/03/2024 10:22:54 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 19/03/2024 10:22:55 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '187' , '1' ) 19/03/2024 10:22:55 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '187' , '1' ) 19/03/2024 10:22:55 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '187' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 19/03/2024 10:24:58 am >> UPDATE ps_address SET id_state = '182', lastname = 'MARIO BALDRIGHI srl - LABORATORIO CONFEZIONI', address1 = 'VIA G. B. STUCCHI 62/27', address2 = '', postcode = '20900', dni = '', vat_number = '02347600963', city = 'MONZA', phone = '039834020', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '187' 19/03/2024 10:24:58 am >> UPDATE ps_supplier SET email = 'segreteria@baldrighi.it', name = 'MARIO BALDRIGHI srl - LABORATORIO CONFEZIONI', date_upd = NOW() WHERE id_supplier = '187' 19/03/2024 10:24:58 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '187' 19/03/2024 10:25:42 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 19/03/2024 10:25:42 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '539' , '1' ) 19/03/2024 10:25:42 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '539' , '2' ) 19/03/2024 10:25:42 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '539' , '3' ) 19/03/2024 10:25:42 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '539' , '1' , 'CONFEZIONI BALDRIGHI' , LOWER('CONFEZIONI-BALDRIGHI') ) 19/03/2024 10:25:42 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '539' , '1' , '0' ) 19/03/2024 10:31:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002245' AND id_product != '22312' AND ean13 != '' 19/03/2024 10:31:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002245', date_upd = NOW() WHERE id_product = '22312' 19/03/2024 10:31:15 am >> UPDATE ps_product_lang SET name = 'CASULA SPIRITO SANTO - C1P820', description = '' WHERE id_product = '22312' 19/03/2024 10:31:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '135.24590163934425' WHERE id_product = '22312' 19/03/2024 10:31:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '135.24590163934425', id_tax_rules_group = '1', id_category_default = '539', 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 = '22312' 19/03/2024 10:31:15 am >> DELETE FROM ps_specific_price WHERE id_product = '22312' 19/03/2024 10:31:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002245' AND id_product != '22312' AND ean13 != '' 19/03/2024 10:31:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002245', date_upd = NOW() WHERE id_product = '22312' 19/03/2024 10:31:58 am >> UPDATE ps_product_lang SET name = 'CASULA SPIRITO SANTO - C1P820', description = '' WHERE id_product = '22312' 19/03/2024 10:31:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '135.24590163934425' WHERE id_product = '22312' 19/03/2024 10:31:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '135.24590163934425', id_tax_rules_group = '1', id_category_default = '539', 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 = '22312' 19/03/2024 10:31:58 am >> DELETE FROM ps_specific_price WHERE id_product = '22312' 19/03/2024 10:31:58 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 = '22312' 19/03/2024 10:31:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22313' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 10:31:58 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 '22313' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22312' 19/03/2024 10:31:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22313' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22312' 19/03/2024 10:32:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002246' AND id_product != '22313' AND ean13 != '' 19/03/2024 10:32:58 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002246', date_upd = NOW() WHERE id_product = '22313' 19/03/2024 10:32:58 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - C1P817', description = '' WHERE id_product = '22313' 19/03/2024 10:32:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '196.72131147540983' WHERE id_product = '22313' 19/03/2024 10:32:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '196.72131147540983', id_tax_rules_group = '1', id_category_default = '539', 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 = '22313' 19/03/2024 10:32:58 am >> DELETE FROM ps_specific_price WHERE id_product = '22313' 19/03/2024 10:32:59 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 = '22313' 19/03/2024 10:32:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22314' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 10:32:59 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 '22314' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22313' 19/03/2024 10:32:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22314' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22313' 19/03/2024 10:34:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002247' AND id_product != '22314' AND ean13 != '' 19/03/2024 10:34:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002247', date_upd = NOW() WHERE id_product = '22314' 19/03/2024 10:34:07 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - C1P855', description = '' WHERE id_product = '22314' 19/03/2024 10:34:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '73.77049180327869' WHERE id_product = '22314' 19/03/2024 10:34:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '73.77049180327869', id_tax_rules_group = '1', id_category_default = '539', 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 = '22314' 19/03/2024 10:34:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22314' 19/03/2024 10:34:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22314' 19/03/2024 10:34:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22315' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 10:34:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22315' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22314' 19/03/2024 10:34:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22315' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22314' 19/03/2024 10:34:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002248' AND id_product != '22315' AND ean13 != '' 19/03/2024 10:34:57 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002248', date_upd = NOW() WHERE id_product = '22315' 19/03/2024 10:34:57 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - C1P965', description = '' WHERE id_product = '22315' 19/03/2024 10:34:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '22315' 19/03/2024 10:34:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '539', 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 = '22315' 19/03/2024 10:34:57 am >> DELETE FROM ps_specific_price WHERE id_product = '22315' 19/03/2024 10:35:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002248' AND id_product != '22315' AND ean13 != '' 19/03/2024 10:35:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002248', date_upd = NOW() WHERE id_product = '22315' 19/03/2024 10:35:17 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - C1P965', description = '' WHERE id_product = '22315' 19/03/2024 10:35:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '22315' 19/03/2024 10:35:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '539', 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 = '22315' 19/03/2024 10:35:17 am >> DELETE FROM ps_specific_price WHERE id_product = '22315' 19/03/2024 10:35:18 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22315' 19/03/2024 10:35:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22316' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 10:35:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22316' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22315' 19/03/2024 10:35:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22316' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22315' 19/03/2024 10:36:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002249' AND id_product != '22316' AND ean13 != '' 19/03/2024 10:36:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002249', date_upd = NOW() WHERE id_product = '22316' 19/03/2024 10:36:01 am >> UPDATE ps_product_lang SET name = 'PIVIALE - P1P858', description = '' WHERE id_product = '22316' 19/03/2024 10:36:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '258.1967213114754' WHERE id_product = '22316' 19/03/2024 10:36:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '258.1967213114754', id_tax_rules_group = '1', id_category_default = '539', 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 = '22316' 19/03/2024 10:36:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22316' 19/03/2024 10:36:36 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' , 'FAR/92' , '2024-03-12' , '92' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '621.59' , '509.50' , NOW() , NOW() ) 19/03/2024 10:36:36 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 = '90828' 19/03/2024 10:36:36 am >> DELETE FROM ps_document_detail WHERE id_document = '90828' 19/03/2024 10:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90828' , '22312' , 'CASULA SPIRITO SANTO - C1P820' , '1' , '1' , '1' , '67' , '54.918032786885' , '22' , '0' , '81.7400' ) 19/03/2024 10:36:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22312' AND id_supplier = '187' 19/03/2024 10:36:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22312' , '187' , '1' ) 19/03/2024 10:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90828' , '22313' , 'CASULA MARIANA - C1P817' , '1' , '1' , '1' , '97' , '79.508196721311' , '22' , '0' , '118.3400' ) 19/03/2024 10:36:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22313' AND id_supplier = '187' 19/03/2024 10:36:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22313' , '187' , '1' ) 19/03/2024 10:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90828' , '22314' , 'CASULA MARIANA - C1P855' , '1' , '1' , '1' , '36' , '29.508196721311' , '22' , '0' , '43.9200' ) 19/03/2024 10:36:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22314' AND id_supplier = '187' 19/03/2024 10:36:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22314' , '187' , '1' ) 19/03/2024 10:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90828' , '22315' , 'CASULA MARIANA - C1P965' , '1' , '1' , '1' , '51.5' , '42.213114754098' , '22' , '0' , '62.8300' ) 19/03/2024 10:36:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22315' AND id_supplier = '187' 19/03/2024 10:36:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22315' , '187' , '1' ) 19/03/2024 10:36:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90828' , '22316' , 'PIVIALE - P1P858' , '2' , '2' , '1' , '129' , '105.73770491803' , '22' , '0' , '314.7600' ) 19/03/2024 10:36:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22316' AND id_supplier = '187' 19/03/2024 10:36:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22316' , '187' , '1' ) 19/03/2024 10:36:41 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 = '22316' 19/03/2024 10:36:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22317' , '1' , '' , 'nuovo-prodotto' ) 19/03/2024 10:36:41 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 '22317' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22316' 19/03/2024 10:36:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22317' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22316' 19/03/2024 10:39:29 am >> SELECT document_num FROM ps_document WHERE document_num = '807' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 10:39:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '807' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 19/03/2024 10:39:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90829' 19/03/2024 10:39:29 am >> DELETE FROM ps_document_detail WHERE id_document = '90829' 19/03/2024 10:39:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90829' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/03/2024 10:49:50 am >> SELECT document_num FROM ps_document WHERE document_num = '808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 10:49: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 ( '11' , '808' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '525.00' , '525.00' , NOW() , NOW() ) 19/03/2024 10:49: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 = '90830' 19/03/2024 10:49:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90830' 19/03/2024 10:49: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 ( '90830' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '15' , '-15' , '4' , '35' , '35' , '0' , '0' , '525.00' ) 19/03/2024 10:57:21 am >> DELETE FROM ps_document WHERE id_document = '90246' 19/03/2024 10:57:21 am >> DELETE FROM ps_document_detail WHERE id_document = '90246' 19/03/2024 11:04:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'C1P262/M' AND id_product != '22317' AND ean13 != '' 19/03/2024 11:04:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'C1P262/M', date_upd = NOW() WHERE id_product = '22317' 19/03/2024 11:04:32 am >> UPDATE ps_product_lang SET name = 'CASULA PERSONALIZZATA', description = '' WHERE id_product = '22317' 19/03/2024 11:04:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98.36065573770492' WHERE id_product = '22317' 19/03/2024 11:04:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98.36065573770492', id_tax_rules_group = '1', id_category_default = '539', 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 = '22317' 19/03/2024 11:04:32 am >> DELETE FROM ps_specific_price WHERE id_product = '22317' 19/03/2024 11:05:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FAR/91' , '2024-03-12' , '91' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '3042.68' , '2494.00' , NOW() , NOW() ) 19/03/2024 11:05:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90831' 19/03/2024 11:05:05 am >> DELETE FROM ps_document_detail WHERE id_document = '90831' 19/03/2024 11:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90831' , '22317' , 'CASULA PERSONALIZZATA' , '46' , '46' , '1' , '49' , '40.16393442623' , '22' , '0' , '2749.8800' ) 19/03/2024 11:05:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '22317' AND id_supplier = '187' 19/03/2024 11:05:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22317' , '187' , '1' ) 19/03/2024 11:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90831' , '' , 'IMPIANTO' , '1' , '1' , '1' , '240' , '196.72131147541' , '22' , '0' , '292.8000' ) 19/03/2024 11:05:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '187' 19/03/2024 11:05:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '187' , '1' ) 19/03/2024 11:11:25 am >> SELECT document_num FROM ps_document WHERE document_num = '809' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 11:11:25 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' , '809' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.20' , '101.41' , NOW() , NOW() ) 19/03/2024 11:11: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 = '90832' 19/03/2024 11:11:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90832' 19/03/2024 11:11: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 ( '90832' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 19/03/2024 11:11: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 ( '90832' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 19/03/2024 11:11: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 ( '90832' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 19/03/2024 11:11: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 ( '90832' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '53.70' ) 19/03/2024 11:14:47 am >> SELECT document_num FROM ps_document WHERE document_num = '810' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 11:14:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '810' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '80.16' , NOW() , NOW() ) 19/03/2024 11:14:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90833' 19/03/2024 11:14:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90833' 19/03/2024 11:14:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90833' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 19/03/2024 11:14:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90833' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 19/03/2024 11:43:05 am >> SELECT document_num FROM ps_document WHERE document_num = '13/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 11:43:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '13/E' , '2024-03-19' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 19/03/2024 11:43:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90834' 19/03/2024 11:43:05 am >> DELETE FROM ps_document_detail WHERE id_document = '90834' 19/03/2024 11:43:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90834' , '13506' , 'SANTO ROSARIO' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '90.00' ) 19/03/2024 11:44:13 am >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 11:44:13 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' , '11' , '2024-03-19' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1260.00' , '1260.00' , NOW() , NOW() ) 19/03/2024 11:44:13 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 = '90835' 19/03/2024 11:44:13 am >> DELETE FROM ps_document_detail WHERE id_document = '90835' 19/03/2024 11:44:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90835' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '60' , '-60' , '4' , '8.00' , '8' , '0' , '0' , '480.00' ) 19/03/2024 11:44:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90835' , '22152' , 'A TE RICORRIAMO' , '260' , '-260' , '4' , '3.00' , '3' , '0' , '0' , '780.00' ) 19/03/2024 11:45:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 11:45:02 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' , '4' , '2024-03-19' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '500.00' , '500.00' , NOW() , NOW() ) 19/03/2024 11:45:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14206' 19/03/2024 11:45:02 am >> DELETE FROM ps_document_detail WHERE id_document = '14206' 19/03/2024 11:45:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14206' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '200' , '-200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.00' ) 19/03/2024 12:02:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '811' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 12:02:48 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' , '811' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 19/03/2024 12:02:48 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 = '90836' 19/03/2024 12:02:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90836' 19/03/2024 12:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90836' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 19/03/2024 12:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90836' , '17938' , 'SAN GIUSEPPE - ARS 119' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 19/03/2024 12:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90836' , '7202' , 'ARTICOLI RELIGIOSI' , '100' , '-100' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '13.00' ) 19/03/2024 12:02:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90836' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 19/03/2024 12:49:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '812' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 12:49:41 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' , '812' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.80' , '92.46' , NOW() , NOW() ) 19/03/2024 12:49:41 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 = '90837' 19/03/2024 12:49:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '90837' 19/03/2024 12:49:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90837' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 19/03/2024 12:50:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '813' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 12:50: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' , '813' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 19/03/2024 12:50: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 = '90838' 19/03/2024 12:50:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '90838' 19/03/2024 12:50: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 ( '90838' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 19/03/2024 01:04:33 pm >> UPDATE ps_address SET id_state = '208', lastname = 'EDIZIONI ART S.R.L.', address1 = 'VIA CARLO POMA, 2 ', address2 = '', postcode = '00151', dni = '', vat_number = '01856010036', city = 'ROMA', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '40' 19/03/2024 01:04:33 pm >> UPDATE ps_supplier SET email = 'info@edizioniart.it', name = 'EDIZIONI ART S.R.L.', date_upd = NOW() WHERE id_supplier = '40' 19/03/2024 01:04:33 pm >> UPDATE ps_supplier_lang SET description = 'SEDE OPERATIVA in Via dei Cantelmo, 65 -', meta_title = '', meta_description = '' WHERE id_supplier = '40' 19/03/2024 02:44:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '616' AND id_document != '90576' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-01') 19/03/2024 02:44:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '616', document_date = '2024-03-01', 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 = '634.33', price_tax_excluded = '525.38', date_upd = NOW() WHERE id_document = '90576' 19/03/2024 02:44: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 = '90576' 19/03/2024 02:44:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90576' 19/03/2024 02:44: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 ( '90576' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/03/2024 02:44: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 ( '90576' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 19/03/2024 02:44: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 ( '90576' , '1090' , 'BIBBIA' , '2' , '-2' , '4' , '9.9000' , '9.9' , '0' , '5' , '18.82' ) 19/03/2024 02:44: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 ( '90576' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 19/03/2024 02:44: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 ( '90576' , '22077' , 'QUARESIMA E PASQUA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 19/03/2024 02:44: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 ( '90576' , '22215' , 'CALICE MALTA - 341' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 19/03/2024 02:44: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 ( '90576' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 19/03/2024 02:44: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 ( '90576' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 19/03/2024 03:18:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '648' AND id_document != '90626' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 19/03/2024 03:18:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '648', document_date = '2024-03-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '90626' 19/03/2024 03:18: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 = '90626' 19/03/2024 03:18:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '90626' 19/03/2024 03:18: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 ( '90626' , '3181' , 'CALAMITE CROCIFISSO 6X9' , '10' , '-10' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '45.00' ) 19/03/2024 03:44:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '814' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 03:44: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' , '814' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '152.75' , '127.34' , NOW() , NOW() ) 19/03/2024 03:44: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 = '90839' 19/03/2024 03:44:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90839' 19/03/2024 03:44: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 ( '90839' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 19/03/2024 03:44: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 ( '90839' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 19/03/2024 03:44: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 ( '90839' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 19/03/2024 03:44: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 ( '90839' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/03/2024 03:44: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 ( '90839' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 19/03/2024 03:44: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 ( '90839' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 19/03/2024 03:44: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 ( '90839' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 19/03/2024 03:44: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 ( '90839' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 19/03/2024 04:45:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '776' AND id_document != '90789' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-16') 19/03/2024 04:45:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '776', document_date = '2024-03-16', 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 = '180.40', price_tax_excluded = '151.77', date_upd = NOW() WHERE id_document = '90789' 19/03/2024 04:45:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90789' 19/03/2024 04:45:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '90789' 19/03/2024 04:45:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/03/2024 04:45:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/03/2024 04:45:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 19/03/2024 04:45:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 19/03/2024 04:45:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 19/03/2024 04:45:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/03/2024 04:45:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 19/03/2024 04:45:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90789' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 19/03/2024 04:52:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '120' , '2024-03-19' , '' , '0' , '186' , '4679210' , 'VIA S. ALLENDE 161/D 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '577.98' , '473.70' , NOW() , NOW() ) 19/03/2024 04:52:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90840' 19/03/2024 04:52:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90840' 19/03/2024 04:52:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90840' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '50' , '50' , '1' , '1.88' , '1.5409836065574' , '22' , '0' , '114.6800' ) 19/03/2024 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20885' AND id_supplier = '186' 19/03/2024 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20885' , '186' , '1' ) 19/03/2024 04:52:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90840' , '1041' , 'BENEDIZIONI' , '5000' , '5000' , '1' , '0.076' , '0.062295081967213' , '22' , '0' , '463.6000' ) 19/03/2024 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1041' AND id_supplier = '186' 19/03/2024 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1041' , '186' , '1' ) 19/03/2024 04:52:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90840' , '' , 'arrotondamento' , '1' , '1' , '0' , '-0.30' , '-0.3' , '' , '0' , '-0.3000' ) 19/03/2024 04:52:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '186' 19/03/2024 04:52:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '186' , '1' ) 19/03/2024 05:01:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 05:01:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '815' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 19/03/2024 05:01:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90841' 19/03/2024 05:01:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90841' 19/03/2024 05:01:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90841' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 19/03/2024 05:01:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90841' , '3103' , 'CROCE SAN BENEDETTO' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 19/03/2024 05:01:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90841' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 19/03/2024 05:06:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/L' AND id_document != '89425' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-11') 19/03/2024 05:06:25 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '23/L', document_date = '2023-12-11', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA BATTIPAGLIA', 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 = '158.20', price_tax_excluded = '135.74', date_upd = NOW() WHERE id_document = '89425' 19/03/2024 05:06:25 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 = '89425' 19/03/2024 05:06:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '89425' 19/03/2024 05:06: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 ( '89425' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 19/03/2024 05:06: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 ( '89425' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 19/03/2024 05:06: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 ( '89425' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 19/03/2024 05:06: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 ( '89425' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/03/2024 05:06: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 ( '89425' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '30' , '-30' , '1' , '3.88' , '3.1803278688525' , '22' , '0' , '116.40' ) 19/03/2024 06:51:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 19/03/2024 06:51:55 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' , '816' , '2024-03-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.90' , '14.03' , NOW() , NOW() ) 19/03/2024 06:51:55 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 = '90842' 19/03/2024 06:51:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90842' 19/03/2024 06:51:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90842' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/03/2024 06:51:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90842' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' )