11/06/2024 10:38:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1943' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 10:38: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' , '1943' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 11/06/2024 10:38: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 = '92241' 11/06/2024 10:38:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92241' 11/06/2024 10:38: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 ( '92241' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 11/06/2024 10:48:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1944' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 10:48:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1944' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 11/06/2024 10:48:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92242' 11/06/2024 10:48:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92242' 11/06/2024 10:48:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92242' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '42' , '34.426229508197' , '22' , '0' , '42.00' ) 11/06/2024 10:51:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1944' AND id_document != '92242' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 10:51:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1944', document_date = '2024-06-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 = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '92242' 11/06/2024 10:51:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92242' 11/06/2024 10:51:16 am >> DELETE FROM ps_document_detail WHERE id_document = '92242' 11/06/2024 10:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92242' , '8669' , 'QUADRO DECORATO 24X24' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 11/06/2024 10:54:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1945' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 10:54:48 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' , '1945' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '54.90' , NOW() , NOW() ) 11/06/2024 10:54:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92243' 11/06/2024 10:54:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92243' 11/06/2024 10:54: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 ( '92243' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 11/06/2024 10:54: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 ( '92243' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 11/06/2024 11:10:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1946' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 11:10:48 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' , '1946' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 11/06/2024 11:10:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92244' 11/06/2024 11:10:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92244' 11/06/2024 11:10: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 ( '92244' , '17006' , 'SEGNALIBRO PR' , '400' , '-400' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '140.00' ) 11/06/2024 11:14:25 am >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 11:14: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 ( '24' , '18' , '2024-06-11' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 11/06/2024 11:14: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 = '92245' 11/06/2024 11:14:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92245' 11/06/2024 11:14: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 ( '92245' , '' , 'deve' , '1' , '-1' , '0' , '10' , '10' , '' , '0' , '10.00' ) 11/06/2024 11:14: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 ( '92245' , '' , 'già scontrinati' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 11/06/2024 12:46:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1937' AND id_document != '92235' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-10') 11/06/2024 12:46:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1937', document_date = '2024-06-10', 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 = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '92235' 11/06/2024 12:46:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92235' 11/06/2024 12:46:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '92235' 11/06/2024 12:46:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92235' , '13366' , 'CORONA VETRO MM 4 CON SCATOLA' , '5' , '-5' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '14.00' ) 11/06/2024 12:46:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0294' AND id_product != '13366' AND ean13 != '' 11/06/2024 12:46:25 pm >> UPDATE ps_product SET id_supplier = '39', reference = '', ean13 = '0294', date_upd = NOW() WHERE id_product = '13366' 11/06/2024 12:46:25 pm >> UPDATE ps_product_lang SET name = 'CORONA VETRO MM 4 CON SCATOLA', description = '' WHERE id_product = '13366' 11/06/2024 12:46:25 pm >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = 'NaN' WHERE id_product = '13366' 11/06/2024 12:46:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = 'NaN', id_tax_rules_group = '1', id_category_default = '187', 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 = '13366' 11/06/2024 12:46:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '13366' 11/06/2024 03:04:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '92020' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-25') 11/06/2024 03:04:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2024-05-25', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '30.50', price_tax_excluded = '25.00', date_upd = NOW() WHERE id_document = '92020' 11/06/2024 03:04:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92020' 11/06/2024 03:04:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92020' 11/06/2024 03:04:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92020' , '15497' , 'CROCE PLEX - 086' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 11/06/2024 03:04:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92020' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '15' , '-15' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '19.50' ) 11/06/2024 03:04:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92020' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/06/2024 03:33:46 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' , '2027' , '2024-06-10' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '220.35' , '220.35' , NOW() , NOW() ) 11/06/2024 03:33:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92246' 11/06/2024 03:33:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92246' 11/06/2024 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92246' , '22111' , 'PREGARE OGGI - 1' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '45' , '4.6750' ) 11/06/2024 03:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 11/06/2024 03:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 11/06/2024 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92246' , '22191' , 'PREGARE CON I SALMI - 2' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '45' , '4.6750' ) 11/06/2024 03:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 11/06/2024 03:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 11/06/2024 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92246' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '1' , '4' , '60.00' , '60' , '0' , '30' , '42.0000' ) 11/06/2024 03:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 11/06/2024 03:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 11/06/2024 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92246' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '1' , '4' , '130.00' , '130' , '0' , '30' , '91.0000' ) 11/06/2024 03:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17330' AND id_supplier = '79' 11/06/2024 03:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17330' , '79' , '1' ) 11/06/2024 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92246' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 11/06/2024 03:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '79' 11/06/2024 03:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '79' , '1' ) 11/06/2024 03:33:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92246' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 11/06/2024 03:33:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '79' 11/06/2024 03:33:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '79' , '1' ) 11/06/2024 03:54:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1947' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 03:54:15 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' , '1947' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '303.00' , '253.04' , NOW() , NOW() ) 11/06/2024 03:54:15 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 = '92247' 11/06/2024 03:54:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92247' 11/06/2024 03:54:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92247' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 11/06/2024 03:54:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92247' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 11/06/2024 03:54:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92247' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 11/06/2024 06:53:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1948' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 06:53:57 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' , '1948' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 11/06/2024 06:53:57 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 = '92248' 11/06/2024 06:53:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '92248' 11/06/2024 06:53:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92248' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 11/06/2024 06:55:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1741' AND id_document != '91986' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-24') 11/06/2024 06:55:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1741', document_date = '2024-05-24', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '91986' 11/06/2024 06:55:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91986' 11/06/2024 06:55:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91986' 11/06/2024 06:55:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91986' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 11/06/2024 06:56:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '92245' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 06:56:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '76/A', document_date = '2024-06-11', document_letter = 'A', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '92245' 11/06/2024 06:56:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92245' 11/06/2024 06:56:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92245' 11/06/2024 06:56:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92245' , '0' , 'deve' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 11/06/2024 06:56:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92245' , '0' , 'già scontrinati' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 11/06/2024 07:19:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1949' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 07:19:29 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' , '1949' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '11.54' , NOW() , NOW() ) 11/06/2024 07:19:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92249' 11/06/2024 07:19:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '92249' 11/06/2024 07:19:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92249' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 11/06/2024 07:19:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92249' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 11/06/2024 07:28:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1950' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 07:28:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1950' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 11/06/2024 07:28:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92250' 11/06/2024 07:28:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92250' 11/06/2024 07:28:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92250' , '22506' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 11/06/2024 07:38:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1951' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-11') 11/06/2024 07:38: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' , '1951' , '2024-06-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.14' , '16.14' , NOW() , NOW() ) 11/06/2024 07:38: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 = '92251' 11/06/2024 07:38:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92251' 11/06/2024 07:38: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 ( '92251' , '22476' , 'AMEN - AGO 2024' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 11/06/2024 07:38: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 ( '92251' , '22475' , 'AMEN - LUG. 2024' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 11/06/2024 07:38: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 ( '92251' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.3' , '1.3' , '0' , '0' , '1.30' )