27/11/2024 09:20:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 09:20:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3664' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 27/11/2024 09:20:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94512' 27/11/2024 09:20:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94512' 27/11/2024 09:20:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94512' , '23194' , 'DILEXIT NOS - 8992' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 27/11/2024 09:24:44 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'UAI5nPymbGUQnmUI' , NOW() , NOW() ) 27/11/2024 09:24:44 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4147' , '1' ) 27/11/2024 09:24:44 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4147' , '2' ) 27/11/2024 09:24:44 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4147' , '3' ) 27/11/2024 09:25:36 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4147' 27/11/2024 09:25:36 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 ( '4147' , '10' , '147' , '' , 'IERARDI' , 'DON NICOLA' , 'VIA BELLAVISTA 1' , '' , '88060' , 'ARGUSTO' , '' , '' , '3319524728' , '' , '' , NOW() , NOW() ) 27/11/2024 09:25:36 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4147' 27/11/2024 09:28:04 am >> SELECT document_num FROM ps_document WHERE document_num = '257' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 09:28:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '257' , '2024-11-27' , '' , '4147' , '0' , '4679443' , 'VIA BELLAVISTA 1 88060 ARGUSTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '143.80' , '143.80' , NOW() , NOW() ) 27/11/2024 09:28:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94513' 27/11/2024 09:28:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94513' 27/11/2024 09:28:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 27/11/2024 09:28:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '0' , '41.90' , '41.9' , '' , '0' , '41.90' ) 27/11/2024 09:28:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94513' , '16657' , 'CLERGY DENIM - ML ' , '1' , '-1' , '0' , '62' , '62' , '' , '0' , '62.00' ) 27/11/2024 09:40:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '6219/00' , '2024-11-25' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'rientro' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '210.00' , '210.00' , NOW() , NOW() ) 27/11/2024 09:40: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 = '94514' 27/11/2024 09:40:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94514' 27/11/2024 09:40: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 ( '94514' , '23092' , 'SPERANZA CHE E\' IN NOI' , '70' , '70' , '4' , '3.00' , '3' , '0' , '0' , '210.0000' ) 27/11/2024 09:41:41 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/11/2024 09:41:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23269' , '1' , '' , 'nuovo-prodotto' ) 27/11/2024 09:41:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23269' , '1' , '1' , '2' , NOW() , NOW() ) 27/11/2024 09:41:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23269' , '0' , '1' , '0' , '0' ) 27/11/2024 09:42:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830819467' AND id_product != '23269' AND ean13 != '' 27/11/2024 09:42:25 am >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9788830819467', date_upd = NOW() WHERE id_product = '23269' 27/11/2024 09:42:25 am >> UPDATE ps_product_lang SET name = 'SIMOLISMO EUCARISTICO NELL\'APOCALISSE - A. POMPILI', description = '' WHERE id_product = '23269' 27/11/2024 09:42:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.5' WHERE id_product = '23269' 27/11/2024 09:42:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.5', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23269' 27/11/2024 09:42:25 am >> DELETE FROM ps_specific_price WHERE id_product = '23269' 27/11/2024 09:43:43 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' , '2024000006220' , '2024-11-25' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '45.18' , '45.18' , NOW() , NOW() ) 27/11/2024 09:43:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94515' 27/11/2024 09:43:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94515' 27/11/2024 09:43:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94515' , '23269' , 'SIMOLISMO EUCARISTICO NELLAPOCALISSE - A. POMPILI' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '35' , '12.6750' ) 27/11/2024 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '23269' AND id_supplier = '107' 27/11/2024 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23269' , '107' , '1' ) 27/11/2024 09:43:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94515' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '35' , '3.9000' ) 27/11/2024 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '15515' AND id_supplier = '107' 27/11/2024 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15515' , '107' , '1' ) 27/11/2024 09:43:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94515' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 27/11/2024 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 27/11/2024 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 27/11/2024 09:43:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94515' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '1' , '4' , '4.00' , '4' , '0' , '35' , '2.6000' ) 27/11/2024 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '107' 27/11/2024 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '107' , '1' ) 27/11/2024 09:43:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94515' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 27/11/2024 09:43:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22998' AND id_supplier = '107' 27/11/2024 09:43:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22998' , '107' , '1' ) 27/11/2024 09:59:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 09:59:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3665' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 27/11/2024 09:59:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94516' 27/11/2024 09:59:05 am >> DELETE FROM ps_document_detail WHERE id_document = '94516' 27/11/2024 09:59:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94516' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 27/11/2024 10:20:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 10:20: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' , '3666' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 27/11/2024 10:20: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 = '94517' 27/11/2024 10:20:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94517' 27/11/2024 10:20: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 ( '94517' , '21137' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 27/11/2024 10:20: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 ( '94517' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '22.50' ) 27/11/2024 10:34:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 10:34: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' , '3667' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '9.60' , NOW() , NOW() ) 27/11/2024 10:34: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 = '94518' 27/11/2024 10:34:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94518' 27/11/2024 10:34: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 ( '94518' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.04' , '0.04' , '0' , '0' , '9.60' ) 27/11/2024 10:35:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 10:35:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3668' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.20' , '64.38' , NOW() , NOW() ) 27/11/2024 10:35:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94519' 27/11/2024 10:35:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94519' 27/11/2024 10:35: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 ( '94519' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '200' , '-200' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '50.00' ) 27/11/2024 10:35: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 ( '94519' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/11/2024 10:35: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 ( '94519' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/11/2024 10:35: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 ( '94519' , '22118' , 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA' , '19' , '-19' , '4' , '0.80' , '0.8' , '0' , '0' , '15.20' ) 27/11/2024 10:40:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 10:40: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 ( '11' , '3669' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.50' , '86.48' , NOW() , NOW() ) 27/11/2024 10:40: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 = '94520' 27/11/2024 10:40:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94520' 27/11/2024 10:40: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 ( '94520' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 27/11/2024 10:40: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 ( '94520' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 27/11/2024 10:40: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 ( '94520' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 27/11/2024 10:49:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 10:49:41 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' , '3670' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.09' , '33.24' , NOW() , NOW() ) 27/11/2024 10:49:41 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 = '94521' 27/11/2024 10:49:41 am >> DELETE FROM ps_document_detail WHERE id_document = '94521' 27/11/2024 10:49:41 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 ( '94521' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 27/11/2024 10:49:41 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 ( '94521' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '20' , '-20' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '8.00' ) 27/11/2024 10:49:41 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 ( '94521' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '5' , '2.09' ) 27/11/2024 11:07:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:07:00 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' , '3671' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '249.68' , '229.34' , NOW() , NOW() ) 27/11/2024 11:07:00 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 = '94522' 27/11/2024 11:07:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94522' 27/11/2024 11:07:00 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 ( '94522' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '23.70' ) 27/11/2024 11:07:00 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 ( '94522' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 27/11/2024 11:07:00 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 ( '94522' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 27/11/2024 11:07:00 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 ( '94522' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2024 11:07:00 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 ( '94522' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/11/2024 11:07:00 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 ( '94522' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 27/11/2024 11:07:00 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 ( '94522' , '23198' , 'CINQUE MINUTI DELLO SPIRITO SANTO - V.M. FERNANDEZ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/11/2024 11:07:00 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 ( '94522' , '23016' , 'MISTICA DELLARATRO - A. ASCENSO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/11/2024 11:07:00 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 ( '94522' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 27/11/2024 11:07:00 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 ( '94522' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 27/11/2024 11:07:00 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 ( '94522' , '21788' , 'MADONNA DEL CARMINE CM 22 - 345' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 27/11/2024 11:07:00 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 ( '94522' , '11193' , 'VENITE CON ME CAT.' , '16' , '-16' , '4' , '5.50' , '5.5' , '0' , '5' , '83.68' ) 27/11/2024 11:08:00 am >> SELECT document_num FROM ps_document WHERE document_num = '258' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:08:00 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' , '258' , '2024-11-27' , '' , '4034' , '0' , '4679121' , 'P. ZZA SAN MARCO 84039 TEGGIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '98.60' , '98.60' , NOW() , NOW() ) 27/11/2024 11:08:00 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 = '94523' 27/11/2024 11:08:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94523' 27/11/2024 11:08:00 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 ( '94523' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 27/11/2024 11:08:00 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 ( '94523' , '4154' , 'FESTA DEL PERDONO' , '16' , '-16' , '4' , '3.00' , '3' , '0' , '15' , '40.80' ) 27/11/2024 11:08:00 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 ( '94523' , '8408' , 'PRENDETE E MANGIATE' , '16' , '-16' , '4' , '3.00' , '3' , '0' , '15' , '40.80' ) 27/11/2024 11:08:00 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 ( '94523' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 27/11/2024 11:12:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:12:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3672' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '12.20' , NOW() , NOW() ) 27/11/2024 11:12:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94524' 27/11/2024 11:12:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94524' 27/11/2024 11:12:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94524' , '23265' , 'ROSARIO E NOVENA A MARIA CHE SCIOGLIE I NODI ' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 27/11/2024 11:12:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94524' , '20936' , 'SANTA RITA - VITA BREVIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/11/2024 11:12:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94524' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 27/11/2024 11:12:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94524' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/11/2024 11:12:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94524' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 27/11/2024 11:14:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:14:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3673' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 27/11/2024 11:14:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94525' 27/11/2024 11:14:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94525' 27/11/2024 11:14:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94525' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 27/11/2024 11:27:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:27:25 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' , '3674' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 27/11/2024 11:27:25 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 = '94526' 27/11/2024 11:27:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94526' 27/11/2024 11:27:25 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 ( '94526' , '' , '' , '1' , '-1' , '4' , '0' , '0' , '0' , '0' , '0' ) 27/11/2024 11:29:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:29:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3675' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.46' , '129.41' , NOW() , NOW() ) 27/11/2024 11:29:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94527' 27/11/2024 11:29:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94527' 27/11/2024 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94527' , '15344' , 'IN ADORAZIONE - CATALINA RIVAS' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 27/11/2024 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94527' , '22944' , 'SUI TUOI PASSI - ADORAZIONE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 27/11/2024 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94527' , '23177' , 'CASULA MORELLO - C1P875' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 27/11/2024 11:47:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3428' AND id_document != '94191' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-11') 27/11/2024 11:47:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3428', document_date = '2024-11-11', 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 = '17.60', price_tax_excluded = '17.49', date_upd = NOW() WHERE id_document = '94191' 27/11/2024 11:47:47 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 = '94191' 27/11/2024 11:47:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94191' 27/11/2024 11:47:47 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 ( '94191' , '22382' , 'STORIA DI UNANIMA - TASC - 8603' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/11/2024 11:47:47 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 ( '94191' , '12904' , 'NOVENA DELLE ROSE A S. TERESA LISIEUX' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 27/11/2024 11:47:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94191' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 27/11/2024 11:47:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94191' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '3' , '-3' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.60' ) 27/11/2024 11:47:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94191' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 27/11/2024 11:55:13 am >> SELECT document_num FROM ps_document WHERE document_num = '259' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 11:55:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '259' , '2024-11-27' , '' , '3805' , '0' , '4672214' , 'VIA S. MARIA DELLE GRAZIE 84030 PERTOSA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '183.86' , '183.86' , NOW() , NOW() ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94528' 27/11/2024 11:55:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94528' 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '-3' , '4' , '3.40' , '3.4' , '0' , '15' , '8.67' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '4154' , 'FESTA DEL PERDONO' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '15' , '7.65' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '21530' , 'PRIMA COMUNIONE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 27/11/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94528' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 27/11/2024 12:13:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3675' AND id_document != '94527' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 12:13:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3675', document_date = '2024-11-27', 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 = '156.46', price_tax_excluded = '129.41', date_upd = NOW() WHERE id_document = '94527' 27/11/2024 12:13:58 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 = '94527' 27/11/2024 12:13:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94527' 27/11/2024 12:13:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94527' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '2.85' , '2.85' , '0' , '0' , '2.85' ) 27/11/2024 12:13:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94527' , '22944' , 'SUI TUOI PASSI - ADORAZIONE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 27/11/2024 12:13:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94527' , '23177' , 'CASULA MORELLO - C1P875' , '1' , '-1' , '1' , '150.0000' , '122.95081967213' , '22' , '0' , '150.00' ) 27/11/2024 12:19:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 12:19:31 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' , '3676' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.09' , '57.83' , NOW() , NOW() ) 27/11/2024 12:19:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94529' 27/11/2024 12:19:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94529' 27/11/2024 12:19: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 ( '94529' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 27/11/2024 12:19: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 ( '94529' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '5' , '2.09' ) 27/11/2024 12:19: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 ( '94529' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 27/11/2024 12:24:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 12:24:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3677' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 27/11/2024 12:24:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94530' 27/11/2024 12:24:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94530' 27/11/2024 12:24:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94530' , '18558' , 'SAN PIETRO BABY - 023 SP/ 9 BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/11/2024 12:24:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94530' , '14621' , 'SANTA RITA BABY - 023 SR/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 27/11/2024 12:24:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 12:24:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3678' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 27/11/2024 12:24:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94531' 27/11/2024 12:24:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94531' 27/11/2024 12:24: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 ( '94531' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 27/11/2024 12:36:06 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '682880', document_date = '2024-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '2.51', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '98.14', price_tax_excluded = '91.76', date_upd = NOW() WHERE id_document = '94476' 27/11/2024 12:36: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 = '94476' 27/11/2024 12:36:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94476' 27/11/2024 12:36: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 ( '94476' , '23263' , 'SEI SPECIALE DI GESU - M. DE SANCTIS' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '30' , '5.60' ) 27/11/2024 12:36: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 ( '94476' , '23264' , 'MEDAGLIA MIRACOLOSA CAMMINO ... - ' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '30' , '2.80' ) 27/11/2024 12:36: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 ( '94476' , '23266' , 'FOLLOWERS 3 ' , '2' , '2' , '4' , '16.0000' , '16' , '0' , '33' , '21.44' ) 27/11/2024 12:36: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 ( '94476' , '22870' , 'AGENDA SAN PAOLO 2025' , '6' , '6' , '1' , '4.8300' , '3.9590163934426' , '22' , '0' , '35.36' ) 27/11/2024 12:36: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 ( '94476' , '21522' , 'MASSIME ETERNE' , '3' , '3' , '4' , '5.5000' , '5.5' , '0' , '30' , '11.55' ) 27/11/2024 12:36: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 ( '94476' , '22265' , 'DIO ATTRAVERSA LA CITTA - TONINO BELLO' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '33' , '4.02' ) 27/11/2024 12:36: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 ( '94476' , '23267' , 'NUTRIRE LA MENTE - CALABRESE/NOE' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 27/11/2024 12:36: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 ( '94476' , '23265' , 'ROSARIO E NOVENA A MARIA CHE SCIOGLIE I NODI ' , '1' , '1' , '4' , '4.00' , '4' , '0' , '30' , '2.8000' ) 27/11/2024 12:38:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 27/11/2024 12:38:10 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2024-11-14', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1113.18', price_tax_excluded = '1113.18', date_upd = NOW() WHERE id_document = '94256' 27/11/2024 12:38: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 = '94256' 27/11/2024 12:38:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94256' 27/11/2024 12: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 ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 27/11/2024 12: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 ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 27/11/2024 12:38:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.8000' , '3.8' , '0' , '15' , '161.50' ) 27/11/2024 12:38:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 27/11/2024 12:38:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 27/11/2024 12:38:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '40' , '-40' , '4' , '14.00' , '14' , '0' , '0' , '560.00' ) 27/11/2024 12:51:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 12:51:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3679' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.58' , '36.58' , NOW() , NOW() ) 27/11/2024 12:51:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94532' 27/11/2024 12:51:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94532' 27/11/2024 12:51:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94532' , '23267' , 'NUTRIRE LA MENTE - CALABRESE/NOE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/11/2024 12:51:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94532' , '22943' , 'AVVENTO 2024' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 27/11/2024 12:51:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94532' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 27/11/2024 01:00:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 27/11/2024 01:00:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2024-11-14', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1276.72', price_tax_excluded = '1265.90', date_upd = NOW() WHERE id_document = '94256' 27/11/2024 01:00: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 = '94256' 27/11/2024 01:00:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94256' 27/11/2024 01:00: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 ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 27/11/2024 01:00: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 ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 27/11/2024 01:00: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 ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 27/11/2024 01:00: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 ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 27/11/2024 01:00: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 ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 27/11/2024 01:00: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 ( '94256' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '40' , '-40' , '4' , '14.0000' , '14' , '0' , '0' , '560.00' ) 27/11/2024 01:00: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 ( '94256' , '' , 'natività campana ' , '1' , '-1' , '4' , '110' , '110' , '0' , '0' , '110.00' ) 27/11/2024 01:00: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 ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 27/11/2024 03:06:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 03:06:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3680' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 27/11/2024 03:06:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94533' 27/11/2024 03:06:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94533' 27/11/2024 03:06:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94533' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 27/11/2024 03:34:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3648' , '2024-11-25' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '190.00' , '190.00' , NOW() , NOW() ) 27/11/2024 03:34:08 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 = '94534' 27/11/2024 03:34:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '94534' 27/11/2024 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94534' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '1' , '4' , '65.00' , '65' , '0' , '30' , '45.5000' ) 27/11/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 27/11/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 27/11/2024 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94534' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '1' , '4' , '65.00' , '65' , '0' , '30' , '45.5000' ) 27/11/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 27/11/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 27/11/2024 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94534' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 27/11/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 27/11/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 27/11/2024 03:34:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94534' , '22507' , 'SPES NON CONFUNDIT' , '20' , '20' , '4' , '2.00' , '2' , '0' , '45' , '22.0000' ) 27/11/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 27/11/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 27/11/2024 03:55:51 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/11/2024 03:55:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23270' , '1' , '' , 'nuovo-prodotto' ) 27/11/2024 03:55:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23270' , '1' , '1' , '2' , NOW() , NOW() ) 27/11/2024 03:55:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23270' , '0' , '1' , '0' , '0' ) 27/11/2024 03:57:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400061840' AND id_product != '23270' AND ean13 != '' 27/11/2024 03:57:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400061840', date_upd = NOW() WHERE id_product = '23270' 27/11/2024 03:57:10 pm >> UPDATE ps_product_lang SET name = 'PINO 3D - P172', description = '' WHERE id_product = '23270' 27/11/2024 03:57:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '23270' 27/11/2024 03:57:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23270' 27/11/2024 03:57:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '23270' 27/11/2024 04:14:11 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' , 'A4586' , '2024-11-27' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '671.67' , '550.55' , NOW() , NOW() ) 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94535' 27/11/2024 04:14:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '94535' 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21841' , 'QUADRETTO SMUSSATO - 1269' , '75' , '75' , '1' , '1' , '0.81967213114754' , '22' , '0' , '91.5000' ) 27/11/2024 04:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21841' AND id_supplier = '28' 27/11/2024 04:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21841' , '28' , '1' ) 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '23270' , 'PINO 3D - P172' , '100' , '100' , '1' , '0.72' , '0.59016393442623' , '22' , '0' , '87.8400' ) 27/11/2024 04:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23270' AND id_supplier = '28' 27/11/2024 04:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23270' , '28' , '1' ) 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '5.4900' ) 27/11/2024 04:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21559' AND id_supplier = '28' 27/11/2024 04:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21559' , '28' , '1' ) 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '1' , '1' , '7.25' , '5.9426229508197' , '22' , '0' , '8.8450' ) 27/11/2024 04:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16985' AND id_supplier = '28' 27/11/2024 04:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16985' , '28' , '1' ) 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '3' , '3' , '1' , '90.6' , '74.262295081967' , '22' , '0' , '331.5960' ) 27/11/2024 04:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 27/11/2024 04:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 27/11/2024 04:14:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '100' , '100' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '146.4000' ) 27/11/2024 04:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23097' AND id_supplier = '28' 27/11/2024 04:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23097' , '28' , '1' ) 27/11/2024 04:15:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 04:15:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3681' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.00' , '52.46' , NOW() , NOW() ) 27/11/2024 04:15: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 = '94536' 27/11/2024 04:15:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '94536' 27/11/2024 04:15: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 ( '94536' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '34.00' ) 27/11/2024 04:15: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 ( '94536' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2024 04:31:18 pm >> UPDATE ps_document SET id_document_type = '31', document_num = 'A4586', document_date = '2024-11-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2623', address1 = 'VIA DEI MILLE 59 80121 NAPOLI', 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 = '409.47', price_tax_excluded = '335.63', date_upd = NOW() WHERE id_document = '94535' 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94535' 27/11/2024 04:31:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94535' 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21841' , 'QUADRETTO SMUSSATO - 1269' , '75' , '75' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '91.50' ) 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '23270' , 'PINO 3D - P172' , '100' , '100' , '1' , '0.7200' , '0.59016393442623' , '22' , '0' , '87.84' ) 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '5.49' ) 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '1' , '1' , '7.2500' , '5.9426229508197' , '22' , '0' , '8.85' ) 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '3' , '3' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '33.1596' ) 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '100' , '100' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '146.40' ) 27/11/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94535' , '21558' , 'ANELLO DECINA ARG - M043' , '6' , '6' , '1' , '4.95' , '4.0573770491803' , '22' , '0' , '36.2340' ) 27/11/2024 04:32:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3681' AND id_document != '94536' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 04:32:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3681', document_date = '2024-11-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '64.00', price_tax_excluded = '52.46', date_upd = NOW() WHERE id_document = '94536' 27/11/2024 04:32: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 = '94536' 27/11/2024 04:32:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94536' 27/11/2024 04:32: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 ( '94536' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '34.00' ) 27/11/2024 04:32: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 ( '94536' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '30.00' ) 27/11/2024 04:42:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 04:42:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3682' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.35' , '32.38' , NOW() , NOW() ) 27/11/2024 04:42:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94537' 27/11/2024 04:42:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94537' 27/11/2024 04:42: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 ( '94537' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '2' , '-2' , '4' , '2.9' , '2.9' , '0' , '0' , '5.80' ) 27/11/2024 04:42: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 ( '94537' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 27/11/2024 04:42: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 ( '94537' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '4.25' , '4.25' , '0' , '0' , '4.25' ) 27/11/2024 04:42: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 ( '94537' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '20' , '-20' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '8.00' ) 27/11/2024 04:42: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 ( '94537' , '3433' , 'DIECI COMANDAMENTI' , '9' , '-9' , '4' , '0.20' , '0.2' , '0' , '0' , '1.80' ) 27/11/2024 04:42: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 ( '94537' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '10' , '-10' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '14.00' ) 27/11/2024 05:04:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '56/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 05:04: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 ( '23' , '56/E' , '2024-11-27' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '94.32' , '94.32' , NOW() , NOW() ) 27/11/2024 05:04: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 = '94538' 27/11/2024 05:04:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94538' 27/11/2024 05:04: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 ( '94538' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '40' , '-40' , '4' , '3.40' , '3.4' , '0' , '38' , '84.32' ) 27/11/2024 05:04: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 ( '94538' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 27/11/2024 05:44:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 05:44:44 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' , '3683' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '56.85' , '54.33' , NOW() , NOW() ) 27/11/2024 05:44:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94539' 27/11/2024 05:44:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '94539' 27/11/2024 05:44:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94539' , '6629' , 'MIA PREGHIERA' , '50' , '-50' , '4' , '0.8' , '0.8' , '0' , '0' , '40.00' ) 27/11/2024 05:44:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94539' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 27/11/2024 05:44:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94539' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/11/2024 05:44:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94539' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 27/11/2024 05:51:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 05:51:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3684' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '177.97' , '167.58' , NOW() , NOW() ) 27/11/2024 05:51: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 = '94540' 27/11/2024 05:51:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '94540' 27/11/2024 05:51: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 ( '94540' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 27/11/2024 05:51: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 ( '94540' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 27/11/2024 05:51: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 ( '94540' , '23199' , 'VERBUM CARO FACTUM EST' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 27/11/2024 05:51: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 ( '94540' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 27/11/2024 05:51: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 ( '94540' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/11/2024 05:51: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 ( '94540' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '2' , '-2' , '4' , '42.00' , '42' , '0' , '5' , '79.80' ) 27/11/2024 05:51: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 ( '94540' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '13.60' ) 27/11/2024 05:51: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 ( '94540' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 27/11/2024 05:51: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 ( '94540' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 27/11/2024 05:51: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 ( '94540' , '18742' , 'VIAGGIO DEI TRE RE - B. MASINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 27/11/2024 05:51: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 ( '94540' , '23169' , 'DILEXIT NOS ' , '4' , '-4' , '4' , '2.20' , '2.2' , '0' , '0' , '8.80' ) 27/11/2024 06:10:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 06:10:34 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' , '3685' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 27/11/2024 06:10:34 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 = '94541' 27/11/2024 06:10:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94541' 27/11/2024 06:10:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '33.90' , '27.786885245902' , '22' , '0' , '33.90' ) 27/11/2024 06:10:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 27/11/2024 06:10:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 27/11/2024 06:10:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/11/2024 06:28:56 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Way1GAYAtJFTi6LR' , NOW() , NOW() ) 27/11/2024 06:28:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7115' , '1' ) 27/11/2024 06:28:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7115' , '2' ) 27/11/2024 06:28:56 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7115' , '3' ) 27/11/2024 06:29:10 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '5al7ZKr8b8PqKZuB' , NOW() , NOW() ) 27/11/2024 06:29:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7116' , '1' ) 27/11/2024 06:29:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7116' , '2' ) 27/11/2024 06:29:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7116' , '3' ) 27/11/2024 06:30:17 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7116' 27/11/2024 06:30:18 pm >> 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 ( '7116' , '10' , '221' , '' , 'NARDELLI' , 'ANTONELLA' , 'VIA RIO PAPA 12' , '' , '38121' , 'TRENTO' , '' , '' , '3533264933' , '' , '' , NOW() , NOW() ) 27/11/2024 06:30:18 pm >> UPDATE ps_customer SET email = 'anto73grafo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7116' 27/11/2024 06:31:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '45' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 06:31: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 ( '21' , '45' , '2024-11-27' , '' , '7116' , '0' , '177359061' , 'VIA RIO PAPA 12 38121 TRENTO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '49.66' , '49.66' , NOW() , NOW() ) 27/11/2024 06:31: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 = '14773' 27/11/2024 06:31:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '14773' 27/11/2024 06:31: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 ( '14773' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '5' , '9.50' ) 27/11/2024 06:31: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 ( '14773' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 27/11/2024 06:31: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 ( '14773' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/11/2024 06:31: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 ( '14773' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/11/2024 07:15:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 27/11/2024 07:15:34 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' , '3686' , '2024-11-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 27/11/2024 07:15:34 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 = '94542' 27/11/2024 07:15:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94542' 27/11/2024 07:15:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94542' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 27/11/2024 07:15:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94542' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )