24/01/2024 09:21:19 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 09:21:19 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' , '12/A' , '2024-01-24' , 'A' , '31' , '0' , '4670717' , 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '288.00' , '236.07' , NOW() , NOW() ) 24/01/2024 09:21:19 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 = '90063' 24/01/2024 09:21:19 am >> DELETE FROM ps_document_detail WHERE id_document = '90063' 24/01/2024 09:21: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 ( '90063' , '12814' , 'LIBRO DEI BATTEZZATI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 24/01/2024 09:21: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 ( '90063' , '12816' , 'LIBRO DEI DEFUNTI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 24/01/2024 09:21: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 ( '90063' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 24/01/2024 09:40:11 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 09:40:11 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' , '22' , '2024-01-24' , '' , '4075' , '0' , '4679231' , 'VIA PARROCO PALI 39020 SLUDERNO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '17.40' , '17.40' , NOW() , NOW() ) 24/01/2024 09:40:11 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 = '90064' 24/01/2024 09:40:11 am >> DELETE FROM ps_document_detail WHERE id_document = '90064' 24/01/2024 09:40:11 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 ( '90064' , '1872' , 'CELEBRARE LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 24/01/2024 09:40:11 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 ( '90064' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 24/01/2024 09:40:46 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4075' 24/01/2024 09:40:47 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4075' , '10' , '138' , '' , 'RITSCH' , 'LUIGIA' , 'VIA PARROCO PALI' , '' , '39020' , 'SLUDERNO' , '' , '' , '347 539 0413' , '' , '' , NOW() , NOW() ) 24/01/2024 09:40:47 am >> UPDATE ps_customer SET email = 'luigia.ritsch60@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4075' 24/01/2024 09:58:33 am >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 09:58: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' , '231' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '36.06' , NOW() , NOW() ) 24/01/2024 09:58: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 = '90065' 24/01/2024 09:58:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90065' 24/01/2024 09:58: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 ( '90065' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 24/01/2024 09:58: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 ( '90065' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 24/01/2024 09:59:28 am >> SELECT document_num FROM ps_document WHERE document_num = '232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 09:59:28 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' , '232' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 24/01/2024 09:59:28 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 = '90066' 24/01/2024 09:59:28 am >> DELETE FROM ps_document_detail WHERE id_document = '90066' 24/01/2024 09:59:28 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 ( '90066' , '11389' , 'VINO ROSSO DOLCE - 103' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 24/01/2024 10:30:14 am >> SELECT document_num FROM ps_document WHERE document_num = '114' AND id_document != '89913' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-11') 24/01/2024 10:30:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '114', document_date = '2024-01-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.00', price_tax_excluded = '13.74', date_upd = NOW() WHERE id_document = '89913' 24/01/2024 10:30: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 = '89913' 24/01/2024 10:30:14 am >> DELETE FROM ps_document_detail WHERE id_document = '89913' 24/01/2024 10:30: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 ( '89913' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 24/01/2024 10:30: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 ( '89913' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '' , '5.00' ) 24/01/2024 10:30: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 ( '89913' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 24/01/2024 10:33:32 am >> SELECT document_num FROM ps_document WHERE document_num = '233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 10:33:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '233' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 24/01/2024 10:33:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90067' 24/01/2024 10:33:32 am >> DELETE FROM ps_document_detail WHERE id_document = '90067' 24/01/2024 10:33:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90067' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 24/01/2024 10:34:04 am >> SELECT document_num FROM ps_document WHERE document_num = '234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 10:34:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '234' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 24/01/2024 10:34:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90068' 24/01/2024 10:34:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90068' 24/01/2024 10:34:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90068' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 24/01/2024 11:24:44 am >> SELECT document_num FROM ps_document WHERE document_num = '235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 11:24:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '235' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 24/01/2024 11:24:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90069' 24/01/2024 11:24:44 am >> DELETE FROM ps_document_detail WHERE id_document = '90069' 24/01/2024 11:24:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90069' , '6338' , 'MEDAGLIA OVALE DECORATA - SAN MICHELE - G291-D' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 24/01/2024 11:24:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90069' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 24/01/2024 11:57:03 am >> SELECT document_num FROM ps_document WHERE document_num = '236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 11:57:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '236' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 24/01/2024 11:57:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90070' 24/01/2024 11:57:03 am >> DELETE FROM ps_document_detail WHERE id_document = '90070' 24/01/2024 11:57:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90070' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 24/01/2024 12:35:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '89821' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-04') 24/01/2024 12:35:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '43', document_date = '2024-01-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.70', price_tax_excluded = '4.89', date_upd = NOW() WHERE id_document = '89821' 24/01/2024 12:35:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89821' 24/01/2024 12:35:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '89821' 24/01/2024 12:35:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89821' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 24/01/2024 12:35:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89821' , '21684' , 'C\'EST LA CONFIANCE ' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 24/01/2024 12:35:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '86' AND id_document != '89872' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-09') 24/01/2024 12:35:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '86', document_date = '2024-01-09', 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 = '245.29', price_tax_excluded = '203.81', date_upd = NOW() WHERE id_document = '89872' 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89872' 24/01/2024 12:35:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89872' 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '19560' , 'PERGAMENA 17X25' , '40' , '-40' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '28.00' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '10' , '-10' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '3.00' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '80' , '-80' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '40.00' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '15294' , 'BENEDIZIONI - RISURREZIONE B' , '500' , '-500' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '75.00' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '16667' , 'VIA CRUCIS' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 24/01/2024 12:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89872' , '21596' , 'CARTOLINE PREGHIERE' , '20' , '-20' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '6.00' ) 24/01/2024 12:36:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '146' AND id_document != '89948' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-15') 24/01/2024 12:36:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '146', document_date = '2024-01-15', 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 = '2.00', price_tax_excluded = '2.00', date_upd = NOW() WHERE id_document = '89948' 24/01/2024 12:36:13 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 = '89948' 24/01/2024 12:36:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89948' 24/01/2024 12:36:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89948' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 24/01/2024 12:36:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '90008' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 24/01/2024 12:36:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '190', document_date = '2024-01-18', 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 = '7.83', price_tax_excluded = '7.75', date_upd = NOW() WHERE id_document = '90008' 24/01/2024 12:36:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90008' 24/01/2024 12:36:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90008' 24/01/2024 12:36:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90008' , '19542' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 24/01/2024 12:36:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90008' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 24/01/2024 12:36:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90008' , '21684' , 'CEST LA CONFIANCE ' , '2' , '-2' , '4' , '1.25' , '1.25' , '0' , '0' , '2.50' ) 24/01/2024 12:37:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '191' AND id_document != '90009' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 24/01/2024 12:37:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '191', document_date = '2024-01-18', 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 = '11.50', price_tax_excluded = '10.13', date_upd = NOW() WHERE id_document = '90009' 24/01/2024 12:37: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 = '90009' 24/01/2024 12:37:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '90009' 24/01/2024 12:37: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 ( '90009' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 24/01/2024 12:37: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 ( '90009' , '21684' , 'CEST LA CONFIANCE ' , '3' , '-3' , '4' , '1.3' , '1.3' , '0' , '0' , '3.90' ) 24/01/2024 12:39:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4026' AND id_document != '89536' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-16') 24/01/2024 12:39:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4026', document_date = '2023-12-16', 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 = '205.00', price_tax_excluded = '191.48', date_upd = NOW() WHERE id_document = '89536' 24/01/2024 12:39:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89536' 24/01/2024 12:39:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89536' 24/01/2024 12:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89536' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 24/01/2024 12:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89536' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/01/2024 12:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89536' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 24/01/2024 12:39:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89536' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 24/01/2024 12:42:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '89370' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 24/01/2024 12:42:02 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '51', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca prof. Giuseppe Lazzaro in Santa Maria ad Martyres\r\nv. Adriano Falvo - 84127 Salerno\r\n', 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 = '2596.00', price_tax_excluded = '2596.00', date_upd = NOW() WHERE id_document = '89370' 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89370' 24/01/2024 12:42:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89370' 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '8562' , 'PROMESSE DEL SACRO CUORE DI GESÙ' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '0' , '6.50' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '22004' , 'PREGHIERA DEL CRISTIANO - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21116' , 'LIBERTA\' DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17001' , 'SPERANZA NON E\' MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 24/01/2024 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 24/01/2024 12:42: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 ( '89370' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/01/2024 12:42: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 ( '89370' , '16442' , 'CARLO ACUTIS L\'AMICO DI GESU\' - 8865' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 24/01/2024 12:42: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 ( '89370' , '22016' , 'COMANDANTE ALFA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/01/2024 12:42: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 ( '89370' , '22036' , 'VANGELO DI GIOVANNI COMM. ESEGETICO' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 24/01/2024 12:42: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 ( '89370' , '22039' , 'VANGELO DI LUCA - G. ROSSE' , '1' , '-1' , '4' , '69.5000' , '69.5' , '0' , '0' , '69.50' ) 24/01/2024 12:42: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 ( '89370' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '0' , '32.00' ) 24/01/2024 12:42: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 ( '89370' , '22044' , 'GIOVANNI - R.E. BROWN' , '1' , '-1' , '4' , '66.5000' , '66.5' , '0' , '0' , '66.50' ) 24/01/2024 12:42: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 ( '89370' , '22043' , 'MATTEO - R. FABRIS' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 24/01/2024 12:42: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 ( '89370' , '22017' , 'UOMO DI DIO - A. SCHNEIDER' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 24/01/2024 12:42: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 ( '89370' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 24/01/2024 12:42: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 ( '89370' , '22057' , 'SEQUELA CHRISTI - C.M. MARTINI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 24/01/2024 12:42: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 ( '89370' , '19737' , 'CARLO MARIA MARTINI - L. PACOMIO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 24/01/2024 12:42: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 ( '89370' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1274.2' , '1274.2' , '0' , '0' , '1274.20' ) 24/01/2024 12:42:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '220' AND id_document != '90049' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-20') 24/01/2024 12:42:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '220', document_date = '2024-01-20', 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 = '23.75', price_tax_excluded = '23.75', date_upd = NOW() WHERE id_document = '90049' 24/01/2024 12:42:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90049' 24/01/2024 12:42:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '90049' 24/01/2024 12:42:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90049' , '21684' , 'C\'EST LA CONFIANCE ' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '5' , '18.10' ) 24/01/2024 12:42:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90049' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.65' , '5.65' , '0' , '0' , '5.65' ) 24/01/2024 12:51:44 pm >> DELETE FROM ps_document WHERE id_document = '90063' 24/01/2024 12:51:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90063' 24/01/2024 12:53:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 12:53:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '12/A' , '2024-01-24' , 'A' , '31' , '0' , '4670717' , 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1352.40' , '1184.26' , NOW() , NOW() ) 24/01/2024 12:53: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 = '90071' 24/01/2024 12:53:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90071' 24/01/2024 12:53: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 ( '90071' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.1475' , '22' , '40' , '54.00' ) 24/01/2024 12:53: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 ( '90071' , '0' , 'spediti il 21/03/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/01/2024 12:53: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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '2' , '-2' , '1' , '40.0000' , '32.7869' , '22' , '40' , '48.00' ) 24/01/2024 12:53: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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.7869' , '22' , '40' , '96.00' ) 24/01/2024 12:53: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 ( '90071' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.7869' , '22' , '40' , '96.00' ) 24/01/2024 12:53: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.3934' , '22' , '40' , '72.00' ) 24/01/2024 12:53: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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '2' , '-2' , '1' , '40.0000' , '32.7869' , '22' , '40' , '48.00' ) 24/01/2024 12:53: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 ( '90071' , '0' , 'spedito il 05/04/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/01/2024 12:53: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 ( '90071' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '200' , '-200' , '4' , '3.5000' , '3.5' , '0' , '40' , '420.00' ) 24/01/2024 12:53: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 ( '90071' , '0' , 'spedito 1/6/23' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/01/2024 12:53: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.3934' , '22' , '40' , '72.00' ) 24/01/2024 12:53: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 ( '90071' , '0' , 'spedito 2/11/23' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 24/01/2024 12:53: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.3934' , '22' , '40' , '72.00' ) 24/01/2024 12:53: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 ( '90071' , '12817' , 'LIBRO DEI MATRIMONI' , '3' , '-3' , '1' , '40.0000' , '32.7869' , '22' , '40' , '72.00' ) 24/01/2024 12:53: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 ( '90071' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '1' , '12.0000' , '9.8361' , '22' , '40' , '14.40' ) 24/01/2024 12:53: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 ( '90071' , '' , 'spediti 24/01/2024' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 24/01/2024 12:53: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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 24/01/2024 12:53: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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 24/01/2024 12:53: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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '96.00' ) 24/01/2024 12:55:19 pm >> DELETE FROM ps_document WHERE id_document = '81217' 24/01/2024 12:55:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '81217' 24/01/2024 03:06:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3839' AND id_document != '89287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 24/01/2024 03:06:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3839', document_date = '2023-12-02', 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 = '230.00', price_tax_excluded = '188.52', date_upd = NOW() WHERE id_document = '89287' 24/01/2024 03:06: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 = '89287' 24/01/2024 03:06:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '89287' 24/01/2024 03:06: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 ( '89287' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '25.00' ) 24/01/2024 03:06: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 ( '89287' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 24/01/2024 03:06: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 ( '89287' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 24/01/2024 03:06: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 ( '89287' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '85' , '69.672131147541' , '22' , '0' , '85.00' ) 24/01/2024 03:06: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 ( '89287' , '19150' , 'MOCCOLO 70X200' , '6' , '-6' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '45.00' ) 24/01/2024 03:42:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 03:42:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '237' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 24/01/2024 03:42:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90072' 24/01/2024 03:42:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90072' 24/01/2024 03:42:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90072' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 24/01/2024 04:08:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 04:08:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '238' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 24/01/2024 04:08:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90073' 24/01/2024 04:08:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '90073' 24/01/2024 04:08:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90073' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '24' , '-24' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '36.00' ) 24/01/2024 04:15:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 04:15:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '239' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 24/01/2024 04:15:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90074' 24/01/2024 04:15:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '90074' 24/01/2024 04:15:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90074' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 24/01/2024 04:29:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 04:29:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '240' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 24/01/2024 04:29:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90075' 24/01/2024 04:29:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90075' 24/01/2024 04:29:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90075' , '21087' , 'BRACCIALE ARG. EMATITE - 1639CAV' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 24/01/2024 04:58:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '89319' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-04') 24/01/2024 04:58:56 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '50', document_date = '2023-12-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670947', address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI', address2 = '', note = 'RESO AL FORNITORE per merce non conforme', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '89319' 24/01/2024 04:58:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89319' 24/01/2024 04:58:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89319' 24/01/2024 04:58:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89319' , '20321' , 'CASULA TESSUTO OPERATO - 65/023957' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 24/01/2024 05:00:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '4020' AND id_document != '89529' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-16') 24/01/2024 05:00:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4020', document_date = '2023-12-16', 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 = '510.00', price_tax_excluded = '418.03', date_upd = NOW() WHERE id_document = '89529' 24/01/2024 05:00:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89529' 24/01/2024 05:00:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89529' 24/01/2024 05:00:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89529' , '20321' , 'CASULA TESSUTO OPERATO - 65/023957' , '1' , '-1' , '1' , '510' , '418.03278688525' , '22' , '0' , '510.00' ) 24/01/2024 05:01:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '89319' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-04') 24/01/2024 05:01:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '50', document_date = '2023-12-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670947', address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '89319' 24/01/2024 05:01:00 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 = '89319' 24/01/2024 05:01:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89319' 24/01/2024 05:01:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89319' , '20321' , 'RESO AL FORNITORE per merce non conforme' , '1' , '-1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 24/01/2024 05:30:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '89917' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-12') 24/01/2024 05:30:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2024-01-12', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 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 = '106.50', price_tax_excluded = '94.72', date_upd = NOW() WHERE id_document = '89917' 24/01/2024 05:30:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89917' 24/01/2024 05:30:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '89917' 24/01/2024 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 24/01/2024 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 24/01/2024 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 24/01/2024 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/01/2024 06:00:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '97' , '2024-01-24' , '' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 24/01/2024 06:00: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 = '90076' 24/01/2024 06:00:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90076' 24/01/2024 06:00: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 ( '90076' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 24/01/2024 06:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '159' 24/01/2024 06:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '159' , '1' ) 24/01/2024 07:06:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 07:06: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' , '241' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.98' , '17.98' , NOW() , NOW() ) 24/01/2024 07:06: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 = '90077' 24/01/2024 07:06:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90077' 24/01/2024 07:06: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 ( '90077' , '5457' , 'IO SONO CON VOI 1 PARTE' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '5' , '7.98' ) 24/01/2024 07:06: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 ( '90077' , '21131' , 'GIOCO DEL BON TON' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 24/01/2024 07:11:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 24/01/2024 07:11:02 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' , '242' , '2024-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '9.99' , NOW() , NOW() ) 24/01/2024 07:11:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90078' 24/01/2024 07:11:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '90078' 24/01/2024 07:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90078' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/01/2024 07:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90078' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/01/2024 07:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90078' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' )