04/11/2023 08:10:39 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 08:10:39 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' , '97' , '2023-11-04' , '' , '6774' , '0' , '9339870' , 'CORSO ITALIA 80067 SORRENTO' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '54.20' , '54.20' , NOW() , NOW() ) 04/11/2023 08:10:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13227' 04/11/2023 08:10:39 am >> DELETE FROM ps_document_detail WHERE id_document = '13227' 04/11/2023 08:10:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13227' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '5' , '51.30' ) 04/11/2023 08:11:51 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '13227' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 08:11:51 am >> UPDATE ps_document SET id_document_type = '21', document_num = '97', document_date = '2023-11-04', document_letter = '', id_customer = '6774', id_supplier = '', id_address = '9339870', address1 = 'CORSO ITALIA 80067 SORRENTO', address2 = '', note = '', price_shipping = '6.9', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '58.20', price_tax_excluded = '58.20', date_upd = NOW() WHERE id_document = '13227' 04/11/2023 08:11:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13227' 04/11/2023 08:11:51 am >> DELETE FROM ps_document_detail WHERE id_document = '13227' 04/11/2023 08:11:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13227' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '3' , '-3' , '4' , '18.0000' , '18' , '0' , '5' , '51.30' ) 04/11/2023 09:24:52 am >> SELECT document_num FROM ps_document WHERE document_num = '13/L' AND id_document != '87512' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-02') 04/11/2023 09:24:52 am >> UPDATE ps_document SET id_document_type = '23', document_num = '13/L', document_date = '2023-10-02', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA BATTIPAGLIA', 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 = '221.85', price_tax_excluded = '217.56', date_upd = NOW() WHERE id_document = '87512' 04/11/2023 09:24:52 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 = '87512' 04/11/2023 09:24:52 am >> DELETE FROM ps_document_detail WHERE id_document = '87512' 04/11/2023 09:24:52 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 ( '87512' , '12899' , 'LODE A TE, SIGNORE' , '45' , '-45' , '4' , '4.2000' , '4.2' , '0' , '5' , '179.55' ) 04/11/2023 09:24:52 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 ( '87512' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/11/2023 09:24:52 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 ( '87512' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 04/11/2023 09:24:52 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 ( '87512' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 04/11/2023 09:24:52 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 ( '87512' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 04/11/2023 09:35:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3451' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 09:35: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' , '3451' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.80' , '55.63' , NOW() , NOW() ) 04/11/2023 09:35: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 = '88722' 04/11/2023 09:35:54 am >> DELETE FROM ps_document_detail WHERE id_document = '88722' 04/11/2023 09:35: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 ( '88722' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 04/11/2023 09:35: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 ( '88722' , '21677' , 'LAUDATE DEUM ' , '2' , '-2' , '4' , '1.20' , '1.2' , '0' , '0' , '2.40' ) 04/11/2023 09:35: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 ( '88722' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 04/11/2023 09:43:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3452' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 09:43:59 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' , '3452' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.81' , '48.54' , NOW() , NOW() ) 04/11/2023 09:43:59 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 = '88723' 04/11/2023 09:43:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88723' 04/11/2023 09:43:59 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 ( '88723' , '18176' , 'ANTIQUUM MINISTERIUM ' , '15' , '-15' , '4' , '1.00' , '1' , '0' , '5' , '14.25' ) 04/11/2023 09:43:59 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 ( '88723' , '21476' , 'QUESTA CASA E TUA 3 - 12/14 ANNI' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 04/11/2023 09:43:59 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 ( '88723' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '5' , '11.88' ) 04/11/2023 09:43:59 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 ( '88723' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/11/2023 09:44:22 am >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 09:44:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '230' , '2023-11-04' , '' , '3191' , '0' , '4670958' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.25' , '21.25' , NOW() , NOW() ) 04/11/2023 09:44:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88724' 04/11/2023 09:44:22 am >> DELETE FROM ps_document_detail WHERE id_document = '88724' 04/11/2023 09:44:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88724' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 04/11/2023 09:45:33 am >> SELECT document_num FROM ps_document WHERE document_num = '115/A' AND id_document != '88635' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-30') 04/11/2023 09:45:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '115/A', document_date = '2023-10-30', document_letter = 'A', id_customer = '3191', id_supplier = '', id_address = '4670958', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '440.60', price_tax_excluded = '440.60', date_upd = NOW() WHERE id_document = '88635' 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88635' 04/11/2023 09:45:33 am >> DELETE FROM ps_document_detail WHERE id_document = '88635' 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.9000' , '9.9' , '0' , '0' , '29.70' ) 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.0000' , '45' , '0' , '0' , '45.00' ) 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '46.0000' , '46' , '0' , '0' , '46.00' ) 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '4' , '-4' , '4' , '38.0000' , '38' , '0' , '0' , '152.00' ) 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '6' , '-6' , '4' , '18.5000' , '18.5' , '0' , '0' , '111.00' ) 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '1199' , 'BIBBIA TOB - SOFTEN' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 04/11/2023 09:45:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88635' , '1102' , 'BIBBIA BROSSURA OLANDESE' , '1' , '-1' , '4' , '26.90' , '26.9' , '0' , '0' , '26.90' ) 04/11/2023 09:47:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3453' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 09:47:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3453' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 04/11/2023 09:47:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88725' 04/11/2023 09:47:17 am >> DELETE FROM ps_document_detail WHERE id_document = '88725' 04/11/2023 09:47:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88725' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/11/2023 09:57:39 am >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '88724' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 09:57:39 am >> UPDATE ps_document SET id_document_type = '21', document_num = '230', document_date = '2023-11-04', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4670958', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '21.25', price_tax_excluded = '21.25', date_upd = NOW() WHERE id_document = '88724' 04/11/2023 09:57:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88724' 04/11/2023 09:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '88724' 04/11/2023 09:57:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88724' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 04/11/2023 10:36:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3454' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 10:36:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3454' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 04/11/2023 10:36:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88726' 04/11/2023 10:36:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88726' 04/11/2023 10:36:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88726' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 04/11/2023 10:42:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3455' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 10:42:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3455' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '39.90' , NOW() , NOW() ) 04/11/2023 10:42:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88727' 04/11/2023 10:42:44 am >> DELETE FROM ps_document_detail WHERE id_document = '88727' 04/11/2023 10:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88727' , '18710' , 'SERVIRE A MESSA ' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 04/11/2023 10:42:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88727' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '5' , '34.20' ) 04/11/2023 10:53:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3375' AND id_document != '88597' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 04/11/2023 10:53:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3375', document_date = '2023-10-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '192.65', price_tax_excluded = '192.65', date_upd = NOW() WHERE id_document = '88597' 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88597' 04/11/2023 10:53:34 am >> DELETE FROM ps_document_detail WHERE id_document = '88597' 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '15475' , 'QUESTA SCUOLA E IL MONDO INTERO + CD - D. PAGANO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '4168' , 'FIGLI DEL VENTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '11280' , 'VI HO CHIAMATO AMICI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '11278' , 'VI HO CHIAMATO AMICI' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '17318' , 'CONOSCI LO SPIRITO SANTO - GUIDA' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '15386' , 'MESSA - LE PAROLE DI PAPA FRANCESCO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '15982' , 'ANTICO TESTAMENTO - 1° ANNO' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '5' , '6.18' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '18432' , 'SETTE SACRAMENTI ' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '5' , '6.18' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '19937' , 'SANTI A COLORI' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '5' , '8.46' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '5' , '22.80' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '5' , '22.80' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '5' , '5.70' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '2.7000' , '2.7' , '0' , '0' , '27.00' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '2.7' , '29.20' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '15316' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '12868' , 'GIOCANDO SCOPRIAMO LANNO LITURGICO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 04/11/2023 10:53:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88597' , '18647' , 'SCOPRIAMO INSIEME AVVENTO E NATALE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 04/11/2023 10:56:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3286' AND id_document != '88472' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-23') 04/11/2023 10:56:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3286', document_date = '2023-10-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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '88472' 04/11/2023 10:56:06 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 = '88472' 04/11/2023 10:56:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88472' 04/11/2023 10:56:06 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 ( '88472' , '21712' , 'SUL CORPO - C.M. MARTINI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 04/11/2023 10:56:06 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 ( '88472' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 04/11/2023 10:56:06 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 ( '88472' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/11/2023 10:56:06 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 ( '88472' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 04/11/2023 10:56:06 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 ( '88472' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 04/11/2023 10:56:06 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 ( '88472' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '3.63' , '3.63' , '0' , '0' , '3.63' ) 04/11/2023 10:56:07 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 ( '88472' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/11/2023 11:08:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3456' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 11:08:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3456' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/11/2023 11:08:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88728' 04/11/2023 11:08:11 am >> DELETE FROM ps_document_detail WHERE id_document = '88728' 04/11/2023 11:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88728' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/11/2023 11:19:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3457' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 11:19:53 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' , '3457' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.95' , '103.76' , NOW() , NOW() ) 04/11/2023 11:19:53 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 = '88729' 04/11/2023 11:19:53 am >> DELETE FROM ps_document_detail WHERE id_document = '88729' 04/11/2023 11:19:53 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 ( '88729' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 04/11/2023 11:19:53 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 ( '88729' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '35.50' , '29.098360655738' , '22' , '0' , '35.50' ) 04/11/2023 11:19:53 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 ( '88729' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/11/2023 11:19:53 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 ( '88729' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/11/2023 11:19:53 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 ( '88729' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19.9' , '16.311475409836' , '22' , '0' , '19.90' ) 04/11/2023 11:24:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3458' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 11:24:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3458' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 04/11/2023 11:24:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88730' 04/11/2023 11:24:00 am >> DELETE FROM ps_document_detail WHERE id_document = '88730' 04/11/2023 11:24:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88730' , '21764' , 'RICAMBIO TAPPO PER 1500/1501 - 54' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 04/11/2023 11:27:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3459' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 11:27:31 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' , '3459' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 04/11/2023 11:27:31 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 = '88731' 04/11/2023 11:27:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88731' 04/11/2023 11:27:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88731' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/11/2023 11:29:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3460' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 11:29:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3460' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 04/11/2023 11:29:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88732' 04/11/2023 11:29:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88732' 04/11/2023 11:29:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88732' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 04/11/2023 11:52:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3461' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 11:52:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3461' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/11/2023 11:52:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88733' 04/11/2023 11:52:29 am >> DELETE FROM ps_document_detail WHERE id_document = '88733' 04/11/2023 11:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88733' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/11/2023 12:02:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '231' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 12:02: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 ( '21' , '231' , '2023-11-04' , '' , '3826' , '0' , '4672780' , 'P. ZZA UMBERTO I 35 - PREPEZZANO 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '64.80' , '64.80' , NOW() , NOW() ) 04/11/2023 12:02: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 = '88734' 04/11/2023 12:02:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88734' 04/11/2023 12:02: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 ( '88734' , '14031' , 'SEGNO DELLA CROCE' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 04/11/2023 12:02: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 ( '88734' , '17034' , 'SACRAMENTO DEL PERDONO' , '19' , '-19' , '4' , '2.00' , '2' , '0' , '15' , '32.30' ) 04/11/2023 12:02: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 ( '88734' , '475' , 'AMICO GESÙ - FIGURINE' , '10' , '-10' , '4' , '0.50' , '0.5' , '0' , '0' , '5.00' ) 04/11/2023 12:02: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 ( '88734' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/11/2023 12:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 12:06:16 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' , '3462' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 04/11/2023 12:06:16 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 = '88735' 04/11/2023 12:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88735' 04/11/2023 12:06: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 ( '88735' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '7.60' ) 04/11/2023 12:11:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3463' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 12:11:39 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' , '3463' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 04/11/2023 12:11:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88736' 04/11/2023 12:11:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '88736' 04/11/2023 12:11: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 ( '88736' , '19720' , 'CROCE LEGNO MET. - CL247' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 04/11/2023 12:16:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3431' AND id_document != '88693' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-03') 04/11/2023 12:16:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3431', document_date = '2023-11-03', 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 = '19.00', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '88693' 04/11/2023 12:16:49 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 = '88693' 04/11/2023 12:16:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '88693' 04/11/2023 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88693' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/11/2023 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88693' , '19618' , 'CARLO ACUTIS' , '4' , '-4' , '4' , '4.5' , '4.5' , '0' , '' , '18.00' ) 04/11/2023 12:24:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3464' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 12:24:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3464' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 04/11/2023 12:24: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 = '88737' 04/11/2023 12:24:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '88737' 04/11/2023 12:24: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 ( '88737' , '18047' , 'CUSTODIA LITURGIA DELLE ORE 4 VOL ECO PELLE - L100E' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 04/11/2023 12:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3465' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 12:26:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3465' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 04/11/2023 12:26: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 = '88738' 04/11/2023 12:26:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '88738' 04/11/2023 12:26: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 ( '88738' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 04/11/2023 12:40:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 04/11/2023 12:40:24 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' , '3466' , '2023-11-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.10' , '20.16' , NOW() , NOW() ) 04/11/2023 12:40: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 = '88739' 04/11/2023 12:40:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '88739' 04/11/2023 12:40: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 ( '88739' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '10' , '-10' , '4' , '0.90' , '0.9' , '0' , '5' , '8.60' ) 04/11/2023 12:40:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88739' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 04/11/2023 12:40:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88739' , '15497' , 'CROCE PLEX - 086' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' )