28/04/2023 09:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 09:46:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '78' , '2023-04-28' , '' , '3045' , '0' , '4674894' , 'VIA MAESTRI DEL LAVORO, 17 85100 POTENZA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '23.44' , NOW() , NOW() ) 28/04/2023 09:46:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82994' 28/04/2023 09:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '82994' 28/04/2023 09:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82994' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '10' , '22.50' ) 28/04/2023 09:46:36 am >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '82994' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 09:46:37 am >> UPDATE ps_document SET id_document_type = '21', document_num = '78', document_date = '2023-04-28', document_letter = '', id_customer = '3045', id_supplier = '', id_address = '4674894', address1 = 'VIA MAESTRI DEL LAVORO, 17 85100 POTENZA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '27.50', price_tax_excluded = '23.44', date_upd = NOW() WHERE id_document = '82994' 28/04/2023 09:46:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82994' 28/04/2023 09:46:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82994' 28/04/2023 09:46:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82994' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '10' , '22.50' ) 28/04/2023 09:57:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1398' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 09:57:03 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' , '1398' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 28/04/2023 09:57:03 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 = '82995' 28/04/2023 09:57:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82995' 28/04/2023 09:57:03 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 ( '82995' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 28/04/2023 10:18:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 10:18: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' , '1399' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 28/04/2023 10:18: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 = '82996' 28/04/2023 10:18:48 am >> DELETE FROM ps_document_detail WHERE id_document = '82996' 28/04/2023 10:18: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 ( '82996' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/04/2023 10:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82996' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 28/04/2023 10:20:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 10:20:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1400' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 28/04/2023 10:20:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82997' 28/04/2023 10:20:15 am >> DELETE FROM ps_document_detail WHERE id_document = '82997' 28/04/2023 10:20:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82997' , '17617' , 'IMMAGINI ISONZO X 100' , '14' , '-14' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '49.00' ) 28/04/2023 10:49:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 10:49: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' , '1401' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '211.84' , NOW() , NOW() ) 28/04/2023 10:49: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 = '82998' 28/04/2023 10:49:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82998' 28/04/2023 10:49: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 ( '82998' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 28/04/2023 10:49: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 ( '82998' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/04/2023 10:49: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 ( '82998' , '11151' , 'LIBRI' , '50' , '-50' , '4' , '0.5' , '0.5' , '0' , '0' , '25.00' ) 28/04/2023 10:49: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 ( '82998' , '15784' , 'COPRILEGGIO MARIANO - PCP004B05' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 28/04/2023 10:49: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 ( '82998' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '133' , '109.01639344262' , '22' , '0' , '133.00' ) 28/04/2023 10:54:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 10:54:08 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' , '1402' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.16' , '60.81' , NOW() , NOW() ) 28/04/2023 10:54:08 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 = '82999' 28/04/2023 10:54:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82999' 28/04/2023 10:54:08 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 ( '82999' , '19338' , 'VANGELO AZZURRO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/04/2023 10:54:08 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 ( '82999' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 28/04/2023 10:54:08 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 ( '82999' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '29' , '23.770491803279' , '22' , '0' , '58.00' ) 28/04/2023 11:02:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 11:02:21 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' , '1403' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 28/04/2023 11:02:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83000' 28/04/2023 11:02:21 am >> DELETE FROM ps_document_detail WHERE id_document = '83000' 28/04/2023 11:02:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83000' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '' , '18.00' ) 28/04/2023 11:03:51 am >> SELECT document_num FROM ps_document WHERE document_num = '79' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 11:03:51 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' , '79' , '2023-04-28' , '' , '3931' , '0' , '4677720' , 'VIALE DELLA LIBERA 11 80079 PROCIDA' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '127.00' , '127.00' , NOW() , NOW() ) 28/04/2023 11:03:51 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 = '83001' 28/04/2023 11:03:51 am >> DELETE FROM ps_document_detail WHERE id_document = '83001' 28/04/2023 11:03:51 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 ( '83001' , '17734' , 'VANGELO E ATTI BAMBINI' , '40' , '-40' , '4' , '3.00' , '3' , '0' , '5' , '114.00' ) 28/04/2023 11:17:00 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'I79mY8lkT9xFZuD6' , NOW() , NOW() ) 28/04/2023 11:17:00 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4011' , '1' ) 28/04/2023 11:17:00 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4011' , '2' ) 28/04/2023 11:17:00 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4011' , '3' ) 28/04/2023 11:18:24 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4011' 28/04/2023 11:18:25 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 ( '4011' , '10' , '183' , '' , 'CICCONE' , 'ANTONIETTA' , 'VIA MARIO DE SENA 250' , '' , '80035' , 'NOLA' , '' , '0818234037' , '3394730705' , '' , '' , NOW() , NOW() ) 28/04/2023 11:18:25 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4011' 28/04/2023 11:18:55 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4011' 28/04/2023 11:18:55 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 ( '4011' , '10' , '183' , '' , 'CICCONE' , 'ANTONIETTA' , 'VIA MARIO DE SENA 250' , '' , '80035' , 'NOLA' , '' , '0818234037' , '3394730705' , '' , '' , NOW() , NOW() ) 28/04/2023 11:18:55 am >> UPDATE ps_customer SET email = 'a.albi@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4011' 28/04/2023 11:22:21 am >> SELECT document_num FROM ps_document WHERE document_num = '80' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 11:22:21 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' , '80' , '2023-04-28' , '' , '4011' , '0' , '4678854' , 'VIA MARIO DE SENA 250 80035 NOLA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.90' , '45.90' , NOW() , NOW() ) 28/04/2023 11:22:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83002' 28/04/2023 11:22:21 am >> DELETE FROM ps_document_detail WHERE id_document = '83002' 28/04/2023 11:22:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83002' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '5' , '38.00' ) 28/04/2023 11:22:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83002' , '' , 'contrassegno' , '1' , '-1' , '0' , '2.9' , '2.9' , '' , '0' , '2.90' ) 28/04/2023 11:22:41 am >> SELECT document_num FROM ps_document WHERE document_num = '80' AND id_document != '83002' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 11:22:42 am >> UPDATE ps_document SET id_document_type = '21', document_num = '80', document_date = '2023-04-28', document_letter = '', id_customer = '4011', id_supplier = '', id_address = '4678854', address1 = 'VIA MARIO DE SENA 250 80035 NOLA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '45.90', price_tax_excluded = '45.90', date_upd = NOW() WHERE id_document = '83002' 28/04/2023 11:22:42 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 = '83002' 28/04/2023 11:22:42 am >> DELETE FROM ps_document_detail WHERE id_document = '83002' 28/04/2023 11:22:42 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 ( '83002' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '0' , '40.0000' , '40' , '0' , '5' , '38.00' ) 28/04/2023 11:22:42 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 ( '83002' , '0' , 'contrassegno' , '1' , '-1' , '0' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 28/04/2023 11:37:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 11:37: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' , '1404' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/04/2023 11:37: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 = '83003' 28/04/2023 11:37:20 am >> DELETE FROM ps_document_detail WHERE id_document = '83003' 28/04/2023 11:37: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 ( '83003' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/04/2023 12:15:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:15:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1405' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '126.74' , NOW() , NOW() ) 28/04/2023 12:15:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83004' 28/04/2023 12:15:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '83004' 28/04/2023 12:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 28/04/2023 12:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '10' , '10' , '0' , '0' , '20.00' ) 28/04/2023 12:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.99' , '9.827868852459' , '22' , '0' , '11.99' ) 28/04/2023 12:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '19099' , 'INCENSO A' , '2' , '-2' , '1' , '44.63' , '36.581967213115' , '22' , '0' , '89.26' ) 28/04/2023 12:21:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:21: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' , '1406' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/04/2023 12:21: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 = '83005' 28/04/2023 12:21:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '83005' 28/04/2023 12:21: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 ( '83005' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/04/2023 12:24:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:24:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1407' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 28/04/2023 12:24:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83006' 28/04/2023 12:24:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '83006' 28/04/2023 12:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83006' , '5835' , 'LIBRO DEL MIO BAMBINO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 28/04/2023 12:40:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1408' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:40: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' , '1408' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '49.42' , NOW() , NOW() ) 28/04/2023 12:40: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 = '83007' 28/04/2023 12:40:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '83007' 28/04/2023 12:40: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 ( '83007' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/04/2023 12:40: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 ( '83007' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '19.00' ) 28/04/2023 12:40: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 ( '83007' , '1114' , 'BIBBIA DEGLI SPOSI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 28/04/2023 12:40: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 ( '83007' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '1' , '-1' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '3.75' ) 28/04/2023 12:44:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:44:21 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' , '1409' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '378.10' , '378.10' , NOW() , NOW() ) 28/04/2023 12:44:21 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 = '83008' 28/04/2023 12:44:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '83008' 28/04/2023 12:44: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 ( '83008' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '-1' , '4' , '150.00' , '150' , '0' , '5' , '142.50' ) 28/04/2023 12:44: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 ( '83008' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 28/04/2023 12:44: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 ( '83008' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 28/04/2023 12:44: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 ( '83008' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '2' , '-2' , '4' , '39.00' , '39' , '0' , '5' , '74.10' ) 28/04/2023 12:45:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1410' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:45:18 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' , '1410' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 28/04/2023 12:45: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 = '83009' 28/04/2023 12:45:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '83009' 28/04/2023 12:45: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 ( '83009' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 28/04/2023 12:46:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 12:46: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' , '1411' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.75' , '27.03' , NOW() , NOW() ) 28/04/2023 12:46: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 = '83010' 28/04/2023 12:46:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '83010' 28/04/2023 12:46: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 ( '83010' , '1114' , 'BIBBIA DEGLI SPOSI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 28/04/2023 12:46: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 ( '83010' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 28/04/2023 02:15:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788880754237' AND id_product != '20046' AND ean13 != '' 28/04/2023 02:15:19 pm >> UPDATE ps_product SET id_supplier = '107', reference = '11/6', ean13 = '9788880754237', date_upd = NOW() WHERE id_product = '20046' 28/04/2023 02:15:19 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE NEI VANGELI - G. DE VIRGILIO', description = '' WHERE id_product = '20046' 28/04/2023 02:15:19 pm >> UPDATE ps_product SET wholesale_price = '11.05', on_sale = '0', price = '17.0000' WHERE id_product = '20046' 28/04/2023 02:15:19 pm >> UPDATE ps_product_shop SET wholesale_price = '11.05', price = '17.0000', id_tax_rules_group = '4', id_category_default = '96', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20046' 28/04/2023 02:15:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '20046' 28/04/2023 02:16:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066715' AND id_product != '17312' AND ean13 != '' 28/04/2023 02:16:33 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788801066715', date_upd = NOW() WHERE id_product = '17312' 28/04/2023 02:16:33 pm >> UPDATE ps_product_lang SET name = 'UN TEMPO PER L\'ANIMA - A GRUN', description = '' WHERE id_product = '17312' 28/04/2023 02:16:33 pm >> UPDATE ps_product SET wholesale_price = '3.25', on_sale = '0', price = '5.0000' WHERE id_product = '17312' 28/04/2023 02:16:33 pm >> UPDATE ps_product_shop SET wholesale_price = '3.25', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17312' 28/04/2023 02:16:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '17312' 28/04/2023 02:16:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066708' AND id_product != '17311' AND ean13 != '' 28/04/2023 02:16:44 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788801066708', date_upd = NOW() WHERE id_product = '17311' 28/04/2023 02:16:44 pm >> UPDATE ps_product_lang SET name = 'CAMMINO DEL SILENZIO - A. GRUN', description = '' WHERE id_product = '17311' 28/04/2023 02:16:44 pm >> UPDATE ps_product SET wholesale_price = '3.25', on_sale = '0', price = '5.0000' WHERE id_product = '17311' 28/04/2023 02:16:44 pm >> UPDATE ps_product_shop SET wholesale_price = '3.25', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17311' 28/04/2023 02:16:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '17311' 28/04/2023 02:16:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801066692' AND id_product != '17310' AND ean13 != '' 28/04/2023 02:16:57 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788801066692', date_upd = NOW() WHERE id_product = '17310' 28/04/2023 02:16:57 pm >> UPDATE ps_product_lang SET name = 'FORZA DI OGNI GIORNO - A. GRUN', description = '' WHERE id_product = '17310' 28/04/2023 02:16:57 pm >> UPDATE ps_product SET wholesale_price = '3.25', on_sale = '0', price = '5.0000' WHERE id_product = '17310' 28/04/2023 02:16:57 pm >> UPDATE ps_product_shop SET wholesale_price = '3.25', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17310' 28/04/2023 02:16:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '17310' 28/04/2023 02:28:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2023-FV000760' , '2023-04-28' , '' , '0' , '0' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '6.5' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '209.50' , '209.50' , NOW() , NOW() ) 28/04/2023 02:28:23 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 = '83011' 28/04/2023 02:28:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '83011' 28/04/2023 02:28:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83011' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '2' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '84.00' ) 28/04/2023 02:28:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83011' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 28/04/2023 02:28:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83011' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 28/04/2023 02:45:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1192' AND id_document != '82731' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-08') 28/04/2023 02:45:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1192', document_date = '2023-04-08', 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 = '5.00', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '82731' 28/04/2023 02:45:21 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 = '82731' 28/04/2023 02:45:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82731' 28/04/2023 02:45:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82731' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 28/04/2023 02:45:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1334' AND id_document != '82915' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-21') 28/04/2023 02:45:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1334', document_date = '2023-04-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.00', price_tax_excluded = '12.83', date_upd = NOW() WHERE id_document = '82915' 28/04/2023 02:45:39 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 = '82915' 28/04/2023 02:45:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82915' 28/04/2023 02:45: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 ( '82915' , '11376' , 'VIENI SPIRITO SANTO' , '15' , '-15' , '4' , '0.2000' , '0.2' , '0' , '0' , '3.00' ) 28/04/2023 02:45: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 ( '82915' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '5' , '-5' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '6.50' ) 28/04/2023 02:45: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 ( '82915' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 28/04/2023 02:46:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1401' AND id_document != '82998' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 02:46:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1401', document_date = '2023-04-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '250.00', price_tax_excluded = '211.84', date_upd = NOW() WHERE id_document = '82998' 28/04/2023 02:46: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 = '82998' 28/04/2023 02:46:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82998' 28/04/2023 02:46: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 ( '82998' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 28/04/2023 02:46: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 ( '82998' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/04/2023 02:46: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 ( '82998' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.25' , '1.25' , '0' , '0' , '1.25' ) 28/04/2023 02:46: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 ( '82998' , '15784' , 'COPRILEGGIO MARIANO - PCP004B05' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 28/04/2023 02:46: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 ( '82998' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '133.0000' , '109.01639344262' , '22' , '0' , '133.00' ) 28/04/2023 02:46: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 ( '82998' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 28/04/2023 02:49:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001995' AND id_product != '19594' AND ean13 != '' 28/04/2023 02:49:36 pm >> UPDATE ps_product SET id_supplier = '77', reference = '', ean13 = '001995', date_upd = NOW() WHERE id_product = '19594' 28/04/2023 02:49:36 pm >> UPDATE ps_product_lang SET name = 'POLO JERSEY COTONE 100%', description = '' WHERE id_product = '19594' 28/04/2023 02:49:36 pm >> UPDATE ps_product SET wholesale_price = '17.90', on_sale = '0', price = '32.704918032786885' WHERE id_product = '19594' 28/04/2023 02:49:36 pm >> UPDATE ps_product_shop SET wholesale_price = '17.90', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '253', 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 = '19594' 28/04/2023 02:49:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '19594' 28/04/2023 02:49:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002139' AND id_product != '20982' AND ean13 != '' 28/04/2023 02:49:45 pm >> UPDATE ps_product SET id_supplier = '77', reference = '', ean13 = '002139', date_upd = NOW() WHERE id_product = '20982' 28/04/2023 02:49:45 pm >> UPDATE ps_product_lang SET name = 'POLO MM VISCOSA 100%', description = '' WHERE id_product = '20982' 28/04/2023 02:49:45 pm >> UPDATE ps_product SET wholesale_price = '17.90', on_sale = '0', price = '32.704918032786885' WHERE id_product = '20982' 28/04/2023 02:49:45 pm >> UPDATE ps_product_shop SET wholesale_price = '17.90', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '253', 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 = '20982' 28/04/2023 02:49:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '20982' 28/04/2023 02:50:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001996' AND id_product != '19595' AND ean13 != '' 28/04/2023 02:50:40 pm >> UPDATE ps_product SET id_supplier = '77', reference = '', ean13 = '001996', date_upd = NOW() WHERE id_product = '19595' 28/04/2023 02:50:40 pm >> UPDATE ps_product_lang SET name = 'POLO JERSEY COTONE 100% - EXTRA', description = '' WHERE id_product = '19595' 28/04/2023 02:50:40 pm >> UPDATE ps_product SET wholesale_price = '18.50', on_sale = '0', price = '34.34426229508197' WHERE id_product = '19595' 28/04/2023 02:50:40 pm >> UPDATE ps_product_shop SET wholesale_price = '18.50', price = '34.34426229508197', id_tax_rules_group = '1', id_category_default = '253', 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 = '19595' 28/04/2023 02:50:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '19595' 28/04/2023 02:52:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000327' AND id_product != '8147' AND ean13 != '' 28/04/2023 02:52:07 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000327', date_upd = NOW() WHERE id_product = '8147' 28/04/2023 02:52:08 pm >> UPDATE ps_product_lang SET name = 'POLO BASIC', description = '' WHERE id_product = '8147' 28/04/2023 02:52:08 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '22.13114754098361' WHERE id_product = '8147' 28/04/2023 02:52:08 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '22.13114754098361', id_tax_rules_group = '1', id_category_default = '253', 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 = '8147' 28/04/2023 02:52:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '8147' 28/04/2023 02:54:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1411' AND id_document != '83010' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 02:54:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1411', document_date = '2023-04-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.75', price_tax_excluded = '27.03', date_upd = NOW() WHERE id_document = '83010' 28/04/2023 02:54:35 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 = '83010' 28/04/2023 02:54:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '83010' 28/04/2023 02:54:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83010' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '23.75' , '23.75' , '0' , '0' , '23.75' ) 28/04/2023 02:54:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83010' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 28/04/2023 03:13:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:13:23 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' , '81' , '2023-04-28' , '' , '246' , '0' , '4676205' , 'VIA NAZIONALE DELLE CALABRIE, 3 84131 FUORNI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 28/04/2023 03:13:23 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 = '83012' 28/04/2023 03:13:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '83012' 28/04/2023 03:13:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83012' , '12253' , 'MIO LIBRO DI PREGHIERE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 28/04/2023 03:19:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:19:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1412' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.25' , '71.86' , NOW() , NOW() ) 28/04/2023 03:19: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 = '83013' 28/04/2023 03:19:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '83013' 28/04/2023 03:19: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 ( '83013' , '17734' , 'VANGELO E ATTI BAMBINI' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 28/04/2023 03:19: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 ( '83013' , '19560' , 'PERGAMENA 17X25' , '11' , '-11' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.70' ) 28/04/2023 03:19: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 ( '83013' , '2026' , 'CHIESA DEL GREMBIULE - TONINO BELLO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 28/04/2023 03:28:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:28: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' , '1413' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 28/04/2023 03:28: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 = '83014' 28/04/2023 03:28:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '83014' 28/04/2023 03:28: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 ( '83014' , '20765' , 'AMEN - MAG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/04/2023 03:28: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 ( '83014' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/04/2023 03:46:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:46:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1414' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 28/04/2023 03:46: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 = '83015' 28/04/2023 03:46:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '83015' 28/04/2023 03:46: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 ( '83015' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 28/04/2023 03:46: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 ( '83015' , '20843' , 'MESSA MEDITAZIONE - MAG/GIU 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 28/04/2023 03:46:57 pm >> DELETE FROM ps_document WHERE id_document = '83015' 28/04/2023 03:46:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '83015' 28/04/2023 03:47:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:47:12 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' , '1414' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '95.00' , NOW() , NOW() ) 28/04/2023 03:47:12 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 = '83016' 28/04/2023 03:47:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '83016' 28/04/2023 03:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83016' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '19' , '-19' , '4' , '5.00' , '5' , '0' , '0' , '95.00' ) 28/04/2023 03:47:26 pm >> DELETE FROM ps_document WHERE id_document = '83016' 28/04/2023 03:47:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '83016' 28/04/2023 03:47:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:47: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' , '1414' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 28/04/2023 03:47: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 = '83017' 28/04/2023 03:47:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '83017' 28/04/2023 03:47: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 ( '83017' , '20843' , 'MESSA MEDITAZIONE - MAG/GIU 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/04/2023 03:55:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:55:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1415' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.00' , '58.89' , NOW() , NOW() ) 28/04/2023 03:55:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83018' 28/04/2023 03:55:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '83018' 28/04/2023 03:55:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83018' , '17513' , 'MEDITARE E CONTEMPLARE IL ROSARIO - M. CERUTI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/04/2023 03:55:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83018' , '6086' , 'MADRE DI MISERICORDIA - M.PAPPALARDO' , '1' , '-1' , '4' , '3.47' , '3.47' , '0' , '0' , '3.47' ) 28/04/2023 03:55:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83018' , '6415' , 'MESARETIM' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 28/04/2023 03:55:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83018' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '30.00' ) 28/04/2023 03:55:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83018' , '13506' , 'SANTO ROSARIO' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '' , '15.00' ) 28/04/2023 03:56:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 03:56:17 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' , '1416' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '26.44' , NOW() , NOW() ) 28/04/2023 03:56:17 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 = '83019' 28/04/2023 03:56:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '83019' 28/04/2023 03:56:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83019' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/04/2023 03:56:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83019' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/04/2023 04:12:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 28/04/2023 04:12:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.90', price_tax_excluded = '80.90', date_upd = NOW() WHERE id_document = '81317' 28/04/2023 04:12: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 = '81317' 28/04/2023 04:12:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 28/04/2023 04:12: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 ( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 28/04/2023 04:12: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 ( '81317' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 28/04/2023 04:12:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20893' , 'VANGELO E ATTI HEART UP' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 28/04/2023 04:12:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20979' , 'BIBBIA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 28/04/2023 04:12:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '19650' , 'UNBOUND' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 28/04/2023 04:13:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1417' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 04:13: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' , '1417' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.35' , '31.35' , NOW() , NOW() ) 28/04/2023 04:13: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 = '83020' 28/04/2023 04:13:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '83020' 28/04/2023 04:13:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83020' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 28/04/2023 04:13:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83020' , '20843' , 'MESSA MEDITAZIONE - MAG/GIU 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/04/2023 04:14:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1091' AND id_document != '82600' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 28/04/2023 04:14:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1091', document_date = '2023-04-01', 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 = '70.50', price_tax_excluded = '66.80', date_upd = NOW() WHERE id_document = '82600' 28/04/2023 04:14: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 = '82600' 28/04/2023 04:14:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '82600' 28/04/2023 04:14: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 ( '82600' , '19776' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '-1' , '1' , '20.5000' , '16.803278688525' , '22' , '0' , '20.50' ) 28/04/2023 04:14: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 ( '82600' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 28/04/2023 04:14: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 ( '82600' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '5' , '47.50' ) 28/04/2023 04:15:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1405' AND id_document != '83004' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 04:15:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1405', document_date = '2023-04-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '145.00', price_tax_excluded = '126.74', date_upd = NOW() WHERE id_document = '83004' 28/04/2023 04:15: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 = '83004' 28/04/2023 04:15:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '83004' 28/04/2023 04:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 28/04/2023 04:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 28/04/2023 04:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.9900' , '9.827868852459' , '22' , '0' , '11.99' ) 28/04/2023 04:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '19099' , 'INCENSO A' , '2' , '-2' , '1' , '44.6300' , '36.581967213115' , '22' , '0' , '89.26' ) 28/04/2023 04:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83004' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 28/04/2023 04:15:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 04:15: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' , '1418' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 28/04/2023 04:15: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 = '83021' 28/04/2023 04:15:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '83021' 28/04/2023 04:15: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 ( '83021' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 28/04/2023 04:19:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1137' AND id_document != '82658' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 28/04/2023 04:19:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1137', document_date = '2023-04-04', 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 = '238.00', price_tax_excluded = '197.43', date_upd = NOW() WHERE id_document = '82658' 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82658' 28/04/2023 04:19:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82658' 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 28/04/2023 04:19:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/04/2023 05:44:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 05:44:21 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' , '1419' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.40' , '18.07' , NOW() , NOW() ) 28/04/2023 05:44:21 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 = '83022' 28/04/2023 05:44:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '83022' 28/04/2023 05:44:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83022' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 28/04/2023 05:44:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83022' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '0.70' ) 28/04/2023 05:44:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83022' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/04/2023 05:44:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83022' , '475' , 'AMICO GESÙ - FIGURINE' , '11' , '-11' , '4' , '0.50' , '0.5' , '0' , '0' , '5.50' ) 28/04/2023 05:47:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 05:47:25 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' , '1420' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 28/04/2023 05:47:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83023' 28/04/2023 05:47:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '83023' 28/04/2023 05:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83023' , '20765' , 'AMEN - MAG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/04/2023 05:47:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83023' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/04/2023 05:53:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 05:53:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1421' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 28/04/2023 05:53: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 = '83024' 28/04/2023 05:53:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '83024' 28/04/2023 05:53: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 ( '83024' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 28/04/2023 05:59:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '83012' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 05:59:38 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '81', document_date = '2023-04-28', document_letter = '', id_customer = '246', id_supplier = '', id_address = '4676205', address1 = 'VIA NAZIONALE DELLE CALABRIE, 3 84131 FUORNI', 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 = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '83012' 28/04/2023 05:59: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 = '83012' 28/04/2023 05:59:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '83012' 28/04/2023 05:59: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 ( '83012' , '12253' , 'MIO LIBRO DI PREGHIERE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 28/04/2023 06:09:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1422' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 06:09:58 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' , '1422' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.60' , '10.06' , NOW() , NOW() ) 28/04/2023 06:09: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 = '83025' 28/04/2023 06:09:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '83025' 28/04/2023 06:09: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 ( '83025' , '15283' , 'DIARIO DELLA FELICITA ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/04/2023 06:09: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 ( '83025' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 28/04/2023 06:48:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 06:48: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' , '1423' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 28/04/2023 06:48: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 = '83026' 28/04/2023 06:48:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '83026' 28/04/2023 06:48: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 ( '83026' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 28/04/2023 07:34:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1424' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 07:34:54 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' , '1424' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 28/04/2023 07:34:54 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 = '83027' 28/04/2023 07:34:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '83027' 28/04/2023 07:34:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83027' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 28/04/2023 07:44:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 28/04/2023 07:44: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 ( '11' , '1425' , '2023-04-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.50' , '20.90' , NOW() , NOW() ) 28/04/2023 07:44: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 = '83028' 28/04/2023 07:44:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '83028' 28/04/2023 07:44:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83028' , '11389' , 'VINO ROSSO DOLCE - 103' , '3' , '-3' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '25.50' )