05/12/2023 09:10:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3868' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 09:10: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' , '3868' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.00' , '58.20' , NOW() , NOW() ) 05/12/2023 09:10: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 = '89330' 05/12/2023 09:10:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89330' 05/12/2023 09:10: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 ( '89330' , '2168' , 'CLERGY BASIC - ML - B&P' , '2' , '-2' , '1' , '35.50' , '29.098360655738' , '22' , '0' , '71.00' ) 05/12/2023 09:10:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3869' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 09:10:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3869' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.40' , '116.09' , NOW() , NOW() ) 05/12/2023 09:10:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89331' 05/12/2023 09:10:45 am >> DELETE FROM ps_document_detail WHERE id_document = '89331' 05/12/2023 09:10: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 ( '89331' , '6283' , 'MASSIME ETERNE - 8362' , '10' , '-10' , '4' , '7.00' , '7' , '0' , '5' , '66.50' ) 05/12/2023 09:10: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 ( '89331' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/12/2023 09:10: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 ( '89331' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/12/2023 09:26:02 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '276' 05/12/2023 09:26:02 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '276' , '10' , '210' , 'PARR. S. BIAGIO' , '' , '' , 'P.ZZA DON GIUSTINO RUSSOLILLO' , '' , '84045' , 'ALTAVILLA SILENTINA' , 'DI POTO DIANA' , '' , '' , '' , '' , NOW() , NOW() ) 05/12/2023 09:26:02 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '276' 05/12/2023 09:26:31 am >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 09:26:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '309' , '2023-12-05' , '' , '276' , '0' , '4679211' , 'P.ZZA DON GIUSTINO RUSSOLILLO 84045 ALTAVILLA SILENTINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '142.80' , '142.80' , NOW() , NOW() ) 05/12/2023 09:26:32 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 = '89332' 05/12/2023 09:26:32 am >> DELETE FROM ps_document_detail WHERE id_document = '89332' 05/12/2023 09:26:32 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 ( '89332' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '60' , '-60' , '4' , '2.80' , '2.8' , '0' , '15' , '142.80' ) 05/12/2023 09:29:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3870' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 09:29:20 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' , '3870' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 05/12/2023 09:29:20 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 = '89333' 05/12/2023 09:29:20 am >> DELETE FROM ps_document_detail WHERE id_document = '89333' 05/12/2023 09:29:20 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 ( '89333' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 05/12/2023 09:30:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/12/2023 09:30:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21960' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 09:30:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21960' , '1' , '1' , '2' , NOW() , NOW() ) 05/12/2023 09:30:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21960' , '0' , '1' , '0' , '0' ) 05/12/2023 09:31:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3870' AND id_document != '89333' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 09:31:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3870', document_date = '2023-12-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.00', price_tax_excluded = '16.00', date_upd = NOW() WHERE id_document = '89333' 05/12/2023 09:31:30 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 = '89333' 05/12/2023 09:31:31 am >> DELETE FROM ps_document_detail WHERE id_document = '89333' 05/12/2023 09:31:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89333' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 05/12/2023 10:07:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3871' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 10:07: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' , '3871' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.80' , '29.34' , NOW() , NOW() ) 05/12/2023 10:07: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 = '89334' 05/12/2023 10:07:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89334' 05/12/2023 10:07: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 ( '89334' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 05/12/2023 10:16:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3872' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 10:16:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3872' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.20' , '16.63' , NOW() , NOW() ) 05/12/2023 10:16:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89335' 05/12/2023 10:16:11 am >> DELETE FROM ps_document_detail WHERE id_document = '89335' 05/12/2023 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89335' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 05/12/2023 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89335' , '14835' , 'STELLA COMETA - P581' , '2' , '-2' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '4.80' ) 05/12/2023 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89335' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 05/12/2023 10:16:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89335' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 05/12/2023 10:24:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845913044' AND id_product != '21960' AND ean13 != '' 05/12/2023 10:24:43 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845913044', date_upd = NOW() WHERE id_product = '21960' 05/12/2023 10:24:43 am >> UPDATE ps_product_lang SET name = 'INTERVISTE IMPOSSIBILI', description = '' WHERE id_product = '21960' 05/12/2023 10:24:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21960' 05/12/2023 10:24:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '463', 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 = '21960' 05/12/2023 10:24:43 am >> DELETE FROM ps_specific_price WHERE id_product = '21960' 05/12/2023 10:24: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 = '21960' 05/12/2023 10:24:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21961' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:24: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 '21961' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21960' 05/12/2023 10:24:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21961' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21960' 05/12/2023 10:25:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845916861' AND id_product != '21961' AND ean13 != '' 05/12/2023 10:25:09 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845916861', date_upd = NOW() WHERE id_product = '21961' 05/12/2023 10:25:09 am >> UPDATE ps_product_lang SET name = 'DIARIO DEGLI ERRORI', description = '' WHERE id_product = '21961' 05/12/2023 10:25:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21961' 05/12/2023 10:25:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '463', 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 = '21961' 05/12/2023 10:25:09 am >> DELETE FROM ps_specific_price WHERE id_product = '21961' 05/12/2023 10:25: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 = '21961' 05/12/2023 10:25:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21962' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:25: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 '21962' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21961' 05/12/2023 10:25:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21962' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21961' 05/12/2023 10:25:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807884092' AND id_product != '21962' AND ean13 != '' 05/12/2023 10:25:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807884092', date_upd = NOW() WHERE id_product = '21962' 05/12/2023 10:25:37 am >> UPDATE ps_product_lang SET name = 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO', description = '' WHERE id_product = '21962' 05/12/2023 10:25:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21962' 05/12/2023 10:25:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '463', 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 = '21962' 05/12/2023 10:25:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21962' 05/12/2023 10:25:38 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 = '21962' 05/12/2023 10:25:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21963' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:25:38 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 '21963' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21962' 05/12/2023 10:25:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21963' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21962' 05/12/2023 10:26:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807171437' AND id_product != '21963' AND ean13 != '' 05/12/2023 10:26:10 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807171437', date_upd = NOW() WHERE id_product = '21963' 05/12/2023 10:26:10 am >> UPDATE ps_product_lang SET name = 'L\'OSPITE INQUIETANTE', description = '' WHERE id_product = '21963' 05/12/2023 10:26:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21963' 05/12/2023 10:26:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '359', 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 = '21963' 05/12/2023 10:26:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21963' 05/12/2023 10:26:11 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 = '21963' 05/12/2023 10:26:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21964' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:26:11 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 '21964' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21963' 05/12/2023 10:26:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21964' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21963' 05/12/2023 10:26:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842829829' AND id_product != '21964' AND ean13 != '' 05/12/2023 10:26:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842829829', date_upd = NOW() WHERE id_product = '21964' 05/12/2023 10:26:38 am >> UPDATE ps_product_lang SET name = 'NOTTE FEDELE E VIRTUOSA', description = '' WHERE id_product = '21964' 05/12/2023 10:26:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21964' 05/12/2023 10:26:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '459', 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 = '21964' 05/12/2023 10:26:38 am >> DELETE FROM ps_specific_price WHERE id_product = '21964' 05/12/2023 10:26:39 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 = '21964' 05/12/2023 10:26:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21965' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:26:39 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 '21965' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21964' 05/12/2023 10:26:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21965' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21964' 05/12/2023 10:31:59 am >> UPDATE ps_document SET id_document_type = '33', document_num = '32337577', document_date = '2023-11-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679195', address1 = 'VIALE DELLA NAVIGAZIONE INTERNA 89 35027 NOVENTA PADOVANA ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '89085' 05/12/2023 10:31:59 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 = '89085' 05/12/2023 10:31:59 am >> DELETE FROM ps_document_detail WHERE id_document = '89085' 05/12/2023 10:31:59 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 ( '89085' , '21899' , 'SACRA BIBBIA cei/uelci ' , '600' , '600' , '4' , '0.0000' , '0' , '0' , '0' , '0.0000' ) 05/12/2023 10:34:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807887987' AND id_product != '21965' AND ean13 != '' 05/12/2023 10:34:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807887987', date_upd = NOW() WHERE id_product = '21965' 05/12/2023 10:34:34 am >> UPDATE ps_product_lang SET name = 'SI STA FACENDO SEMPRE PIU\' TARDI', description = '' WHERE id_product = '21965' 05/12/2023 10:34:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '21965' 05/12/2023 10:34:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '359', 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 = '21965' 05/12/2023 10:34:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21965' 05/12/2023 10:34:35 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 = '21965' 05/12/2023 10:34:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21966' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:34:35 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 '21966' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21965' 05/12/2023 10:34:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21966' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21965' 05/12/2023 10:35:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807883965' AND id_product != '21966' AND ean13 != '' 05/12/2023 10:35:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807883965', date_upd = NOW() WHERE id_product = '21966' 05/12/2023 10:35:01 am >> UPDATE ps_product_lang SET name = 'LA CONDIZIONE POSTMODERNA', description = '' WHERE id_product = '21966' 05/12/2023 10:35:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21966' 05/12/2023 10:35:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '359', 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 = '21966' 05/12/2023 10:35:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21966' 05/12/2023 10:35:02 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 = '21966' 05/12/2023 10:35:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21967' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:35:02 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 '21967' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21966' 05/12/2023 10:35:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21967' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21966' 05/12/2023 10:35:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842097358' AND id_product != '21967' AND ean13 != '' 05/12/2023 10:35:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842097358', date_upd = NOW() WHERE id_product = '21967' 05/12/2023 10:35:34 am >> UPDATE ps_product_lang SET name = 'MODERNITA\' LIQUIDA', description = '' WHERE id_product = '21967' 05/12/2023 10:35:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21967' 05/12/2023 10:35:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '350', 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 = '21967' 05/12/2023 10:35:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21967' 05/12/2023 10:35:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842097358' AND id_product != '21967' AND ean13 != '' 05/12/2023 10:35:57 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842097358', date_upd = NOW() WHERE id_product = '21967' 05/12/2023 10:35:57 am >> UPDATE ps_product_lang SET name = 'MODERNITA\' LIQUIDA', description = '' WHERE id_product = '21967' 05/12/2023 10:35:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21967' 05/12/2023 10:35:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '350', 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 = '21967' 05/12/2023 10:35:57 am >> DELETE FROM ps_specific_price WHERE id_product = '21967' 05/12/2023 10:35:57 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21967' 05/12/2023 10:35:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21968' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:35:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21968' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21967' 05/12/2023 10:35:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21968' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21967' 05/12/2023 10:36:53 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 05/12/2023 10:36:53 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '534' , '1' ) 05/12/2023 10:36:53 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '534' , '2' ) 05/12/2023 10:36:53 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '534' , '3' ) 05/12/2023 10:36:53 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '534' , '1' , 'BALDINI CASTOLDI' , LOWER('BALDINI-CASTOLDI') ) 05/12/2023 10:36:53 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '534' , '1' , '0' ) 05/12/2023 10:37:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893880169' AND id_product != '21968' AND ean13 != '' 05/12/2023 10:37:02 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788893880169', date_upd = NOW() WHERE id_product = '21968' 05/12/2023 10:37:02 am >> UPDATE ps_product_lang SET name = 'LA SOCIETA\' DELLO SPETTACOLO', description = '' WHERE id_product = '21968' 05/12/2023 10:37:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21968' 05/12/2023 10:37:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '534', 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 = '21968' 05/12/2023 10:37:02 am >> DELETE FROM ps_specific_price WHERE id_product = '21968' 05/12/2023 10:37:04 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 = '21968' 05/12/2023 10:37:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21969' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:37:04 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 '21969' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21968' 05/12/2023 10:37:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21969' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21968' 05/12/2023 10:37:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885583559' AND id_product != '21969' AND ean13 != '' 05/12/2023 10:37:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788885583559', date_upd = NOW() WHERE id_product = '21969' 05/12/2023 10:37:28 am >> UPDATE ps_product_lang SET name = 'IO NON SONO UN POETA', description = '' WHERE id_product = '21969' 05/12/2023 10:37:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21969' 05/12/2023 10:37:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '531', 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 = '21969' 05/12/2023 10:37:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21969' 05/12/2023 10:37:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21969' 05/12/2023 10:37:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21970' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:37:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21970' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21969' 05/12/2023 10:37:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21970' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21969' 05/12/2023 10:38:42 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 05/12/2023 10:38:42 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '535' , '1' ) 05/12/2023 10:38:42 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '535' , '2' ) 05/12/2023 10:38:42 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '535' , '3' ) 05/12/2023 10:38:42 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '535' , '1' , 'BOLLATI BORINGHIERI' , LOWER('BOLLATI-BORINGHIERI') ) 05/12/2023 10:38:42 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '535' , '1' , '0' ) 05/12/2023 10:38:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788833937694' AND id_product != '21970' AND ean13 != '' 05/12/2023 10:38:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788833937694', date_upd = NOW() WHERE id_product = '21970' 05/12/2023 10:38:50 am >> UPDATE ps_product_lang SET name = 'TRA LE NOSTRE PAROLE', description = '' WHERE id_product = '21970' 05/12/2023 10:38:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '21970' 05/12/2023 10:38:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '535', 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 = '21970' 05/12/2023 10:38:50 am >> DELETE FROM ps_specific_price WHERE id_product = '21970' 05/12/2023 10:38: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 = '21970' 05/12/2023 10:38:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21971' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:38: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 '21971' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21970' 05/12/2023 10:38:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21971' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21970' 05/12/2023 10:39:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845934902' AND id_product != '21971' AND ean13 != '' 05/12/2023 10:39:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845934902', date_upd = NOW() WHERE id_product = '21971' 05/12/2023 10:39:20 am >> UPDATE ps_product_lang SET name = 'COME ORDINARE UNA BIBLIOTECA', description = '' WHERE id_product = '21971' 05/12/2023 10:39:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21971' 05/12/2023 10:39:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '463', 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 = '21971' 05/12/2023 10:39:20 am >> DELETE FROM ps_specific_price WHERE id_product = '21971' 05/12/2023 10:39:21 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 = '21971' 05/12/2023 10:39:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21972' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:39:21 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 '21972' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21971' 05/12/2023 10:39:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21972' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21971' 05/12/2023 10:40:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845916540' AND id_product != '21972' AND ean13 != '' 05/12/2023 10:40:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845916540', date_upd = NOW() WHERE id_product = '21972' 05/12/2023 10:40:05 am >> UPDATE ps_product_lang SET name = 'AUTO DA FE\'', description = '' WHERE id_product = '21972' 05/12/2023 10:40:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21972' 05/12/2023 10:40:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '463', 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 = '21972' 05/12/2023 10:40:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21972' 05/12/2023 10:40:05 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 = '21972' 05/12/2023 10:40:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21973' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:40:05 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 '21973' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21972' 05/12/2023 10:40:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21973' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21972' 05/12/2023 10:40:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806170264' AND id_product != '21973' AND ean13 != '' 05/12/2023 10:40:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806170264', date_upd = NOW() WHERE id_product = '21973' 05/12/2023 10:40:30 am >> UPDATE ps_product_lang SET name = 'HOMO SACER', description = '' WHERE id_product = '21973' 05/12/2023 10:40:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21973' 05/12/2023 10:40:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '278', 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 = '21973' 05/12/2023 10:40:31 am >> DELETE FROM ps_specific_price WHERE id_product = '21973' 05/12/2023 10:40:31 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 = '21973' 05/12/2023 10:40:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21974' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:40:31 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 '21974' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21973' 05/12/2023 10:40:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21974' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21973' 05/12/2023 10:41:18 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 05/12/2023 10:41:18 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '536' , '1' ) 05/12/2023 10:41:18 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '536' , '2' ) 05/12/2023 10:41:18 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '536' , '3' ) 05/12/2023 10:41:18 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '536' , '1' , 'LA NAVE DI TESEO' , LOWER('LA-NAVE-DI-TESEO') ) 05/12/2023 10:41:18 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '536' , '1' , '0' ) 05/12/2023 10:41:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893442411' AND id_product != '21974' AND ean13 != '' 05/12/2023 10:41:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788893442411', date_upd = NOW() WHERE id_product = '21974' 05/12/2023 10:41:25 am >> UPDATE ps_product_lang SET name = 'FASCISMO ETERNO', description = '' WHERE id_product = '21974' 05/12/2023 10:41:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '21974' 05/12/2023 10:41:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '536', 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 = '21974' 05/12/2023 10:41:25 am >> DELETE FROM ps_specific_price WHERE id_product = '21974' 05/12/2023 10:41:26 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 = '21974' 05/12/2023 10:41:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21975' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:41:26 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 '21975' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21974' 05/12/2023 10:41:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21975' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21974' 05/12/2023 10:41:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842829775' AND id_product != '21975' AND ean13 != '' 05/12/2023 10:41:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842829775', date_upd = NOW() WHERE id_product = '21975' 05/12/2023 10:41:45 am >> UPDATE ps_product_lang SET name = 'ARARAT', description = '' WHERE id_product = '21975' 05/12/2023 10:41:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21975' 05/12/2023 10:41:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '459', 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 = '21975' 05/12/2023 10:41:45 am >> DELETE FROM ps_specific_price WHERE id_product = '21975' 05/12/2023 10:41:46 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 = '21975' 05/12/2023 10:41:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21976' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:41:46 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 '21976' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21975' 05/12/2023 10:41:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21976' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21975' 05/12/2023 10:42:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788811818946' AND id_product != '21976' AND ean13 != '' 05/12/2023 10:42:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788811818946', date_upd = NOW() WHERE id_product = '21976' 05/12/2023 10:42:20 am >> UPDATE ps_product_lang SET name = 'PRIMO CAFFE\' DELLA GIORNATA', description = '' WHERE id_product = '21976' 05/12/2023 10:42:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21976' 05/12/2023 10:42:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '337', 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 = '21976' 05/12/2023 10:42:20 am >> DELETE FROM ps_specific_price WHERE id_product = '21976' 05/12/2023 10:42:21 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 = '21976' 05/12/2023 10:42:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21977' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:42:21 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 '21977' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21976' 05/12/2023 10:42:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21977' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21976' 05/12/2023 10:42:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788811606413' AND id_product != '21977' AND ean13 != '' 05/12/2023 10:42:43 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788811606413', date_upd = NOW() WHERE id_product = '21977' 05/12/2023 10:42:43 am >> UPDATE ps_product_lang SET name = 'LE POESIE - ROSSELLI', description = '' WHERE id_product = '21977' 05/12/2023 10:42:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '21977' 05/12/2023 10:42:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '337', 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 = '21977' 05/12/2023 10:42:43 am >> DELETE FROM ps_specific_price WHERE id_product = '21977' 05/12/2023 10:42: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 = '21977' 05/12/2023 10:42:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21978' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:42: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 '21978' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21977' 05/12/2023 10:42:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21978' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21977' 05/12/2023 10:43:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788811811084' AND id_product != '21978' AND ean13 != '' 05/12/2023 10:43:09 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788811811084', date_upd = NOW() WHERE id_product = '21978' 05/12/2023 10:43:09 am >> UPDATE ps_product_lang SET name = 'TUTTE LE POESIE - CAPRONI', description = '' WHERE id_product = '21978' 05/12/2023 10:43:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '21978' 05/12/2023 10:43:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '337', 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 = '21978' 05/12/2023 10:43:09 am >> DELETE FROM ps_specific_price WHERE id_product = '21978' 05/12/2023 10:43:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21978' 05/12/2023 10:43:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21979' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:43:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21979' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21978' 05/12/2023 10:43:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21979' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21978' 05/12/2023 10:43:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788842829683' AND id_product != '21979' AND ean13 != '' 05/12/2023 10:43:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788842829683', date_upd = NOW() WHERE id_product = '21979' 05/12/2023 10:43:32 am >> UPDATE ps_product_lang SET name = 'IRIS SELVATICO', description = '' WHERE id_product = '21979' 05/12/2023 10:43:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21979' 05/12/2023 10:43:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '459', 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 = '21979' 05/12/2023 10:43:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21979' 05/12/2023 10:43: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 = '21979' 05/12/2023 10:43:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21980' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:43: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 '21980' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21979' 05/12/2023 10:43:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21980' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21979' 05/12/2023 10:44:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791221207521' AND id_product != '21980' AND ean13 != '' 05/12/2023 10:44:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791221207521', date_upd = NOW() WHERE id_product = '21980' 05/12/2023 10:44:05 am >> UPDATE ps_product_lang SET name = 'LA FINE DELLA STORIA E L\'ULTIMO UOMO', description = '' WHERE id_product = '21980' 05/12/2023 10:44:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.5' WHERE id_product = '21980' 05/12/2023 10:44:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.5', id_tax_rules_group = '4', id_category_default = '526', 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 = '21980' 05/12/2023 10:44:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21980' 05/12/2023 10:44:11 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 = '21980' 05/12/2023 10:44:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21981' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:44:11 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 '21981' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21980' 05/12/2023 10:44:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21981' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21980' 05/12/2023 10:45:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788874627912' AND id_product != '21981' AND ean13 != '' 05/12/2023 10:45:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788874627912', date_upd = NOW() WHERE id_product = '21981' 05/12/2023 10:45:20 am >> UPDATE ps_product_lang SET name = 'CHE COS\'E\' LA FILOSOFIA?', description = '' WHERE id_product = '21981' 05/12/2023 10:45:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21981' 05/12/2023 10:45:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '526', 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 = '21981' 05/12/2023 10:45:20 am >> DELETE FROM ps_specific_price WHERE id_product = '21981' 05/12/2023 10:45:24 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 = '21981' 05/12/2023 10:45:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21982' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:45:24 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 '21982' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21981' 05/12/2023 10:45:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21982' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21981' 05/12/2023 10:45:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845905858' AND id_product != '21982' AND ean13 != '' 05/12/2023 10:45:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845905858', date_upd = NOW() WHERE id_product = '21982' 05/12/2023 10:45:54 am >> UPDATE ps_product_lang SET name = 'COSCIENZA DELLE PAROLE', description = '' WHERE id_product = '21982' 05/12/2023 10:45:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '21982' 05/12/2023 10:45:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '463', 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 = '21982' 05/12/2023 10:45:54 am >> DELETE FROM ps_specific_price WHERE id_product = '21982' 05/12/2023 10:45:55 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 = '21982' 05/12/2023 10:45:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21983' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:45:55 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 '21983' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21982' 05/12/2023 10:45:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21983' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21982' 05/12/2023 10:46:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806238452' AND id_product != '21983' AND ean13 != '' 05/12/2023 10:46:32 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806238452', date_upd = NOW() WHERE id_product = '21983' 05/12/2023 10:46:32 am >> UPDATE ps_product_lang SET name = 'ORA D\'ARTE', description = '' WHERE id_product = '21983' 05/12/2023 10:46:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21983' 05/12/2023 10:46:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '278', 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 = '21983' 05/12/2023 10:46:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21983' 05/12/2023 10:46: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 = '21983' 05/12/2023 10:46:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21984' , '1' , '' , 'nuovo-prodotto' ) 05/12/2023 10:46: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 '21984' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21983' 05/12/2023 10:46:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21984' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21983' 05/12/2023 10:51:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788854523357' AND id_product != '21940' AND ean13 != '' 05/12/2023 10:51:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788854523357', date_upd = NOW() WHERE id_product = '21940' 05/12/2023 10:51:44 am >> UPDATE ps_product_lang SET name = 'CARO PIER PAOLO', description = '' WHERE id_product = '21940' 05/12/2023 10:51:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21940' 05/12/2023 10:51:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '532', 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 = '21940' 05/12/2023 10:51:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21940' 05/12/2023 10:53:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804764878' AND id_product != '21953' AND ean13 != '' 05/12/2023 10:53:31 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804764878', date_upd = NOW() WHERE id_product = '21953' 05/12/2023 10:53:31 am >> UPDATE ps_product_lang SET name = 'FA BENE O FA MALE?', description = '' WHERE id_product = '21953' 05/12/2023 10:53:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21953' 05/12/2023 10:53:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '46', 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 = '21953' 05/12/2023 10:53:31 am >> DELETE FROM ps_specific_price WHERE id_product = '21953' 05/12/2023 10:55:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3873' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 10:55: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 ( '11' , '3873' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.92' , NOW() , NOW() ) 05/12/2023 10:55: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 = '89336' 05/12/2023 10:55:24 am >> DELETE FROM ps_document_detail WHERE id_document = '89336' 05/12/2023 10:55: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 ( '89336' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/12/2023 10:56:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845911316' AND id_product != '21947' AND ean13 != '' 05/12/2023 10:56:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788845911316', date_upd = NOW() WHERE id_product = '21947' 05/12/2023 10:56:47 am >> UPDATE ps_product_lang SET name = 'IL GIOCO DEGLI OCCHI', description = '' WHERE id_product = '21947' 05/12/2023 10:56:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21947' 05/12/2023 10:56:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '463', 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 = '21947' 05/12/2023 10:56:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21947' 05/12/2023 11:03:19 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' , '1236048' , '2023-11-30' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '978.60' , '978.60' , NOW() , NOW() ) 05/12/2023 11:03:19 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 = '89337' 05/12/2023 11:03:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89337' 05/12/2023 11:03:19 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 ( '89337' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '7' , '7' , '4' , '16.90' , '16.9' , '0' , '0' , '118.3000' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21934' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21934' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '1' , '4' , '14.50' , '14.5' , '0' , '0' , '14.50' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21945' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21945' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21937' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21937' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21775' , 'AMORE VINCE - C. AMIRANTE' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21775' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21775' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21944' , 'APPUNTI 1942-1993' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21944' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21944' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21975' , 'ARARAT' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21975' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21975' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21972' , 'AUTO DA FE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21972' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21972' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21962' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21962' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21948' , 'BUCHI BIANCHI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21948' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21948' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21940' , 'CARO PIER PAOLO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21940' AND id_supplier = '177' 05/12/2023 11:03:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21940' , '177' , '1' ) 05/12/2023 11:03:19 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 ( '89337' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 05/12/2023 11:03:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21981' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21981' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21971' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21971' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21966' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21966' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '1' , '4' , '28.00' , '28' , '0' , '0' , '28.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21982' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21982' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21961' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21961' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '0' , '18.90' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21938' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21938' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21958' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21958' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21953' , 'FA BENE O FA MALE?' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21953' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21953' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21974' , 'FASCISMO ETERNO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21974' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21974' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21980' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21980' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '1' , '4' , '13' , '13' , '0' , '0' , '13.0000' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21947' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21947' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21949' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21949' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21939' , 'HOMO DEUS' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21939' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21939' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21960' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21960' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21969' , 'IO NON SONO UN POETA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21969' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21969' , '177' , '1' ) 05/12/2023 11:03:20 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 ( '89337' , '21979' , 'IRIS SELVATICO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 05/12/2023 11:03:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '21979' AND id_supplier = '177' 05/12/2023 11:03:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21979' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '1' , '4' , '15.50' , '15.5' , '0' , '0' , '15.50' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21956' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21956' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21936' , 'KITCHEN' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21936' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21936' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21943' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21943' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21935' , 'MARIGOLD E ROSE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21935' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21935' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21952' , 'METAFISICA CONCRETA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21952' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21952' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21967' , 'MODERNITA LIQUIDA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21967' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21967' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21964' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21964' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21983' , 'ORA DARTE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21983' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21983' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21963' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21963' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21699' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21699' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21977' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21977' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21912' , 'POETI ITALIANI' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21912' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21912' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21973' , 'HOMO SACER' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21973' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21973' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21976' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21976' , '177' , '1' ) 05/12/2023 11:03: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 ( '89337' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 05/12/2023 11:03:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '21954' AND id_supplier = '177' 05/12/2023 11:03:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21954' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21941' , 'SACRO MINORE' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21941' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21941' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21946' , 'SALUTZ 1984-1986' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21946' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21946' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21965' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21965' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21968' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21968' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21955' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21955' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21942' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21942' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21970' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21970' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21978' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21978' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21957' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21957' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21951' , 'VERSO IL PARADISO' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21951' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21951' , '177' , '1' ) 05/12/2023 11:03:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89337' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 05/12/2023 11:03:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21950' AND id_supplier = '177' 05/12/2023 11:03:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21950' , '177' , '1' ) 05/12/2023 11:05:14 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'NNdHbTzdIq5IrKnl' , NOW() , NOW() ) 05/12/2023 11:05:14 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4066' , '1' ) 05/12/2023 11:05:14 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4066' , '2' ) 05/12/2023 11:05:14 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4066' , '3' ) 05/12/2023 11:06:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4066' 05/12/2023 11:06:28 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4066' , '10' , '191' , '' , 'MORETTI' , 'MARTA ' , 'VIA PAROLA 10' , '' , '43015' , 'NOCETO' , '' , '' , '3492869086' , '' , '' , NOW() , NOW() ) 05/12/2023 11:06:28 am >> UPDATE ps_customer SET email = 'm_marta93@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4066' 05/12/2023 11:07:19 am >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 11:07:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '310' , '2023-12-05' , '' , '4066' , '0' , '4679212' , 'VIA PAROLA 10 43015 NOCETO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '34.26' , '34.26' , NOW() , NOW() ) 05/12/2023 11:07:19 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 = '89338' 05/12/2023 11:07:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89338' 05/12/2023 11:07:19 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 ( '89338' , '12253' , 'MIO LIBRO DI PREGHIERE' , '11' , '-11' , '4' , '2.80' , '2.8' , '0' , '5' , '29.26' ) 05/12/2023 11:21:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3874' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 11:21:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3874' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '32.00' , NOW() , NOW() ) 05/12/2023 11:21:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89339' 05/12/2023 11:21:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89339' 05/12/2023 11:21:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89339' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '32' , '32' , '0' , '0' , '32.00' ) 05/12/2023 11:27:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3875' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 11:27:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3875' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '98.08' , NOW() , NOW() ) 05/12/2023 11:27:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89340' 05/12/2023 11:27:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89340' 05/12/2023 11:27:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89340' , '16441' , 'PREGHIERE DEGLI OBLATI DI S. GIUSEPPE - 8633' , '5' , '-5' , '4' , '9.00' , '9' , '0' , '5' , '42.75' ) 05/12/2023 11:27:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89340' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 05/12/2023 11:27:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89340' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 05/12/2023 11:27:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89340' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '38.35' , '31.434426229508' , '22' , '0' , '38.35' ) 05/12/2023 12:21:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3876' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 12:21:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3876' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.33' , '3.33' , NOW() , NOW() ) 05/12/2023 12:21:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89341' 05/12/2023 12:21:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89341' 05/12/2023 12:21:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89341' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 05/12/2023 12:30:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3877' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 12:30:07 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' , '3877' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.60' , '106.08' , NOW() , NOW() ) 05/12/2023 12:30:07 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 = '89342' 05/12/2023 12:30:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89342' 05/12/2023 12:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89342' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 05/12/2023 12:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89342' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 05/12/2023 12:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89342' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/12/2023 12:30:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89342' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 05/12/2023 03:22:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '311' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 03:22:40 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' , '311' , '2023-12-05' , '' , '1207' , '0' , '4672082' , 'VIA SS. SALVATORE, 2 84080 CALVANICO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '238.43' , '238.43' , NOW() , NOW() ) 05/12/2023 03:22: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 = '89343' 05/12/2023 03:22:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '89343' 05/12/2023 03:22: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 ( '89343' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 05/12/2023 03:22: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 ( '89343' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 05/12/2023 03:22: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 ( '89343' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.4000' , '3.4' , '0' , '15' , '28.90' ) 05/12/2023 03:22: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 ( '89343' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 05/12/2023 03:22: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 ( '89343' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 05/12/2023 03:22: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 ( '89343' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 05/12/2023 03:22: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 ( '89343' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 05/12/2023 03:22: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 ( '89343' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '15' , '-15' , '4' , '2.4000' , '2.4' , '0' , '15' , '30.60' ) 05/12/2023 03:23:12 pm >> DELETE FROM ps_document WHERE id_document = '88650' 05/12/2023 03:23:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '88650' 05/12/2023 03:36:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3878' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 03:36:53 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' , '3878' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.86' , '97.97' , NOW() , NOW() ) 05/12/2023 03:36:53 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 = '89344' 05/12/2023 03:36:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89344' 05/12/2023 03:36:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89344' , '5823' , 'LIBRO DORO' , '35' , '-35' , '4' , '0.60' , '0.6' , '0' , '5' , '19.95' ) 05/12/2023 03:36:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89344' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 05/12/2023 03:36:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89344' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '12' , '12' , '0' , '0' , '60.00' ) 05/12/2023 03:36:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89344' , '21744' , 'GIOCA CON SAN FRANCESCO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 05/12/2023 03:44:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3879' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 03:44:40 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' , '3879' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.10' , '49.52' , NOW() , NOW() ) 05/12/2023 03:44: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 = '89345' 05/12/2023 03:44:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '89345' 05/12/2023 03:44: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 ( '89345' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 05/12/2023 03:44: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 ( '89345' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 05/12/2023 03:44: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 ( '89345' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/12/2023 03:44: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 ( '89345' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 05/12/2023 03:48:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 03:48: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' , '3880' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '17.13' , NOW() , NOW() ) 05/12/2023 03:48: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 = '89346' 05/12/2023 03:48:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89346' 05/12/2023 03:48: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 ( '89346' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/12/2023 03:48: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 ( '89346' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 05/12/2023 03:57:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '139/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 03:57: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 ( '24' , '139/A' , '2023-12-05' , 'A' , '206' , '0' , '4671015' , 'VIA N. BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '16.90' , NOW() , NOW() ) 05/12/2023 03:57: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 = '89347' 05/12/2023 03:57:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '89347' 05/12/2023 03:57: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 ( '89347' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 05/12/2023 04:04:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 04:04:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '33/S' , '2023-12-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO NOVEMBRE 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2050.25' , '2017.97' , NOW() , NOW() ) 05/12/2023 04:04:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13762' 05/12/2023 04:04:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '13762' 05/12/2023 04:04: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 ( '13762' , '2' , 'I miracoli da colorare. La nascita di Gesù' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/12/2023 04:04: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 ( '13762' , '17' , 'LA FEDE NELLO ZAINETTO' , '84' , '0' , '4' , '6.00' , '6' , '0' , '50' , '252.00' ) 05/12/2023 04:04: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 ( '13762' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/12/2023 04:04: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 ( '13762' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '7' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '6.30' ) 05/12/2023 04:04: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 ( '13762' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '53' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '39.75' ) 05/12/2023 04:04: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 ( '13762' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '29' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '36.25' ) 05/12/2023 04:04: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 ( '13762' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '33' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '41.25' ) 05/12/2023 04:04: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 ( '13762' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/12/2023 04:04: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 ( '13762' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '21' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '26.25' ) 05/12/2023 04:04: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 ( '13762' , '125' , 'MIE PREGHIERINE - N. E.' , '50' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '37.50' ) 05/12/2023 04:04: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 ( '13762' , '33' , '100 GIORNI CON LO SPIRITO' , '7' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '26.25' ) 05/12/2023 04:04: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 ( '13762' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2023 04:04: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 ( '13762' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '4.95' ) 05/12/2023 04:04: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 ( '13762' , '50' , 'PERDONAMI SIGNORE' , '22' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '27.50' ) 05/12/2023 04:04: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 ( '13762' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/12/2023 04:04: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 ( '13762' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '111' , '0' , '4' , '2.00' , '2' , '0' , '50' , '111.00' ) 05/12/2023 04:04: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 ( '13762' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '6' , '0' , '4' , '30.00' , '30' , '0' , '50' , '90.00' ) 05/12/2023 04:04: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 ( '13762' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 05/12/2023 04:04: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 ( '13762' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2023 04:04: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 ( '13762' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/12/2023 04:04: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 ( '13762' , '91' , 'I 10 COMANDAMENTI' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/12/2023 04:04: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 ( '13762' , '92' , 'LA PREGHIERA DEL ROSARIO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2023 04:04: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 ( '13762' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/12/2023 04:04: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 ( '13762' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '102' , 'LE BEATITUDINI N.EDIZ.' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '14' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '110' , 'SE MI AMI NON PIANGERE' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '111' , 'I NONNI SONO UN TESORO' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '0' , '4' , '4.00' , '4' , '0' , '50' , '2.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '123' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '153.75' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '31' , '0' , '4' , '3.00' , '3' , '0' , '50' , '46.50' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '54' , '0' , '4' , '18.00' , '18' , '0' , '50' , '486.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '138' , 'LA NASCITA DI GESU' , '168' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '210.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '139' , 'E NATO - n.e.' , '179' , '0' , '1' , '2.00' , '1.6393442622951' , '22' , '50' , '179.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '136' , 'ANGELO DI DIO N.E.' , '4' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '137' , 'AVVENTO' , '143' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '178.75' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '0' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 05/12/2023 04:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13762' , '126' , 'SACRAMENTO DEL PERDONO' , '19' , '0' , '4' , '2.00' , '2' , '0' , '50' , '19.00' ) 05/12/2023 04:07:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 04:07:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '34/S' , '2023-12-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA NOVEMBRE 2023' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.15' , '48.15' , NOW() , NOW() ) 05/12/2023 04:07:56 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 = '13763' 05/12/2023 04:07:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '13763' 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '13' , 'BUSSATE E VI SARÀ APERTO' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '15' , 'LA BIBBIA: GENESI ALBUM+FIGURINE' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '125' , 'MIE PREGHIERINE - N. E.' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '33' , '100 GIORNI CON LO SPIRITO' , '2' , '2' , '4' , '7.50' , '7.5' , '0' , '50' , '7.50' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '52' , 'Il Padre Nostro spiegato ai bambini' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '76' , 'LA BIBBIA: NUOVO TESTAMENTO' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '50' , '3.95' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '84' , 'LAVVENTO' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '85' , 'Il Buon Samaritano' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '86' , 'Il figliol prodigo' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/12/2023 04:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 05/12/2023 04:07:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/12/2023 04:07:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 05/12/2023 04:07:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13763' , '104' , 'TEMPO DI QUARESIMA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2023 04:15:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '57/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 04:15:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '57/E' , '2023-12-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '9661.10' , '9661.10' , NOW() , NOW() ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89348' 05/12/2023 04:15:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89348' 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '740' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '888.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '131' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '163.75' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '5446' , 'IO SONO CON VOI - GUIDA' , '6' , '0' , '4' , '8.00' , '8' , '0' , '50' , '24.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11183' , 'VENITE CON ME - GUIDA' , '8' , '0' , '4' , '8.00' , '8' , '0' , '50' , '32.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '5548' , 'LAMPADA AI MIEI PASSI - ANNO C' , '1' , '0' , '4' , '10.33' , '10.33' , '0' , '50' , '5.17' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '3' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '9.30' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '9675' , 'SARETE MIEI TESTIMONI' , '208' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '364.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8254' , 'PREGHIAMO CON MARIA' , '1' , '0' , '4' , '0.65' , '0.65' , '0' , '50' , '0.33' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1180' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1652.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '5458' , 'IO SONO CON VOI 2 PARTE' , '955' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1337.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11191' , 'VENITE CON ME 1 PARTE' , '635' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '889.00' ) 05/12/2023 04:15:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11192' , 'VENITE CON ME 2 PARTE' , '727' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1017.80' ) 05/12/2023 04:15: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 ( '89348' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '62' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '108.50' ) 05/12/2023 04:15: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 ( '89348' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '19' , '0' , '4' , '8.00' , '8' , '0' , '50' , '76.00' ) 05/12/2023 04:15: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 ( '89348' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '330' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '561.00' ) 05/12/2023 04:15: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 ( '89348' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/12/2023 04:15: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 ( '89348' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '14' , '0' , '4' , '5.00' , '5' , '0' , '50' , '35.00' ) 05/12/2023 04:15: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 ( '89348' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '12' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '20.40' ) 05/12/2023 04:15: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 ( '89348' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '10' , '0' , '4' , '5.00' , '5' , '0' , '50' , '25.00' ) 05/12/2023 04:15: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 ( '89348' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '12' , '0' , '4' , '8.00' , '8' , '0' , '50' , '48.00' ) 05/12/2023 04:15: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 ( '89348' , '6629' , 'MIA PREGHIERA' , '68' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '30.60' ) 05/12/2023 04:15: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 ( '89348' , '8408' , 'PRENDETE E MANGIATE' , '450' , '0' , '4' , '3.00' , '3' , '0' , '50' , '675.00' ) 05/12/2023 04:15: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 ( '89348' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '6' , '0' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 05/12/2023 04:15: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 ( '89348' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '13' , '0' , '4' , '5.00' , '5' , '0' , '50' , '32.50' ) 05/12/2023 04:15: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 ( '89348' , '4154' , 'FESTA DEL PERDONO' , '432' , '0' , '4' , '3.00' , '3' , '0' , '50' , '648.00' ) 05/12/2023 04:15: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 ( '89348' , '2679' , 'CONOSCERE GESU' , '549' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '960.75' ) 05/12/2023 04:15: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 ( '89348' , '2680' , 'CONOSCERE GESU - GUIDA' , '11' , '0' , '4' , '6.00' , '6' , '0' , '50' , '33.00' ) 05/12/2023 04:18:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 04:18: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' , '3881' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 05/12/2023 04:18: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 = '89349' 05/12/2023 04:18:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89349' 05/12/2023 04:18: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 ( '89349' , '19749' , 'INCENSO MATTHAEUS ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/12/2023 04:18: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 ( '89349' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/12/2023 04:29:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '57/E' AND id_document != '89348' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 04:29:51 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '57/E', document_date = '2023-12-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO NOVEMBRE 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '12354.00', price_tax_excluded = '12341.29', date_upd = NOW() WHERE id_document = '89348' 05/12/2023 04:29: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 = '89348' 05/12/2023 04:29:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89348' 05/12/2023 04:29: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 ( '89348' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '740' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '888.00' ) 05/12/2023 04:29: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 ( '89348' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '131' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '163.75' ) 05/12/2023 04:29: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 ( '89348' , '5446' , 'IO SONO CON VOI - GUIDA' , '6' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '24.00' ) 05/12/2023 04:29: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 ( '89348' , '11183' , 'VENITE CON ME - GUIDA' , '8' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '32.00' ) 05/12/2023 04:29: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 ( '89348' , '5548' , 'LAMPADA AI MIEI PASSI - ANNO C' , '1' , '0' , '4' , '10.3300' , '10.33' , '0' , '50' , '5.17' ) 05/12/2023 04:29: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 ( '89348' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '3' , '0' , '4' , '6.2000' , '6.2' , '0' , '50' , '9.30' ) 05/12/2023 04:29: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 ( '89348' , '9675' , 'SARETE MIEI TESTIMONI' , '208' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '364.00' ) 05/12/2023 04:29: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 ( '89348' , '8254' , 'PREGHIAMO CON MARIA' , '1' , '0' , '4' , '0.6500' , '0.65' , '0' , '50' , '0.33' ) 05/12/2023 04:29: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 ( '89348' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1180' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1652.00' ) 05/12/2023 04:29: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 ( '89348' , '5458' , 'IO SONO CON VOI 2 PARTE' , '955' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1337.00' ) 05/12/2023 04:29: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 ( '89348' , '11191' , 'VENITE CON ME 1 PARTE' , '635' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '889.00' ) 05/12/2023 04:29: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 ( '89348' , '11192' , 'VENITE CON ME 2 PARTE' , '727' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1017.80' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '62' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '108.50' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '19' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '76.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '330' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '561.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '14' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '35.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '12' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '20.40' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '10' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '25.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '12' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '48.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '6629' , 'MIA PREGHIERA' , '68' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '30.60' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8408' , 'PRENDETE E MANGIATE' , '450' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '675.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '6' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '15.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '13' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '32.50' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4154' , 'FESTA DEL PERDONO' , '432' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '648.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '2679' , 'CONOSCERE GESU' , '549' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '960.75' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '2680' , 'CONOSCERE GESU - GUIDA' , '11' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '33.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '46' , '0' , '4' , '5.00' , '5' , '0' , '50' , '115.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '9' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '38.25' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '18' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '14.40' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '10' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '8.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '7543' , 'PARABOLE DI GESÙ' , '15' , '0' , '4' , '3.00' , '3' , '0' , '50' , '22.50' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '9' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '15.75' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '55' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '96.25' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '35.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '2' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '1.60' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '12819' , 'REGISTRO DEL CATECHISTA ' , '141' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '70.50' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '12253' , 'MIO LIBRO DI PREGHIERE' , '13' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '18.20' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '69' , '0' , '4' , '6.00' , '6' , '0' , '50' , '207.00' ) 05/12/2023 04:29:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '13397' , 'MIO GESU' , '58' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '101.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '13956' , 'MIRACOLI DI GESU' , '14' , '0' , '4' , '3.00' , '3' , '0' , '50' , '21.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '14029' , 'ANGELO DI DIO' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '191' , '0' , '4' , '1.00' , '1' , '0' , '50' , '95.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '15019' , 'PREGHIAMO CON MARIA' , '3' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '1.20' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '15020' , 'PREGARE OGNI GIORNO' , '31' , '0' , '4' , '1.00' , '1' , '0' , '50' , '15.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '5' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '8.75' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '17257' , 'IO TI BATTEZZO ' , '20' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '18.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '243' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '230.85' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '30' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '37.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '16' , '0' , '4' , '2.00' , '2' , '0' , '50' , '16.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '4' , '0' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.00' , '7' , '0' , '50' , '14.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '2' , '0' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '5' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '11.25' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.00' , '35' , '0' , '50' , '17.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '38' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '47.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20719' , 'CORONA DELL’ADDOLORATA' , '9' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '8.10' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20721' , 'AVE MARIA - L. CALABRETTA' , '5' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '11.25' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '5' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '11.25' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20722' , 'SEMINATORI DI GIOIA' , '62' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '77.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '58' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '72.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '5' , '0' , '4' , '20.00' , '20' , '0' , '50' , '50.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '264' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '330.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '31' , '0' , '4' , '8.00' , '8' , '0' , '50' , '124.00' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '11' , '0' , '4' , '25.00' , '25' , '0' , '50' , '137.50' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '73' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '91.25' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '39' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '54.60' ) 05/12/2023 04:29:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89348' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '218' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '305.20' ) 05/12/2023 04:38:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 04:38: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 ( '25' , '58/E' , '2023-12-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA NOVEMBRE 2023' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '245.45' , '245.45' , NOW() , NOW() ) 05/12/2023 04:38: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 = '89350' 05/12/2023 04:38:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89350' 05/12/2023 04:38: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 ( '89350' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 05/12/2023 04:38: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 ( '89350' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 05/12/2023 04:38: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 ( '89350' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 05/12/2023 04:38: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 ( '89350' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 05/12/2023 04:38: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 ( '89350' , '6629' , 'MIA PREGHIERA' , '8' , '8' , '4' , '0.90' , '0.9' , '0' , '50' , '3.60' ) 05/12/2023 04:38: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 ( '89350' , '8408' , 'PRENDETE E MANGIATE' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/12/2023 04:38: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 ( '89350' , '4154' , 'FESTA DEL PERDONO' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '8' , '8' , '4' , '1.60' , '1.6' , '0' , '50' , '6.40' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '8' , '8' , '4' , '1.60' , '1.6' , '0' , '50' , '6.40' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '4' , '4' , '4' , '1.60' , '1.6' , '0' , '50' , '3.20' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '4' , '4' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '14030' , 'PADRE NOSTRO' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '14032' , 'AVE MARIA' , '7' , '7' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '14029' , 'ANGELO DI DIO' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '2' , '2' , '4' , '1.00' , '1' , '0' , '50' , '1.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '15019' , 'PREGHIAMO CON MARIA' , '3' , '3' , '4' , '0.80' , '0.8' , '0' , '50' , '1.20' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '3' , '3' , '4' , '1.00' , '1' , '0' , '50' , '1.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '16667' , 'VIA CRUCIS' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '50' , '0.95' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '9' , '9' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20721' , 'AVE MARIA - L. CALABRETTA' , '8' , '8' , '4' , '4.50' , '4.5' , '0' , '50' , '18.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '9' , '9' , '4' , '4.50' , '4.5' , '0' , '50' , '20.25' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20954' , 'TEMPO DELL’APOCALISSE ' , '3' , '3' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 05/12/2023 04:38:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89350' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/12/2023 04:47:41 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'siENY1wEa7KLfal8' , NOW() , NOW() ) 05/12/2023 04:47:41 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4067' , '1' ) 05/12/2023 04:47:41 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4067' , '2' ) 05/12/2023 04:47:41 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4067' , '3' ) 05/12/2023 05:39:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 05/12/2023 05:39:10 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' , '3882' , '2023-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.60' , '30.60' , NOW() , NOW() ) 05/12/2023 05:39:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89351' 05/12/2023 05:39:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89351' 05/12/2023 05:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89351' , '21809' , 'AMEN - GEN 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 05/12/2023 05:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89351' , '21810' , 'AMEN - FEB 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 05/12/2023 05:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89351' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/12/2023 06:33:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '23FP01163' , '2023-11-29' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '56.00' , NOW() , NOW() ) 05/12/2023 06: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 = '89352' 05/12/2023 06:33:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '89352' 05/12/2023 06: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 ( '89352' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '80' , '80' , '4' , '0.70' , '0.7' , '0' , '0' , '56.0000' ) 05/12/2023 06:33:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 05/12/2023 06:33:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' )