02/12/2024 09:22:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3743' AND id_document != '94607' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 02/12/2024 09:22:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3743', document_date = '2024-11-30', 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.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '94607' 02/12/2024 09:22:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94607' 02/12/2024 09:22:21 am >> DELETE FROM ps_document_detail WHERE id_document = '94607' 02/12/2024 09:22:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94607' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 02/12/2024 09:22:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3749' AND id_document != '94613' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 02/12/2024 09:22:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3749', document_date = '2024-11-30', 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 = '368.60', price_tax_excluded = '305.94', date_upd = NOW() WHERE id_document = '94613' 02/12/2024 09:22: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 = '94613' 02/12/2024 09:22:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94613' 02/12/2024 09:22: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 ( '94613' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 02/12/2024 09:22: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 ( '94613' , '1616' , 'CANDELABRO MOD. 700 FINITURA ORO - CM 30 DM169R' , '2' , '-2' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '340.00' ) 02/12/2024 09:22: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 ( '94613' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 02/12/2024 09:22: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 ( '94613' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 02/12/2024 09:22: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 ( '94613' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/12/2024 09:22: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 ( '94613' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/12/2024 09:22: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 ( '94613' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/12/2024 09:22: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 ( '94613' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/12/2024 09:25:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/12/2024 09:25:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23276' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:25:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23276' , '1' , '1' , '2' , NOW() , NOW() ) 02/12/2024 09:25:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23276' , '0' , '1' , '0' , '0' ) 02/12/2024 09:25:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'MPTE33S00' AND id_product != '23276' AND ean13 != '' 02/12/2024 09:25:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'MPTE33S00', date_upd = NOW() WHERE id_product = '23276' 02/12/2024 09:25:47 am >> UPDATE ps_product_lang SET name = 'TELA POLIESTERE', description = '' WHERE id_product = '23276' 02/12/2024 09:25:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.245901639344263' WHERE id_product = '23276' 02/12/2024 09:25:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.245901639344263', id_tax_rules_group = '1', id_category_default = '440', 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 = '23276' 02/12/2024 09:25:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23276' 02/12/2024 09:25:49 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23276' 02/12/2024 09:25:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23277' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:25:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23277' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23276' 02/12/2024 09:25:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23277' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23276' 02/12/2024 09:26:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1002' , '2024-11-26' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.47' , '13.50' , NOW() , NOW() ) 02/12/2024 09:26:24 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 = '94614' 02/12/2024 09:26:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94614' 02/12/2024 09:26:24 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 ( '94614' , '23276' , 'TELA POLIESTERE' , '3' , '3' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '16.4700' ) 02/12/2024 09:26:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '23276' AND id_supplier = '122' 02/12/2024 09:26:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23276' , '122' , '1' ) 02/12/2024 09:26:56 am >> SELECT document_num FROM ps_document WHERE document_num = '127/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 09:26:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '127/A' , '2024-12-02' , 'A' , '3432' , '0' , '4670953' , 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '30.74' , NOW() , NOW() ) 02/12/2024 09:26:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94615' 02/12/2024 09:26:56 am >> DELETE FROM ps_document_detail WHERE id_document = '94615' 02/12/2024 09:26:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94615' , '23276' , 'TELA POLIESTERE' , '3' , '-3' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '37.50' ) 02/12/2024 09:31:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '578/1C2' , '2024-11-28' , '1C2' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '256.20' , '210.00' , NOW() , NOW() ) 02/12/2024 09:31:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94616' 02/12/2024 09:31:36 am >> DELETE FROM ps_document_detail WHERE id_document = '94616' 02/12/2024 09:36:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002294' AND id_product != '22778' AND ean13 != '' 02/12/2024 09:36:09 am >> UPDATE ps_product SET id_supplier = '187', reference = '', ean13 = '002294', date_upd = NOW() WHERE id_product = '22778' 02/12/2024 09:36:09 am >> UPDATE ps_product_lang SET name = 'CASULA - C2P856', description = '' WHERE id_product = '22778' 02/12/2024 09:36:09 am >> UPDATE ps_product SET wholesale_price = '151.00', on_sale = '0', price = '299.1803' WHERE id_product = '22778' 02/12/2024 09:36:09 am >> UPDATE ps_product_shop SET wholesale_price = '151.00', price = '299.1803', id_tax_rules_group = '1', id_category_default = '539', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22778' 02/12/2024 09:36:09 am >> DELETE FROM ps_specific_price WHERE id_product = '22778' 02/12/2024 09:41:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024010002210' , '2024-12-01' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '61.83' , '61.83' , NOW() , NOW() ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94617' 02/12/2024 09:41:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94617' 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '23193' , 'ACCOMPAGNARE NEL CAMMINO MATRIMONIALE ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23193' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23193' , '107' , '1' ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '35' , '4.55' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '22995' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22995' , '107' , '1' ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '23269' , 'SIMOLISMO EUCARISTICO NELLAPOCALISSE - A. POMPILI' , '1' , '0' , '4' , '19.5000' , '19.5' , '0' , '35' , '12.68' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '23269' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23269' , '107' , '1' ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.0000' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '15515' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15515' , '107' , '1' ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '35' , '2.60' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '107' , '1' ) 02/12/2024 09:41:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94617' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '3.25' ) 02/12/2024 09:41:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '22998' AND id_supplier = '107' 02/12/2024 09:41:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22998' , '107' , '1' ) 02/12/2024 09:49:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281917101' AND id_product != '23277' AND ean13 != '' 02/12/2024 09:49:09 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9791281917101', date_upd = NOW() WHERE id_product = '23277' 02/12/2024 09:49:09 am >> UPDATE ps_product_lang SET name = 'GESU\' - G. VIGINI', description = '' WHERE id_product = '23277' 02/12/2024 09:49:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '23277' 02/12/2024 09:49:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '483', 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 = '23277' 02/12/2024 09:49:09 am >> DELETE FROM ps_specific_price WHERE id_product = '23277' 02/12/2024 09:49:10 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23277' 02/12/2024 09:49:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23278' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:49:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23278' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23277' 02/12/2024 09:49:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23278' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23277' 02/12/2024 09:49:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245969' AND id_product != '23278' AND ean13 != '' 02/12/2024 09:49:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892245969', date_upd = NOW() WHERE id_product = '23278' 02/12/2024 09:49:50 am >> UPDATE ps_product_lang SET name = 'AMEN - MAR 25', description = '' WHERE id_product = '23278' 02/12/2024 09:49:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '23278' 02/12/2024 09:49:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23278' 02/12/2024 09:49:50 am >> DELETE FROM ps_specific_price WHERE id_product = '23278' 02/12/2024 09:49:51 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23278' 02/12/2024 09:49:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23279' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:49:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23279' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23278' 02/12/2024 09:49:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23279' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23278' 02/12/2024 09:50:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245976' AND id_product != '23279' AND ean13 != '' 02/12/2024 09:50:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892245976', date_upd = NOW() WHERE id_product = '23279' 02/12/2024 09:50:32 am >> UPDATE ps_product_lang SET name = 'AMEN - APR 25', description = '' WHERE id_product = '23279' 02/12/2024 09:50:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '23279' 02/12/2024 09:50:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23279' 02/12/2024 09:50:32 am >> DELETE FROM ps_specific_price WHERE id_product = '23279' 02/12/2024 09:50:33 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23279' 02/12/2024 09:50:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23280' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:50:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23280' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23279' 02/12/2024 09:50:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23280' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23279' 02/12/2024 09:51:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557368' AND id_product != '23280' AND ean13 != '' 02/12/2024 09:51:51 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788831557368', date_upd = NOW() WHERE id_product = '23280' 02/12/2024 09:51:51 am >> UPDATE ps_product_lang SET name = 'ABC DEL PAPA\' - MARCEL/VINCENTE', description = '' WHERE id_product = '23280' 02/12/2024 09:51:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23280' 02/12/2024 09:51:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '27', 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 = '23280' 02/12/2024 09:51:51 am >> DELETE FROM ps_specific_price WHERE id_product = '23280' 02/12/2024 09:51:52 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23280' 02/12/2024 09:51:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23281' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:51:52 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23281' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23280' 02/12/2024 09:51:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23281' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23280' 02/12/2024 09:52:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571932' AND id_product != '23281' AND ean13 != '' 02/12/2024 09:52:39 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788867571932', date_upd = NOW() WHERE id_product = '23281' 02/12/2024 09:52:39 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME L\'ANNO LITURGICO', description = '' WHERE id_product = '23281' 02/12/2024 09:52:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '23281' 02/12/2024 09:52:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23281' 02/12/2024 09:52:39 am >> DELETE FROM ps_specific_price WHERE id_product = '23281' 02/12/2024 09:52:40 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23281' 02/12/2024 09:52:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23282' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:52:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23282' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23281' 02/12/2024 09:52:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23282' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23281' 02/12/2024 09:53:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244641' AND id_product != '23282' AND ean13 != '' 02/12/2024 09:53:41 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788892244641', date_upd = NOW() WHERE id_product = '23282' 02/12/2024 09:53:41 am >> UPDATE ps_product_lang SET name = 'CASTITA\' - E. VARDEN', description = '' WHERE id_product = '23282' 02/12/2024 09:53:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '23282' 02/12/2024 09:53:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23282' 02/12/2024 09:53:42 am >> DELETE FROM ps_specific_price WHERE id_product = '23282' 02/12/2024 09:53:42 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23282' 02/12/2024 09:53:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23283' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:53:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23283' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23282' 02/12/2024 09:53:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23283' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23282' 02/12/2024 09:54:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246096' AND id_product != '23283' AND ean13 != '' 02/12/2024 09:54:43 am >> UPDATE ps_product SET id_supplier = '', reference = '13/5', ean13 = '9788892246096', date_upd = NOW() WHERE id_product = '23283' 02/12/2024 09:54:43 am >> UPDATE ps_product_lang SET name = 'LIBRO DELLA VITA - M. ZAPPELLA', description = '' WHERE id_product = '23283' 02/12/2024 09:54:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23283' 02/12/2024 09:54:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23283' 02/12/2024 09:54:43 am >> DELETE FROM ps_specific_price WHERE id_product = '23283' 02/12/2024 09:54:44 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23283' 02/12/2024 09:54:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23284' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:54:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23284' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23283' 02/12/2024 09:54:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23284' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23283' 02/12/2024 09:55:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245297' AND id_product != '23284' AND ean13 != '' 02/12/2024 09:55:17 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788892245297', date_upd = NOW() WHERE id_product = '23284' 02/12/2024 09:55:17 am >> UPDATE ps_product_lang SET name = 'TUE PREGHIERE', description = '' WHERE id_product = '23284' 02/12/2024 09:55:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '23284' 02/12/2024 09:55:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23284' 02/12/2024 09:55:17 am >> DELETE FROM ps_specific_price WHERE id_product = '23284' 02/12/2024 09:55:18 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23284' 02/12/2024 09:55:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23285' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:55:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23285' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23284' 02/12/2024 09:55:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23285' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23284' 02/12/2024 09:56:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069402' AND id_product != '23285' AND ean13 != '' 02/12/2024 09:56:47 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788801069402', date_upd = NOW() WHERE id_product = '23285' 02/12/2024 09:56:47 am >> UPDATE ps_product_lang SET name = 'CHI E\' GESU\' - G. LAJOLO', description = '' WHERE id_product = '23285' 02/12/2024 09:56:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '23285' 02/12/2024 09:56:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23285' 02/12/2024 09:56:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23285' 02/12/2024 09:56:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23285' 02/12/2024 09:56:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23286' , '1' , '' , 'nuovo-prodotto' ) 02/12/2024 09:56:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23286' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23285' 02/12/2024 09:56:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23286' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23285' 02/12/2024 09:57:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '683428' , '2024-11-27' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.73' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '257.87' , '254.90' , NOW() , NOW() ) 02/12/2024 09:57:44 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 = '94618' 02/12/2024 09:57:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94618' 02/12/2024 09:57:44 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 ( '94618' , '23276' , 'TELA POLIESTERE' , '3' , '3' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '16.47' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23276' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23276' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23277' , 'GESU - G. VIGINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23277' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23277' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23278' , 'AMEN - MAR 25' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23278' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23278' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23278' , 'AMEN - MAR 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23278' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23278' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23279' , 'AMEN - APR 25' , '24' , '24' , '4' , '3.90' , '3.9' , '0' , '33' , '62.7120' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23279' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23279' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23279' , 'AMEN - APR 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '100' , '0.0000' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23279' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23279' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23280' , 'ABC DEL PAPA - MARCEL/VINCENTE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23280' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23280' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23281' , 'SCOPRIAMO INSIEME LANNO LITURGICO' , '3' , '3' , '4' , '4.90' , '4.9' , '0' , '30' , '10.2900' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23281' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23281' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23282' , 'CASTITA - E. VARDEN' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23282' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23282' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23283' , 'LIBRO DELLA VITA - M. ZAPPELLA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23283' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23283' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23284' , 'TUE PREGHIERE' , '5' , '5' , '4' , '2.90' , '2.9' , '0' , '33' , '9.7150' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23284' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23284' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23285' , 'CHI E GESU - G. LAJOLO' , '1' , '1' , '4' , '28.00' , '28' , '0' , '35' , '18.2000' ) 02/12/2024 09:57:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23285' AND id_supplier = '7' 02/12/2024 09:57:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23285' , '7' , '1' ) 02/12/2024 09:57:44 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 ( '94618' , '23196' , 'DILEXIT NOS' , '12' , '12' , '4' , '2.90' , '2.9' , '0' , '33' , '23.3160' ) 02/12/2024 09:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '23196' AND id_supplier = '7' 02/12/2024 09:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23196' , '7' , '1' ) 02/12/2024 09:57: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 ( '94618' , '23196' , 'DILEXIT NOS' , '1' , '1' , '4' , '2.90' , '2.9' , '0' , '100' , '0.0000' ) 02/12/2024 09:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '23196' AND id_supplier = '7' 02/12/2024 09:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23196' , '7' , '1' ) 02/12/2024 10:15:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3750' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 10:15:40 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' , '3750' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 02/12/2024 10:15:40 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 = '94619' 02/12/2024 10:15:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94619' 02/12/2024 10:15:40 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 ( '94619' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2024 10:15:40 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 ( '94619' , '19231' , 'CARD CARLO ACUTIS - RN93' , '38' , '-38' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '38.00' ) 02/12/2024 10:17:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3751' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 10:17:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3751' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 02/12/2024 10:17:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94620' 02/12/2024 10:17:05 am >> DELETE FROM ps_document_detail WHERE id_document = '94620' 02/12/2024 10:17:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94620' , '20195' , 'VANGELO E ATTI DEGLI APOSTOLI A CARATTERI GRANDI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 02/12/2024 10:17:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94620' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 02/12/2024 10:17:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94620' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 02/12/2024 10:37:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3752' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 10:37:07 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' , '3752' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 02/12/2024 10:37:07 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 = '94621' 02/12/2024 10:37:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94621' 02/12/2024 10:37:07 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 ( '94621' , '12744' , 'COPRILEGGIO MARIANO - 364/TP' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 02/12/2024 10:37:07 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 ( '94621' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 02/12/2024 10:38:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3753' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 10:38:49 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' , '3753' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '266.00' , '266.00' , NOW() , NOW() ) 02/12/2024 10:38:49 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 = '94622' 02/12/2024 10:38:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94622' 02/12/2024 10:38:49 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 ( '94622' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '20' , '-20' , '4' , '14.00' , '14' , '0' , '5' , '266.00' ) 02/12/2024 11:03:43 am >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 02/12/2024 11:03:43 am >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2024-11-14', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '752.72', price_tax_excluded = '735.41', date_upd = NOW() WHERE id_document = '94256' 02/12/2024 11:03:43 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 = '94256' 02/12/2024 11:03:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94256' 02/12/2024 11:03:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 02/12/2024 11:03:44 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 ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 02/12/2024 11:03:44 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 ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 02/12/2024 11:03:44 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 ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 02/12/2024 11:03:44 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 ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 02/12/2024 11:03:44 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 ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 02/12/2024 11:03:44 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 ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 02/12/2024 11:03:44 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 ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 02/12/2024 11:05:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3696' AND id_document != '94555' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 02/12/2024 11:05:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3696', document_date = '2024-11-28', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '94555' 02/12/2024 11:05:34 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 = '94555' 02/12/2024 11:05:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94555' 02/12/2024 11:05:34 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 ( '94555' , '23191' , 'GRUPPO NATIVITA CM 20 - PB17025' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 02/12/2024 11:05:34 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 ( '94555' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 02/12/2024 11:43:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '531/TP' AND id_product != '12292' AND ean13 != '' 02/12/2024 11:43:23 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '531/TP', date_upd = NOW() WHERE id_product = '12292' 02/12/2024 11:43:23 am >> UPDATE ps_product_lang SET name = 'CASULA 100% POLIESTERE', description = '' WHERE id_product = '12292' 02/12/2024 11:43:23 am >> UPDATE ps_product SET wholesale_price = '25.40', on_sale = '0', price = '57.3770' WHERE id_product = '12292' 02/12/2024 11:43:23 am >> UPDATE ps_product_shop SET wholesale_price = '25.40', price = '57.3770', id_tax_rules_group = '1', id_category_default = '396', 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 = '12292' 02/12/2024 11:43:23 am >> DELETE FROM ps_specific_price WHERE id_product = '12292' 02/12/2024 11:44:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3754' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 11:44:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3754' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 02/12/2024 11:44:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94623' 02/12/2024 11:44:15 am >> DELETE FROM ps_document_detail WHERE id_document = '94623' 02/12/2024 11:44:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94623' , '12292' , 'CASULA 100% POLIESTERE' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 02/12/2024 11:44:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94623' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 02/12/2024 11:46:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3755' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 11:46:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3755' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 02/12/2024 11:46:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94624' 02/12/2024 11:46:06 am >> DELETE FROM ps_document_detail WHERE id_document = '94624' 02/12/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94624' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 02/12/2024 11:59:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '342542' , '2024-11-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '420.00' , '420.00' , NOW() , NOW() ) 02/12/2024 11:59:18 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 = '94625' 02/12/2024 11:59:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94625' 02/12/2024 11:59:18 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 ( '94625' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '10' , '10' , '4' , '42.00' , '42' , '0' , '0' , '420.0000' ) 02/12/2024 11:59:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '23256' AND id_supplier = '109' 02/12/2024 11:59:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23256' , '109' , '1' ) 02/12/2024 12:27:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3756' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 12:27:05 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' , '3756' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 02/12/2024 12:27: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 = '94626' 02/12/2024 12:27:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94626' 02/12/2024 12:27: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 ( '94626' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2024 12:39:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3757' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 12:39:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3757' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '9.75' , NOW() , NOW() ) 02/12/2024 12:39:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94627' 02/12/2024 12:39:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94627' 02/12/2024 12:39: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 ( '94627' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 02/12/2024 12:39: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 ( '94627' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 02/12/2024 12:46:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3758' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 12:46:20 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' , '3758' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 02/12/2024 12:46:20 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 = '94628' 02/12/2024 12:46:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94628' 02/12/2024 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94628' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 02/12/2024 02:47:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '260' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 02:47:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '260' , '2024-12-02' , '' , '4060' , '0' , '4679391' , 'PIAZZA DONATORI DI SANGUE 1 37050 CA DEGLI OPPI DI OPPEANO ' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.25' , '19.25' , NOW() , NOW() ) 02/12/2024 02:47:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94629' 02/12/2024 02:47:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94629' 02/12/2024 02:47:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94629' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 02/12/2024 02:47:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '260' AND id_document != '94629' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 02:47:25 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '260', document_date = '2024-12-02', document_letter = '', id_customer = '4060', id_supplier = '', id_address = '4679391', address1 = 'PIAZZA DONATORI DI SANGUE 1 37050 CA DEGLI OPPI DI OPPEANO ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '19.25', price_tax_excluded = '19.25', date_upd = NOW() WHERE id_document = '94629' 02/12/2024 02:47: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 = '94629' 02/12/2024 02:47:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94629' 02/12/2024 02:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94629' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '801' , '2024-11-29' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '44' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '1389.70' , '1139.10' , NOW() , NOW() ) 02/12/2024 02:52:28 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 = '94630' 02/12/2024 02:52:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94630' 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20157' , 'ALBERO DI NATALE - MIX' , '209' , '0' , '1' , '0.8000' , '0.6557' , '22' , '0' , '203.98' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20157' , 'ALBERO DI NATALE - MIX' , '210' , '0' , '1' , '0.7000' , '0.5738' , '22' , '0' , '179.34' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '630' , '0' , '1' , '0.6500' , '0.5328' , '22' , '0' , '499.59' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '104' , '0' , '1' , '0.6000' , '0.4918' , '22' , '0' , '76.13' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20521' , 'ALBERO IN RESINA CON NATIVITA - 31/175 ' , '32' , '0' , '1' , '1.9000' , '1.5574' , '22' , '0' , '74.18' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20521' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20521' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '40' , '0' , '1' , '2.0000' , '1.6393' , '22' , '0' , '97.60' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20520' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20520' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '12' , '0' , '1' , '1.8000' , '1.4754' , '22' , '0' , '26.35' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20154' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20154' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '12' , '0' , '1' , '1.8000' , '1.4754' , '22' , '0' , '26.35' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20153' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20153' , '60' , '1' ) 02/12/2024 02:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94630' , '1312' , 'BRACCIALE DECINA' , '250' , '0' , '1' , '0.5000' , '0.4098' , '22' , '0' , '152.50' ) 02/12/2024 02:52:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '60' 02/12/2024 02:52:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '60' , '1' ) 02/12/2024 03:33:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3759' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 03:33:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3759' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 02/12/2024 03:33: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 = '94631' 02/12/2024 03:33:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94631' 02/12/2024 03:33: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 ( '94631' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 02/12/2024 03:33: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 ( '94631' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 02/12/2024 03:33: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 ( '94631' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 02/12/2024 03:33: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 ( '94631' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 02/12/2024 03:33: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 ( '94631' , '18130' , 'TAU GRANDE CM 4 - T9' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 02/12/2024 03:33: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 ( '94631' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 02/12/2024 03:36: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 ( '33' , '683594' , '2024-11-28' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.02' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.47' , '70.47' , NOW() , NOW() ) 02/12/2024 03:36: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 = '94632' 02/12/2024 03:36:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94632' 02/12/2024 03:36: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 ( '94632' , '12104' , 'MINISTERO ORDINATO - E. CASTELLUCCI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '30' , '18.2000' ) 02/12/2024 03:36:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12104' AND id_supplier = '7' 02/12/2024 03:36:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12104' , '7' , '1' ) 02/12/2024 03:36: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 ( '94632' , '22975' , 'VERGINITA DELLA MADRE DI GESU - S.M. PERRELLA' , '1' , '1' , '4' , '55.00' , '55' , '0' , '33' , '36.8500' ) 02/12/2024 03:36:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22975' AND id_supplier = '7' 02/12/2024 03:36:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22975' , '7' , '1' ) 02/12/2024 03:36: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 ( '94632' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 02/12/2024 03:36:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23247' AND id_supplier = '7' 02/12/2024 03:36:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23247' , '7' , '1' ) 02/12/2024 04:13:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001679' AND id_product != '18080' AND ean13 != '' 02/12/2024 04:13:02 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '001679', date_upd = NOW() WHERE id_product = '18080' 02/12/2024 04:13:02 pm >> UPDATE ps_product_lang SET name = 'BAMBINO DI PRAGA CM 25 - 311', description = '' WHERE id_product = '18080' 02/12/2024 04:13:02 pm >> UPDATE ps_product SET wholesale_price = '11.97', on_sale = '0', price = '26.2295' WHERE id_product = '18080' 02/12/2024 04:13:02 pm >> UPDATE ps_product_shop SET wholesale_price = '11.97', price = '26.2295', id_tax_rules_group = '1', id_category_default = '165', 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 = '18080' 02/12/2024 04:13:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '18080' 02/12/2024 04:40:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002241' AND id_product != '22253' AND ean13 != '' 02/12/2024 04:40:36 pm >> UPDATE ps_product SET id_supplier = '130', reference = '', ean13 = '002241', date_upd = NOW() WHERE id_product = '22253' 02/12/2024 04:40:36 pm >> UPDATE ps_product_lang SET name = 'SAN MICHELE CM 53 - PA510', description = '' WHERE id_product = '22253' 02/12/2024 04:40:36 pm >> UPDATE ps_product SET wholesale_price = '142.50', on_sale = '0', price = '300.0000' WHERE id_product = '22253' 02/12/2024 04:40:36 pm >> UPDATE ps_product_shop SET wholesale_price = '142.50', price = '300.0000', id_tax_rules_group = '1', id_category_default = '165', 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 = '22253' 02/12/2024 04:40:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '22253' 02/12/2024 04:46:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3760' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 04:46:33 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' , '3760' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '107.50' , '90.60' , NOW() , NOW() ) 02/12/2024 04:46:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94633' 02/12/2024 04:46:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94633' 02/12/2024 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94633' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/12/2024 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94633' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 02/12/2024 04:46:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94633' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 02/12/2024 05:21:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '93792' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-23') 02/12/2024 05:21:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2024-10-23', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '246.70', price_tax_excluded = '214.72', date_upd = NOW() WHERE id_document = '93792' 02/12/2024 05:21:40 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 = '93792' 02/12/2024 05:21:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93792' 02/12/2024 05:21:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/12/2024 05:21:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/12/2024 05:21:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '2168' , 'CLERGY BASIC - ML - B&P' , '2' , '-2' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '72.00' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '23082' , 'CAMICE REGLAN CERNIERA DAVANTI - CA01' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '0' , 'MAGLIA' , '1' , '-1' , '0' , '30.0000' , '30' , '0' , '0' , '30.00' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 02/12/2024 05:21:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93792' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 02/12/2024 05:29:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3699' AND id_document != '94558' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 02/12/2024 05:29:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3699', document_date = '2024-11-28', 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 = '33.00', price_tax_excluded = '27.05', date_upd = NOW() WHERE id_document = '94558' 02/12/2024 05:29: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 = '94558' 02/12/2024 05:29:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94558' 02/12/2024 05:29:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 02/12/2024 05:29:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.7' , '1.3934426229508' , '22' , '0' , '1.70' ) 02/12/2024 05:29:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 02/12/2024 05:29:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94558' , '23041' , 'CORONA SANTA RITA - 10944' , '1' , '-1' , '1' , '8.80' , '7.2131147540984' , '22' , '0' , '8.80' ) 02/12/2024 05:33:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3591' AND id_document != '94416' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 02/12/2024 05:33:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3591', document_date = '2024-11-21', 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 = '130.08', price_tax_excluded = '108.77', date_upd = NOW() WHERE id_document = '94416' 02/12/2024 05:33: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 = '94416' 02/12/2024 05:33:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '94416' 02/12/2024 05:33: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 ( '94416' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 02/12/2024 05:33: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 ( '94416' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 02/12/2024 05:33: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 ( '94416' , '23121' , 'AVVENTO 2024 GIORNO PER GIORNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/12/2024 05:33: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 ( '94416' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/12/2024 05:33: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 ( '94416' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.4' , '4.4262295081967' , '22' , '0' , '5.40' ) 02/12/2024 05:48:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3761' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 05:48:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3761' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 02/12/2024 05:48:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94634' 02/12/2024 05:48:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94634' 02/12/2024 05:48: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 ( '94634' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 02/12/2024 05:50: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 ( '32' , '6024241435' , '2024-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.21' , '17.21' , NOW() , NOW() ) 02/12/2024 05:50: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 = '94635' 02/12/2024 05:50:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94635' 02/12/2024 05:50: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 ( '94635' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '0' , '4' , '13.7' , '13.7' , '0' , '0' , '13.7000' ) 02/12/2024 05:50:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109' 02/12/2024 05:50:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' ) 02/12/2024 05:50: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 ( '94635' , '23237' , 'MARIA ALLALBA DELLOTTAVO GIORNO' , '1' , '0' , '4' , '3.51' , '3.51' , '0' , '0' , '3.5100' ) 02/12/2024 05:50:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23237' AND id_supplier = '109' 02/12/2024 05:50:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23237' , '109' , '1' ) 02/12/2024 05:54: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 ( '32' , '6024241436' , '2024-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.14' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '647.16' , '647.16' , NOW() , NOW() ) 02/12/2024 05:54: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 = '94636' 02/12/2024 05:54:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '94636' 02/12/2024 05:54: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 ( '94636' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '20' , '0' , '4' , '26.68' , '26.68' , '0' , '0' , '533.6000' ) 02/12/2024 05:54:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23256' AND id_supplier = '109' 02/12/2024 05:54:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23256' , '109' , '1' ) 02/12/2024 05:54: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 ( '94636' , '23258' , 'MARIA PORTA DEL CIELO' , '5' , '0' , '4' , '2.86' , '2.86' , '0' , '0' , '14.3000' ) 02/12/2024 05:54:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23258' AND id_supplier = '109' 02/12/2024 05:54:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23258' , '109' , '1' ) 02/12/2024 05:54: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 ( '94636' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '4' , '0' , '4' , '12.39' , '12.39' , '0' , '0' , '49.5600' ) 02/12/2024 05:54:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109' 02/12/2024 05:54:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' ) 02/12/2024 05:54: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 ( '94636' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '4' , '0' , '4' , '12.39' , '12.39' , '0' , '0' , '49.5600' ) 02/12/2024 05:54:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109' 02/12/2024 05:54:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' ) 02/12/2024 05:57: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 ( '32' , '6024241434' , '2024-12-02' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.64' , '81.64' , NOW() , NOW() ) 02/12/2024 05:57: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 = '94637' 02/12/2024 05:57:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94637' 02/12/2024 05:57: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 ( '94637' , '22862' , 'E LA TUA PARTE 1 - 6/8 ANNI' , '2' , '0' , '4' , '12.705' , '12.705' , '0' , '0' , '25.4100' ) 02/12/2024 05:57:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22862' AND id_supplier = '109' 02/12/2024 05:57:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22862' , '109' , '1' ) 02/12/2024 05:57: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 ( '94637' , '23234' , 'AGENDA MISSIONARIA 2025' , '1' , '0' , '4' , '9.72' , '9.72' , '0' , '0' , '9.7200' ) 02/12/2024 05:57:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23234' AND id_supplier = '109' 02/12/2024 05:57:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23234' , '109' , '1' ) 02/12/2024 05:57: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 ( '94637' , '21617' , 'SINFONIA DELLA PAROLA - F. MANNS' , '1' , '0' , '4' , '12.96' , '12.96' , '0' , '0' , '12.9600' ) 02/12/2024 05:57:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21617' AND id_supplier = '109' 02/12/2024 05:57:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21617' , '109' , '1' ) 02/12/2024 05:57: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 ( '94637' , '23236' , 'REGOLA DI SAN BENEDETTO' , '1' , '0' , '4' , '9.29' , '9.29' , '0' , '0' , '9.2900' ) 02/12/2024 05:57:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23236' AND id_supplier = '109' 02/12/2024 05:57:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23236' , '109' , '1' ) 02/12/2024 05:57: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 ( '94637' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' , '14.18' , '14.18' , '0' , '0' , '14.1800' ) 02/12/2024 05:57:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 02/12/2024 05:57:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 02/12/2024 05:57: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 ( '94637' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' , '10.08' , '10.08' , '0' , '0' , '10.0800' ) 02/12/2024 05:57:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 02/12/2024 05:57:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 02/12/2024 06:00:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6024241433' , '2024-11-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '682.47' , '682.47' , NOW() , NOW() ) 02/12/2024 06:00:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94638' 02/12/2024 06:00:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94638' 02/12/2024 06:00: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 ( '94638' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '0' , '4' , '16.75' , '16.75' , '0' , '0' , '16.7500' ) 02/12/2024 06:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23235' AND id_supplier = '109' 02/12/2024 06:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23235' , '109' , '1' ) 02/12/2024 06:00: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 ( '94638' , '23233' , 'AD THEOLOGIAM PROMOVENDAM' , '1' , '0' , '4' , '8.63' , '8.63' , '0' , '0' , '8.6300' ) 02/12/2024 06:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23233' AND id_supplier = '109' 02/12/2024 06:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23233' , '109' , '1' ) 02/12/2024 06:00: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 ( '94638' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '40' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '364.0000' ) 02/12/2024 06:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20085' AND id_supplier = '109' 02/12/2024 06:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20085' , '109' , '1' ) 02/12/2024 06:00: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 ( '94638' , '23257' , 'CON UN PIEDE IN PARADISO' , '35' , '0' , '4' , '7.7998' , '7.7998' , '0' , '0' , '272.9930' ) 02/12/2024 06:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23257' AND id_supplier = '109' 02/12/2024 06:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23257' , '109' , '1' ) 02/12/2024 06:00: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 ( '94638' , '23272' , 'BOTTA E RISPOSTA CON I GIOVANI... - M. BOTTA' , '2' , '0' , '4' , '10.05' , '10.05' , '0' , '0' , '20.1000' ) 02/12/2024 06:00:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23272' AND id_supplier = '109' 02/12/2024 06:00:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23272' , '109' , '1' ) 02/12/2024 06:13:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450343' AND id_product != '23264' AND ean13 != '' 02/12/2024 06:13:49 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/3', ean13 = '9791256450343', date_upd = NOW() WHERE id_product = '23264' 02/12/2024 06:13:49 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MIRACOLOSA CAMMINO ... - ', description = '' WHERE id_product = '23264' 02/12/2024 06:13:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0000' WHERE id_product = '23264' 02/12/2024 06:13:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '518', 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 = '23264' 02/12/2024 06:13:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '23264' 02/12/2024 06:14:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873672685' AND id_product != '17670' AND ean13 != '' 02/12/2024 06:14:02 pm >> UPDATE ps_product SET id_supplier = '107', reference = '13/3', ean13 = '9788873672685', date_upd = NOW() WHERE id_product = '17670' 02/12/2024 06:14:02 pm >> UPDATE ps_product_lang SET name = 'NOVENA ALLA BEATA VERGINE ', description = '' WHERE id_product = '17670' 02/12/2024 06:14:02 pm >> UPDATE ps_product SET wholesale_price = '1.95', on_sale = '0', price = '3.0000' WHERE id_product = '17670' 02/12/2024 06:14:02 pm >> UPDATE ps_product_shop SET wholesale_price = '1.95', price = '3.0000', id_tax_rules_group = '4', id_category_default = '380', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17670' 02/12/2024 06:14:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '17670' 02/12/2024 06:27:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3762' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 06:27: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' , '3762' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.53' , '20.53' , NOW() , NOW() ) 02/12/2024 06:27: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 = '94639' 02/12/2024 06:27:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '94639' 02/12/2024 06:27: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 ( '94639' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 02/12/2024 06:27: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 ( '94639' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 02/12/2024 06:36:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3763' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 06:36:37 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' , '3763' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.71' , '27.75' , NOW() , NOW() ) 02/12/2024 06:36:37 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 = '94640' 02/12/2024 06:36:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '94640' 02/12/2024 06:36: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 ( '94640' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/12/2024 06:36: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 ( '94640' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/12/2024 06:36: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 ( '94640' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 02/12/2024 06:38:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3764' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 06:38:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3764' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.76' , NOW() , NOW() ) 02/12/2024 06:38: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 = '94641' 02/12/2024 06:38:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94641' 02/12/2024 06:38: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 ( '94641' , '4525' , 'GIGLER COMPLETO - 248 ' , '2' , '-2' , '1' , '4' , '3.2786885245902' , '22' , '0' , '8.00' ) 02/12/2024 06:38: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 ( '94641' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 02/12/2024 06:38: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 ( '94641' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2024 06:38: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 ( '94641' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/12/2024 06:38: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 ( '94641' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '23.1' , '18.934426229508' , '22' , '0' , '23.10' ) 02/12/2024 06:38: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 ( '94641' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 02/12/2024 07:05:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3765' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 02/12/2024 07:05:20 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' , '3765' , '2024-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 02/12/2024 07:05:20 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 = '94642' 02/12/2024 07:05:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94642' 02/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94642' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/12/2024 07:26: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 ( '32' , '6224755644' , '2024-11-30' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.61' , '215.61' , NOW() , NOW() ) 02/12/2024 07:26: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 = '94643' 02/12/2024 07:26:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94643' 02/12/2024 07:26: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 ( '94643' , '23173' , 'NOSTALGIA DEL SANGUE' , '1' , '0' , '4' , '7.66' , '7.66' , '0' , '0' , '7.6600' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23173' AND id_supplier = '177' 02/12/2024 07:26:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23173' , '177' , '1' ) 02/12/2024 07:26: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 ( '94643' , '23174' , 'SERIAL KILLER' , '1' , '0' , '4' , '9.68' , '9.68' , '0' , '0' , '9.6800' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23174' AND id_supplier = '177' 02/12/2024 07:26:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23174' , '177' , '1' ) 02/12/2024 07:26: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 ( '94643' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '3' , '0' , '4' , '13.09' , '13.09' , '0' , '0' , '39.2700' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23006' AND id_supplier = '177' 02/12/2024 07:26:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23006' , '177' , '1' ) 02/12/2024 07:26: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 ( '94643' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '0' , '4' , '9.3' , '9.3' , '0' , '0' , '9.3000' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '177' 02/12/2024 07:26:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '177' , '1' ) 02/12/2024 07:26: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 ( '94643' , '23172' , 'CHI E DI SCENA - 15/18 ANNI' , '1' , '0' , '4' , '9.94' , '9.94' , '0' , '0' , '9.9400' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23172' AND id_supplier = '177' 02/12/2024 07:26:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23172' , '177' , '1' ) 02/12/2024 07:26: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 ( '94643' , '23171' , 'CODICE DELLANIMA - J. HILLMAN' , '1' , '0' , '4' , '10.07' , '10.07' , '0' , '0' , '10.0700' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23171' AND id_supplier = '177' 02/12/2024 07:26:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23171' , '177' , '1' ) 02/12/2024 07:26: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 ( '94643' , '23238' , 'MANIFESTO DEL CAMBIAMENTO - G. CACCAMO' , '3' , '0' , '4' , '17.1634' , '17.1634' , '0' , '0' , '51.4902' ) 02/12/2024 07:26:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23238' AND id_supplier = '177' 02/12/2024 07:26:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23238' , '177' , '1' ) 02/12/2024 07:26:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23239' , 'TU SEI AMATO - P. CURTAZ' , '1' , '0' , '4' , '14.75' , '14.75' , '0' , '0' , '14.7500' ) 02/12/2024 07:26:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23239' AND id_supplier = '177' 02/12/2024 07:26:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23239' , '177' , '1' ) 02/12/2024 07:26:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '0' , '4' , '13.26' , '13.26' , '0' , '0' , '13.2600' ) 02/12/2024 07:26:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23005' AND id_supplier = '177' 02/12/2024 07:26:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23005' , '177' , '1' ) 02/12/2024 07:26:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '3' , '0' , '4' , '0.8567' , '0.8567' , '0' , '' , '2.5701' ) 02/12/2024 07:26:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '177' 02/12/2024 07:26:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '177' , '1' ) 02/12/2024 07:26:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '4' , '0' , '4' , '11.905' , '11.905' , '0' , '0' , '47.6200' ) 02/12/2024 07:26:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23006' AND id_supplier = '177' 02/12/2024 07:26:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23006' , '177' , '1' ) 02/12/2024 07:36:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3732' AND id_document != '94596' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 02/12/2024 07:36:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3732', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '37.79', date_upd = NOW() WHERE id_document = '94596' 02/12/2024 07:36:20 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 = '94596' 02/12/2024 07:36:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94596' 02/12/2024 07:36:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94596' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 02/12/2024 07:36:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94596' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 02/12/2024 07:36:46 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '6024241434', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '81.64', price_tax_excluded = '81.64', date_upd = NOW() WHERE id_document = '94637' 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94637' 02/12/2024 07:36:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '94637' 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94637' , '22862' , 'E LA TUA PARTE 1 - 6/8 ANNI' , '2' , '0' , '4' , '12.7050' , '12.705' , '0' , '0' , '25.41' ) 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94637' , '23234' , 'AGENDA MISSIONARIA 2025' , '1' , '0' , '4' , '9.7200' , '9.72' , '0' , '0' , '9.72' ) 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94637' , '21617' , 'SINFONIA DELLA PAROLA - F. MANNS' , '1' , '0' , '4' , '12.9600' , '12.96' , '0' , '0' , '12.96' ) 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94637' , '23236' , 'REGOLA DI SAN BENEDETTO' , '1' , '0' , '4' , '9.2900' , '9.29' , '0' , '0' , '9.29' ) 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94637' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' , '14.1800' , '14.18' , '0' , '0' , '14.18' ) 02/12/2024 07:36:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94637' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' , '10.0800' , '10.08' , '0' , '0' , '10.08' ) 02/12/2024 07:40:33 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '6224755644', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679057', address1 = 'VIA G. VERDI 8 20057 ASSAGO', 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 = '287.99', price_tax_excluded = '287.99', date_upd = NOW() WHERE id_document = '94643' 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94643' 02/12/2024 07:40:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '94643' 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23173' , 'NOSTALGIA DEL SANGUE' , '1' , '0' , '4' , '7.6600' , '7.66' , '0' , '0' , '7.66' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23174' , 'SERIAL KILLER' , '1' , '0' , '4' , '9.6800' , '9.68' , '0' , '0' , '9.68' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '3' , '0' , '4' , '13.0900' , '13.09' , '0' , '0' , '39.27' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '0' , '4' , '9.3000' , '9.3' , '0' , '0' , '9.30' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23172' , 'CHI E DI SCENA - 15/18 ANNI' , '1' , '0' , '4' , '9.9400' , '9.94' , '0' , '0' , '9.94' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23171' , 'CODICE DELLANIMA - J. HILLMAN' , '1' , '0' , '4' , '10.0700' , '10.07' , '0' , '0' , '10.07' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23238' , 'MANIFESTO DEL CAMBIAMENTO - G. CACCAMO' , '3' , '0' , '4' , '17.1634' , '17.1634' , '0' , '0' , '51.49' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23239' , 'TU SEI AMATO - P. CURTAZ' , '1' , '0' , '4' , '14.7500' , '14.75' , '0' , '0' , '14.75' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '0' , '4' , '13.2600' , '13.26' , '0' , '0' , '13.26' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '14543' , 'CALENDARIO LITURGICO MARIANO 2025' , '3' , '0' , '4' , '0.8567' , '0.8567' , '0' , '' , '2.57' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '4' , '0' , '4' , '11.9050' , '11.905' , '0' , '0' , '47.62' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '2' , '0' , '4' , '13.74' , '13.74' , '0' , '0' , '27.4800' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '13249' , 'PICCOLO PRINCIPE' , '1' , '0' , '4' , '4.16' , '4.16' , '0' , '0' , '4.1600' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '2' , '0' , '4' , '11.98' , '11.98' , '0' , '0' , '23.9600' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '23112' , 'CONOSCI TE STESSO - C. AMIRANTE' , '1' , '0' , '4' , '9.09' , '9.09' , '0' , '0' , '9.0900' ) 02/12/2024 07:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94643' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '1' , '0' , '4' , '7.69' , '7.69' , '0' , '0' , '7.6900' )