08/07/2022 10:01:43 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/07/2022 10:01:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19734' , '1' , '' , 'nuovo-prodotto' ) 08/07/2022 10:01:43 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19734' , '1' , '1' , '2' , NOW() , NOW() ) 08/07/2022 10:01:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19734' , '0' , '1' , '0' , '0' ) 08/07/2022 10:03:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400286878' AND id_product != '19734' AND ean13 != '' 08/07/2022 10:03:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400286878', date_upd = NOW() WHERE id_product = '19734' 08/07/2022 10:03:18 am >> UPDATE ps_product_lang SET name = 'DECINA PERSONALIZZATA - 1763D', description = '' WHERE id_product = '19734' 08/07/2022 10:03:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9508196721311477' WHERE id_product = '19734' 08/07/2022 10:03:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9508196721311477', id_tax_rules_group = '1', id_category_default = '95', 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 = '19734' 08/07/2022 10:03:18 am >> DELETE FROM ps_specific_price WHERE id_product = '19734' 08/07/2022 10:08:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400029246' AND id_product != '9688' AND ean13 != '' 08/07/2022 10:08:41 am >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '8058400029246', date_upd = NOW() WHERE id_product = '9688' 08/07/2022 10:08:41 am >> UPDATE ps_product_lang SET name = 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ', description = '' WHERE id_product = '9688' 08/07/2022 10:08:41 am >> UPDATE ps_product SET wholesale_price = '1.00', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '9688' 08/07/2022 10:08:41 am >> UPDATE ps_product_shop SET wholesale_price = '1.00', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', 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 = '9688' 08/07/2022 10:08:41 am >> DELETE FROM ps_specific_price WHERE id_product = '9688' 08/07/2022 10:28:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263138' AND id_product != '13845' AND ean13 != '' 08/07/2022 10:28:49 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263138', date_upd = NOW() WHERE id_product = '13845' 08/07/2022 10:28:49 am >> UPDATE ps_product_lang SET name = 'COLLANINA IN ACCIAIO ANGELO - 1984/A48', description = '' WHERE id_product = '13845' 08/07/2022 10:28:49 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '3.1147540983606556' WHERE id_product = '13845' 08/07/2022 10:28:49 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '3.1147540983606556', id_tax_rules_group = '1', id_category_default = '95', 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 = '13845' 08/07/2022 10:28:49 am >> DELETE FROM ps_specific_price WHERE id_product = '13845' 08/07/2022 10:29:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263121' AND id_product != '13844' AND ean13 != '' 08/07/2022 10:29:44 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263121', date_upd = NOW() WHERE id_product = '13844' 08/07/2022 10:29:44 am >> UPDATE ps_product_lang SET name = 'COLLANINA IN ACCIAIO MADONNA - 1984/M14', description = '' WHERE id_product = '13844' 08/07/2022 10:29:44 am >> UPDATE ps_product SET wholesale_price = '1.47', on_sale = '0', price = '3.1147540983606556' WHERE id_product = '13844' 08/07/2022 10:29:44 am >> UPDATE ps_product_shop SET wholesale_price = '1.47', price = '3.1147540983606556', id_tax_rules_group = '1', id_category_default = '95', 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 = '13844' 08/07/2022 10:29:44 am >> DELETE FROM ps_specific_price WHERE id_product = '13844' 08/07/2022 10:29:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263145' AND id_product != '13549' AND ean13 != '' 08/07/2022 10:29:51 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263145', date_upd = NOW() WHERE id_product = '13549' 08/07/2022 10:29:51 am >> UPDATE ps_product_lang SET name = 'COLLANINA ARGENTATA ALBERO DELLA VITA - 1984/J97', description = '' WHERE id_product = '13549' 08/07/2022 10:29:51 am >> UPDATE ps_product SET wholesale_price = '1.19', on_sale = '0', price = '3.1147540983606556' WHERE id_product = '13549' 08/07/2022 10:29:51 am >> UPDATE ps_product_shop SET wholesale_price = '1.19', price = '3.1147540983606556', id_tax_rules_group = '1', id_category_default = '95', 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 = '13549' 08/07/2022 10:29:51 am >> DELETE FROM ps_specific_price WHERE id_product = '13549' 08/07/2022 10:30:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400263152' AND id_product != '13550' AND ean13 != '' 08/07/2022 10:30:10 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400263152', date_upd = NOW() WHERE id_product = '13550' 08/07/2022 10:30:10 am >> UPDATE ps_product_lang SET name = 'COLLANINA ARGENTATA ORME DELLA SABBIA - 1984/J98', description = '' WHERE id_product = '13550' 08/07/2022 10:30:10 am >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '3.1147540983606556' WHERE id_product = '13550' 08/07/2022 10:30:10 am >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '3.1147540983606556', id_tax_rules_group = '1', id_category_default = '95', 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 = '13550' 08/07/2022 10:30:10 am >> DELETE FROM ps_specific_price WHERE id_product = '13550' 08/07/2022 10:32:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400297355' AND id_product != '17276' AND ean13 != '' 08/07/2022 10:32:00 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400297355', date_upd = NOW() WHERE id_product = '17276' 08/07/2022 10:32:00 am >> UPDATE ps_product_lang SET name = 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911', description = '' WHERE id_product = '17276' 08/07/2022 10:32:00 am >> UPDATE ps_product SET wholesale_price = '1.50', on_sale = '0', price = '3.7704918032786883' WHERE id_product = '17276' 08/07/2022 10:32:01 am >> UPDATE ps_product_shop SET wholesale_price = '1.50', price = '3.7704918032786883', id_tax_rules_group = '1', id_category_default = '95', 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 = '17276' 08/07/2022 10:32:01 am >> DELETE FROM ps_specific_price WHERE id_product = '17276' 08/07/2022 10:33: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 ( '31' , 'A2903' , '2022-07-05' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '12.34' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '541.91' , '444.19' , NOW() , NOW() ) 08/07/2022 10:33: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 = '59102' 08/07/2022 10:33:45 am >> DELETE FROM ps_document_detail WHERE id_document = '59102' 08/07/2022 10:33: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 ( '59102' , '19734' , 'DECINA PERSONALIZZATA - 1763D' , '15' , '15' , '1' , '0.97' , '0.79508196721311' , '22' , '0' , '17.7510' ) 08/07/2022 10:33:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19734' AND id_supplier = '28' 08/07/2022 10:33:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19734' , '28' , '1' ) 08/07/2022 10:33: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 ( '59102' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '24' , '24' , '1' , '1.73' , '1.4180327868852' , '22' , '0' , '50.6544' ) 08/07/2022 10:33:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18099' AND id_supplier = '28' 08/07/2022 10:33:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18099' , '28' , '1' ) 08/07/2022 10:33: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 ( '59102' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '24' , '24' , '1' , '1.73' , '1.4180327868852' , '22' , '0' , '50.6544' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18098' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18098' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '50' , '50' , '1' , '1.188' , '0.97377049180328' , '22' , '0' , '72.4680' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '19320' , 'QUADRO PIASTRELLA 20X20 SACRA FAMIGLIA - 2189/I0102' , '1' , '1' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '11.0532' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19320' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19320' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '24' , '24' , '1' , '2.38' , '1.9508196721311' , '22' , '0' , '69.6864' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '12' , '12' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '20.4960' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '12' , '12' , '1' , '1.47' , '1.2049180327869' , '22' , '0' , '21.5208' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '9113' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9113' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '13845' , 'COLLANINA IN ACCIAIO ANGELO - 1984/A48' , '24' , '24' , '1' , '1.54' , '1.2622950819672' , '22' , '0' , '45.0912' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '13845' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13845' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '13549' , 'COLLANINA ARGENTATA ALBERO DELLA VITA - 1984/J97' , '24' , '24' , '1' , '1.54' , '1.2622950819672' , '22' , '0' , '45.0912' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '13549' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13549' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '24' , '24' , '1' , '1.54' , '1.2622950819672' , '22' , '0' , '45.0912' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '13844' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13844' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '13550' , 'COLLANINA ARGENTATA ORME DELLA SABBIA - 1984/J98' , '12' , '12' , '1' , '1.54' , '1.2622950819672' , '22' , '0' , '22.5456' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '13550' AND id_supplier = '28' 08/07/2022 10:33:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13550' , '28' , '1' ) 08/07/2022 10:33:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59102' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '24' , '24' , '1' , '1.87' , '1.5327868852459' , '22' , '0' , '54.7536' ) 08/07/2022 10:33:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17276' AND id_supplier = '28' 08/07/2022 10:33:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17276' , '28' , '1' ) 08/07/2022 11:06:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 11:06: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 ( '11' , '2212' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 08/07/2022 11:06: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 = '59103' 08/07/2022 11:06:02 am >> DELETE FROM ps_document_detail WHERE id_document = '59103' 08/07/2022 11:06: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 ( '59103' , '19662' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 08/07/2022 11:06:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19662' AND id_supplier = '' 08/07/2022 11:06:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19662' , '' , '1' ) 08/07/2022 11:16:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 11:16:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2213' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 08/07/2022 11:16:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59104' 08/07/2022 11:16:37 am >> DELETE FROM ps_document_detail WHERE id_document = '59104' 08/07/2022 11:16:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59104' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 08/07/2022 11:16:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 08/07/2022 11:16:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 08/07/2022 11:41:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 11:41:58 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' , '2214' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.20' , '16.84' , NOW() , NOW() ) 08/07/2022 11:41:58 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 = '59105' 08/07/2022 11:41:58 am >> DELETE FROM ps_document_detail WHERE id_document = '59105' 08/07/2022 11:41:58 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 ( '59105' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 08/07/2022 11:41:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '' 08/07/2022 11:41:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '' , '1' ) 08/07/2022 11:41:58 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 ( '59105' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 08/07/2022 11:41:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 08/07/2022 11:41:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 08/07/2022 11:44:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 11:44:04 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' , '2215' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 08/07/2022 11:44:04 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 = '59106' 08/07/2022 11:44:04 am >> DELETE FROM ps_document_detail WHERE id_document = '59106' 08/07/2022 11:44:04 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 ( '59106' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '4' , '-4' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '52.00' ) 08/07/2022 11:44:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '' 08/07/2022 11:44:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '' , '1' ) 08/07/2022 11:44:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 11:44: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' , '2216' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.85' , '2.85' , NOW() , NOW() ) 08/07/2022 11:44: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 = '59107' 08/07/2022 11:44:31 am >> DELETE FROM ps_document_detail WHERE id_document = '59107' 08/07/2022 11:44: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 ( '59107' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 08/07/2022 11:44:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 08/07/2022 11:44:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 08/07/2022 11:49:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 11:49: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' , '2217' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 08/07/2022 11:49: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 = '59108' 08/07/2022 11:49:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59108' 08/07/2022 11:49: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 ( '59108' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '4' , '-4' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '60.00' ) 08/07/2022 11:49:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 08/07/2022 11:49:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 08/07/2022 12:05:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1022' AND id_document != '54622' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-07') 08/07/2022 12:05:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1022', document_date = '2022-04-07', 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 = '9.60', price_tax_excluded = '7.87', date_upd = NOW() WHERE id_document = '54622' 08/07/2022 12:05:06 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 = '54622' 08/07/2022 12:05:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '54622' 08/07/2022 12:05:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54622' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '48' , '-48' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '9.60' ) 08/07/2022 12:05:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 08/07/2022 12:05:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 08/07/2022 12:05:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1099' AND id_document != '54710' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-12') 08/07/2022 12:05:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1099', document_date = '2022-04-12', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '54710' 08/07/2022 12:05:29 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 = '54710' 08/07/2022 12:05:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '54710' 08/07/2022 12:05:29 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 ( '54710' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 08/07/2022 12:05:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 08/07/2022 12:05:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 08/07/2022 12:05:29 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 ( '54710' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '65' , '-65' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '13.00' ) 08/07/2022 12:05:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 08/07/2022 12:05:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 08/07/2022 12:06:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 12:06: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 ( '11' , '2218' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '12.02' , NOW() , NOW() ) 08/07/2022 12:06: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 = '59109' 08/07/2022 12:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '59109' 08/07/2022 12:06: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 ( '59109' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/07/2022 12:06:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 08/07/2022 12:06:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 08/07/2022 12:06: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 ( '59109' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 08/07/2022 12:06:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 08/07/2022 12:06:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 08/07/2022 12:08:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1227' AND id_document != '55883' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 08/07/2022 12:08:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1227', document_date = '2022-04-23', 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 = '118.00', price_tax_excluded = '96.72', date_upd = NOW() WHERE id_document = '55883' 08/07/2022 12:08: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 = '55883' 08/07/2022 12:08:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '55883' 08/07/2022 12:08: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 ( '55883' , '18249' , 'CLERGY JEANS NIDO DAPE MM - XL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 08/07/2022 12:08:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18249' AND id_supplier = '' 08/07/2022 12:08:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18249' , '' , '1' ) 08/07/2022 12:08: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 ( '55883' , '18254' , 'CLERGY BLU NIDO DAPE MM - XL' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 08/07/2022 12:08:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18254' AND id_supplier = '' 08/07/2022 12:08:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18254' , '' , '1' ) 08/07/2022 12:08: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 ( '55883' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '190' , '-190' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '38.00' ) 08/07/2022 12:08:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 08/07/2022 12:08:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 08/07/2022 12:19:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 12:19: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' , '2219' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '39.90' , NOW() , NOW() ) 08/07/2022 12:19: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 = '59110' 08/07/2022 12:19:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59110' 08/07/2022 12:19: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 ( '59110' , '19642' , 'RIFORMA - M. SEEWALD' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '5' , '22.80' ) 08/07/2022 12:19:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19642' AND id_supplier = '' 08/07/2022 12:19:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19642' , '' , '1' ) 08/07/2022 12:19: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 ( '59110' , '19646' , 'LUCI E OMBRE DELLA RELIGIOSITA - D.GOMEZ' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 08/07/2022 12:19:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19646' AND id_supplier = '' 08/07/2022 12:19:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19646' , '' , '1' ) 08/07/2022 12:25:22 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/07/2022 12:25:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19735' , '1' , '' , 'nuovo-prodotto' ) 08/07/2022 12:25:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19735' , '1' , '1' , '2' , NOW() , NOW() ) 08/07/2022 12:25:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19735' , '0' , '1' , '0' , '0' ) 08/07/2022 12:26:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851424305' AND id_product != '19735' AND ean13 != '' 08/07/2022 12:26:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788851424305', date_upd = NOW() WHERE id_product = '19735' 08/07/2022 12:26:11 pm >> UPDATE ps_product_lang SET name = 'convertire peter pan - a. matteo', description = '' WHERE id_product = '19735' 08/07/2022 12:26:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '19735' 08/07/2022 12:26:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19735' 08/07/2022 12:26:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19735' 08/07/2022 12:27:38 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' , '220307' , '2022-07-06' , '' , '0' , '119' , '4669226' , 'VIA B. CRESPI, 30 20159 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '78.00' , '78.00' , NOW() , NOW() ) 08/07/2022 12:27:38 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 = '59111' 08/07/2022 12:27:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '59111' 08/07/2022 12:27:38 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 ( '59111' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '1' , '4' , '48.00' , '48' , '0' , '38' , '29.7600' ) 08/07/2022 12:27:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10914' AND id_supplier = '119' 08/07/2022 12:27:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10914' , '119' , '1' ) 08/07/2022 12:27:38 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 ( '59111' , '18115' , 'BIBBIA GIOVANE' , '1' , '1' , '4' , '24.90' , '24.9' , '0' , '38' , '15.4380' ) 08/07/2022 12:27:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18115' AND id_supplier = '119' 08/07/2022 12:27:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18115' , '119' , '1' ) 08/07/2022 12:27:38 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 ( '59111' , '1102' , 'BIBBIA BROSSURA OLANDESE' , '1' , '1' , '4' , '26.90' , '26.9' , '0' , '38' , '16.6780' ) 08/07/2022 12:27:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1102' AND id_supplier = '119' 08/07/2022 12:27:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1102' , '119' , '1' ) 08/07/2022 12:27:38 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 ( '59111' , '19735' , 'convertire peter pan - a. matteo' , '2' , '2' , '4' , '13.00' , '13' , '0' , '38' , '16.1200' ) 08/07/2022 12:27:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19735' AND id_supplier = '119' 08/07/2022 12:27:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19735' , '119' , '1' ) 08/07/2022 12:40: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 ( '31' , '000' , '2022-07-08' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , 'modificare numero' , '13' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '624.64' , '512.00' , NOW() , NOW() ) 08/07/2022 12:40: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 = '59112' 08/07/2022 12:40:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59112' 08/07/2022 12:40: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 ( '59112' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '8' , '8' , '1' , '56' , '45.901639344262' , '22' , '0' , '546.5600' ) 08/07/2022 12:40:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '118' 08/07/2022 12:40:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '118' , '1' ) 08/07/2022 12:40: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 ( '59112' , '19194' , 'STOLA DIACONALE - 209' , '2' , '2' , '1' , '25.5' , '20.901639344262' , '22' , '0' , '62.2200' ) 08/07/2022 12:40:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19194' AND id_supplier = '118' 08/07/2022 12:40:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19194' , '118' , '1' ) 08/07/2022 12:52:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 12:52:17 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' , '2220' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.50' , NOW() , NOW() ) 08/07/2022 12:52:17 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 = '59113' 08/07/2022 12:52:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '59113' 08/07/2022 12:52:17 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 ( '59113' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/07/2022 12:52:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 08/07/2022 12:52:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 08/07/2022 12:52:17 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 ( '59113' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/07/2022 12:52:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 08/07/2022 12:52:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 08/07/2022 12:52:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59113' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 08/07/2022 12:52:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 08/07/2022 12:52:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 08/07/2022 02:46:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 02:46:30 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' , '2221' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '24.70' , NOW() , NOW() ) 08/07/2022 02:46:30 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 = '59114' 08/07/2022 02:46:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '59114' 08/07/2022 02:46:30 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 ( '59114' , '19735' , 'convertire peter pan - a. matteo' , '2' , '-2' , '4' , '13.00' , '13' , '0' , '5' , '24.70' ) 08/07/2022 02:46:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19735' AND id_supplier = '' 08/07/2022 02:46:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19735' , '' , '1' ) 08/07/2022 02:46:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 02:46: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' , '2222' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.50' , '121.50' , NOW() , NOW() ) 08/07/2022 02:46: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 = '59115' 08/07/2022 02:46:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '59115' 08/07/2022 02:46: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 ( '59115' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '27' , '-27' , '4' , '4.5' , '4.5' , '0' , '0' , '121.50' ) 08/07/2022 02:46:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 08/07/2022 02:46:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 08/07/2022 03:58:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1160' AND id_document != '55292' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-16') 08/07/2022 03:58:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1160', document_date = '2022-04-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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '55292' 08/07/2022 03:58:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55292' 08/07/2022 03:58:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '55292' 08/07/2022 03:58:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55292' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '25' , '-25' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '45.00' ) 08/07/2022 03:58:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 08/07/2022 03:58:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 08/07/2022 03:58:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55292' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 08/07/2022 03:58:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 08/07/2022 03:58:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 08/07/2022 03:59:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1174' AND id_document != '55307' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-19') 08/07/2022 03:59:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1174', document_date = '2022-04-19', 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 = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '55307' 08/07/2022 03:59:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '55307' 08/07/2022 03:59:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '55307' 08/07/2022 03:59:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55307' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' , '-1' , '1' , '150.0000' , '122.95081967213' , '22' , '0' , '150.00' ) 08/07/2022 03:59:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1364' AND id_supplier = '' 08/07/2022 03:59:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1364' , '' , '1' ) 08/07/2022 03:59:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55307' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '25' , '-25' , '1' , '2' , '1.6393442622951' , '22' , '0' , '50.00' ) 08/07/2022 03:59:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 08/07/2022 03:59:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 08/07/2022 04:00:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1104' AND id_document != '54717' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-12') 08/07/2022 04:00:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1104', document_date = '2022-04-12', 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 = '73.50', price_tax_excluded = '64.00', date_upd = NOW() WHERE id_document = '54717' 08/07/2022 04:00:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '54717' 08/07/2022 04:00:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '54717' 08/07/2022 04:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 08/07/2022 04:00:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 08/07/2022 04:00:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '6.00' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '3.40' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '3.00' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 08/07/2022 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54717' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 08/07/2022 04:00:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 08/07/2022 04:00:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 08/07/2022 04:00:12 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 ( '54717' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '12' , '-12' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '21.60' ) 08/07/2022 04:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 08/07/2022 04:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 08/07/2022 04:26:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 04:26:12 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 ( '22' , '12/S' , '2022-07-08' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GIUGNO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '728.25' , '728.25' , NOW() , NOW() ) 08/07/2022 04:26:12 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 = '5375' 08/07/2022 04:26:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '5375' 08/07/2022 04:26:12 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 ( '5375' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '0' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 08/07/2022 04:26:12 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 ( '5375' , '21' , 'LA COMUNIONE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 08/07/2022 04:26:12 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 ( '5375' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '43' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '32.25' ) 08/07/2022 04:26:12 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 ( '5375' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '24' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '30.00' ) 08/07/2022 04:26:12 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 ( '5375' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '28' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '35.00' ) 08/07/2022 04:26:12 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 ( '5375' , '125' , 'MIE PREGHIERINE - N. E.' , '205' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '153.75' ) 08/07/2022 04:26:12 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 ( '5375' , '33' , '100 GIORNI CON LO SPIRITO' , '5' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '18.75' ) 08/07/2022 04:26:12 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 ( '5375' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '50' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '37.50' ) 08/07/2022 04:26:13 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 ( '5375' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 08/07/2022 04:26:13 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 ( '5375' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 08/07/2022 04:26:13 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 ( '5375' , '77' , 'LA SACRA SINDONE SPIEGATA AI RAGAZZI' , '1' , '0' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 08/07/2022 04:26:13 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 ( '5375' , '92' , 'LA PREGHIERA DEL ROSARIO' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 08/07/2022 04:26:13 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 ( '5375' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 08/07/2022 04:26:13 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 ( '5375' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 08/07/2022 04:26:13 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 ( '5375' , '110' , 'SE MI AMI NON PIANGERE' , '461' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '345.75' ) 08/07/2022 04:26:13 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 ( '5375' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 08/07/2022 04:26:13 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 ( '5375' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 08/07/2022 04:26:13 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 ( '5375' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 08/07/2022 04:26:13 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 ( '5375' , '126' , 'SACRAMENTO DEL PERDONO' , '17' , '0' , '4' , '2.00' , '2' , '0' , '50' , '17.00' ) 08/07/2022 04:28:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 04:28: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 ( '25' , '13/S' , '2022-07-08' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GIUGNO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.25' , '97.25' , NOW() , NOW() ) 08/07/2022 04:28: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 = '5376' 08/07/2022 04:28:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '5376' 08/07/2022 04:28: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 ( '5376' , '20' , 'GIOVEDÌ SANTO' , '28' , '28' , '4' , '1.50' , '1.5' , '0' , '50' , '21.00' ) 08/07/2022 04:28: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 ( '5376' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '35' , '35' , '4' , '2.00' , '2' , '0' , '50' , '35.00' ) 08/07/2022 04:28: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 ( '5376' , '75' , 'IL SEGNO DELLA CROCE' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 08/07/2022 04:28: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 ( '5376' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 08/07/2022 04:28: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 ( '5376' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '16' , '16' , '4' , '3.00' , '3' , '0' , '50' , '24.00' ) 08/07/2022 04:28: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 ( '5376' , '126' , 'SACRAMENTO DEL PERDONO' , '10' , '10' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 08/07/2022 04:28:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/S' AND id_document != '5375' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 04:28:25 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '12/S', document_date = '2022-07-08', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO GIUGNO 2022', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '727.00', price_tax_excluded = '727.00', date_upd = NOW() WHERE id_document = '5375' 08/07/2022 04:28: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 = '5375' 08/07/2022 04:28:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '5375' 08/07/2022 04:28: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 ( '5375' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '21' , 'LA COMUNIONE' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '43' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '32.25' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '124' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '124' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '24' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '30.00' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '28' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '35.00' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '130' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '130' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '125' , 'MIE PREGHIERINE - N. E.' , '205' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '153.75' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '33' , '100 GIORNI CON LO SPIRITO' , '5' , '0' , '4' , '7' , '7' , '0' , '50' , '17.50' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '33' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '33' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '50' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '37.50' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '55' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '55' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '57' AND id_supplier = '' 08/07/2022 04:28:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '57' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 08/07/2022 04:28:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '67' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '67' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '77' , 'LA SACRA SINDONE SPIEGATA AI RAGAZZI' , '1' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '0.50' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '77' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '77' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '92' , 'LA PREGHIERA DEL ROSARIO' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '92' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '92' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '99' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '99' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '127' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '127' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '110' , 'SE MI AMI NON PIANGERE' , '461' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '345.75' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '123' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '123' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '118' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '118' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '132' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '132' , '' , '1' ) 08/07/2022 04:28: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 ( '5375' , '126' , 'SACRAMENTO DEL PERDONO' , '17' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '17.00' ) 08/07/2022 04:28:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '126' AND id_supplier = '' 08/07/2022 04:28:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '126' , '' , '1' ) 08/07/2022 04:41:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 04:41:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '21/E' , '2022-07-08' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GIUGNO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1167.50' , '1167.05' , NOW() , NOW() ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59116' 08/07/2022 04:41:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '59116' 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '57' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '68.40' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '5446' , 'IO SONO CON VOI - GUIDA' , '5' , '0' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '11183' , 'VENITE CON ME - GUIDA' , '5' , '0' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '9996' , 'SIGNORE, TI PREGO' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '6' , '0' , '4' , '6.00' , '6' , '0' , '50' , '18.00' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '4154' , 'FESTA DEL PERDONO' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '17' , '0' , '4' , '5.00' , '5' , '0' , '50' , '42.50' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '2' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '8.50' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '67' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '53.60' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '297' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '237.60' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '7543' , 'PARABOLE DI GESÙ' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 08/07/2022 04:41:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '105' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '84.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '2.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '12253' , 'MIO LIBRO DI PREGHIERE' , '19' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '26.60' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '12255' , 'IN CAMMINO CON GESU' , '10' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '19.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '4' , '0' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '13956' , 'MIRACOLI DI GESU' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '14032' , 'AVE MARIA' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '205' , '0' , '4' , '1.00' , '1' , '0' , '50' , '102.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '0.80' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '0' , '4' , '1.00' , '1' , '0' , '50' , '1.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '4' , '0' , '4' , '1.00' , '1' , '0' , '50' , '2.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '16667' , 'VIA CRUCIS' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '4' , '0' , '4' , '15.00' , '15' , '0' , '50' , '30.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '17257' , 'IO TI BATTEZZO ' , '58' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '52.20' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '17582' , 'SAN CESARE DE BUS' , '3' , '0' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '3' , '0' , '4' , '20.00' , '20' , '0' , '50' , '30.00' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '6' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '11.40' ) 08/07/2022 04:41:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59116' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '2' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '1.90' ) 08/07/2022 04:41:38 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 ( '59116' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '21' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '26.25' ) 08/07/2022 04:41:38 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 ( '59116' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 08/07/2022 04:41:38 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 ( '59116' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 08/07/2022 04:41:38 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 ( '59116' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '3' , '0' , '4' , '20.00' , '20' , '0' , '50' , '30.00' ) 08/07/2022 04:41:38 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 ( '59116' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 08/07/2022 04:41:38 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 ( '59116' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '15' , '0' , '4' , '7.00' , '7' , '0' , '50' , '52.50' ) 08/07/2022 04:41:38 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 ( '59116' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '13' , '0' , '4' , '2.00' , '2' , '0' , '50' , '13.00' ) 08/07/2022 04:41:38 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 ( '59116' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 08/07/2022 04:41:38 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 ( '59116' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 08/07/2022 04:41:38 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 ( '59116' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '5' , '0' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 08/07/2022 04:41:38 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 ( '59116' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '0' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 08/07/2022 04:41:38 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 ( '59116' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 08/07/2022 04:41:38 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 ( '59116' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '5' , '0' , '4' , '20.00' , '20' , '0' , '50' , '50.00' ) 08/07/2022 04:41:38 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 ( '59116' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '7' , '0' , '4' , '12.00' , '12' , '0' , '50' , '42.00' ) 08/07/2022 04:41:38 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 ( '59116' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 08/07/2022 04:51:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 04:51: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 ( '25' , '22/E' , '2022-07-08' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GIUGNO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '798.10' , '798.10' , NOW() , NOW() ) 08/07/2022 04:51: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 = '59117' 08/07/2022 04:51:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '59117' 08/07/2022 04:51: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 ( '59117' , '9675' , 'SARETE MIEI TESTIMONI' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 08/07/2022 04:51: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 ( '59117' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '13' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 08/07/2022 04:51: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 ( '59117' , '5458' , 'IO SONO CON VOI 2 PARTE' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 08/07/2022 04:51: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 ( '59117' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '16' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 08/07/2022 04:51: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 ( '59117' , '11192' , 'VENITE CON ME 2 PARTE' , '19' , '19' , '4' , '2.50' , '2.5' , '0' , '50' , '23.75' ) 08/07/2022 04:51: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 ( '59117' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '5' , '5' , '4' , '3.40' , '3.4' , '0' , '50' , '8.50' ) 08/07/2022 04:51: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 ( '59117' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 08/07/2022 04:51: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 ( '59117' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 08/07/2022 04:51: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 ( '59117' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 08/07/2022 04:51: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 ( '59117' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 08/07/2022 04:51: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 ( '59117' , '3978' , 'EUCARISTIA: RITO E VITA' , '2' , '2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 08/07/2022 04:51: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 ( '59117' , '8408' , 'PRENDETE E MANGIATE' , '19' , '19' , '4' , '3.00' , '3' , '0' , '50' , '28.50' ) 08/07/2022 04:51: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 ( '59117' , '4154' , 'FESTA DEL PERDONO' , '13' , '13' , '4' , '3.00' , '3' , '0' , '50' , '19.50' ) 08/07/2022 04:51: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 ( '59117' , '2679' , 'CONOSCERE GESU' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 08/07/2022 04:51: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 ( '59117' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 08/07/2022 04:51: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 ( '59117' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '3' , '3' , '4' , '12.00' , '12' , '0' , '50' , '18.00' ) 08/07/2022 04:51: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 ( '59117' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '7' , '7' , '4' , '3.50' , '3.5' , '0' , '50' , '12.25' ) 08/07/2022 04:51: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 ( '59117' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 08/07/2022 04:51: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 ( '59117' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 08/07/2022 04:51: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 ( '59117' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '2' , '2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 08/07/2022 04:51: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 ( '59117' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '2' , '4' , '1.00' , '1' , '0' , '50' , '1.00' ) 08/07/2022 04:51: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 ( '59117' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '63' , '63' , '4' , '1.00' , '1' , '0' , '50' , '31.50' ) 08/07/2022 04:51: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 ( '59117' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '11' , '11' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 08/07/2022 04:51: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 ( '59117' , '16667' , 'VIA CRUCIS' , '9' , '9' , '4' , '3.00' , '3' , '0' , '50' , '13.50' ) 08/07/2022 04:51: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 ( '59117' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 08/07/2022 04:51: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 ( '59117' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '4' , '4' , '4' , '15.00' , '15' , '0' , '50' , '30.00' ) 08/07/2022 04:51: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 ( '59117' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '6' , '6' , '4' , '1.90' , '1.9' , '0' , '50' , '5.70' ) 08/07/2022 04:51: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 ( '59117' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 08/07/2022 04:51: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 ( '59117' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '63' , '63' , '4' , '1.50' , '1.5' , '0' , '50' , '47.25' ) 08/07/2022 04:51: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 ( '59117' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '3' , '3' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 08/07/2022 04:51: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 ( '59117' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 08/07/2022 04:51: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 ( '59117' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '4' , '4' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 08/07/2022 04:51: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 ( '59117' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 08/07/2022 04:51: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 ( '59117' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '9' , '9' , '4' , '16.00' , '16' , '0' , '50' , '72.00' ) 08/07/2022 04:51: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 ( '59117' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '3' , '3' , '4' , '7.00' , '7' , '0' , '50' , '10.50' ) 08/07/2022 04:51: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 ( '59117' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '6' , '6' , '4' , '4.80' , '4.8' , '0' , '50' , '14.40' ) 08/07/2022 04:51: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 ( '59117' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '6' , '6' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 08/07/2022 04:51: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 ( '59117' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '13' , '13' , '4' , '9.00' , '9' , '0' , '50' , '58.50' ) 08/07/2022 04:51: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 ( '59117' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '11' , '11' , '4' , '9.00' , '9' , '0' , '50' , '49.50' ) 08/07/2022 04:51: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 ( '59117' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '13' , '13' , '4' , '9.00' , '9' , '0' , '50' , '58.50' ) 08/07/2022 04:51: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 ( '59117' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 08/07/2022 04:51: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 ( '59117' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 08/07/2022 04:51: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 ( '59117' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 08/07/2022 04:51: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 ( '59117' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '59' , '59' , '4' , '2.00' , '2' , '0' , '50' , '59.00' ) 08/07/2022 05:02:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-24') 08/07/2022 05:02: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 ( '24' , '19' , '2022-06-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'spedito da velar 06/06/2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '250.00' , NOW() , NOW() ) 08/07/2022 05:02: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 = '59118' 08/07/2022 05:02:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '59118' 08/07/2022 05:02: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 ( '59118' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '-100' , '4' , '2.50' , '2.5' , '0' , '0' , '250.00' ) 08/07/2022 05:05: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 ( '31' , '135/22' , '2022-06-30' , '22' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '62.40' , '60.00' , NOW() , NOW() ) 08/07/2022 05:05: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 = '59119' 08/07/2022 05:05:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '59119' 08/07/2022 05:05: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 ( '59119' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '100' , '3' , '0.6' , '0.57692307692308' , '4' , '0' , '62.4000' ) 08/07/2022 05:05:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17861' AND id_supplier = '145' 08/07/2022 05:05:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17861' , '145' , '1' ) 08/07/2022 05:41:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 05:41:52 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' , '50/A' , '2022-07-08' , 'A' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '244.00' , '244.00' , NOW() , NOW() ) 08/07/2022 05:41:52 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 = '59120' 08/07/2022 05:41:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '59120' 08/07/2022 05:41:52 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 ( '59120' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 08/07/2022 05:41:52 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 ( '59120' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 08/07/2022 05:41:52 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 ( '59120' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '0' , '15.00' ) 08/07/2022 05:41:52 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 ( '59120' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '19' , '-19' , '4' , '3.00' , '3' , '0' , '0' , '57.00' ) 08/07/2022 05:41:52 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 ( '59120' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '18' , '-18' , '4' , '3.00' , '3' , '0' , '0' , '54.00' ) 08/07/2022 05:41:52 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 ( '59120' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '17' , '-17' , '4' , '3.00' , '3' , '0' , '0' , '51.00' ) 08/07/2022 05:41:52 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 ( '59120' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '11' , '-11' , '4' , '3.00' , '3' , '0' , '0' , '33.00' ) 08/07/2022 05:41:52 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 ( '59120' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '8' , '-8' , '4' , '3.00' , '3' , '0' , '0' , '24.00' ) 08/07/2022 06:18:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/A' AND id_document != '59120' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 06:18:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '50/A', document_date = '2022-07-08', document_letter = 'A', id_customer = '2379', id_supplier = '', id_address = '4671437', address1 = 'R.NE PESCARA 84025 EBOLI', 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 = '339.00', price_tax_excluded = '339.00', date_upd = NOW() WHERE id_document = '59120' 08/07/2022 06:18:50 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 = '59120' 08/07/2022 06:18:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '59120' 08/07/2022 06:18:50 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 ( '59120' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 08/07/2022 06:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '' 08/07/2022 06:18:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '' , '1' ) 08/07/2022 06:18:50 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 ( '59120' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 08/07/2022 06:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '' 08/07/2022 06:18:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '' , '1' ) 08/07/2022 06:18:50 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 ( '59120' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '5' , '-5' , '4' , '3.0000' , '3' , '0' , '0' , '15.00' ) 08/07/2022 06:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 08/07/2022 06:18:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 08/07/2022 06:18:50 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 ( '59120' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '19' , '-19' , '4' , '3.0000' , '3' , '0' , '0' , '57.00' ) 08/07/2022 06:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 08/07/2022 06:18:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 08/07/2022 06:18:50 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 ( '59120' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '0' , '54.00' ) 08/07/2022 06:18:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 08/07/2022 06:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 08/07/2022 06: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 ( '59120' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '17' , '-17' , '4' , '3.0000' , '3' , '0' , '0' , '51.00' ) 08/07/2022 06:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 08/07/2022 06:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 08/07/2022 06: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 ( '59120' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '11' , '-11' , '4' , '3.0000' , '3' , '0' , '0' , '33.00' ) 08/07/2022 06:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 08/07/2022 06:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 08/07/2022 06: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 ( '59120' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '8' , '-8' , '4' , '3.0000' , '3' , '0' , '0' , '24.00' ) 08/07/2022 06:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 08/07/2022 06:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 08/07/2022 06: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 ( '59120' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '0' , '10.00' ) 08/07/2022 06:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 08/07/2022 06:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 08/07/2022 06: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 ( '59120' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.40' , '3.4' , '0' , '0' , '85.00' ) 08/07/2022 06:18:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 08/07/2022 06:18:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 08/07/2022 06:26:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/A' AND id_document != '59120' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 06:26:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '50/A', document_date = '2022-07-08', document_letter = 'A', id_customer = '2379', id_supplier = '', id_address = '4671437', address1 = 'R.NE PESCARA 84025 EBOLI', 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 = '295.60', price_tax_excluded = '295.60', date_upd = NOW() WHERE id_document = '59120' 08/07/2022 06:26:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59120' 08/07/2022 06:26:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '59120' 08/07/2022 06:26:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '10' , '4.50' ) 08/07/2022 06:26:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '' 08/07/2022 06:26:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '' , '1' ) 08/07/2022 06:26:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '10' , '4.50' ) 08/07/2022 06:26:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '' 08/07/2022 06:26:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '' , '1' ) 08/07/2022 06:26:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '5' , '-5' , '4' , '3.0000' , '3' , '0' , '10' , '13.50' ) 08/07/2022 06:26:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 08/07/2022 06:26:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 08/07/2022 06:26:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '19' , '-19' , '4' , '3.0000' , '3' , '0' , '10' , '51.30' ) 08/07/2022 06:26:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 08/07/2022 06:26:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 08/07/2022 06:26:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '10' , '48.60' ) 08/07/2022 06:26:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 08/07/2022 06:26:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 08/07/2022 06:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '17' , '-17' , '4' , '3.0000' , '3' , '0' , '10' , '45.90' ) 08/07/2022 06:26:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 08/07/2022 06:26:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 08/07/2022 06:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '11' , '-11' , '4' , '3.0000' , '3' , '0' , '10' , '29.70' ) 08/07/2022 06:26:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 08/07/2022 06:26:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 08/07/2022 06:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '8' , '-8' , '4' , '3.0000' , '3' , '0' , '10' , '21.60' ) 08/07/2022 06:26:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 08/07/2022 06:26:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 08/07/2022 06:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '20' , '8.00' ) 08/07/2022 06:26:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 08/07/2022 06:26:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 08/07/2022 06:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59120' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '25' , '-25' , '4' , '3.4000' , '3.4' , '0' , '20' , '68.00' ) 08/07/2022 06:26:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 08/07/2022 06:26:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 08/07/2022 07:03:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 07:03:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2223' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.00' , '109.84' , NOW() , NOW() ) 08/07/2022 07:03:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59121' 08/07/2022 07:03:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '59121' 08/07/2022 07:03: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 ( '59121' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 08/07/2022 07:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14114' AND id_supplier = '' 08/07/2022 07:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14114' , '' , '1' ) 08/07/2022 07:03: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 ( '59121' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 08/07/2022 07:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 08/07/2022 07:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 08/07/2022 07:03: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 ( '59121' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 08/07/2022 07:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 08/07/2022 07:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 08/07/2022 07:03: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 ( '59121' , '8079' , 'POLO LIMITED EXTRA' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 08/07/2022 07:03:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8079' AND id_supplier = '' 08/07/2022 07:03:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8079' , '' , '1' ) 08/07/2022 07:10:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 07:10:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2224' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.60' , '54.59' , NOW() , NOW() ) 08/07/2022 07:10:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59122' 08/07/2022 07:10:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '59122' 08/07/2022 07:10:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59122' , '16188' , 'STOLA QUATTRO EVANGELISTI - PST009' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 08/07/2022 07:10:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16188' AND id_supplier = '' 08/07/2022 07:10:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16188' , '' , '1' ) 08/07/2022 07:10:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59122' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/07/2022 07:10:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18130' AND id_supplier = '' 08/07/2022 07:10:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18130' , '' , '1' ) 08/07/2022 07:10:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59122' , '19309' , 'CROCE ULIVO PRIMA COMUNIONE - 1328' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 08/07/2022 07:10:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19309' AND id_supplier = '' 08/07/2022 07:10:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19309' , '' , '1' ) 08/07/2022 07:10:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59122' , '19310' , 'SACCHETTO CON CORONCINA E SEGNALIBRO - 1315/K182' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 08/07/2022 07:10:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19310' AND id_supplier = '' 08/07/2022 07:10:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19310' , '' , '1' ) 08/07/2022 07:10:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59122' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 08/07/2022 07:10:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 08/07/2022 07:10:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 08/07/2022 07:21:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 07:21:27 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' , '2225' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.40' , '48.69' , NOW() , NOW() ) 08/07/2022 07:21:27 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 = '59123' 08/07/2022 07:21:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '59123' 08/07/2022 07:21: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 ( '59123' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 08/07/2022 07:21:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 08/07/2022 07:21:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 08/07/2022 07:21: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 ( '59123' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 08/07/2022 07:21:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17276' AND id_supplier = '' 08/07/2022 07:21:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17276' , '' , '1' ) 08/07/2022 07:21: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 ( '59123' , '18220' , 'CATENA CON CROCE - NS020' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 08/07/2022 07:21:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18220' AND id_supplier = '' 08/07/2022 07:21:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18220' , '' , '1' ) 08/07/2022 07:21: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 ( '59123' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 08/07/2022 07:21:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 08/07/2022 07:21:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 08/07/2022 07:21: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 ( '59123' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '3.70' ) 08/07/2022 07:21:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 08/07/2022 07:21:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 08/07/2022 07:32:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2128' AND id_document != '58998' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-01') 08/07/2022 07:32:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2128', document_date = '2022-07-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 = '144.00', price_tax_excluded = '118.03', date_upd = NOW() WHERE id_document = '58998' 08/07/2022 07:32:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58998' 08/07/2022 07:32:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58998' 08/07/2022 07:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58998' , '16456' , 'CINGOLO - CING03' , '8' , '-8' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '108.00' ) 08/07/2022 07:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 08/07/2022 07:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 08/07/2022 07:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58998' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/07/2022 07:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 08/07/2022 07:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 08/07/2022 07:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58998' , '10462' , 'TAVOLETTA IN LEGNO 30X40 - MISERICORDIOSO - 1283/G0001' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 08/07/2022 07:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10462' AND id_supplier = '' 08/07/2022 07:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10462' , '' , '1' ) 08/07/2022 07:45:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2129' AND id_document != '58999' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-01') 08/07/2022 07:45:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2129', document_date = '2022-07-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 = '64.00', price_tax_excluded = '52.46', date_upd = NOW() WHERE id_document = '58999' 08/07/2022 07:45:50 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 = '58999' 08/07/2022 07:45:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58999' 08/07/2022 07:45:50 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 ( '58999' , '5536' , 'LACCIO' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 08/07/2022 07:45:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5536' AND id_supplier = '' 08/07/2022 07:45:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5536' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '6345' , 'MEDAGLIA S. BENEDETTO MET. DOR. SMALT. 3,2 - Q2006-D' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6345' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6345' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19128' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19128' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '19150' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '19106' , 'FRAGRANZA NARDO' , '2' , '-2' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '31.80' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6304' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6304' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 08/07/2022 07:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58999' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 08/07/2022 07:45:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 08/07/2022 07:45:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 08/07/2022 07:46:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2128' AND id_document != '58998' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-01') 08/07/2022 07:46:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2128', document_date = '2022-07-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 = '144.00', price_tax_excluded = '118.03', date_upd = NOW() WHERE id_document = '58998' 08/07/2022 07:46:05 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 = '58998' 08/07/2022 07:46:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '58998' 08/07/2022 07:46:05 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 ( '58998' , '16456' , 'CINGOLO - CING03' , '8' , '-8' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '108.00' ) 08/07/2022 07:46:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 08/07/2022 07:46:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 08/07/2022 07:46:05 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 ( '58998' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/07/2022 07:46:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 08/07/2022 07:46:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 08/07/2022 07:46:05 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 ( '58998' , '10462' , 'TAVOLETTA IN LEGNO 30X40 - MISERICORDIOSO - 1283/G0001' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 08/07/2022 07:46:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10462' AND id_supplier = '' 08/07/2022 07:46:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10462' , '' , '1' ) 08/07/2022 07:57:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-08') 08/07/2022 07:57: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' , '2226' , '2022-07-08' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.40' , '43.77' , NOW() , NOW() ) 08/07/2022 07:57: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 = '59124' 08/07/2022 07:57:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59124' 08/07/2022 07:57: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 ( '59124' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '29.40' ) 08/07/2022 07:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 08/07/2022 07:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 08/07/2022 07:57: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 ( '59124' , '11389' , 'VINO ROSSO DOLCE - 103' , '3' , '-3' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '24.00' ) 08/07/2022 07:57:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 08/07/2022 07:57:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' )