28/11/2023 08:33:26 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 ( '34' , '479' , '2023-11-27' , '' , '0' , '0' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.40' , '215.40' , NOW() , NOW() ) 28/11/2023 08:33:26 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 = '89191' 28/11/2023 08:33:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89191' 28/11/2023 08:33:26 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 ( '89191' , '21037' , 'SULLA TUA PAROLA - LUG/AGO 23' , '10' , '0' , '4' , '5.0000' , '5' , '0' , '40' , '30.0000' ) 28/11/2023 08:33:26 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 ( '89191' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '9' , '0' , '4' , '5.0000' , '5' , '0' , '40' , '27.0000' ) 28/11/2023 08:33:26 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 ( '89191' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '40' , '6.0000' ) 28/11/2023 08:33:26 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 ( '89191' , '19115' , 'NOTTE DI PASSIONE - 8051' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '40' , '3.6000' ) 28/11/2023 08:33:26 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 ( '89191' , '20276' , 'CONCILIO VATICANO II - VOL. 1 - 701' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:26 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 ( '89191' , '20562' , 'RIVELAZIONE COME PAROLA DI DIO - VOL. 2 - 702' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:26 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 ( '89191' , '20563' , 'TRADIZIONE - VOL. 3 - 703' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:26 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 ( '89191' , '20564' , 'ISPIRAZIONE - VOL. 4 - 704' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:26 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 ( '89191' , '20565' , 'SACRA SCRITTURA NELLA VITA.. VOL. 5 - 705' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:26 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 ( '89191' , '20566' , 'LITURGIA NEL MISTERO... - VOL. 6 - 706' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:26 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 ( '89191' , '20567' , 'SACRA SCRITTURA NELLA LITURGIA - VOL. 7 - 707' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20568' , 'VIVERE LA LITURGIA IN PARROCCHIA - VOL. 8 - 708' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20569' , 'MISTERO EUCARISTICO - VOL. 9 - 709' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20570' , 'LITURGIA DELLE ORE - VOL. 10 - 710' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20571' , 'SACRAMENTI - VOL. 11 - 711' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20572' , 'DOMENICA - VOL. 12 - 712' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20573' , 'TEMPI FORTI DELLANNO LITURGICO - VOL. 13 - 713' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20574' , 'MUSICA NELLA LITURGIA - VOL. 14 - 714' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20575' , 'BELLEZZA DELLA LITURGIA - VOL. 15 - 715' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20576' , 'MISTERO DELLA CHIESA - VOL. 16 - 716' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20577' , 'IMMAGINI DELLA CHIESA - VOL. 17 - 717' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20712' , 'POPOLO DI DIO - 718' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20593' , 'CHIESA E PER LAVANGELIZZAZIONE - 19' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20713' , 'PAPA I VESCOVI I SACERDOTI ... - 720' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20594' , 'LAICI - 21' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20714' , 'VITA CONSACRATA - 722' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20595' , 'SANTITA UNA VOCAZIONE - 23' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20715' , 'CHIESA PELLEGRINA - 724' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20596' , 'MARIA LA PRIMA DI CREDENTI - 725' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20597' , 'CHIESA NEL MONDO DI OGGI - 26' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20598' , 'GRANDE TEMA DEL SENSO DELLA VITA - 27' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20599' , 'SOCIETA DEGLI UOMINI - 28' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20600' , 'AUTONOMIA E SERVIZIO - 29' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20601' , 'FAMIGLIA -30' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20602' , 'CULTURA - 31' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20716' , 'ECONOMIA E FINANZA - 732' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '2.4000' ) 28/11/2023 08:33:27 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 ( '89191' , '20604' , 'POLITICA - 33' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20605' , 'DIALOGO COME STRUMENTO - 34' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 08:33:27 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 ( '89191' , '20606' , 'PACE - 35' , '2' , '0' , '4' , '4.0000' , '4' , '0' , '40' , '4.8000' ) 28/11/2023 09:46:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3769' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 09:46:29 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' , '3769' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.46' , '6.46' , NOW() , NOW() ) 28/11/2023 09:46:29 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 = '89192' 28/11/2023 09:46:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89192' 28/11/2023 09:46:29 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 ( '89192' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '2' , '-2' , '4' , '3.40' , '3.4' , '0' , '5' , '6.46' ) 28/11/2023 10:08:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3770' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 10:08:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3770' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.00' , '104.16' , NOW() , NOW() ) 28/11/2023 10:08:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89193' 28/11/2023 10:08:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89193' 28/11/2023 10:08:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89193' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '7' , '-7' , '4' , '2.00' , '2' , '0' , '' , '14.00' ) 28/11/2023 10:08:01 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 ( '89193' , '18984' , 'POLO FELPATO ML ' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 28/11/2023 10:09:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3771' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 10:09:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3771' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 28/11/2023 10:09:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89194' 28/11/2023 10:09:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89194' 28/11/2023 10:09:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89194' , '21679' , 'LAUDATE DEUM - 8583' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 28/11/2023 10:23:17 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 28/11/2023 10:23:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 220,00 - 27/12 € 200,00 + € 100 20/3/23 + 300,00 17/06/23 - 300,00 26/09/2023 - 100,00 28/11/2023', 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 = '2700.00', price_tax_excluded = '2213.11', date_upd = NOW() WHERE id_document = '75504' 28/11/2023 10:23: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 = '75504' 28/11/2023 10:23:18 am >> DELETE FROM ps_document_detail WHERE id_document = '75504' 28/11/2023 10:23: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 ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 28/11/2023 10:23: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 ( '75504' , '0' , 'ACCONTO € 220,00' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '' , '0.00' ) 28/11/2023 10:23: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 ( '75504' , '0' , 'acconto € 200,00 27/12/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:23: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 ( '75504' , '0' , 'acconto € 100,00 20/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:23: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 ( '75504' , '0' , 'acconto € 300,00 - 17/06/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:23: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 ( '75504' , '0' , 'acconto € 300,00 26/09/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:23: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 ( '75504' , '' , 'ACCONTO € 100,00 28/11/2023' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 28/11/2023 10:26:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 10:26:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3772' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 28/11/2023 10:26:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89195' 28/11/2023 10:26:33 am >> DELETE FROM ps_document_detail WHERE id_document = '89195' 28/11/2023 10:26:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89195' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/11/2023 10:26:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89195' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/11/2023 10:33:58 am >> SELECT document_num FROM ps_document WHERE document_num = '298' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 10:33:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '298' , '2023-11-28' , '' , '3543' , '0' , '4677176' , 'VIA ROMA 1478 30015 CHIOGGIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '238.01' , '238.01' , NOW() , NOW() ) 28/11/2023 10:33:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89196' 28/11/2023 10:33:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89196' 28/11/2023 10:33:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89196' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 28/11/2023 10:33:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89196' , '13397' , 'MIO GESU\'' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 28/11/2023 10:33:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89196' , '4154' , 'FESTA DEL PERDONO' , '35' , '-35' , '4' , '3.00' , '3' , '0' , '15' , '89.25' ) 28/11/2023 10:39:30 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 28/11/2023 10:39:30 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 220,00 - 27/12 € 200,00 + € 100 20/3/23 + 300,00 17/06/23 - 300,00 26/09/2023 - ', 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 = '2700.00', price_tax_excluded = '2213.11', date_upd = NOW() WHERE id_document = '75504' 28/11/2023 10:39:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75504' 28/11/2023 10:39:30 am >> DELETE FROM ps_document_detail WHERE id_document = '75504' 28/11/2023 10:39:30 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 ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 28/11/2023 10:39:30 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 ( '75504' , '0' , 'ACCONTO € 220,00' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '' , '0.00' ) 28/11/2023 10:39:30 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 ( '75504' , '0' , 'acconto € 200,00 27/12/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:39:30 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 ( '75504' , '0' , 'acconto € 100,00 20/03/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:39:30 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 ( '75504' , '0' , 'acconto € 300,00 - 17/06/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:39:30 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 ( '75504' , '0' , 'acconto € 300,00 26/09/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 28/11/2023 10:56:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 10:56:17 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' , '3773' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 28/11/2023 10:56:17 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 = '89197' 28/11/2023 10:56:17 am >> DELETE FROM ps_document_detail WHERE id_document = '89197' 28/11/2023 10:56:17 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 ( '89197' , '18364' , 'EUCARISTIA - M. DE SANCTIS' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/11/2023 11:01:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 11:01:34 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' , '3774' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.02' , '33.02' , NOW() , NOW() ) 28/11/2023 11:01:34 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 = '89198' 28/11/2023 11:01:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89198' 28/11/2023 11:01:34 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 ( '89198' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 28/11/2023 11:01:34 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 ( '89198' , '21537' , 'AMEN - DIC. 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 28/11/2023 11:10:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3471' AND id_document != '88744' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-06') 28/11/2023 11:10:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3471', document_date = '2023-11-06', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '88744' 28/11/2023 11:10:02 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 = '88744' 28/11/2023 11:10:02 am >> DELETE FROM ps_document_detail WHERE id_document = '88744' 28/11/2023 11:10:02 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 ( '88744' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 28/11/2023 11:10:02 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 ( '88744' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/11/2023 11:14:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3494' AND id_document != '88799' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 28/11/2023 11:14:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3494', document_date = '2023-11-07', 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 = '21.40', price_tax_excluded = '18.84', date_upd = NOW() WHERE id_document = '88799' 28/11/2023 11:14:39 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 = '88799' 28/11/2023 11:14:39 am >> DELETE FROM ps_document_detail WHERE id_document = '88799' 28/11/2023 11:14:39 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 ( '88799' , '15020' , 'PREGARE OGNI GIORNO' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '0' , '4.00' ) 28/11/2023 11:14:39 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 ( '88799' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 28/11/2023 11:14:39 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 ( '88799' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.2000' , '5.0819672131148' , '22' , '0' , '6.20' ) 28/11/2023 11:14:39 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 ( '88799' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 28/11/2023 12:00:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 12:00:04 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' , '3775' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '270.00' , '228.78' , NOW() , NOW() ) 28/11/2023 12:00:04 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 = '89199' 28/11/2023 12:00:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89199' 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '19625' , 'CROCIFISSO CM 30 - 1004' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '19882' , 'CROCE CM 25 LUNA/TORTORA - 4965/727' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '12190' , 'CROCE VETRO CASABLANCA BIA/ARG CM 23' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '16252' , 'CUORE PENDENTE' , '3' , '-3' , '1' , '12.20' , '10' , '22' , '0' , '36.60' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '18031' , 'BRUCIAINCENSO H 8' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '15704' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2980/F0024' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '19' , '19' , '0' , '0' , '19.00' ) 28/11/2023 12:00:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '19884' , 'COPPIA SPOSI H 12 CON CUORE LUM - 4249/822' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 28/11/2023 12:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '13275' , 'NATIVITA CON LED CM 12' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 28/11/2023 12:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.4' , '2.4' , '0' , '0' , '2.40' ) 28/11/2023 12:01:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 12:01:01 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' , '3776' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.95' , '19.21' , NOW() , NOW() ) 28/11/2023 12:01:01 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 = '89200' 28/11/2023 12:01:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89200' 28/11/2023 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 28/11/2023 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/11/2023 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 28/11/2023 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/11/2023 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/11/2023 12:04:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 12:04:30 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' , '3777' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '27.39' , NOW() , NOW() ) 28/11/2023 12:04:30 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 = '89201' 28/11/2023 12:04:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '89201' 28/11/2023 12:04:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '5' , '-5' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '14.50' ) 28/11/2023 12:04:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15.5' , '15.5' , '0' , '0' , '15.50' ) 28/11/2023 12:09:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 12:09:06 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' , '3778' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 28/11/2023 12:09:06 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 = '89202' 28/11/2023 12:09:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '89202' 28/11/2023 12:09:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89202' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '5' , '19.00' ) 28/11/2023 12:37:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '131/A' AND id_document != '89033' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-20') 28/11/2023 12:37:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '131/A', document_date = '2023-11-20', document_letter = 'A', id_customer = '292', id_supplier = '', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', 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 = '1168.90', price_tax_excluded = '1166.95', date_upd = NOW() WHERE id_document = '89033' 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89033' 28/11/2023 12:37:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89033' 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '51' , '-51' , '4' , '4.5000' , '4.5' , '0' , '0' , '229.50' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '71' , '-71' , '4' , '4.5000' , '4.5' , '0' , '0' , '319.50' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '18' , '-18' , '4' , '4.5000' , '4.5' , '0' , '0' , '81.00' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '3' , '-3' , '4' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '24' , '-24' , '4' , '2.9000' , '2.9' , '0' , '0' , '69.60' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '4.2500' , '4.25' , '0' , '0' , '8.50' ) 28/11/2023 12:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '1' , '0.9000' , '0.73770491803279' , '22' , '0' , '10.80' ) 28/11/2023 12:56:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '88330' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-10-17') 28/11/2023 12:56:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '43', document_date = '2023-10-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = 'RESA - nota credito ricevuta', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '359.00', price_tax_excluded = '359.00', date_upd = NOW() WHERE id_document = '88330' 28/11/2023 12:56:42 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 = '88330' 28/11/2023 12:56:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '88330' 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '21037' , 'SULLA TUA PAROLA - LUG/AGO 23' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '0' , '50.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '9' , '-9' , '4' , '5.0000' , '5' , '0' , '0' , '45.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '19115' , 'NOTTE DI PASSIONE - 8051' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '0' , '6.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20276' , 'CONCILIO VATICANO II - VOL. 1 - 701' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20562' , 'RIVELAZIONE COME PAROLA DI DIO - VOL. 2 - 702' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20563' , 'TRADIZIONE - VOL. 3 - 703' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20564' , 'ISPIRAZIONE - VOL. 4 - 704' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20565' , 'SACRA SCRITTURA NELLA VITA.. VOL. 5 - 705' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20566' , 'LITURGIA NEL MISTERO... - VOL. 6 - 706' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20567' , 'SACRA SCRITTURA NELLA LITURGIA - VOL. 7 - 707' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20568' , 'VIVERE LA LITURGIA IN PARROCCHIA - VOL. 8 - 708' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20569' , 'MISTERO EUCARISTICO - VOL. 9 - 709' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20570' , 'LITURGIA DELLE ORE - VOL. 10 - 710' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20571' , 'SACRAMENTI - VOL. 11 - 711' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20572' , 'DOMENICA - VOL. 12 - 712' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20573' , 'TEMPI FORTI DELLANNO LITURGICO - VOL. 13 - 713' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20574' , 'MUSICA NELLA LITURGIA - VOL. 14 - 714' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20575' , 'BELLEZZA DELLA LITURGIA - VOL. 15 - 715' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20576' , 'MISTERO DELLA CHIESA - VOL. 16 - 716' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20577' , 'IMMAGINI DELLA CHIESA - VOL. 17 - 717' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20712' , 'POPOLO DI DIO - 718' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20593' , 'CHIESA E PER LAVANGELIZZAZIONE - 19' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20713' , 'PAPA I VESCOVI I SACERDOTI ... - 720' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20594' , 'LAICI - 21' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20714' , 'VITA CONSACRATA - 722' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20595' , 'SANTITA UNA VOCAZIONE - 23' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20715' , 'CHIESA PELLEGRINA - 724' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20596' , 'MARIA LA PRIMA DI CREDENTI - 725' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20597' , 'CHIESA NEL MONDO DI OGGI - 26' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20598' , 'GRANDE TEMA DEL SENSO DELLA VITA - 27' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20599' , 'SOCIETA DEGLI UOMINI - 28' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20600' , 'AUTONOMIA E SERVIZIO - 29' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20601' , 'FAMIGLIA -30' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20602' , 'CULTURA - 31' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20716' , 'ECONOMIA E FINANZA - 732' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20604' , 'POLITICA - 33' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20605' , 'DIALOGO COME STRUMENTO - 34' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 12:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88330' , '20606' , 'PACE - 35' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 28/11/2023 01:09:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '131/A' AND id_document != '89033' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-20') 28/11/2023 01:09:36 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '131/A', document_date = '2023-11-20', document_letter = 'A', id_customer = '292', id_supplier = '', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', 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 = '1177.90', price_tax_excluded = '1175.95', date_upd = NOW() WHERE id_document = '89033' 28/11/2023 01:09: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 = '89033' 28/11/2023 01:09:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '89033' 28/11/2023 01:09: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 ( '89033' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '51' , '-51' , '4' , '4.5000' , '4.5' , '0' , '0' , '229.50' ) 28/11/2023 01:09: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 ( '89033' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '73' , '-73' , '4' , '4.5000' , '4.5' , '0' , '0' , '328.50' ) 28/11/2023 01:09: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 ( '89033' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 28/11/2023 01:09: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 ( '89033' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 28/11/2023 01:09: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 ( '89033' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '18' , '-18' , '4' , '4.5000' , '4.5' , '0' , '0' , '81.00' ) 28/11/2023 01:09: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 ( '89033' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '3' , '-3' , '4' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 28/11/2023 01:09: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 ( '89033' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 28/11/2023 01:09: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 ( '89033' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '24' , '-24' , '4' , '2.9000' , '2.9' , '0' , '0' , '69.60' ) 28/11/2023 01:09: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 ( '89033' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '4.2500' , '4.25' , '0' , '0' , '8.50' ) 28/11/2023 01:09: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 ( '89033' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '1' , '0.9000' , '0.73770491803279' , '22' , '0' , '10.80' ) 28/11/2023 01:10:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 01:10: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 ( '23' , '19/L' , '2023-11-28' , 'L' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1177.90' , '1175.95' , NOW() , NOW() ) 28/11/2023 01:10: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 = '89203' 28/11/2023 01:10:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89203' 28/11/2023 01:10: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 ( '89203' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '51' , '-51' , '4' , '4.5000' , '4.5' , '0' , '0' , '229.50' ) 28/11/2023 01:10: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 ( '89203' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '73' , '-73' , '4' , '4.5000' , '4.5' , '0' , '0' , '328.50' ) 28/11/2023 01:10: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 ( '89203' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 28/11/2023 01:10: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 ( '89203' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 28/11/2023 01:10: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 ( '89203' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '18' , '-18' , '4' , '4.5000' , '4.5' , '0' , '0' , '81.00' ) 28/11/2023 01:10: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 ( '89203' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '3' , '-3' , '4' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 28/11/2023 01:10: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 ( '89203' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 28/11/2023 01:10: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 ( '89203' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '24' , '-24' , '4' , '2.9000' , '2.9' , '0' , '0' , '69.60' ) 28/11/2023 01:10: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 ( '89203' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '4.2500' , '4.25' , '0' , '0' , '8.50' ) 28/11/2023 01:10: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 ( '89203' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '1' , '0.9000' , '0.7377' , '22' , '0' , '10.80' ) 28/11/2023 01:13:39 pm >> DELETE FROM ps_document WHERE id_document = '89033' 28/11/2023 01:13:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89033' 28/11/2023 01:13:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/L' AND id_document != '89203' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 01:13:59 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/L', document_date = '2023-11-28', document_letter = 'L', id_customer = '292', id_supplier = '', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1177.90', price_tax_excluded = '1175.95', date_upd = NOW() WHERE id_document = '89203' 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89203' 28/11/2023 01:13:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89203' 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '51' , '-51' , '4' , '4.5000' , '4.5' , '0' , '0' , '229.50' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '73' , '-73' , '4' , '4.5000' , '4.5' , '0' , '0' , '328.50' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '18' , '-18' , '4' , '4.5000' , '4.5' , '0' , '0' , '81.00' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '3' , '-3' , '4' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '24' , '-24' , '4' , '2.9000' , '2.9' , '0' , '0' , '69.60' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '4.2500' , '4.25' , '0' , '0' , '8.50' ) 28/11/2023 01:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89203' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '1' , '0.9000' , '0.73770491803279' , '22' , '0' , '10.80' ) 28/11/2023 01:14:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/L' AND id_document != '89203' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 01:14:51 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/L', document_date = '2023-11-28', document_letter = 'L', id_customer = '292', id_supplier = '', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1180.60', price_tax_excluded = '1178.17', date_upd = NOW() WHERE id_document = '89203' 28/11/2023 01:14: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 = '89203' 28/11/2023 01:14:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89203' 28/11/2023 01:14: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 ( '89203' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '51' , '-51' , '4' , '4.5000' , '4.5' , '0' , '0' , '229.50' ) 28/11/2023 01:14: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 ( '89203' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '73' , '-73' , '4' , '4.5000' , '4.5' , '0' , '0' , '328.50' ) 28/11/2023 01:14: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 ( '89203' , '14529' , 'PANE E VINO - SUSSIDIO' , '70' , '-70' , '4' , '4.5000' , '4.5' , '0' , '0' , '315.00' ) 28/11/2023 01:14: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 ( '89203' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '-2' , '4' , '13.5000' , '13.5' , '0' , '0' , '27.00' ) 28/11/2023 01:14: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 ( '89203' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '18' , '-18' , '4' , '4.5000' , '4.5' , '0' , '0' , '81.00' ) 28/11/2023 01:14: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 ( '89203' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '3' , '-3' , '4' , '13.5000' , '13.5' , '0' , '0' , '40.50' ) 28/11/2023 01:14: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 ( '89203' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 28/11/2023 01:14: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 ( '89203' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '24' , '-24' , '4' , '2.9000' , '2.9' , '0' , '0' , '69.60' ) 28/11/2023 01:14: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 ( '89203' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '4.2500' , '4.25' , '0' , '0' , '8.50' ) 28/11/2023 01:14: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 ( '89203' , '12819' , 'REGISTRO DEL CATECHISTA ' , '15' , '-15' , '1' , '0.9000' , '0.73770491803279' , '22' , '0' , '13.50' ) 28/11/2023 01:22:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 01:22:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3779' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 28/11/2023 01:22:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89204' 28/11/2023 01:22:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89204' 28/11/2023 01:22:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89204' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '60' , '60' , '0' , '0' , '60.00' ) 28/11/2023 03:28:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 03:28: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' , '3780' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '93.85' , NOW() , NOW() ) 28/11/2023 03:28: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 = '89205' 28/11/2023 03:28:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89205' 28/11/2023 03:28: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 ( '89205' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '3' , '-3' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '8.70' ) 28/11/2023 03:28: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 ( '89205' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '5' , '7.14' ) 28/11/2023 03:28: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 ( '89205' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '5' , '-5' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 28/11/2023 03:28: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 ( '89205' , '20072' , 'BRACCIALE - BC1759N' , '5' , '-5' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 28/11/2023 03:28: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 ( '89205' , '18223' , 'CORONA MISSIONARIA - R102' , '25' , '-25' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '25.00' ) 28/11/2023 03:28: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 ( '89205' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '5' , '13.30' ) 28/11/2023 03:28: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 ( '89205' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35.86' , '29.393442622951' , '22' , '0' , '35.86' ) 28/11/2023 03:47:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3777' AND id_document != '89201' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 03:47:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3777', document_date = '2023-11-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 = '30.00', price_tax_excluded = '27.39', date_upd = NOW() WHERE id_document = '89201' 28/11/2023 03:47:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89201' 28/11/2023 03:47:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89201' 28/11/2023 03:47:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '5' , '-5' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '14.50' ) 28/11/2023 03:47:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.24' , '3.24' , '0' , '0' , '3.24' ) 28/11/2023 03:47:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '21775' , 'AMORE VINCE - C. AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 28/11/2023 03:51:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3775' AND id_document != '89199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 03:51:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3775', document_date = '2023-11-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 = '270.00', price_tax_excluded = '228.78', date_upd = NOW() WHERE id_document = '89199' 28/11/2023 03:51: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 = '89199' 28/11/2023 03:51:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89199' 28/11/2023 03:51: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 ( '89199' , '19625' , 'CROCIFISSO CM 30 - 1004' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 28/11/2023 03:51: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 ( '89199' , '19882' , 'CROCE CM 25 LUNA/TORTORA - 4965/727' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 28/11/2023 03:51: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 ( '89199' , '12190' , 'CROCE VETRO CASABLANCA BIA/ARG CM 23' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 28/11/2023 03:51: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 ( '89199' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/11/2023 03:51: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 ( '89199' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36.6' , '30' , '22' , '0' , '36.60' ) 28/11/2023 03:51: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 ( '89199' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 28/11/2023 03:51: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 ( '89199' , '18031' , 'BRUCIAINCENSO H 8' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 28/11/2023 03:51: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 ( '89199' , '15704' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2980/F0024' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 28/11/2023 03:51: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 ( '89199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 28/11/2023 03:51: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 ( '89199' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 28/11/2023 03:51: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 ( '89199' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 28/11/2023 03:51: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 ( '89199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 28/11/2023 03:51: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 ( '89199' , '19884' , 'COPPIA SPOSI H 12 CON CUORE LUM - 4249/822' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 28/11/2023 03:51: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 ( '89199' , '13275' , 'NATIVITA CON LED CM 12' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 28/11/2023 03:51: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 ( '89199' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.4000' , '2.4' , '0' , '0' , '2.40' ) 28/11/2023 04:09:34 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/11/2023 04:09:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21910' , '1' , '' , 'nuovo-prodotto' ) 28/11/2023 04:09:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21910' , '1' , '1' , '2' , NOW() , NOW() ) 28/11/2023 04:09:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21910' , '0' , '1' , '0' , '0' ) 28/11/2023 04:10:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788834331217' AND id_product != '21910' AND ean13 != '' 28/11/2023 04:10:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788834331217', date_upd = NOW() WHERE id_product = '21910' 28/11/2023 04:10:32 pm >> UPDATE ps_product_lang SET name = 'ITALO CALVINO', description = '' WHERE id_product = '21910' 28/11/2023 04:10:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21910' 28/11/2023 04:10:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '444', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21910' 28/11/2023 04:10:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21910' 28/11/2023 04:10:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21910' 28/11/2023 04:10:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21911' , '1' , '' , 'nuovo-prodotto' ) 28/11/2023 04:10:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21911' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21910' 28/11/2023 04:10:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21911' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21910' 28/11/2023 04:11:28 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 28/11/2023 04:11:28 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '530' , '1' ) 28/11/2023 04:11:28 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '530' , '2' ) 28/11/2023 04:11:28 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '530' , '3' ) 28/11/2023 04:11:28 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '530' , '1' , 'GRIBAUDO' , LOWER('GRIBAUDO') ) 28/11/2023 04:11:28 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '530' , '1' , '0' ) 28/11/2023 04:11:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858043059' AND id_product != '21911' AND ean13 != '' 28/11/2023 04:11:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788858043059', date_upd = NOW() WHERE id_product = '21911' 28/11/2023 04:11:36 pm >> UPDATE ps_product_lang SET name = 'GEOPOLITICA UMANA', description = '' WHERE id_product = '21911' 28/11/2023 04:11:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9' WHERE id_product = '21911' 28/11/2023 04:11:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9', id_tax_rules_group = '4', id_category_default = '530', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21911' 28/11/2023 04:11:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21911' 28/11/2023 04:11:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21911' 28/11/2023 04:11:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21912' , '1' , '' , 'nuovo-prodotto' ) 28/11/2023 04:11:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21912' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21911' 28/11/2023 04:11:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21912' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21911' 28/11/2023 04:12:54 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 28/11/2023 04:12:54 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '531' , '1' ) 28/11/2023 04:12:54 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '531' , '2' ) 28/11/2023 04:12:54 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '531' , '3' ) 28/11/2023 04:12:54 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '531' , '1' , 'INTERNOPOESIA' , LOWER('INTERNOPOESIA') ) 28/11/2023 04:12:54 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '531' , '1' , '0' ) 28/11/2023 04:13:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885583795' AND id_product != '21912' AND ean13 != '' 28/11/2023 04:13:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788885583795', date_upd = NOW() WHERE id_product = '21912' 28/11/2023 04:13:04 pm >> UPDATE ps_product_lang SET name = 'POETI ITALIANI', description = '' WHERE id_product = '21912' 28/11/2023 04:13:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '21912' 28/11/2023 04:13:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '531', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21912' 28/11/2023 04:13:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '21912' 28/11/2023 04:13:05 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21912' 28/11/2023 04:13:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21913' , '1' , '' , 'nuovo-prodotto' ) 28/11/2023 04:13:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21913' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21912' 28/11/2023 04:13:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21913' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21912' 28/11/2023 04:13:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788860309952' AND id_product != '21913' AND ean13 != '' 28/11/2023 04:13:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788860309952', date_upd = NOW() WHERE id_product = '21913' 28/11/2023 04:13:33 pm >> UPDATE ps_product_lang SET name = 'VITA 3.0', description = '' WHERE id_product = '21913' 28/11/2023 04:13:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29' WHERE id_product = '21913' 28/11/2023 04:13:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29', id_tax_rules_group = '4', id_category_default = '429', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21913' 28/11/2023 04:13:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '21913' 28/11/2023 04:13:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21913' 28/11/2023 04:13:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21914' , '1' , '' , 'nuovo-prodotto' ) 28/11/2023 04:13:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21914' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21913' 28/11/2023 04:13:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21914' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21913' 28/11/2023 04:14:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858046784' AND id_product != '21914' AND ean13 != '' 28/11/2023 04:14:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788858046784', date_upd = NOW() WHERE id_product = '21914' 28/11/2023 04:14:46 pm >> UPDATE ps_product_lang SET name = 'LIBRO DELLA STORIA LGBTQ+', description = '' WHERE id_product = '21914' 28/11/2023 04:14:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.9' WHERE id_product = '21914' 28/11/2023 04:14:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.9', id_tax_rules_group = '4', id_category_default = '530', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21914' 28/11/2023 04:14:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '21914' 28/11/2023 04:17:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/11/2023 04:17:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21915' , '1' , '' , 'nuovo-prodotto' ) 28/11/2023 04:17:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21915' , '1' , '1' , '2' , NOW() , NOW() ) 28/11/2023 04:17:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21915' , '0' , '1' , '0' , '0' ) 28/11/2023 04:18:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869292873' AND id_product != '21915' AND ean13 != '' 28/11/2023 04:18:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788869292873', date_upd = NOW() WHERE id_product = '21915' 28/11/2023 04:18:10 pm >> UPDATE ps_product_lang SET name = 'CI SPOSIAMO? - N. E. - L. FAGGIOLI', description = '' WHERE id_product = '21915' 28/11/2023 04:18:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21915' 28/11/2023 04:18:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21915' 28/11/2023 04:18:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '21915' 28/11/2023 04:20: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 ( '33' , '1161993' , '2023-11-27' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '296.70' , '296.70' , NOW() , NOW() ) 28/11/2023 04:20: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 = '89206' 28/11/2023 04:20:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89206' 28/11/2023 04:20: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 ( '89206' , '21912' , 'POETI ITALIANI' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21912' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21912' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '21910' , 'ITALO CALVINO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21910' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21910' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '1' , '4' , '24.90' , '24.9' , '0' , '0' , '24.90' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21914' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21914' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '21911' , 'GEOPOLITICA UMANA' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '0' , '14.90' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21911' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21911' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '21733' , 'GUARIRE CON LE PARABOLE - R. CHEIAB' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '0' , '15.90' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21733' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21733' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '21915' , 'CI SPOSIAMO? - N. E. - L. FAGGIOLI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21915' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21915' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21699' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21699' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '3590' , 'DIZIONARIO DEI CONCETTI BIBLICI DEL NUOVO TESTAMENTO' , '1' , '1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3590' AND id_supplier = '109' 28/11/2023 04:20:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3590' , '109' , '1' ) 28/11/2023 04:20: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 ( '89206' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '1' , '4' , '52.00' , '52' , '0' , '0' , '52.00' ) 28/11/2023 04:20:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 28/11/2023 04:20:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 28/11/2023 04:20:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89206' , '21913' , 'VITA 3.0' , '1' , '1' , '4' , '29.00' , '29' , '0' , '0' , '29.00' ) 28/11/2023 04:20:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21913' AND id_supplier = '109' 28/11/2023 04:20:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21913' , '109' , '1' ) 28/11/2023 05:14:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 05:14:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3781' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 28/11/2023 05:14:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89207' 28/11/2023 05:14:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89207' 28/11/2023 05:14:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89207' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 28/11/2023 05:48:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 05:48:19 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' , '3782' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '34.00' , NOW() , NOW() ) 28/11/2023 05:48:19 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 = '89208' 28/11/2023 05:48:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89208' 28/11/2023 05:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89208' , '21897' , 'OGNUNO FA IL FUOCO CON LA LEGNA CHE HA - M. POZZA' , '2' , '-2' , '4' , '17.00' , '17' , '0' , '5' , '32.30' ) 28/11/2023 05:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89208' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.7' , '1.7' , '0' , '0' , '1.70' ) 28/11/2023 06:06:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280229045' AND id_product != '17658' AND ean13 != '' 28/11/2023 06:06:26 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9791280229045', date_upd = NOW() WHERE id_product = '17658' 28/11/2023 06:06:26 pm >> UPDATE ps_product_lang SET name = 'TI AUGURO IL SORRISO', description = '' WHERE id_product = '17658' 28/11/2023 06:06:26 pm >> UPDATE ps_product SET wholesale_price = '11.18', on_sale = '0', price = '14.9000' WHERE id_product = '17658' 28/11/2023 06:06:26 pm >> UPDATE ps_product_shop SET wholesale_price = '11.18', price = '14.9000', id_tax_rules_group = '4', id_category_default = '511', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17658' 28/11/2023 06:06:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '17658' 28/11/2023 06:12:05 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '1302', document_date = '2023-09-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2643', address1 = 'VIA MAZARA, 209 91025 MARSALA', address2 = '', note = '', price_shipping = '3.71', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '2470.55', price_tax_excluded = '2025.71', date_upd = NOW() WHERE id_document = '87362' 28/11/2023 06:12:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87362' 28/11/2023 06:12:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '87362' 28/11/2023 06:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87362' , '11384' , 'VINO BIANCO DOLCE - 102' , '300' , '300' , '1' , '4.1000' , '3.3606557377049' , '22' , '' , '1500.60' ) 28/11/2023 06:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87362' , '11389' , 'VINO ROSSO DOLCE - 103' , '180' , '180' , '1' , '4.4000' , '3.6065573770492' , '22' , '' , '966.24' ) 28/11/2023 06:34:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3777' AND id_document != '89201' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 06:34:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3777', document_date = '2023-11-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 = '30.00', price_tax_excluded = '27.39', date_upd = NOW() WHERE id_document = '89201' 28/11/2023 06:34:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89201' 28/11/2023 06:34:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89201' 28/11/2023 06:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '5' , '-5' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '14.50' ) 28/11/2023 06:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '9571' , 'SANTA ILDEGARDA DI BINGEN - ARLEDLER/CANOPI' , '1' , '-1' , '4' , '3.24' , '3.24' , '0' , '0' , '3.24' ) 28/11/2023 06:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89201' , '21775' , 'AMORE VINCE - C. AMIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 28/11/2023 06:34:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 06:34:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '109' , '2023-11-28' , '' , '7042' , '0' , '130686738' , 'PIAZZA SAN GIORGIO 87040 ZUMPANO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '68.10' , '68.10' , NOW() , NOW() ) 28/11/2023 06:34:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13756' 28/11/2023 06:34:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '13756' 28/11/2023 06:34:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13756' , '17' , 'LA FEDE NELLO ZAINETTO' , '12' , '-12' , '4' , '6.00' , '6' , '0' , '15' , '61.20' ) 28/11/2023 07:28:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 07: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 ( '11' , '3783' , '2023-11-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.80' , '89.17' , NOW() , NOW() ) 28/11/2023 07: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 = '89209' 28/11/2023 07:28:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '89209' 28/11/2023 07: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 ( '89209' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '64.5' , '52.868852459016' , '22' , '0' , '64.50' ) 28/11/2023 07: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 ( '89209' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/11/2023 07: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 ( '89209' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/11/2023 07: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 ( '89209' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 28/11/2023 07: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 ( '89209' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 28/11/2023 07:48:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3776' AND id_document != '89200' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 28/11/2023 07:48:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3776', document_date = '2023-11-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 = '21.95', price_tax_excluded = '19.21', date_upd = NOW() WHERE id_document = '89200' 28/11/2023 07:48:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89200' 28/11/2023 07:48:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89200' 28/11/2023 07:48:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.2' , '10' , '22' , '0' , '12.20' ) 28/11/2023 07:48:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/11/2023 07:48:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 28/11/2023 07:48:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/11/2023 07:48:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89200' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' )