25/11/2023 08:30:18 am >> SELECT document_num FROM ps_document WHERE document_num = '134/A' AND id_document != '89079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-22') 25/11/2023 08:30:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '134/A', document_date = '2023-11-22', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI - SCONTO 10% SE NON INDICATO DIVERSAMENTE', 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 = '779.40', price_tax_excluded = '775.79', date_upd = NOW() WHERE id_document = '89079' 25/11/2023 08:30: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 = '89079' 25/11/2023 08:30:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89079' 25/11/2023 08:30: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 ( '89079' , '20002' , 'GESU BAMBINO DORATO CM 20 - BJ146-20D' , '1' , '-1' , '0' , '21.0000' , '21' , '0' , '0' , '21.00' ) 25/11/2023 08:30: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 ( '89079' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '1' , '-1' , '0' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 25/11/2023 08:30: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 ( '89079' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '0' , '34.0000' , '34' , '0' , '0' , '34.00' ) 25/11/2023 08:30: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 ( '89079' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '2' , '-2' , '0' , '18.0000' , '18' , '0' , '0' , '36.00' ) 25/11/2023 08:30: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 ( '89079' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '0' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 25/11/2023 08:30: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 ( '89079' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 25/11/2023 08:30: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 ( '89079' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '2' , '-2' , '0' , '12.9000' , '12.9' , '0' , '0' , '25.80' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '3' , '-3' , '0' , '7.0000' , '7' , '0' , '0' , '21.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '3' , '-3' , '0' , '6.0000' , '6' , '0' , '0' , '18.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16508' , 'ANGELO BIANCO IN RESINA CAMPANA - 4218' , '2' , '-2' , '0' , '6.0000' , '6' , '0' , '0' , '12.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'ANGELO 4232' , '2' , '-2' , '0' , '9.0000' , '9' , '' , '0' , '18.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19601' , 'ANGELO ALI TORTORA - 4231' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '15591' , 'ANGELO CON CAMPANA ARG. - 4216' , '1' , '-1' , '0' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '0' , '11.5000' , '11.5' , '0' , '0' , '11.50' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13538' , 'ANGELO RESINA CON GRANO - 4207' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '4' , '-4' , '0' , '6.0000' , '6' , '0' , '0' , '24.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '2' , '-2' , '0' , '4.8000' , '4.8' , '0' , '0' , '9.60' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20169' , 'croce corpo resina 30x21 - 671/3' , '1' , '-1' , '0' , '18.0000' , '18' , '0' , '0' , '18.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20168' , 'croce corpo resina 22x15 - 671/2' , '1' , '-1' , '0' , '14.0000' , '14' , '0' , '0' , '14.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.0000' , '28' , '0' , '0' , '28.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB ***immacolata' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'QUADRO NUVOLA - QUADRI E QUADRI - € 15,00 CAD****' , '3' , '-3' , '0' , '20.0000' , '20' , '0' , '0' , '60.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13112' , 'SACRO CUORE BABY- 023 SH 9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '0' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '0' , '2.0000' , '2' , '0' , '0' , '4.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18223' , 'CORONA MISSIONARIA - R102' , '5' , '-5' , '0' , '1.0000' , '1' , '0' , '0' , '5.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '0' , '12.5000' , '12.5' , '0' , '0' , '25.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '0' , '5.0000' , '5' , '0' , '0' , '10.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '3' , '-3' , '0' , '4.0000' , '4' , '0' , '0' , '12.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '4' , '-4' , '0' , '3.0000' , '3' , '0' , '0' , '12.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 25/11/2023 08:30:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89079' , '0' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 25/11/2023 09:07:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 09:07:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3728' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.63' , '16.63' , NOW() , NOW() ) 25/11/2023 09:07:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89137' 25/11/2023 09:07:21 am >> DELETE FROM ps_document_detail WHERE id_document = '89137' 25/11/2023 09:07:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89137' , '21865' , 'ETA DA INVENTARE - V. PAGLIA' , '1' , '-1' , '4' , '17.50' , '17.5' , '0' , '5' , '16.63' ) 25/11/2023 09:07:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 09:07:40 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' , '3729' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.35' , '31.35' , NOW() , NOW() ) 25/11/2023 09:07:40 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 = '89138' 25/11/2023 09:07:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89138' 25/11/2023 09:07:40 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 ( '89138' , '20902' , 'SCIENZIATI DUNQUE CREDENTI - F. AGNOLI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 25/11/2023 09:07:40 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 ( '89138' , '21870' , 'FIGLI DI NAGASAKI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 25/11/2023 09:20:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 09:20:47 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' , '3730' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.43' , '39.43' , NOW() , NOW() ) 25/11/2023 09:20:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89139' 25/11/2023 09:20:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89139' 25/11/2023 09:20:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89139' , '21781' , 'PER- CORSI DI PEDAGOGIA GENERALE' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 25/11/2023 09:20:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89139' , '4149' , 'FENOMENO RELIGIOSO' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 25/11/2023 09:28:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 09:28:36 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' , '3731' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.49' , '36.63' , NOW() , NOW() ) 25/11/2023 09:28:36 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 = '89140' 25/11/2023 09:28:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89140' 25/11/2023 09:28:36 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 ( '89140' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '23' , '-23' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '29.90' ) 25/11/2023 09:28:36 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 ( '89140' , '20158' , 'CASETTA NATIVITA - 23/97NAT04' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 25/11/2023 09:28:36 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 ( '89140' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 25/11/2023 09:28:36 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 ( '89140' , '2679' , 'CONOSCERE GESU' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '5' , '9.99' ) 25/11/2023 09:35:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 09:35:30 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' , '3732' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '46.26' , NOW() , NOW() ) 25/11/2023 09:35: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 = '89141' 25/11/2023 09:35:30 am >> DELETE FROM ps_document_detail WHERE id_document = '89141' 25/11/2023 09:35: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 ( '89141' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 25/11/2023 09:35:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89141' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 25/11/2023 09:35:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89141' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 25/11/2023 10:09:01 am >> SELECT document_num FROM ps_document WHERE document_num = '137/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:09:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '137/A' , '2023-11-25' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7600.00' , '7600.00' , NOW() , NOW() ) 25/11/2023 10:09:01 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 = '89142' 25/11/2023 10:09:01 am >> DELETE FROM ps_document_detail WHERE id_document = '89142' 25/11/2023 10:09: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 ( '89142' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '304' , '0' , '4' , '25.00' , '25' , '0' , '0' , '7600.00' ) 25/11/2023 10:17:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3733' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:17: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' , '3733' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 25/11/2023 10:17: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 = '89143' 25/11/2023 10:17:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89143' 25/11/2023 10:17: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 ( '89143' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 25/11/2023 10:22:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3734' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:22:54 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' , '3734' , '2023-11-25' , '' , '0' , '0' , '0' , 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '399.67' , '396.93' , NOW() , NOW() ) 25/11/2023 10:22:54 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 = '89144' 25/11/2023 10:22:54 am >> DELETE FROM ps_document_detail WHERE id_document = '89144' 25/11/2023 10:22:54 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 ( '89144' , '10751' , 'TU MI PERDONI' , '12' , '-12' , '4' , '5.9000' , '5.9' , '0' , '10' , '63.72' ) 25/11/2023 10:22:55 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 ( '89144' , '14719' , 'TU MI AMI DAVVERO' , '15' , '-15' , '4' , '5.9000' , '5.9' , '0' , '10' , '79.65' ) 25/11/2023 10:22:55 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 ( '89144' , '10748' , 'TU MI CHIAMI PER NOME' , '35' , '-35' , '4' , '6.90' , '6.9' , '0' , '10' , '217.35' ) 25/11/2023 10:22:55 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 ( '89144' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 25/11/2023 10:22:55 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 ( '89144' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '15.20' ) 25/11/2023 10:28:56 am >> SELECT document_num FROM ps_document WHERE document_num = '290' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:28:56 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' , '290' , '2023-11-25' , '' , '2214' , '0' , '4671715' , 'P.ZZA S. FRANCESCO 84124 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 25/11/2023 10:28:56 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 = '89145' 25/11/2023 10:28:56 am >> DELETE FROM ps_document_detail WHERE id_document = '89145' 25/11/2023 10:28:57 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 ( '89145' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 25/11/2023 10:38:18 am >> SELECT document_num FROM ps_document WHERE document_num = '138/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:38:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '138/A' , '2023-11-25' , 'A' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 25/11/2023 10:38: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 = '89146' 25/11/2023 10:38:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89146' 25/11/2023 10:38: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 ( '89146' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 25/11/2023 10:40:49 am >> SELECT document_num FROM ps_document WHERE document_num = '138/A' AND id_document != '89146' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:40:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '138/A', document_date = '2023-11-25', document_letter = 'A', id_customer = '2402', id_supplier = '0', id_address = '4670818', 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 = '102.00', price_tax_excluded = '83.61', date_upd = NOW() WHERE id_document = '89146' 25/11/2023 10:40:49 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 = '89146' 25/11/2023 10:40:49 am >> DELETE FROM ps_document_detail WHERE id_document = '89146' 25/11/2023 10:40:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89146' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '102.00' ) 25/11/2023 10:42:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3735' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:42:54 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' , '3735' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 25/11/2023 10:42:54 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 = '89147' 25/11/2023 10:42:54 am >> DELETE FROM ps_document_detail WHERE id_document = '89147' 25/11/2023 10:42:54 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 ( '89147' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 25/11/2023 10:51:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3736' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:51:01 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' , '3736' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.90' , '52.28' , NOW() , NOW() ) 25/11/2023 10:51:01 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 = '89148' 25/11/2023 10:51:01 am >> DELETE FROM ps_document_detail WHERE id_document = '89148' 25/11/2023 10:51: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 ( '89148' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 25/11/2023 10:51: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 ( '89148' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 25/11/2023 10:51: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 ( '89148' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/11/2023 10:51: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 ( '89148' , '20523' , 'CROCE - 094 ALV' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 25/11/2023 10:52:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3737' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:52:22 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' , '3737' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 25/11/2023 10:52:22 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 = '89149' 25/11/2023 10:52:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89149' 25/11/2023 10:52:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89149' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '29.90' ) 25/11/2023 10:59:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3738' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 10:59:12 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' , '3738' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '27.07' , NOW() , NOW() ) 25/11/2023 10:59:12 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 = '89150' 25/11/2023 10:59:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89150' 25/11/2023 10:59:12 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 ( '89150' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 25/11/2023 10:59:12 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 ( '89150' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 25/11/2023 11:01:47 am >> DELETE FROM ps_document WHERE id_document = '88658' 25/11/2023 11:01:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88658' 25/11/2023 11:02:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3737' AND id_document != '89149' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 11:02:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3737', document_date = '2023-11-25', 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 = '29.90', price_tax_excluded = '24.51', date_upd = NOW() WHERE id_document = '89149' 25/11/2023 11:02:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89149' 25/11/2023 11:02:16 am >> DELETE FROM ps_document_detail WHERE id_document = '89149' 25/11/2023 11:02:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89149' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '29.9' , '24.508196721311' , '22' , '0' , '29.90' ) 25/11/2023 11:16:52 am >> DELETE FROM ps_document WHERE id_document = '89146' 25/11/2023 11:16:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89146' 25/11/2023 11:17:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2883' AND id_document != '87376' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 25/11/2023 11:17:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2883', document_date = '2023-09-22', 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 = '181.20', price_tax_excluded = '148.52', date_upd = NOW() WHERE id_document = '87376' 25/11/2023 11:17: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 = '87376' 25/11/2023 11:17:34 am >> DELETE FROM ps_document_detail WHERE id_document = '87376' 25/11/2023 11:17: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 ( '87376' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 25/11/2023 11:17: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 ( '87376' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 25/11/2023 11:17: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 ( '87376' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 25/11/2023 11:59:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3739' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 11:59:14 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' , '3739' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '20.25' , NOW() , NOW() ) 25/11/2023 11:59:14 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 = '89151' 25/11/2023 11:59:14 am >> DELETE FROM ps_document_detail WHERE id_document = '89151' 25/11/2023 11:59:14 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 ( '89151' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 25/11/2023 11:59:14 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 ( '89151' , '16265' , 'MIE PREGHIERE' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 25/11/2023 12:00:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '291' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 12:00:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '291' , '2023-11-25' , '' , '1178' , '0' , '4671042' , 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '50.58' , '50.58' , NOW() , NOW() ) 25/11/2023 12:00:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89152' 25/11/2023 12:00:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '89152' 25/11/2023 12:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89152' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 25/11/2023 12:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89152' , '11191' , 'VENITE CON ME 1 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 25/11/2023 12:02:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3740' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 12:02:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3740' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '14.82' , NOW() , NOW() ) 25/11/2023 12:02:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89153' 25/11/2023 12:02:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89153' 25/11/2023 12:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89153' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 25/11/2023 12:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89153' , '17499' , 'E NATO PER NOI - PAPA FRANCESCO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 25/11/2023 12:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89153' , '21737' , 'NOVENA ALLIMMACOLATA - BENEDETTO XVI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 25/11/2023 12:02:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89153' , '13033' , 'NOVENA ALLIMMACOLATA CONCEZIONE E AL SANTO NATALE - 8176' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 25/11/2023 12:05:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3741' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 12:05:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3741' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 25/11/2023 12:05:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89154' 25/11/2023 12:05:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89154' 25/11/2023 12:05:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89154' , '17290' , 'SPILLA PORTACIUCCIO' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 25/11/2023 12:17:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3742' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 12:17: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' , '3742' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '216.50' , '194.57' , NOW() , NOW() ) 25/11/2023 12:17: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 = '89155' 25/11/2023 12:17:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89155' 25/11/2023 12:17: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 ( '89155' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.04' , '0.04' , '0' , '0' , '38.40' ) 25/11/2023 12:17: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 ( '89155' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 25/11/2023 12:17: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 ( '89155' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 25/11/2023 12:17: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 ( '89155' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/11/2023 12:17: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 ( '89155' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 25/11/2023 12:17: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 ( '89155' , '21851' , 'CORPO CRISTO' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 25/11/2023 12:17: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 ( '89155' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 25/11/2023 12:17: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 ( '89155' , '21645' , 'LAUDATE DEUM' , '20' , '-20' , '4' , '1.90' , '1.9' , '0' , '5' , '36.20' ) 25/11/2023 12:18:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '99/A' AND id_document != '87578' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-04') 25/11/2023 12:18:14 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '99/A', document_date = '2023-10-04', document_letter = 'A', id_customer = '3030', id_supplier = '', id_address = '4671709', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '108.56', price_tax_excluded = '108.56', date_upd = NOW() WHERE id_document = '87578' 25/11/2023 12:18:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87578' 25/11/2023 12:18:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '87578' 25/11/2023 12:18: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 ( '87578' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 25/11/2023 12:18: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 ( '87578' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '5' , '3.23' ) 25/11/2023 12:18: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 ( '87578' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '50' , '-50' , '4' , '2.4000' , '2.4' , '0' , '15' , '102.00' ) 25/11/2023 12:18:24 pm >> DELETE FROM ps_document WHERE id_document = '89098' 25/11/2023 12:18:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89098' 25/11/2023 12:34:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3743' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-25') 25/11/2023 12:34:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3743' , '2023-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 25/11/2023 12:34: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 = '89156' 25/11/2023 12:34:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89156' 25/11/2023 12:34: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 ( '89156' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '0' , '5.00' )