21/05/2024 08:49:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 21/05/2024 08:49:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22554' , '1' , '' , 'nuovo-prodotto' ) 21/05/2024 08:49:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22554' , '1' , '1' , '2' , NOW() , NOW() ) 21/05/2024 08:49:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22554' , '0' , '1' , '0' , '0' ) 21/05/2024 08:50:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049278' AND id_product != '22554' AND ean13 != '' 21/05/2024 08:50:16 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788884049278', date_upd = NOW() WHERE id_product = '22554' 21/05/2024 08:50:16 am >> UPDATE ps_product_lang SET name = 'MERAVIGLIOSA VITA DI SANTA RITA RACCONTATA AI BAMBINI - 8599', description = '' WHERE id_product = '22554' 21/05/2024 08:50:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '22554' 21/05/2024 08:50:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22554' 21/05/2024 08:50:16 am >> DELETE FROM ps_specific_price WHERE id_product = '22554' 21/05/2024 08:50:32 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 = '22554' 21/05/2024 08:50:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22555' , '1' , '' , 'nuovo-prodotto' ) 21/05/2024 08:50:32 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 '22555' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22554' 21/05/2024 08:50:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22555' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22554' 21/05/2024 08:51:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049568' AND id_product != '22555' AND ean13 != '' 21/05/2024 08:51:22 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884049568', date_upd = NOW() WHERE id_product = '22555' 21/05/2024 08:51:22 am >> UPDATE ps_product_lang SET name = 'RITA DA CASCIA - 8658', description = '' WHERE id_product = '22555' 21/05/2024 08:51:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22555' 21/05/2024 08:51:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22555' 21/05/2024 08:51:22 am >> DELETE FROM ps_specific_price WHERE id_product = '22555' 21/05/2024 08:51:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '7831/00/2024' , '2024-05-17' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '400.20' , '400.20' , NOW() , NOW() ) 21/05/2024 08:51: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 = '91923' 21/05/2024 08:51:36 am >> DELETE FROM ps_document_detail WHERE id_document = '91923' 21/05/2024 08:51: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 ( '91923' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '130' , '130' , '4' , '5.00' , '5' , '0' , '40' , '390.0000' ) 21/05/2024 08:51:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22414' AND id_supplier = '38' 21/05/2024 08:51:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22414' , '38' , '1' ) 21/05/2024 08:51: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 ( '91923' , '22554' , 'MERAVIGLIOSA VITA DI SANTA RITA RACCONTATA AI BAMBINI - 8599' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 21/05/2024 08:51:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22554' AND id_supplier = '38' 21/05/2024 08:51:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22554' , '38' , '1' ) 21/05/2024 08:51: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 ( '91923' , '22555' , 'RITA DA CASCIA - 8658' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 21/05/2024 08:51:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22555' AND id_supplier = '38' 21/05/2024 08:51:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22555' , '38' , '1' ) 21/05/2024 10:08:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831106511' AND id_product != '15211' AND ean13 != '' 21/05/2024 10:08:29 am >> UPDATE ps_product SET id_supplier = '109', reference = '7/1', ean13 = '9788831106511', date_upd = NOW() WHERE id_product = '15211' 21/05/2024 10:08:29 am >> UPDATE ps_product_lang SET name = 'SOMMA DI TEOLOGIA - 2', description = '' WHERE id_product = '15211' 21/05/2024 10:08:29 am >> UPDATE ps_product SET wholesale_price = '27.30', on_sale = '0', price = '46' WHERE id_product = '15211' 21/05/2024 10:08:29 am >> UPDATE ps_product_shop SET wholesale_price = '27.30', price = '46', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15211' 21/05/2024 10:08:29 am >> DELETE FROM ps_specific_price WHERE id_product = '15211' 21/05/2024 10:09:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831106511' AND id_product != '15211' AND ean13 != '' 21/05/2024 10:09:49 am >> UPDATE ps_product SET id_supplier = '109', reference = '7/1', ean13 = '9788831106511', date_upd = NOW() WHERE id_product = '15211' 21/05/2024 10:09:49 am >> UPDATE ps_product_lang SET name = 'SOMMA DI TEOLOGIA - 2', description = '' WHERE id_product = '15211' 21/05/2024 10:09:49 am >> UPDATE ps_product SET wholesale_price = '27.30', on_sale = '0', price = '46' WHERE id_product = '15211' 21/05/2024 10:09:49 am >> UPDATE ps_product_shop SET wholesale_price = '27.30', price = '46', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '62', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15211' 21/05/2024 10:09:49 am >> DELETE FROM ps_specific_price WHERE id_product = '15211' 21/05/2024 10:16:44 am >> SELECT document_num FROM ps_document WHERE document_num = '60/A' AND id_document != '91773' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-13') 21/05/2024 10:16:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '60/A', document_date = '2024-05-13', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', 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 = '190.00', price_tax_excluded = '155.74', date_upd = NOW() WHERE id_document = '91773' 21/05/2024 10:16: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 = '91773' 21/05/2024 10:16:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91773' 21/05/2024 10:16: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 ( '91773' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 21/05/2024 10:16: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 ( '91773' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 21/05/2024 10:16: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 ( '91773' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 21/05/2024 10:57:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788889667453' AND id_product != '7831' AND ean13 != '' 21/05/2024 10:57:47 am >> UPDATE ps_product SET id_supplier = '177', reference = '1/5', ean13 = '9788889667453', date_upd = NOW() WHERE id_product = '7831' 21/05/2024 10:57:47 am >> UPDATE ps_product_lang SET name = 'PER LA VITA DEL MONDO', description = '' WHERE id_product = '7831' 21/05/2024 10:57:47 am >> UPDATE ps_product SET wholesale_price = '11.69', on_sale = '0', price = '16.0000' WHERE id_product = '7831' 21/05/2024 10:57:47 am >> UPDATE ps_product_shop SET wholesale_price = '11.69', price = '16.0000', id_tax_rules_group = '4', id_category_default = '249', id_argoment_default = '145', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7831' 21/05/2024 10:57:47 am >> DELETE FROM ps_specific_price WHERE id_product = '7831' 21/05/2024 11:16:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 11:16:33 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' , '1690' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 21/05/2024 11:16:33 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 = '91924' 21/05/2024 11:16:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91924' 21/05/2024 11:16:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91924' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 21/05/2024 11:22:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 11:22:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1691' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.74' , '31.74' , NOW() , NOW() ) 21/05/2024 11:22:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91925' 21/05/2024 11:22:28 am >> DELETE FROM ps_document_detail WHERE id_document = '91925' 21/05/2024 11:22:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91925' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 21/05/2024 11:22:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91925' , '22528' , 'DIARIO' , '1' , '-1' , '4' , '17.50' , '17.5' , '0' , '5' , '16.63' ) 21/05/2024 11:22:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91925' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/05/2024 11:32:48 am >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '89869' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-09') 21/05/2024 11:32:48 am >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2024-01-09', document_letter = 'A', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', 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 = '357.20', price_tax_excluded = '357.20', date_upd = NOW() WHERE id_document = '89869' 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89869' 21/05/2024 11:32:48 am >> DELETE FROM ps_document_detail WHERE id_document = '89869' 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '15294' , 'BENEDIZIONI - RISURREZIONE B' , '200' , '-200' , '4' , '0.1500' , '0.15' , '0' , '0' , '30.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '7753' , 'PECCATO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '4500' , 'GESÙ SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 21/05/2024 11:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '13129' , 'ESAME DI COSCIENZA SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 21/05/2024 11:32: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 ( '89869' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 21/05/2024 11:32: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 ( '89869' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 21/05/2024 11:32: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 ( '89869' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 21/05/2024 11:32: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 ( '89869' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 21/05/2024 11:32: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 ( '89869' , '0' , 'ritirati A CASA' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 21/05/2024 11:32: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 ( '89869' , '15020' , 'PREGARE OGNI GIORNO' , '100' , '-100' , '4' , '1.0000' , '1' , '0' , '15' , '85.00' ) 21/05/2024 11:32: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 ( '89869' , '0' , '20/4/24' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 21/05/2024 11:32: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 ( '89869' , '15020' , 'PREGARE OGNI GIORNO' , '100' , '-100' , '4' , '1.0000' , '1' , '0' , '15' , '85.00' ) 21/05/2024 12:25:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1692' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 12:25:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1692' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 21/05/2024 12:25:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91926' 21/05/2024 12:25:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91926' 21/05/2024 12:25: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 ( '91926' , '22535' , 'CARA GIULIA ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 21/05/2024 03:49:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 03:49:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1693' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 21/05/2024 03:49:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91927' 21/05/2024 03:49:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91927' 21/05/2024 03:49:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91927' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 21/05/2024 05:08:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 05:08:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1694' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.08' , NOW() , NOW() ) 21/05/2024 05:08:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91928' 21/05/2024 05:08:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91928' 21/05/2024 05:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91928' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 21/05/2024 05:11:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 05:11:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1695' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.00' , '54.10' , NOW() , NOW() ) 21/05/2024 05:11:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91929' 21/05/2024 05:11:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91929' 21/05/2024 05:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91929' , '7202' , 'ARTICOLI RELIGIOSI' , '11' , '-11' , '1' , '6' , '4.9180327868852' , '22' , '0' , '66.00' ) 21/05/2024 05:17:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 05:17:14 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' , '1696' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '18.20' , NOW() , NOW() ) 21/05/2024 05:17:14 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 = '91930' 21/05/2024 05:17:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91930' 21/05/2024 05:17:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91930' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/05/2024 05:17:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91930' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 21/05/2024 05:17:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91930' , '7986' , 'PICCOLA VITA DI SANTA RITA DA CASCIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 21/05/2024 05:17:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91930' , '13866' , 'IN PREGHIERA CON SANTA RITA ' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 21/05/2024 05:21:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 05:21:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1697' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 21/05/2024 05:21:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91931' 21/05/2024 05:21:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91931' 21/05/2024 05:21:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91931' , '13996' , 'CORONA BIBLICA PER IL DONO DEI FIGLI - 8443' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 21/05/2024 07:12:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 07:12:59 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' , '1698' , '2024-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 21/05/2024 07:12:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91932' 21/05/2024 07:12:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91932' 21/05/2024 07:13:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91932' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 21/05/2024 07:58:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1695' AND id_document != '91929' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 21/05/2024 07:58:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1695', document_date = '2024-05-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 = '66.00', price_tax_excluded = '54.10', date_upd = NOW() WHERE id_document = '91929' 21/05/2024 07:58: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 = '91929' 21/05/2024 07:58:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91929' 21/05/2024 07:58: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 ( '91929' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '57' , '46.72131147541' , '22' , '0' , '57.00' ) 21/05/2024 07:58: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 ( '91929' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' )