12/01/2023 08:33:38 am >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 08:33:38 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' , '6' , '2023-01-12' , '' , '3775' , '0' , '4671825' , 'via del Casale di San Pio V , 11/13 00165 Roma ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '94.10' , '94.10' , NOW() , NOW() ) 12/01/2023 08:33:38 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 = '78779' 12/01/2023 08:33:38 am >> DELETE FROM ps_document_detail WHERE id_document = '78779' 12/01/2023 08:33:38 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 ( '78779' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '60' , '-60' , '4' , '1.6000' , '1.6' , '0' , '5' , '91.20' ) 12/01/2023 08:33:38 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 ( '78779' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 12/01/2023 08:33:53 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2023-01-12' WHERE id_order = '412' 12/01/2023 08:33:53 am >> DELETE FROM ps_document WHERE document_num = '412' AND id_document_type = '28' 12/01/2023 08:34:27 am >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '78779' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 08:34:27 am >> UPDATE ps_document SET id_document_type = '21', document_num = '6', document_date = '2023-01-12', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4671825', address1 = 'via del Casale di San Pio V , 11/13 00165 Roma ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '94.10', price_tax_excluded = '94.10', date_upd = NOW() WHERE id_document = '78779' 12/01/2023 08:34:27 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 = '78779' 12/01/2023 08:34:27 am >> DELETE FROM ps_document_detail WHERE id_document = '78779' 12/01/2023 08:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78779' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '60' , '-60' , '4' , '1.6000' , '1.6' , '0' , '5' , '91.20' ) 12/01/2023 08:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78779' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 12/01/2023 09:19:29 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3775' 12/01/2023 09:19:29 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 ( '3775' , '10' , '208' , 'CONGREGAZIONE SUORE DI SAN GIOVANNI BATTISTA' , 'ROMANO' , 'SUOR CAROLINA' , 'VIA DEL CASALE DI SAN PIO V, 11/13' , '' , '00165' , 'ROMA ' , '' , '' , '3351432955 ' , '00993241009' , '01405490580' , NOW() , NOW() ) 12/01/2023 09:19:29 am >> UPDATE ps_customer SET email = 'segreteria.sgb@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3775' 12/01/2023 09:22:46 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3971' 12/01/2023 09:22:46 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 ( '3971' , '10' , '152' , 'PARR. S. MARIA MAGGIORE' , 'MARRA' , 'DON GIUSEPPE' , 'CORSO GIOVE' , '' , '88837' , 'PETILIA POLICASTRO' , '' , '' , '3332786101' , '' , '91003940797' , NOW() , NOW() ) 12/01/2023 09:22:46 am >> UPDATE ps_customer SET email = 's.marra.giuseppe@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3971' 12/01/2023 09:23:15 am >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 09:23:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '7' , '2023-01-12' , '' , '3971' , '0' , '4678096' , 'CORSO GIOVE 88837 PETILIA POLICASTRO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '107.03' , '107.03' , NOW() , NOW() ) 12/01/2023 09:23:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78780' 12/01/2023 09:23:15 am >> DELETE FROM ps_document_detail WHERE id_document = '78780' 12/01/2023 09:23:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78780' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 12/01/2023 09:23:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78780' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 12/01/2023 09:23:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78780' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 12/01/2023 09:23:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78780' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 12/01/2023 10:12:55 am >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 10:12:55 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' , '117' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.65' , '8.77' , NOW() , NOW() ) 12/01/2023 10:12:55 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 = '78781' 12/01/2023 10:12:55 am >> DELETE FROM ps_document_detail WHERE id_document = '78781' 12/01/2023 10:12:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78781' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/01/2023 10:12:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78781' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 12/01/2023 10:15:09 am >> SELECT document_num FROM ps_document WHERE document_num = '118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 10:15:09 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' , '118' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '9.00' , NOW() , NOW() ) 12/01/2023 10:15:09 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 = '78782' 12/01/2023 10:15:09 am >> DELETE FROM ps_document_detail WHERE id_document = '78782' 12/01/2023 10:15:09 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 ( '78782' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '-3' , '4' , '3' , '3' , '0' , '0' , '9.00' ) 12/01/2023 11:02:21 am >> SELECT document_num FROM ps_document WHERE document_num = '35/A' AND id_document != '28276' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-04-23') 12/01/2023 11:02:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '35/A', document_date = '2021-04-23', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO CASULA € 950,00 + 100,00 23/12 + 04/01 € 100,00+12/01 € 100,00', 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 = '1400.00', price_tax_excluded = '1147.54', date_upd = NOW() WHERE id_document = '28276' 12/01/2023 11:02:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '28276' 12/01/2023 11:02:21 am >> DELETE FROM ps_document_detail WHERE id_document = '28276' 12/01/2023 11:02:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '28276' , '14716' , 'CASULA - COT/VISCOSA CON TESSUTI A TELAIO******' , '1' , '-1' , '1' , '1400.0000' , '1147.5409836066' , '22' , '0' , '1400.00' ) 12/01/2023 11:13:01 am >> SELECT document_num FROM ps_document WHERE document_num = '119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 11:13:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '119' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 12/01/2023 11:13:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78783' 12/01/2023 11:13:01 am >> DELETE FROM ps_document_detail WHERE id_document = '78783' 12/01/2023 11:13:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78783' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 12/01/2023 11:23:54 am >> SELECT document_num FROM ps_document WHERE document_num = '120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 11:23:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '120' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '31.43' , NOW() , NOW() ) 12/01/2023 11:23:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78784' 12/01/2023 11:23:54 am >> DELETE FROM ps_document_detail WHERE id_document = '78784' 12/01/2023 11:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '20612' , 'LIBRO CHE CI LEGGE - C. MIRIANO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 11:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 11:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15.8' , '12.950819672131' , '22' , '0' , '15.80' ) 12/01/2023 11:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 11:45:28 am >> SELECT document_num FROM ps_document WHERE document_num = '121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 11:45: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' , '121' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.35' , '64.16' , NOW() , NOW() ) 12/01/2023 11:45: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 = '78785' 12/01/2023 11:45:28 am >> DELETE FROM ps_document_detail WHERE id_document = '78785' 12/01/2023 11:45: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 ( '78785' , '10501' , 'TECA STANDARD IHS ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 12/01/2023 11:45: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 ( '78785' , '8197' , 'PORTATECA - 059' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 12/01/2023 11:45: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 ( '78785' , '15483' , 'CROCE - 075 ALV' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 11:45: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 ( '78785' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 12/01/2023 11:45: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 ( '78785' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/01/2023 11:45: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 ( '78785' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 12/01/2023 11:45: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 ( '78785' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/01/2023 11:47:49 am >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 11:47:49 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' , '122' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '17.84' , NOW() , NOW() ) 12/01/2023 11:47:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78786' 12/01/2023 11:47:49 am >> DELETE FROM ps_document_detail WHERE id_document = '78786' 12/01/2023 11:47:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78786' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/01/2023 11:47:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78786' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 12/01/2023 12:09:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 12:09:50 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' , '123' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.50' , '55.50' , NOW() , NOW() ) 12/01/2023 12:09:50 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 = '78787' 12/01/2023 12:09:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '78787' 12/01/2023 12:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78787' , '3878' , 'ENTRARE NELLA DOMENICA DALLA PORTA - ANNO A - R. PAGANELLI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 12/01/2023 12:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78787' , '10202' , 'STARE NELLA DOMENICA ALLA MENSA ... - R. PAGANELLI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 12:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78787' , '1410' , 'BUONA NOTIZIA PER TE! - ANNO B - A. COMASTRI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 12/01/2023 12:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78787' , '20578' , 'TOTUM AMORIS EST ' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '' , '6.00' ) 12/01/2023 12:09:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78787' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '' , '5.80' ) 12/01/2023 12:36:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 12:36: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' , '124' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.38' , '21.38' , NOW() , NOW() ) 12/01/2023 12:36: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 = '78788' 12/01/2023 12:36:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '78788' 12/01/2023 12:36: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 ( '78788' , '20616' , 'VANGELO DELLA GIOIA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 12/01/2023 12:36: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 ( '78788' , '20615' , 'OGNI GIORNO UNALBA' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '5' , '11.88' ) 12/01/2023 12:38:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 12:38:53 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' , '125' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 12/01/2023 12:38:53 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 = '78789' 12/01/2023 12:38:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '78789' 12/01/2023 12:38:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78789' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 12:40:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 12:40:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '126' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 12/01/2023 12:40:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78790' 12/01/2023 12:40:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '78790' 12/01/2023 12:40:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78790' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 12/01/2023 02:48:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '100/A' AND id_document != '74857' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-24') 12/01/2023 02:48:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '100/A', document_date = '2022-11-24', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI', 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 = '159.40', price_tax_excluded = '153.99', date_upd = NOW() WHERE id_document = '74857' 12/01/2023 02:48: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 = '74857' 12/01/2023 02:48:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '74857' 12/01/2023 02:48: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 ( '74857' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 12/01/2023 02:48: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 ( '74857' , '9165' , 'ROSARIO PER SCOPRIRE IL VOLTO...' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:48: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 ( '74857' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L.M. EPICOCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 12/01/2023 02:48: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 ( '74857' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '0' , '2.0000' , '2' , '0' , '0' , '2.00' ) 12/01/2023 02:48: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 ( '74857' , '20090' , 'CALENDARIO 2023 - 40812' , '1' , '-1' , '0' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:48: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 ( '74857' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:48: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 ( '74857' , '20254' , 'VERSO IL NATALE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 12/01/2023 02:48: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 ( '74857' , '18357' , 'MIE PREGHIERINE N.E.' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '0' , '6.00' ) 12/01/2023 02:48: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 ( '74857' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:48: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 ( '74857' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 12/01/2023 02:48: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 ( '74857' , '9992' , 'SIGNORE, DACCI SEMPRE ...' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:48: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 ( '74857' , '20087' , 'CALENDARIO GESU CONFIDO IN TE 2023 - 8081' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 12/01/2023 02:48: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 ( '74857' , '0' , 'ORA E\' IL TEMPO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 12/01/2023 02:48: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 ( '74857' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 02:48: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 ( '74857' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:48: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 ( '74857' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:48: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 ( '74857' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 12/01/2023 02:48: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 ( '74857' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:48: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 ( '74857' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 12/01/2023 02:50:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '76125' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-06') 12/01/2023 02:50:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2022-12-06', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', 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 = '224.00', price_tax_excluded = '224.00', date_upd = NOW() WHERE id_document = '76125' 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76125' 12/01/2023 02:50:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '76125' 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '17795' , 'MIRACOLOSA cm 20 - 023 mir/20' , '1' , '-1' , '0' , '23.5000' , '23.5' , '0' , '0' , '23.50' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '17956' , 'SAN GIUSEPPE DORMIENTE CM 30 - 4041' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '19921' , 'AGENDA 2023 - 40809' , '1' , '-1' , '0' , '7.0000' , '7' , '0' , '0' , '7.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '0' , '5/1/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 12/01/2023 02:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '0' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 12/01/2023 02:51:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '100/A' AND id_document != '74857' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-24') 12/01/2023 02:51:01 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '100/A', document_date = '2022-11-24', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'LIBRI', 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 = '139.40', price_tax_excluded = '133.99', date_upd = NOW() WHERE id_document = '74857' 12/01/2023 02:51: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 = '74857' 12/01/2023 02:51:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '74857' 12/01/2023 02:51: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 ( '74857' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 12/01/2023 02:51: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 ( '74857' , '9165' , 'ROSARIO PER SCOPRIRE IL VOLTO...' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:51: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 ( '74857' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L.M. EPICOCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 12/01/2023 02:51: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 ( '74857' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '0' , '2.0000' , '2' , '0' , '0' , '2.00' ) 12/01/2023 02:51: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 ( '74857' , '20090' , 'CALENDARIO 2023 - 40812' , '1' , '-1' , '0' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:51: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 ( '74857' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:51: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 ( '74857' , '20254' , 'VERSO IL NATALE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 12/01/2023 02:51: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 ( '74857' , '18357' , 'MIE PREGHIERINE N.E.' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '0' , '6.00' ) 12/01/2023 02:51: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 ( '74857' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:51: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 ( '74857' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 12/01/2023 02:51: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 ( '74857' , '9992' , 'SIGNORE, DACCI SEMPRE ...' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:51: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 ( '74857' , '20087' , 'CALENDARIO GESU CONFIDO IN TE 2023 - 8081' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 12/01/2023 02:51: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 ( '74857' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 02:51: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 ( '74857' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:51: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 ( '74857' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 02:51: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 ( '74857' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 12/01/2023 02:51: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 ( '74857' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 02:51: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 ( '74857' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 12/01/2023 03:08:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '99/A' AND id_document != '74855' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-24') 12/01/2023 03:08:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '99/A', document_date = '2022-11-24', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', address2 = '', note = 'OGGETTI', 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 = '608.90', price_tax_excluded = '607.06', date_upd = NOW() WHERE id_document = '74855' 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74855' 12/01/2023 03:08:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '74855' 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '9486' , 'S. MICHELE ARC. BABY - 023 SMK/9 BB' , '1' , '-1' , '0' , '11.0000' , '11' , '0' , '0' , '11.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB' , '2' , '-2' , '0' , '9.0000' , '9' , '0' , '0' , '18.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '16125' , 'MARIA CHE SCIOGLIE I NODI BABY - MSN9-BB' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '13111' , 'FATIMA BABY - 023 FAT 9 BB' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '13540' , 'ANGELO RESINA CON CUORE - 4202' , '1' , '-1' , '0' , '8.0000' , '8' , '0' , '0' , '8.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19601' , 'ANGELO ALI TORTORA - 4231' , '1' , '-1' , '0' , '9.0000' , '9' , '0' , '0' , '9.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19317' , 'ANGELO CON CUORE TORTORA - 4228' , '1' , '-1' , '0' , '5.3000' , '5.3' , '0' , '0' , '5.30' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.0000' , '28' , '0' , '0' , '28.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '13347' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '1' , '-1' , '0' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '9273' , 'SACRA FAMIGLIA EFFETTO PIETRA 10X15 - P374' , '1' , '-1' , '0' , '11.0000' , '11' , '0' , '0' , '11.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '14876' , 'ANGELO IN RESINA PREGHIERA CM 9 - KS124-P' , '3' , '-3' , '0' , '7.8000' , '7.8' , '' , '0' , '23.40' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '16771' , 'QUADRO DECORATO' , '1' , '-1' , '0' , '7.3000' , '7.3' , '0' , '0' , '7.30' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '1' , '-1' , '0' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '2' , '-2' , '0' , '4.5000' , '4.5' , '0' , '0' , '9.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19883' , 'ALBERO DELLA VITA LUMINOSO - 4425' , '1' , '-1' , '0' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '0' , '12.2000' , '12.2' , '' , '0' , '12.20' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '16328' , 'GRUPPO NATIVITA CM 20' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 12/01/2023 03:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '15072' , 'PRESEPE ALABASTRO - 210' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '13553' , 'CONFEZIONE BRACCIALE DELL\'AMICIZIA - 3157' , '1' , '-1' , '0' , '2.5000' , '2.5' , '' , '0' , '2.50' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '5' , '-5' , '0' , '11.5000' , '11.5' , '0' , '0' , '57.50' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '8440' , 'PRESEPE COMPONIBILE IN MDF CON 9 PZ ' , '1' , '-1' , '0' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '20000' , 'GESU BAMBINO CM 15 - BJ140-15E' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19999' , 'GESU BAMBINO CON AUREOLA CM 15 - BJ148-15' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '13134' , 'BAMBINO GESU BETLEMME - OCCHI DI VETRO - P514' , '1' , '-1' , '0' , '14.0000' , '14' , '0' , '0' , '14.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '17568' , 'BAMBINO IN RESINA FASCIA ORO - PB13629' , '1' , '-1' , '0' , '15.0000' , '15' , '0' , '0' , '15.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '0' , '15.0000' , '15' , '0' , '0' , '15.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '0' , '23.0000' , '23' , '0' , '0' , '23.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19075' , 'GLOBO BAMBINO - PB9876' , '2' , '-2' , '0' , '2.4000' , '2.4' , '0' , '0' , '4.80' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '20004' , 'GESU BAMBINO CM 20 - BJ142-20E' , '1' , '-1' , '0' , '21.0000' , '21' , '0' , '0' , '21.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '0' , '6.0000' , '6' , '' , '0' , '6.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '2' , '-2' , '0' , '8.0000' , '8' , '0' , '0' , '16.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '18223' , 'CORONA MISSIONARIA - R102' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '20071' , 'ROSARIO MISSIONARIO MM8' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 03:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74855' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 12/01/2023 03:09:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '76125' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-06') 12/01/2023 03:09:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2022-12-06', document_letter = 'A', id_customer = '302', id_supplier = '', id_address = '4672778', address1 = 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA', 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 = '165.50', price_tax_excluded = '165.50', date_upd = NOW() WHERE id_document = '76125' 12/01/2023 03:09:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76125' 12/01/2023 03:09:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '76125' 12/01/2023 03:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 03:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '0' , '19.0000' , '19' , '0' , '0' , '19.00' ) 12/01/2023 03:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '19921' , 'AGENDA 2023 - 40809' , '1' , '-1' , '0' , '7.0000' , '7' , '0' , '0' , '7.00' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '0' , '5/1/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 12/01/2023 03:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76125' , '0' , 'MIRACOLOSA CM 30' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 12/01/2023 03:18:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 03:18:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '127' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.40' , '33.41' , NOW() , NOW() ) 12/01/2023 03:18:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78791' 12/01/2023 03:18:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '78791' 12/01/2023 03:18:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78791' , '20432' , 'PARTICOLA 2MM - P2M250' , '6' , '-6' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '27.00' ) 12/01/2023 03:18:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78791' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 12/01/2023 03:18:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78791' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 12/01/2023 03:23:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 03:23: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' , '128' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '847.28' , '847.28' , NOW() , NOW() ) 12/01/2023 03:23: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 = '78792' 12/01/2023 03:23:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '78792' 12/01/2023 03:23:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78792' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '0' , '786.4' , '786.4' , '' , '15' , '668.44' ) 12/01/2023 03:23:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78792' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '210.4' , '210.4' , '0' , '15' , '178.84' ) 12/01/2023 03:23:25 pm >> DELETE FROM ps_document WHERE id_document = '78792' 12/01/2023 03:23:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '78792' 12/01/2023 03:49:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3619' AND id_document != '74885' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 12/01/2023 03:49:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3619', document_date = '2022-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '188.00', price_tax_excluded = '154.10', date_upd = NOW() WHERE id_document = '74885' 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74885' 12/01/2023 03:49:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '74885' 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74885' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74885' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74885' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74885' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74885' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '15' , '34.00' ) 12/01/2023 03:49:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74885' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 12/01/2023 03:49:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '75453' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 12/01/2023 03:49:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3661', document_date = '2022-11-29', 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 = '68.00', price_tax_excluded = '58.48', date_upd = NOW() WHERE id_document = '75453' 12/01/2023 03:49:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75453' 12/01/2023 03:49:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '75453' 12/01/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 12/01/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 12/01/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 12/01/2023 03:49:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.8000' , '4.7540983606557' , '22' , '0' , '5.80' ) 12/01/2023 03:52:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3811' AND id_document != '76689' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 12/01/2023 03:52:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3811', document_date = '2022-12-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.50', price_tax_excluded = '21.72', date_upd = NOW() WHERE id_document = '76689' 12/01/2023 03:52:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76689' 12/01/2023 03:52:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '76689' 12/01/2023 03:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/01/2023 03:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '19921' , 'AGENDA 2023 - 40809' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 12/01/2023 03:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 12/01/2023 03:52:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '19075' , 'GLOBO BAMBINO - PB9876' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 12/01/2023 03:52:52 pm >> DELETE FROM ps_document WHERE id_document = '76125' 12/01/2023 03:52:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '76125' 12/01/2023 03:52:54 pm >> DELETE FROM ps_document WHERE id_document = '74861' 12/01/2023 03:52:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '74861' 12/01/2023 03:52:56 pm >> DELETE FROM ps_document WHERE id_document = '74857' 12/01/2023 03:52:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '74857' 12/01/2023 03:52:58 pm >> DELETE FROM ps_document WHERE id_document = '74855' 12/01/2023 03:52:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '74855' 12/01/2023 03:53:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '74897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 12/01/2023 03:53:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3628', document_date = '2022-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '215.00', price_tax_excluded = '176.23', date_upd = NOW() WHERE id_document = '74897' 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74897' 12/01/2023 03:53:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '74897' 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13506' , 'SANTO ROSARIO' , '60' , '-60' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '18.00' ) 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '20173' , 'ANGELO IN PREGHIERA - R17' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13363' , 'CORONA MM 6 ' , '60' , '-60' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '174.00' ) 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '13365' , 'SCATOLA 6x4' , '60' , '-60' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '15.00' ) 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 03:53:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74897' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/01/2023 03:55:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '75453' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 12/01/2023 03:55:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3661', document_date = '2022-11-29', 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 = '68.00', price_tax_excluded = '58.48', date_upd = NOW() WHERE id_document = '75453' 12/01/2023 03:55:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75453' 12/01/2023 03:55:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '75453' 12/01/2023 03:55:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 12/01/2023 03:55:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 12/01/2023 03:55:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '20172' , 'ANGELO MUSICANTE CM 10 - R12' , '4' , '-4' , '1' , '4' , '3.2786885245902' , '22' , '0' , '16.00' ) 12/01/2023 03:55:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75453' , '20179' , 'ANGELO IN RESINA CM 6 - AR94' , '10' , '-10' , '1' , '1.98' , '1.6229508196721' , '22' , '0' , '19.80' ) 12/01/2023 03:56:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3668' AND id_document != '75463' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 12/01/2023 03:56:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3668', document_date = '2022-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.50', price_tax_excluded = '10.25', date_upd = NOW() WHERE id_document = '75463' 12/01/2023 03:56:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75463' 12/01/2023 03:56:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '75463' 12/01/2023 03:56: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 ( '75463' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 12/01/2023 03:56: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 ( '75463' , '20175' , 'ANGELO CM 9 - AR79' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 12/01/2023 03:56:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3763' AND id_document != '76104' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-05') 12/01/2023 03:56:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3763', document_date = '2022-12-05', 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 = '56.50', price_tax_excluded = '47.09', date_upd = NOW() WHERE id_document = '76104' 12/01/2023 03:56: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 = '76104' 12/01/2023 03:56:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '76104' 12/01/2023 03:56: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 ( '76104' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/01/2023 03:56: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 ( '76104' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/01/2023 03:56: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 ( '76104' , '17738' , 'CAMPANELLO CM 11' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 12/01/2023 03:56: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 ( '76104' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 12/01/2023 03:56: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 ( '76104' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '9' , '-9' , '1' , '3.4000' , '2.7868852459016' , '22' , '0' , '30.60' ) 12/01/2023 03:56: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 ( '76104' , '20175' , 'ANGELO CM 9 - AR79' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 12/01/2023 03:57:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3745' AND id_document != '75567' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-05') 12/01/2023 03:57:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3745', document_date = '2022-12-05', 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 = '12.30', date_upd = NOW() WHERE id_document = '75567' 12/01/2023 03:57: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 = '75567' 12/01/2023 03:57:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '75567' 12/01/2023 03:57: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 ( '75567' , '17520' , 'LUMINO SMERALDO' , '25' , '-25' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '12.50' ) 12/01/2023 03:57: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 ( '75567' , '20175' , 'ANGELO CM 9 - AR79' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/01/2023 03:57:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '4021' AND id_document != '77460' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-21') 12/01/2023 03:57:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4021', document_date = '2022-12-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.80', price_tax_excluded = '3.11', date_upd = NOW() WHERE id_document = '77460' 12/01/2023 03:57:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77460' 12/01/2023 03:57:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '77460' 12/01/2023 03:57:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77460' , '20175' , 'ANGELO CM 9 - AR79' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 12/01/2023 03:58:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3015' AND id_document != '65800' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-12') 12/01/2023 03:58:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3015', document_date = '2022-10-12', 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 = '154.00', price_tax_excluded = '132.81', date_upd = NOW() WHERE id_document = '65800' 12/01/2023 03:58:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65800' 12/01/2023 03:58:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '65800' 12/01/2023 03:58:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65800' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 12/01/2023 03:58:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65800' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 12/01/2023 03:58:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65800' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 12/01/2023 03:58:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65800' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '5' , '-5' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '13.50' ) 12/01/2023 03:58:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65800' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '1' , '-1' , '1' , '4.1' , '3.3606557377049' , '22' , '0' , '4.10' ) 12/01/2023 03:58:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3462' AND id_document != '73118' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 12/01/2023 03:58:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3462', document_date = '2022-11-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 = '62.50', price_tax_excluded = '56.91', date_upd = NOW() WHERE id_document = '73118' 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73118' 12/01/2023 03:58:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '73118' 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '31.5000' , '31.5' , '0' , '0' , '31.50' ) 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '10507' , 'TEGOLA NASCITA - AZZURRA - OGGETTI' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 12/01/2023 03:58:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73118' , '19317' , 'ANGELO CON CUORE TORTORA - 4228' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 12/01/2023 04:00:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3494' AND id_document != '73175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 12/01/2023 04:00:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3494', document_date = '2022-11-17', 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.50', price_tax_excluded = '12.70', date_upd = NOW() WHERE id_document = '73175' 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73175' 12/01/2023 04:00:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '73175' 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '1' , '-1' , '1' , '4.4000' , '3.6065573770492' , '22' , '0' , '4.40' ) 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '18223' , 'CORONA MISSIONARIA - R102' , '2' , '-2' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '1.30' ) 12/01/2023 04:00:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '20071' , 'ROSARIO MISSIONARIO MM8' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 04:10:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '74854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-24') 12/01/2023 04:10:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3595', document_date = '2022-11-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.20', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '74854' 12/01/2023 04:10: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 = '74854' 12/01/2023 04:10:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '74854' 12/01/2023 04:10: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 ( '74854' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '2' , '-2' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '2.20' ) 12/01/2023 04:10: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 ( '74854' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '28' , '-28' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '5.60' ) 12/01/2023 04:10: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 ( '74854' , '16989' , 'QUADRETTO SMUSSATO 7X10 MIRACOLOSA' , '2' , '-2' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '4.20' ) 12/01/2023 04:10: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 ( '74854' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 12/01/2023 04:11:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3494' AND id_document != '73175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-17') 12/01/2023 04:11:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3494', document_date = '2022-11-17', 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.50', price_tax_excluded = '12.70', date_upd = NOW() WHERE id_document = '73175' 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73175' 12/01/2023 04:11:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '73175' 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '1' , '-1' , '1' , '4.4000' , '3.6065573770492' , '22' , '0' , '4.40' ) 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '18223' , 'CORONA MISSIONARIA - R102' , '2' , '-2' , '1' , '0.6500' , '0.5327868852459' , '22' , '0' , '1.30' ) 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '20071' , 'ROSARIO MISSIONARIO MM8' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 04:11:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73175' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '1' , '1.25' , '1.0245901639344' , '22' , '0' , '2.50' ) 12/01/2023 04:24:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 04:24:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '128' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.74' , '95.89' , NOW() , NOW() ) 12/01/2023 04:24:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78793' 12/01/2023 04:24:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '78793' 12/01/2023 04:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78793' , '1240' , 'BISACCIA DEL PELLEGRINO - TONINO BELLO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 12/01/2023 04:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78793' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 12/01/2023 04:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78793' , '9527' , 'SANTAGNESE - A. GOVERNALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 12/01/2023 04:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78793' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 12/01/2023 04:25:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 04:25:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '129' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '1.20' , NOW() , NOW() ) 12/01/2023 04:25:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78794' 12/01/2023 04:25:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '78794' 12/01/2023 04:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78794' , '16518' , 'ADMIRABILE SIGNUM' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 12/01/2023 04:28:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3761' AND id_document != '76101' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-05') 12/01/2023 04:28:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3761', document_date = '2022-12-05', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '76101' 12/01/2023 04:28:41 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 = '76101' 12/01/2023 04:28:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '76101' 12/01/2023 04:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76101' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 12/01/2023 04:28:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76101' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/01/2023 04:29:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3851' AND id_document != '77253' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 12/01/2023 04:29:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3851', document_date = '2022-12-13', 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 = '85.00', price_tax_excluded = '71.39', date_upd = NOW() WHERE id_document = '77253' 12/01/2023 04:29:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77253' 12/01/2023 04:29:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '77253' 12/01/2023 04:29: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 ( '77253' , '20147' , 'LAMPADA A SFERA AZZURRA - 049DK' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 12/01/2023 04:29: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 ( '77253' , '17833' , 'LAMPADA SAN GIUSEPPE' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 12/01/2023 04:29: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 ( '77253' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 12/01/2023 04:29: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 ( '77253' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/01/2023 04:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 04:31:00 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' , '5/A' , '2023-01-12' , 'A' , '1148' , '0' , '1148' , 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.60' , '55.60' , NOW() , NOW() ) 12/01/2023 04:31: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 = '78795' 12/01/2023 04:31:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '78795' 12/01/2023 04:31: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 ( '78795' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 12/01/2023 04:31: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 ( '78795' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 12/01/2023 04:31: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 ( '78795' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '2' , '-2' , '4' , '14.80' , '14.8' , '0' , '0' , '29.60' ) 12/01/2023 04:31:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 04:31:38 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' , '130' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 12/01/2023 04:31:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78796' 12/01/2023 04:31:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '78796' 12/01/2023 04:31:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78796' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 04:36:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3819' AND id_document != '76698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 12/01/2023 04:36:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3819', document_date = '2022-12-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '95.87', date_upd = NOW() WHERE id_document = '76698' 12/01/2023 04:36: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 = '76698' 12/01/2023 04:36:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '76698' 12/01/2023 04:36: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 ( '76698' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 12/01/2023 04:36: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 ( '76698' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '4.4500' , '4.45' , '0' , '0' , '4.45' ) 12/01/2023 04:36: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 ( '76698' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '3.00' ) 12/01/2023 04:36: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 ( '76698' , '19925' , 'AMEN - NOV. 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.55' ) 12/01/2023 04:36: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 ( '76698' , '14622' , 'IMMACOLATA CONCEZIONE BABY - 023 IC/9BB' , '2' , '-2' , '1' , '8' , '6.5573770491803' , '22' , '0' , '16.00' ) 12/01/2023 04:36: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 ( '76698' , '9486' , 'S. MICHELE ARC. BABY - 023 SMK/9 BB' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/01/2023 04:36: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 ( '76698' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 12/01/2023 04:36: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 ( '76698' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 12/01/2023 04:36: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 ( '76698' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 12/01/2023 04:36: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 ( '76698' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 12/01/2023 04:37:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3524' AND id_document != '73727' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-19') 12/01/2023 04:37:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3524', document_date = '2022-11-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.00', price_tax_excluded = '17.75', date_upd = NOW() WHERE id_document = '73727' 12/01/2023 04: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 = '73727' 12/01/2023 04:37:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '73727' 12/01/2023 04: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 ( '73727' , '11099' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/01/2023 04: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 ( '73727' , '13537' , 'ANGELO RESINA CON CUORE - 4208' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 12/01/2023 04: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 ( '73727' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/01/2023 04:38:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '77503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 12/01/2023 04:38:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2022-12-23', document_letter = 'A', id_customer = '3843', id_supplier = '', id_address = '4673209', address1 = 'RIONE PIOMBINO 84080 PELLEZZANO', address2 = '', note = '12/01 € 300,00', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '77503' 12/01/2023 04:38: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 = '77503' 12/01/2023 04:38:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '77503' 12/01/2023 04:38: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 ( '77503' , '15679' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '800.0000' , '655.73770491803' , '22' , '0' , '800.00' ) 12/01/2023 04:40:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 04:40:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '131' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 12/01/2023 04:40:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78797' 12/01/2023 04:40:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '78797' 12/01/2023 04:40:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78797' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 12/01/2023 04:49:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '46' AND id_document != '78180' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 12/01/2023 04:49:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '46', document_date = '2023-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 = '18.00', price_tax_excluded = '17.87', date_upd = NOW() WHERE id_document = '78180' 12/01/2023 04:49:26 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 = '78180' 12/01/2023 04:49:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '78180' 12/01/2023 04:49:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78180' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/01/2023 04:49:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78180' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 12/01/2023 04:50:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '78184' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-05') 12/01/2023 04:50:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '50', document_date = '2023-01-05', 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 = '100.00', price_tax_excluded = '95.33', date_upd = NOW() WHERE id_document = '78184' 12/01/2023 04:50: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 = '78184' 12/01/2023 04:50:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '78184' 12/01/2023 04:50: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 ( '78184' , '17969' , 'NEL CASTELLO DELLANIMA - E. STEIN ' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 12/01/2023 04:50: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 ( '78184' , '20017' , 'CHI DORME NON PIGLIA CRISTO - M. POZZA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 12/01/2023 04:50: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 ( '78184' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 12/01/2023 04:50: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 ( '78184' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 04:50: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 ( '78184' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '25.9000' , '21.229508196721' , '22' , '0' , '25.90' ) 12/01/2023 04:50:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '39' AND id_document != '78172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 12/01/2023 04:50:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '39', document_date = '2023-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 = '77.90', price_tax_excluded = '67.64', date_upd = NOW() WHERE id_document = '78172' 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78172' 12/01/2023 04:50:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '78172' 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '20076' , 'ROSARIO ARGENTO/QUARZO' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '18222' , 'ROSARIO COLORATO - R316' , '6' , '-6' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '4.20' ) 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 12/01/2023 04:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 04:51:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '78221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 12/01/2023 04:51:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '83', document_date = '2023-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 = '69.50', price_tax_excluded = '61.39', date_upd = NOW() WHERE id_document = '78221' 12/01/2023 04:51:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78221' 12/01/2023 04:51:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '78221' 12/01/2023 04:51:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '19996' , 'GESU BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 12/01/2023 04:51:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9.3' , '9.3' , '0' , '0' , '9.30' ) 12/01/2023 04:51:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/01/2023 04:53:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3590' AND id_document != '74848' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-24') 12/01/2023 04:53:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3590', document_date = '2022-11-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '320.00', price_tax_excluded = '266.99', date_upd = NOW() WHERE id_document = '74848' 12/01/2023 04:53:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74848' 12/01/2023 04:53:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '74848' 12/01/2023 04:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '9526' , 'SANT\'AGNELLO - 80 ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '13524' , 'RELIQUIARIO IN BRONZO DORATO - 4030' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '19953' , 'FELIZ CITTA - GIOCO CARLO ACUTIS' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '16330' , 'GRUPPO NATIVITA PORCELLANA CM 17' , '17' , '-17' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '85.00' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '16771' , 'QUADRO DECORATO' , '1' , '-1' , '1' , '5.1' , '4.1803278688525' , '22' , '0' , '5.10' ) 12/01/2023 04:53:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74848' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 12/01/2023 04:55:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3669' AND id_document != '75464' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 12/01/2023 04:55:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3669', document_date = '2022-11-30', 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 = '6.10', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '75464' 12/01/2023 04:55:48 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 = '75464' 12/01/2023 04:55:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '75464' 12/01/2023 04:55:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75464' , '14835' , 'STELLA COMETA - P581' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 12/01/2023 04:55:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75464' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 12/01/2023 04:55:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75464' , '8440' , 'PRESEPE COMPONIBILE IN MDF CON 9 PZ ' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 12/01/2023 04:56:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3622' AND id_document != '74889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-25') 12/01/2023 04:56:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3622', document_date = '2022-11-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '74889' 12/01/2023 04:56: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 = '74889' 12/01/2023 04:56:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '74889' 12/01/2023 04:56: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 ( '74889' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '96.00' ) 12/01/2023 04:56: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 ( '74889' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/01/2023 04:56: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 ( '74889' , '16328' , 'GRUPPO NATIVITA CM 20' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 12/01/2023 04:56: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 ( '74889' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 12/01/2023 04:56: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 ( '74889' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '9.00' ) 12/01/2023 04:56: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 ( '74889' , '13553' , 'CONFEZIONE BRACCIALE DELL\'AMICIZIA - 3157' , '1' , '-1' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '1.40' ) 12/01/2023 05:00:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '77256' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 12/01/2023 05:00:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3854', document_date = '2022-12-13', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '77256' 12/01/2023 05:00:03 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 = '77256' 12/01/2023 05:00:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '77256' 12/01/2023 05:00: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 ( '77256' , '17290' , 'SPILLA PORTACIUCCIO' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 12/01/2023 05:00: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 ( '77256' , '15072' , 'PRESEPE ALABASTRO - 210' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 12/01/2023 05:00:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3900' AND id_document != '77318' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 12/01/2023 05:00:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3900', document_date = '2022-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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '77318' 12/01/2023 05:00:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77318' 12/01/2023 05:00:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '77318' 12/01/2023 05:00: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 ( '77318' , '19013' , 'BAMBINELLO CM 30 - 16813/00/30' , '1' , '-1' , '1' , '125.0000' , '102.45901639344' , '22' , '0' , '125.00' ) 12/01/2023 05:00: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 ( '77318' , '17568' , 'BAMBINO IN RESINA FASCIA ORO - PB13629' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 12/01/2023 05:03:48 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' , '823007' , '2022-12-13' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1600.00' , '1600.00' , NOW() , NOW() ) 12/01/2023 05:03:48 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 = '78798' 12/01/2023 05:03:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '78798' 12/01/2023 05:03:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78798' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '50' , '50' , '4' , '32.00' , '32' , '0' , '0' , '1600.0000' ) 12/01/2023 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1134' AND id_supplier = '109' 12/01/2023 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1134' , '109' , '1' ) 12/01/2023 05:04:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3811' AND id_document != '76689' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 12/01/2023 05:04:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3811', document_date = '2022-12-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.50', price_tax_excluded = '21.72', date_upd = NOW() WHERE id_document = '76689' 12/01/2023 05:04:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76689' 12/01/2023 05:04:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '76689' 12/01/2023 05:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/01/2023 05:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '19921' , 'AGENDA 2023 - 40809' , '1' , '-1' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '5.50' ) 12/01/2023 05:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 12/01/2023 05:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '19075' , 'GLOBO BAMBINO - PB9876' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 12/01/2023 05:04:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76689' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 05:07:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '121' AND id_document != '78785' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 05:07:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '121', document_date = '2023-01-12', 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 = '76.35', price_tax_excluded = '64.16', date_upd = NOW() WHERE id_document = '78785' 12/01/2023 05:07:03 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 = '78785' 12/01/2023 05:07:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '78785' 12/01/2023 05:07: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 ( '78785' , '10501' , 'TECA STANDARD IHS ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 12/01/2023 05:07: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 ( '78785' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 12/01/2023 05:07: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 ( '78785' , '15483' , 'CROCE - 075 ALV' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 12/01/2023 05:07: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 ( '78785' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.9000' , '4.8360655737705' , '22' , '0' , '5.90' ) 12/01/2023 05:07: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 ( '78785' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/01/2023 05:07: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 ( '78785' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 12/01/2023 05:07: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 ( '78785' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 12/01/2023 05:09:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '74854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-24') 12/01/2023 05:09:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3595', document_date = '2022-11-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.20', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '74854' 12/01/2023 05:09: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 = '74854' 12/01/2023 05:09:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '74854' 12/01/2023 05:09: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 ( '74854' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '2.20' ) 12/01/2023 05:09: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 ( '74854' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '28' , '-28' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '5.60' ) 12/01/2023 05:09: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 ( '74854' , '16989' , 'QUADRETTO SMUSSATO 7X10 MIRACOLOSA' , '2' , '-2' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '4.20' ) 12/01/2023 05:09: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 ( '74854' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 12/01/2023 05:12:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3753' AND id_document != '75575' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-05') 12/01/2023 05:12:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3753', document_date = '2022-12-05', 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 = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '75575' 12/01/2023 05:12:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75575' 12/01/2023 05:12:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '75575' 12/01/2023 05:12:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75575' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '2' , '-2' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '38.00' ) 12/01/2023 05:12:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75575' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 12/01/2023 05:12:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75575' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 12/01/2023 05:14:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '4101' AND id_document != '77551' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 12/01/2023 05:14:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4101', document_date = '2022-12-27', 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 = '22.60', price_tax_excluded = '18.52', date_upd = NOW() WHERE id_document = '77551' 12/01/2023 05:14:03 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 = '77551' 12/01/2023 05:14:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '77551' 12/01/2023 05:14: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 ( '77551' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 12/01/2023 05:14: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 ( '77551' , '16125' , 'MARIA CHE SCIOGLIE I NODI BABY - MSN9-BB' , '1' , '-1' , '1' , '10.2' , '8.3606557377049' , '22' , '0' , '10.20' ) 12/01/2023 05:14: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 ( '77551' , '13111' , 'FATIMA BABY - 023 FAT 9 BB' , '1' , '-1' , '1' , '10.2' , '8.3606557377049' , '22' , '0' , '10.20' ) 12/01/2023 05:14:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4088' AND id_document != '77538' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 12/01/2023 05:14:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4088', document_date = '2022-12-27', 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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '77538' 12/01/2023 05:14:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77538' 12/01/2023 05:14:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '77538' 12/01/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77538' , '19601' , 'ANGELO ALI TORTORA - 4231' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 12/01/2023 05:15:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '4003' AND id_document != '77437' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-21') 12/01/2023 05:15:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4003', document_date = '2022-12-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.50', price_tax_excluded = '7.79', date_upd = NOW() WHERE id_document = '77437' 12/01/2023 05:15:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77437' 12/01/2023 05:15:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '77437' 12/01/2023 05:15:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77437' , '10207' , 'MARIA CHE SCIOGLIE NODI CM 12 - 023 MSN/12' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 12/01/2023 05:16:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3921' AND id_document != '77342' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 12/01/2023 05:16:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3921', document_date = '2022-12-17', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '77342' 12/01/2023 05:16:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77342' 12/01/2023 05:16:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '77342' 12/01/2023 05:16:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77342' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 12/01/2023 05:16:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77342' , '10208' , 'STATUA MARIA CHE SCIOGLIE NODI CM 20' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 12/01/2023 05:16:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3891' AND id_document != '77307' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 12/01/2023 05:16:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3891', document_date = '2022-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 = '23.70', price_tax_excluded = '19.43', date_upd = NOW() WHERE id_document = '77307' 12/01/2023 05:16:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77307' 12/01/2023 05:16:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '77307' 12/01/2023 05:16:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77307' , '20183' , 'TESTA ANGELI CM 8 - AR05' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/01/2023 05:16:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77307' , '18847' , 'QUADRETTO NATIVITA ORO A CALDO - P662' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 12/01/2023 05:16:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77307' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 12/01/2023 05:16:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77307' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 12/01/2023 05:16:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77307' , '13540' , 'ANGELO RESINA CON CUORE - 4202' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/01/2023 05:21:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4105' AND id_document != '77559' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 12/01/2023 05:21:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4105', document_date = '2022-12-27', 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 = '60.00', price_tax_excluded = '55.74', date_upd = NOW() WHERE id_document = '77559' 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77559' 12/01/2023 05:21:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '77559' 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77559' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '-1' , '4' , '34.0000' , '34' , '0' , '5' , '32.30' ) 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77559' , '6005' , 'LUMEN GENTIUM' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77559' , '2528' , 'COMPIETA' , '1' , '-1' , '4' , '1.3000' , '1.3' , '0' , '5' , '1.24' ) 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77559' , '14876' , 'ANGELO IN RESINA PREGHIERA CM 9 - KS124-P' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77559' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/01/2023 05:21:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77559' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '5.61' , '4.5983606557377' , '22' , '0' , '5.61' ) 12/01/2023 05:21:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '77546' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 12/01/2023 05:21:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4096', document_date = '2022-12-27', 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 = '8.80', price_tax_excluded = '7.57', date_upd = NOW() WHERE id_document = '77546' 12/01/2023 05:21:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77546' 12/01/2023 05:21:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '77546' 12/01/2023 05:21: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 ( '77546' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '1' , '-1' , '1' , '6.8' , '5.5737704918033' , '22' , '0' , '6.80' ) 12/01/2023 05:21: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 ( '77546' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 12/01/2023 05:22:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '4044' AND id_document != '77485' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 12/01/2023 05:22:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4044', document_date = '2022-12-23', 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 = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '77485' 12/01/2023 05:22:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77485' 12/01/2023 05:22:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '77485' 12/01/2023 05:22:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77485' , '20004' , 'GESU BAMBINO CM 20 - BJ142-20E' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 12/01/2023 05:22:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77485' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 12/01/2023 05:23:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3865' AND id_document != '77268' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-14') 12/01/2023 05:23:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3865', document_date = '2022-12-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '77268' 12/01/2023 05:23:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77268' 12/01/2023 05:23:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '77268' 12/01/2023 05:23:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77268' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 12/01/2023 05:23:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77268' , '20170' , 'ANGELO IN GINOCCHIO - AR66' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/01/2023 05:23:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77268' , '20182' , 'COPPIA TESTE DI ANGELO CM7 - AR06' , '4' , '-4' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '20.00' ) 12/01/2023 05:23:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77268' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 12/01/2023 05:24:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '78130' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-02') 12/01/2023 05:24:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3', document_date = '2023-01-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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '78130' 12/01/2023 05:24:50 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 = '78130' 12/01/2023 05:24:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '78130' 12/01/2023 05:24:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78130' , '14833' , 'NATIVITA CM 22 - P557' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 12/01/2023 05:24:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78130' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '3' , '-3' , '1' , '10' , '8.1967213114754' , '22' , '0' , '30.00' ) 12/01/2023 05:25:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3888' AND id_document != '77302' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 12/01/2023 05:25:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3888', document_date = '2022-12-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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '77302' 12/01/2023 05:25:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77302' 12/01/2023 05:25:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '77302' 12/01/2023 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77302' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 12/01/2023 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77302' , '19998' , 'GESU BAMBINO CM 20 - BJ142-28E' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 12/01/2023 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77302' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 12/01/2023 05:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77302' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/01/2023 05:29:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3888' AND id_document != '77302' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 12/01/2023 05:29:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3888', document_date = '2022-12-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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '77302' 12/01/2023 05:29: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 = '77302' 12/01/2023 05:29:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '77302' 12/01/2023 05:29: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 ( '77302' , '19998' , 'GESU BAMBINO CM 20 - BJ142-28E' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 12/01/2023 05:29: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 ( '77302' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 12/01/2023 05:29: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 ( '77302' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/01/2023 05:29: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 ( '77302' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 12/01/2023 05:30:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '78129' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-02') 12/01/2023 05:30:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2', document_date = '2023-01-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 = '170.00', price_tax_excluded = '143.32', date_upd = NOW() WHERE id_document = '78129' 12/01/2023 05:30: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 = '78129' 12/01/2023 05:30:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '78129' 12/01/2023 05:30: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 ( '78129' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 12/01/2023 05:30: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 ( '78129' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '70.00' ) 12/01/2023 05:30: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 ( '78129' , '20578' , 'TOTUM AMORIS EST ' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 12/01/2023 05:30: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 ( '78129' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.9500' , '1.5983606557377' , '22' , '0' , '1.95' ) 12/01/2023 05:30: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 ( '78129' , '18809' , 'TEMPO DI NATALE - G. SACINO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 12/01/2023 05:30: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 ( '78129' , '20488' , 'CHIESA E VIVA - J. RATZINGER' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 12/01/2023 05:30: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 ( '78129' , '20000' , 'GESU BAMBINO CM 15 - BJ140-15E' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/01/2023 05:30: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 ( '78129' , '19999' , 'GESU BAMBINO CON AUREOLA CM 15 - BJ148-15' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/01/2023 05:30: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 ( '78129' , '13134' , 'BAMBINO GESU BETLEMME - OCCHI DI VETRO - P514' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 12/01/2023 05:30: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 ( '78129' , '16328' , 'GRUPPO NATIVITA CM 20 - PB14890' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 12/01/2023 05:32:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 05:32:32 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' , '132' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 12/01/2023 05:32:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78799' 12/01/2023 05:32:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '78799' 12/01/2023 05:32:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78799' , '801' , 'ASTUCCIO STOPPINO - MT 2 - 117' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 12/01/2023 05:33:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 05:33:38 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' , '133' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 12/01/2023 05:33:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78800' 12/01/2023 05:33:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '78800' 12/01/2023 05:33:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78800' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 12/01/2023 05:37:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 05:37:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '8' , '2023-01-12' , '' , '1504' , '0' , '4671992' , 'P. ZZA ALBERTO I 52035 MONTERCHI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '62.90' , '62.90' , NOW() , NOW() ) 12/01/2023 05:37:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78801' 12/01/2023 05:37:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '78801' 12/01/2023 05:37:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78801' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 12/01/2023 05:37:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78801' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 12/01/2023 05:37:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78801' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.40' , '2.4' , '0' , '15' , '20.40' ) 12/01/2023 05:50:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 05:50:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '134' , '2023-01-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.50' , NOW() , NOW() ) 12/01/2023 05:50:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78802' 12/01/2023 05:50:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '78802' 12/01/2023 05:50:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78802' , '475' , 'AMICO GESÙ - FIGURINE' , '15' , '-15' , '4' , '0.50' , '0.5' , '0' , '0' , '7.50' ) 12/01/2023 06:04:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '39' AND id_document != '78172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-04') 12/01/2023 06:04:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '39', document_date = '2023-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 = '77.90', price_tax_excluded = '67.64', date_upd = NOW() WHERE id_document = '78172' 12/01/2023 06:04:26 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 = '78172' 12/01/2023 06:04:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '78172' 12/01/2023 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '9165' , 'ROSARIO PER SCOPRIRE IL VOLTO...' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 12/01/2023 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '20076' , 'ROSARIO ARGENTO/QUARZO' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 12/01/2023 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 12/01/2023 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '18222' , 'ROSARIO COLORATO - R316' , '6' , '-6' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '4.20' ) 12/01/2023 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 12/01/2023 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78172' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 12/01/2023 06:05:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '54' AND id_document != '78189' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-05') 12/01/2023 06:05:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '54', document_date = '2023-01-05', 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 = '24.56', price_tax_excluded = '22.31', date_upd = NOW() WHERE id_document = '78189' 12/01/2023 06:05:53 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 = '78189' 12/01/2023 06:05:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '78189' 12/01/2023 06:05:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78189' , '11684' , 'BRACCIALE TAU' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 12/01/2023 06:05:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78189' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/01/2023 06:05: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 ( '78189' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 12/01/2023 06:05: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 ( '78189' , '19744' , 'ASCOLTAMI GESU' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 12/01/2023 06:05: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 ( '78189' , '19337' , 'VANGELO VERDE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 12/01/2023 06:05: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 ( '78189' , '19652' , 'VANGELO IN FAMIGLIA' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 12/01/2023 06:05: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 ( '78189' , '14134' , 'SACRA FAMIGLIA - 387' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 12/01/2023 06:05: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 ( '78189' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 12/01/2023 06:05: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 ( '78189' , '20090' , 'CALENDARIO 2023 - 40812' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 12/01/2023 06:06:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3844' AND id_document != '77239' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 12/01/2023 06:06:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3844', document_date = '2022-12-13', 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 = '13.00', price_tax_excluded = '10.66', date_upd = NOW() WHERE id_document = '77239' 12/01/2023 06:06:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77239' 12/01/2023 06:06:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '77239' 12/01/2023 06:06:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77239' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '11.00' ) 12/01/2023 06:06:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77239' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/01/2023 06:08:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '58' AND id_document != '78193' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-05') 12/01/2023 06:08:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '58', document_date = '2023-01-05', 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.00', price_tax_excluded = '7.00', date_upd = NOW() WHERE id_document = '78193' 12/01/2023 06:08:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78193' 12/01/2023 06:08:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '78193' 12/01/2023 06:08:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78193' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 12/01/2023 06:08:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78193' , '9522' , 'SANT ANDREA AP. - A.GOVERNALE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 12/01/2023 06:10:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '78221' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-09') 12/01/2023 06:10:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '83', document_date = '2023-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 = '69.50', price_tax_excluded = '61.39', date_upd = NOW() WHERE id_document = '78221' 12/01/2023 06:10:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78221' 12/01/2023 06:10:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '78221' 12/01/2023 06:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '19996' , 'GESU BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 12/01/2023 06:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 12/01/2023 06:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 12/01/2023 06:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 12/01/2023 06:10:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78221' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '' , '2.80' ) 12/01/2023 06:13:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '87' AND id_document != '78227' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 12/01/2023 06:13:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '87', document_date = '2023-01-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '84.00', price_tax_excluded = '73.61', date_upd = NOW() WHERE id_document = '78227' 12/01/2023 06:13:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78227' 12/01/2023 06:13:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '78227' 12/01/2023 06:13:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78227' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 12/01/2023 06:13:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78227' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 12/01/2023 06:13:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78227' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 12/01/2023 06:13:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78227' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 12/01/2023 06:13:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78227' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 12/01/2023 06:13: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 ( '78227' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 12/01/2023 06:13: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 ( '78227' , '20254' , 'VERSO IL NATALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 12/01/2023 06:13: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 ( '78227' , '9992' , 'SIGNORE, DACCI SEMPRE ...' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 12/01/2023 06:28:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1504' 12/01/2023 06:28:32 pm >> 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 ( '1504' , '10' , '127' , 'PARROCCHIA SAN SIMEONE' , 'GIORGINI ' , 'DON QUINTO' , 'P. ZZA UMBERTO I' , '' , '52035' , 'MONTERCHI' , '' , '0575/70043 - 3383875080' , '' , '' , '910018105513' , NOW() , NOW() ) 12/01/2023 06:28:32 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1504' 12/01/2023 06:50:11 pm >> DELETE FROM ps_document WHERE id_document = '73131' 12/01/2023 06:50:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '73131' 12/01/2023 06:51:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '77325' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-16') 12/01/2023 06:51:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3905', document_date = '2022-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 = '13.40', price_tax_excluded = '12.14', date_upd = NOW() WHERE id_document = '77325' 12/01/2023 06:51:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77325' 12/01/2023 06:51:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '77325' 12/01/2023 06:51:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77325' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' , '-4' , '4' , '1.60' , '1.6' , '0' , '0' , '6.40' ) 12/01/2023 06:51:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77325' , '18131' , 'TAU MEDIO CM3 - T6' , '7' , '-7' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '7.00' ) 12/01/2023 06:51:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '78779' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 06:51:47 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '6', document_date = '2023-01-12', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4671825', address1 = 'via del Casale di San Pio V , 11/13 00165 Roma ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '94.10', price_tax_excluded = '94.10', date_upd = NOW() WHERE id_document = '78779' 12/01/2023 06:51:47 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 = '78779' 12/01/2023 06:51:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '78779' 12/01/2023 06:51:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78779' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '60' , '-60' , '4' , '1.60' , '1.6' , '0' , '5' , '91.20' ) 12/01/2023 06:51:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78779' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 12/01/2023 06:52:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '78779' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-12') 12/01/2023 06:52:10 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '6', document_date = '2023-01-12', document_letter = '', id_customer = '3775', id_supplier = '', id_address = '4671825', address1 = 'via del Casale di San Pio V , 11/13 00165 Roma ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '94.10', price_tax_excluded = '94.10', date_upd = NOW() WHERE id_document = '78779' 12/01/2023 06:52: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 = '78779' 12/01/2023 06:52:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '78779' 12/01/2023 06:52: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 ( '78779' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '60' , '-60' , '4' , '1.60' , '1.6' , '0' , '5' , '91.20' ) 12/01/2023 06:52: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 ( '78779' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 12/01/2023 06:52:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '59687' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-07-14') 12/01/2023 06:52:35 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '105', document_date = '2022-07-14', document_letter = '', id_customer = '2866', id_supplier = '', id_address = '4674412', address1 = 'VIA ROMA, 9 81016 SAN POTITO SANNITICO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '43.00', date_upd = NOW() WHERE id_document = '59687' 12/01/2023 06:52: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 = '59687' 12/01/2023 06:52:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '59687' 12/01/2023 06:52: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 ( '59687' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '25' , '-25' , '4' , '1.60' , '1.6' , '0' , '5' , '38.00' ) 12/01/2023 06:53:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '58643' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-07') 12/01/2023 06:53:24 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '97', document_date = '2022-06-07', document_letter = '', id_customer = '3581', id_supplier = '', id_address = '4671106', address1 = 'PIAZZA 4 NOVEMBRE 84039 TEGGIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '600.00', price_tax_excluded = '600.00', date_upd = NOW() WHERE id_document = '58643' 12/01/2023 06:53:24 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 = '58643' 12/01/2023 06:53:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '58643' 12/01/2023 06:53:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58643' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '408' , '-408' , '4' , '1.6000' , '1.6' , '0' , '25' , '489.60' ) 12/01/2023 06:53:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58643' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '92' , '-92' , '4' , '1.60' , '1.6' , '0' , '25' , '110.40' ) 12/01/2023 07:42:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820976224' AND id_product != '2549' AND ean13 != '' 12/01/2023 07:42:27 pm >> UPDATE ps_product SET id_supplier = '79', reference = '13/7', ean13 = '9788820976224', date_upd = NOW() WHERE id_product = '2549' 12/01/2023 07:42:27 pm >> UPDATE ps_product_lang SET name = 'COMUNICAZIONE E MISSIONE', description = '' WHERE id_product = '2549' 12/01/2023 07:42:27 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '10.0000' WHERE id_product = '2549' 12/01/2023 07:42:27 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '10.0000', id_tax_rules_group = '4', id_category_default = '261', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2549' 12/01/2023 07:42:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '2549'