01/09/2023 08:57:41 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/09/2023 08:57:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21505' , '1' , '' , 'nuovo-prodotto' ) 01/09/2023 08:57:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21505' , '1' , '1' , '2' , NOW() , NOW() ) 01/09/2023 08:57:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21505' , '0' , '1' , '0' , '0' ) 01/09/2023 08:59:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831537162' AND id_product != '21505' AND ean13 != '' 01/09/2023 08:59:32 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788831537162', date_upd = NOW() WHERE id_product = '21505' 01/09/2023 08:59:32 am >> UPDATE ps_product_lang SET name = 'VITA DEL SANTO CURATO D\'ARS', description = '' WHERE id_product = '21505' 01/09/2023 08:59:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '21505' 01/09/2023 08:59:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21505' 01/09/2023 08:59:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21505' 01/09/2023 08:59: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 = '21505' 01/09/2023 08:59:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21506' , '1' , '' , 'nuovo-prodotto' ) 01/09/2023 08:59: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 '21506' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21505' 01/09/2023 08:59:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21506' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21505' 01/09/2023 09:01:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885589995' AND id_product != '21506' AND ean13 != '' 01/09/2023 09:01:58 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788885589995', date_upd = NOW() WHERE id_product = '21506' 01/09/2023 09:01:58 am >> UPDATE ps_product_lang SET name = 'PANE QUOTIDIANO NOV/DIC 2023', description = '' WHERE id_product = '21506' 01/09/2023 09:01:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21506' 01/09/2023 09:01:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '343', 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 = '21506' 01/09/2023 09:01:58 am >> DELETE FROM ps_specific_price WHERE id_product = '21506' 01/09/2023 09:03:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862448871' AND id_product != '17713' AND ean13 != '' 01/09/2023 09:03:08 am >> UPDATE ps_product SET id_supplier = '7', reference = 'GONDOLA 1', ean13 = '9788862448871', date_upd = NOW() WHERE id_product = '17713' 01/09/2023 09:03:08 am >> UPDATE ps_product_lang SET name = 'FARSI SANTI CON CIO CHE C\'E\' - L. EPICOCO', description = '' WHERE id_product = '17713' 01/09/2023 09:03:08 am >> UPDATE ps_product SET wholesale_price = '6.30', on_sale = '0', price = '12' WHERE id_product = '17713' 01/09/2023 09:03:08 am >> UPDATE ps_product_shop SET wholesale_price = '6.30', price = '12', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17713' 01/09/2023 09:03:08 am >> DELETE FROM ps_specific_price WHERE id_product = '17713' 01/09/2023 09:05:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821538926' AND id_product != '10128' AND ean13 != '' 01/09/2023 09:05:15 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788821538926', date_upd = NOW() WHERE id_product = '10128' 01/09/2023 09:05:15 am >> UPDATE ps_product_lang SET name = 'SPERANZA A CARO PREZZO - T. BELLO', description = '' WHERE id_product = '10128' 01/09/2023 09:05:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '10128' 01/09/2023 09:05:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10128' 01/09/2023 09:05:16 am >> DELETE FROM ps_specific_price WHERE id_product = '10128' 01/09/2023 09:05:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '639102' , '2023-08-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '1.93' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '66.50' , '66.50' , NOW() , NOW() ) 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87135' 01/09/2023 09:05:55 am >> DELETE FROM ps_document_detail WHERE id_document = '87135' 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '21506' , 'PANE QUOTIDIANO NOV/DIC 2023' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 01/09/2023 09:05:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21506' AND id_supplier = '7' 01/09/2023 09:05:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21506' , '7' , '1' ) 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '21505' , 'VITA DEL SANTO CURATO DARS' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '35' , '3.1850' ) 01/09/2023 09:05:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '21505' AND id_supplier = '7' 01/09/2023 09:05:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21505' , '7' , '1' ) 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 01/09/2023 09:05:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 01/09/2023 09:05:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 01/09/2023 09:05:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '7' 01/09/2023 09:05:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '7' , '1' ) 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 01/09/2023 09:05:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '7' 01/09/2023 09:05:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '7' , '1' ) 01/09/2023 09:05:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '21198' , 'AMEN - SET 2023' , '3' , '3' , '4' , '3.90' , '3.9' , '0' , '33' , '7.8390' ) 01/09/2023 09:05:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '21198' AND id_supplier = '7' 01/09/2023 09:05:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21198' , '7' , '1' ) 01/09/2023 09:05:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '21199' , 'AMEN - OTT 23' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 01/09/2023 09:05:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 01/09/2023 09:05:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 01/09/2023 09:05:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '6658' , 'MIE NOTTI INSONNI - TONINO BELLO' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '33' , '6.3650' ) 01/09/2023 09:05:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '6658' AND id_supplier = '7' 01/09/2023 09:05:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6658' , '7' , '1' ) 01/09/2023 09:05:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87135' , '10128' , 'SPERANZA A CARO PREZZO - T. BELLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 01/09/2023 09:05:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '10128' AND id_supplier = '7' 01/09/2023 09:05:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10128' , '7' , '1' ) 01/09/2023 09:13:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 09:13: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' , '2693' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '146.00' , '126.06' , NOW() , NOW() ) 01/09/2023 09:13: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 = '87136' 01/09/2023 09:13:52 am >> DELETE FROM ps_document_detail WHERE id_document = '87136' 01/09/2023 09:13: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 ( '87136' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 01/09/2023 09:13: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 ( '87136' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 01/09/2023 09:13: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 ( '87136' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 01/09/2023 09:13: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 ( '87136' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 01/09/2023 09:13: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 ( '87136' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/09/2023 09:13: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 ( '87136' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 01/09/2023 09:14:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 09:14: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 ( '11' , '2694' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 01/09/2023 09:14: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 = '87137' 01/09/2023 09:14:05 am >> DELETE FROM ps_document_detail WHERE id_document = '87137' 01/09/2023 09:14: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 ( '87137' , '11389' , 'VINO ROSSO DOLCE - 103' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 01/09/2023 09:33:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 09:33:09 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' , '2695' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 01/09/2023 09:33:09 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 = '87138' 01/09/2023 09:33:09 am >> DELETE FROM ps_document_detail WHERE id_document = '87138' 01/09/2023 09:33:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87138' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 01/09/2023 09:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 09:48:14 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' , '2696' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '38.70' , NOW() , NOW() ) 01/09/2023 09:48:14 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 = '87139' 01/09/2023 09:48:14 am >> DELETE FROM ps_document_detail WHERE id_document = '87139' 01/09/2023 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87139' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/09/2023 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87139' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 01/09/2023 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87139' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3' , '4.1346153846154' , '4' , '0' , '4.30' ) 01/09/2023 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87139' , '19560' , 'PERGAMENA 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 01/09/2023 09:49:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 09:49:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2697' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2023 09:49:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87140' 01/09/2023 09:49:54 am >> DELETE FROM ps_document_detail WHERE id_document = '87140' 01/09/2023 09:49:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87140' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2023 10:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:11:10 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' , '2698' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '44.78' , NOW() , NOW() ) 01/09/2023 10:11:10 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 = '87141' 01/09/2023 10:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '87141' 01/09/2023 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87141' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/09/2023 10:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87141' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '4' , '-4' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '30.00' ) 01/09/2023 10:11:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:11:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2699' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '26.24' , NOW() , NOW() ) 01/09/2023 10:11:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87142' 01/09/2023 10:11:54 am >> DELETE FROM ps_document_detail WHERE id_document = '87142' 01/09/2023 10:11:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87142' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 01/09/2023 10:11:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87142' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 01/09/2023 10:11:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87142' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/09/2023 10:12:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:12:38 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' , '2700' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.50' , '57.86' , NOW() , NOW() ) 01/09/2023 10:12:38 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 = '87143' 01/09/2023 10:12:38 am >> DELETE FROM ps_document_detail WHERE id_document = '87143' 01/09/2023 10:12:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87143' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 01/09/2023 10:12:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87143' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 01/09/2023 10:13:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:13:31 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' , '2701' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 01/09/2023 10:13:31 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 = '87144' 01/09/2023 10:13:31 am >> DELETE FROM ps_document_detail WHERE id_document = '87144' 01/09/2023 10:13:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87144' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 01/09/2023 10:14:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:14:53 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' , '2702' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 01/09/2023 10:14:53 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 = '87145' 01/09/2023 10:14:53 am >> DELETE FROM ps_document_detail WHERE id_document = '87145' 01/09/2023 10:14:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87145' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 01/09/2023 10:22:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:22:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2703' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.96' , NOW() , NOW() ) 01/09/2023 10:22:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87146' 01/09/2023 10:22:11 am >> DELETE FROM ps_document_detail WHERE id_document = '87146' 01/09/2023 10:22:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87146' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 01/09/2023 10:22:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87146' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 01/09/2023 10:22:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87146' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/09/2023 10:25:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:25:23 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' , '2704' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/09/2023 10:25:23 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 = '87147' 01/09/2023 10:25:23 am >> DELETE FROM ps_document_detail WHERE id_document = '87147' 01/09/2023 10:25: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 ( '87147' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/09/2023 10:26:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:26:06 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' , '2705' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.33' , '22.33' , NOW() , NOW() ) 01/09/2023 10:26:06 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 = '87148' 01/09/2023 10:26:06 am >> DELETE FROM ps_document_detail WHERE id_document = '87148' 01/09/2023 10:26:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87148' , '10128' , 'SPERANZA A CARO PREZZO - T. BELLO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 01/09/2023 10:26:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87148' , '6658' , 'MIE NOTTI INSONNI - TONINO BELLO' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 01/09/2023 10:37:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 10:37: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' , '2706' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 01/09/2023 10:37: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 = '87149' 01/09/2023 10:37:28 am >> DELETE FROM ps_document_detail WHERE id_document = '87149' 01/09/2023 10:37: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 ( '87149' , '21199' , 'AMEN - OTT 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/09/2023 10:37: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 ( '87149' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/09/2023 10:39:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2707' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 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' , '2707' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '10.61' , NOW() , NOW() ) 01/09/2023 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 = '87150' 01/09/2023 10:39:16 am >> DELETE FROM ps_document_detail WHERE id_document = '87150' 01/09/2023 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 ( '87150' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 01/09/2023 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 ( '87150' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 01/09/2023 10:54:37 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3476' 01/09/2023 10:54:37 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 ( '3476' , '10' , '208' , 'PARR. SANTI AQUILA E PRISCILLA' , 'QUARANTA' , 'DON SANTINO GIUSEPPE' , 'VIA PIETRO BLASERNA 113' , '' , '00146' , 'ROMA' , '' , '' , '34717300026' , '' , '80209550583' , NOW() , NOW() ) 01/09/2023 10:54:37 am >> UPDATE ps_customer SET email = 'dsq@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3476' 01/09/2023 11:06:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 11:06:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2708' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 01/09/2023 11:06:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87151' 01/09/2023 11:06:15 am >> DELETE FROM ps_document_detail WHERE id_document = '87151' 01/09/2023 11:06:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87151' , '21416' , 'MESSA MEDITAZIONE - SET/OTT 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 01/09/2023 11:50:42 am >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 11:50: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 ( '21' , '51' , '2023-09-01' , '' , '3476' , '0' , '144688384' , 'VIA PIETRO BLASERNA 113 00146 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '382.50' , '382.50' , NOW() , NOW() ) 01/09/2023 11:50: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 = '12137' 01/09/2023 11:50:42 am >> DELETE FROM ps_document_detail WHERE id_document = '12137' 01/09/2023 11:50: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 ( '12137' , '17' , 'LA FEDE NELLO ZAINETTO' , '75' , '-75' , '4' , '6.00' , '6' , '0' , '15' , '382.50' ) 01/09/2023 12:08:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 12:08:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2709' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 01/09/2023 12:08:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87152' 01/09/2023 12:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '87152' 01/09/2023 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87152' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 01/09/2023 02:26:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 02:26: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 ( '24' , '12' , '2023-09-01' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1710.00' , '1710.00' , NOW() , NOW() ) 01/09/2023 02:26: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 = '12138' 01/09/2023 02:26:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '12138' 01/09/2023 02:26:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12138' , '17' , 'LA FEDE NELLO ZAINETTO' , '160' , '-160' , '4' , '6.00' , '6' , '0' , '0' , '960.00' ) 01/09/2023 02:26:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12138' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '300' , '-300' , '4' , '2.50' , '2.5' , '0' , '0' , '750.00' ) 01/09/2023 02:27:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 02:27:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '33' , '2023-09-01' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '780.00' , '780.00' , NOW() , NOW() ) 01/09/2023 02:27:32 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 = '87153' 01/09/2023 02:27:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '87153' 01/09/2023 02:27:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87153' , '20954' , 'TEMPO DELL’APOCALISSE ' , '50' , '-50' , '4' , '15.00' , '15' , '0' , '0' , '750.00' ) 01/09/2023 02:27:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87153' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '2' , '-2' , '4' , '15.00' , '15' , '0' , '0' , '30.00' ) 01/09/2023 02:29:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 02:29:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '37/E' , '2023-09-01' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1104.00' , '904.92' , NOW() , NOW() ) 01/09/2023 02:29:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87154' 01/09/2023 02:29:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87154' 01/09/2023 02:29:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87154' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 01/09/2023 02:29:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87154' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 01/09/2023 02:29:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87154' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 01/09/2023 02:29:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87154' , '12849' , 'LIBRO DELLE SS. MESSE' , '20' , '-20' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '240.00' ) 01/09/2023 03:36:22 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 ( '32' , '2023010001644' , '2023-09-01' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.42' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '214.99' , '211.48' , NOW() , NOW() ) 01/09/2023 03:36:22 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 = '87155' 01/09/2023 03:36:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '87155' 01/09/2023 03:36: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 ( '87155' , '21462' , 'DIO IN CUI CREDIAMO - M. LAVRA' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21462' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21462' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21460' , 'CALENDARIO DA TAVOLO 2024' , '2' , '0' , '1' , '5.33' , '4.3688524590164' , '22' , '35' , '8.4534' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21460' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21460' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21463' , 'CALENDARIO DELLAVVENTO 2023' , '1' , '0' , '1' , '8.19' , '6.7131147540984' , '22' , '35' , '6.4947' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21463' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21463' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21464' , 'NELLA COMUNIONE DELLA SS TRINITA - D. COGONI' , '1' , '0' , '4' , '17.9000' , '17.9' , '0' , '35' , '11.64' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21464' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21464' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21465' , 'AGIRE SACRAMENTALE - P. CASPANI' , '1' , '0' , '4' , '18.5000' , '18.5' , '0' , '35' , '12.03' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21465' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21465' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21458' , 'MUSICA E LITURGIA - V. CIAROCCHI' , '1' , '0' , '4' , '42.0000' , '42' , '0' , '35' , '27.30' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21458' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21458' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21466' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21466' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17385' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17385' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21461' , 'PAROLA PER OGGI 2024' , '2' , '0' , '1' , '2.86' , '2.344262295082' , '22' , '35' , '4.5360' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21461' AND id_supplier = '107' 01/09/2023 03:36:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21461' , '107' , '1' ) 01/09/2023 03:36: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 ( '87155' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 01/09/2023 03:36:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21467' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21467' , '107' , '1' ) 01/09/2023 03:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87155' , '21468' , 'BIBBIA E CATECHESI - G. DE VIRGILIO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 01/09/2023 03:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21468' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21468' , '107' , '1' ) 01/09/2023 03:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87155' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 01/09/2023 03:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '107' , '1' ) 01/09/2023 03:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87155' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '7.0000' ) 01/09/2023 03:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13780' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13780' , '107' , '1' ) 01/09/2023 03:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87155' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 01/09/2023 03:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 01/09/2023 03:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87155' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '10' , '0' , '4' , '1.0000' , '1' , '0' , '35' , '6.50' ) 01/09/2023 03:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '107' , '1' ) 01/09/2023 03:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87155' , '21459' , 'TRADITIO CANENDI' , '1' , '0' , '4' , '38.7300' , '38.73' , '0' , '35' , '25.17' ) 01/09/2023 03:36:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21459' AND id_supplier = '107' 01/09/2023 03:36:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21459' , '107' , '1' ) 01/09/2023 03:57:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 03:57: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' , '2710' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.30' , '23.37' , NOW() , NOW() ) 01/09/2023 03:57: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 = '87156' 01/09/2023 03:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '87156' 01/09/2023 03:57: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 ( '87156' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 01/09/2023 03:57: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 ( '87156' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 01/09/2023 03:57: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 ( '87156' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 01/09/2023 04:29:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '86986' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-08-07') 01/09/2023 04:29:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '108', document_date = '2023-08-07', document_letter = '', id_customer = '351', id_supplier = '', id_address = '4673707', address1 = 'VIA MASSARENTI, 418 40138 BOLOGNA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '104.50', price_tax_excluded = '104.50', date_upd = NOW() WHERE id_document = '86986' 01/09/2023 04:29: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 = '86986' 01/09/2023 04:29:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '86986' 01/09/2023 04:29: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 ( '86986' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '3' , '-3' , '4' , '21.235' , '21.235' , '0' , '' , '63.70' ) 01/09/2023 04:29: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 ( '86986' , '3511' , 'DIO PARLA ALL\'UOMO' , '4' , '-4' , '4' , '12.00' , '12' , '0' , '15' , '40.80' ) 01/09/2023 04:30:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '110' AND id_document != '87068' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-08-28') 01/09/2023 04:30:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '110', document_date = '2023-08-28', document_letter = '', id_customer = '3858', id_supplier = '', id_address = '4673596', address1 = 'VIA G.B.VENTURI,140 , 140 42021 bibbiano', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '38.00', date_upd = NOW() WHERE id_document = '87068' 01/09/2023 04:30:15 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 = '87068' 01/09/2023 04:30:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '87068' 01/09/2023 04:30:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87068' , '9996' , 'SIGNORE, TI PREGO' , '10' , '-10' , '4' , '3.8' , '3.8' , '0' , '0' , '38.00' ) 01/09/2023 04:31:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '87086' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-08-29') 01/09/2023 04:31:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '111', document_date = '2023-08-29', document_letter = '', id_customer = '4025', id_supplier = '', id_address = '4679072', address1 = 'VIA ANTONELLI E TEBALDI, 149 62018 POTENZA PICENA', address2 = '', note = '', price_shipping = '5.19', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '47.57', price_tax_excluded = '47.57', date_upd = NOW() WHERE id_document = '87086' 01/09/2023 04:31:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87086' 01/09/2023 04:31:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87086' 01/09/2023 04:31: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 ( '87086' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 01/09/2023 04:31: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 ( '87086' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 01/09/2023 04:31:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87086' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '14' , '-14' , '4' , '2.4000' , '2.4' , '0' , '5' , '31.92' ) 01/09/2023 04:31:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87086' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '1.90' , '1.9' , '0' , '0' , '3.80' ) 01/09/2023 05:18:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 05:18:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2711' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 01/09/2023 05:18:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87157' 01/09/2023 05:18:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '87157' 01/09/2023 05:18:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87157' , '19560' , 'PERGAMENA 17X25' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 01/09/2023 05:48:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 05:48:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2712' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.17' , NOW() , NOW() ) 01/09/2023 05:48:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87158' 01/09/2023 05:48:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87158' 01/09/2023 05:48: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 ( '87158' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 01/09/2023 06:47:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 06:47:21 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' , '2713' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '43.31' , NOW() , NOW() ) 01/09/2023 06:47: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 = '87159' 01/09/2023 06:47:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '87159' 01/09/2023 06:47: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 ( '87159' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 01/09/2023 06:47: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 ( '87159' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '22' , '22' , '0' , '0' , '22.00' ) 01/09/2023 06:47: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 ( '87159' , '17961' , 'CATENINA ARG. CM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 01/09/2023 07:19:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 01/09/2023 07:19:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2714' , '2023-09-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 01/09/2023 07:19:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87160' 01/09/2023 07:19:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87160' 01/09/2023 07:19: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 ( '87160' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' )