08/10/2024 09:01:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 09:01:57 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' , '2953' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.20' , '21.61' , NOW() , NOW() ) 08/10/2024 09:01:57 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 = '93503' 08/10/2024 09:01:57 am >> DELETE FROM ps_document_detail WHERE id_document = '93503' 08/10/2024 09:01:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93503' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 08/10/2024 09:01:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93503' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11' , '11' , '0' , '0' , '11.00' ) 08/10/2024 09:01:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93503' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 08/10/2024 09:21:11 am >> SELECT document_num FROM ps_document WHERE document_num = '139' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 09:21:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '139' , '2024-10-08' , '' , '3952' , '0' , '4676204' , 'P. ZZA F. GAGLIARDI 84033 MONTESANO SULLA MARCELLANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.86' , '94.86' , NOW() , NOW() ) 08/10/2024 09:21: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 = '93504' 08/10/2024 09:21:11 am >> DELETE FROM ps_document_detail WHERE id_document = '93504' 08/10/2024 09:21: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 ( '93504' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '-3' , '4' , '3.40' , '3.4' , '0' , '15' , '8.67' ) 08/10/2024 09:21: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 ( '93504' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '15' , '17.00' ) 08/10/2024 09:21: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 ( '93504' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 08/10/2024 09:21: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 ( '93504' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 08/10/2024 09:21: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 ( '93504' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 08/10/2024 09:21: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 ( '93504' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 08/10/2024 09:21: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 ( '93504' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 08/10/2024 09:21: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 ( '93504' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 08/10/2024 09:21:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 09:21: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' , '2954' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.79' , '29.79' , NOW() , NOW() ) 08/10/2024 09:21: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 = '93505' 08/10/2024 09:21:54 am >> DELETE FROM ps_document_detail WHERE id_document = '93505' 08/10/2024 09:21: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 ( '93505' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 08/10/2024 09:21: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 ( '93505' , '9448' , 'SAN GIORGIO MARTIRE - G. PESENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/10/2024 09:21: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 ( '93505' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 08/10/2024 09:21: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 ( '93505' , '22873' , 'COME ESSERE CHIESA SINODALE MISSIONARIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/10/2024 09:21: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 ( '93505' , '22413' , 'VITA DI SAN GIUSEPPE - 8653' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 08/10/2024 09:24:40 am >> SELECT document_num FROM ps_document WHERE document_num = '139' AND id_document != '93504' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 09:24:40 am >> UPDATE ps_document SET id_document_type = '21', document_num = '139', document_date = '2024-10-08', document_letter = '', id_customer = '3952', id_supplier = '', id_address = '4676204', address1 = 'P. ZZA F. GAGLIARDI 84033 MONTESANO SULLA MARCELLANA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '94.86', price_tax_excluded = '94.86', date_upd = NOW() WHERE id_document = '93504' 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93504' 08/10/2024 09:24:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93504' 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '-3' , '4' , '3.4000' , '3.4' , '0' , '15' , '8.67' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '15' , '17.00' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '15' , '3.23' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '15' , '3.23' ) 08/10/2024 09:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93504' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '15' , '3.23' ) 08/10/2024 10:05:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 10:05:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2955' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.12' , '15.12' , NOW() , NOW() ) 08/10/2024 10:05:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93506' 08/10/2024 10:05:43 am >> DELETE FROM ps_document_detail WHERE id_document = '93506' 08/10/2024 10:05:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93506' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '5' , '7.98' ) 08/10/2024 10:05:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93506' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2024 10:05:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93506' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2024 10:05:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93506' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/10/2024 10:36:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2576/24' , '2024-10-04' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '892.90' , '858.56' , NOW() , NOW() ) 08/10/2024 10:36:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93507' 08/10/2024 10:36:18 am >> DELETE FROM ps_document_detail WHERE id_document = '93507' 08/10/2024 10:36:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93507' , '7311' , 'OSTIA SOTTILE 74MM' , '100' , '100' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '111.9768' ) 08/10/2024 10:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 08/10/2024 10:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 08/10/2024 10:36:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93507' , '16689' , 'OSTIA PAN DI CENA mm80' , '200' , '200' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '242.1120' ) 08/10/2024 10:36:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 08/10/2024 10:36:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 08/10/2024 10:36:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93507' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '200' , '200' , '3' , '2' , '1.9230769230769' , '4' , '0' , '416.0000' ) 08/10/2024 10:36:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 08/10/2024 10:36:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 08/10/2024 10:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93507' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '3' , '3' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '6.3554' ) 08/10/2024 10:36:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '22' 08/10/2024 10:36:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '22' , '1' ) 08/10/2024 10:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93507' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '7' , '7' , '3' , '2.5' , '2.4038461538462' , '4' , '3' , '17.6540' ) 08/10/2024 10:36:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '22' 08/10/2024 10:36:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '22' , '1' ) 08/10/2024 10:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93507' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '50' , '50' , '3' , '1.9' , '1.8269230769231' , '4' , '0' , '98.8000' ) 08/10/2024 10:36:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '22' 08/10/2024 10:36:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '22' , '1' ) 08/10/2024 10:38:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2928' AND id_document != '93473' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-05') 08/10/2024 10:38:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2928', document_date = '2024-10-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 = '104.30', price_tax_excluded = '87.32', date_upd = NOW() WHERE id_document = '93473' 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93473' 08/10/2024 10:38:04 am >> DELETE FROM ps_document_detail WHERE id_document = '93473' 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4' , '3.8461538461538' , '4' , '0' , '4.00' ) 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '22.80' ) 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 08/10/2024 10:38:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93473' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/10/2024 10:39:35 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ugmbVPInD42CzhE3' , NOW() , NOW() ) 08/10/2024 10:39:35 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4123' , '1' ) 08/10/2024 10:39:35 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4123' , '2' ) 08/10/2024 10:39:35 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4123' , '3' ) 08/10/2024 10:41:25 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4123' 08/10/2024 10:41:25 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 ( '4123' , '10' , '191' , 'Associazione Diffusione Sociale Locale' , 'ROSSOLINI' , 'DON FRANCESCO' , 'VIA GRENOBLE 9' , '' , '43123' , 'PARMA' , '' , '' , '3333083842' , '' , '' , NOW() , NOW() ) 08/10/2024 10:41:25 am >> UPDATE ps_customer SET email = 'donrossolini@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4123' 08/10/2024 10:43:59 am >> SELECT document_num FROM ps_document WHERE document_num = '140' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 10: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 ( '21' , '140' , '2024-10-08' , '' , '4123' , '0' , '4679380' , 'VIA GRENOBLE 9 43123 PARMA' , '' , '' , '4.99' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '26.38' , '26.38' , NOW() , NOW() ) 08/10/2024 10: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 = '93508' 08/10/2024 10:43:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93508' 08/10/2024 10: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 ( '93508' , '8855' , 'REGISTRO DEL CATECHISTA' , '30' , '-30' , '4' , '0.713' , '0.713' , '0' , '0' , '21.39' ) 08/10/2024 10:48:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 10:48: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' , '2956' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.15' , '54.15' , NOW() , NOW() ) 08/10/2024 10:48: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 = '93509' 08/10/2024 10:48:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93509' 08/10/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93509' , '23001' , 'MISTERO DI UN DIO TRINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 08/10/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93509' , '22564' , 'PAOLO E L\'EVANGELO DELLA SPERANZA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 08/10/2024 11:03:09 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'HZN6FBvdq2yU0IBV' , NOW() , NOW() ) 08/10/2024 11:03:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4124' , '1' ) 08/10/2024 11:03:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4124' , '2' ) 08/10/2024 11:03:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4124' , '3' ) 08/10/2024 11:03:29 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fLLmilcfAhBTopS2' , NOW() , NOW() ) 08/10/2024 11:03:29 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4125' , '1' ) 08/10/2024 11:03:29 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4125' , '2' ) 08/10/2024 11:03:29 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4125' , '3' ) 08/10/2024 11:07:35 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4125' 08/10/2024 11:07:35 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 ( '4125' , '10' , '183' , 'PARR. MARIA SS DEL BUONCONSIGLIO' , 'ALFANO' , 'DON CIRO' , 'VIA BUONCONSIGLIO 154' , '' , '80057' , 'SANT\'ANTONIO ABATE' , 'suor gerarda 3472331277' , '' , '' , '' , '90006750633' , NOW() , NOW() ) 08/10/2024 11:07:35 am >> UPDATE ps_customer SET email = 'alfano.arcangelociro@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4125' 08/10/2024 11:08:58 am >> SELECT document_num FROM ps_document WHERE document_num = '141' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 11:08:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '141' , '2024-10-08' , '' , '4125' , '0' , '4679381' , 'VIA BUONCONSIGLIO 154 80057 SANT\\\'ANTONIO ABATE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '265.20' , '265.20' , NOW() , NOW() ) 08/10/2024 11:08:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93510' 08/10/2024 11:08:58 am >> DELETE FROM ps_document_detail WHERE id_document = '93510' 08/10/2024 11:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93510' , '11191' , 'VENITE CON ME 1 PARTE' , '50' , '-50' , '4' , '2.80' , '2.8' , '0' , '15' , '119.00' ) 08/10/2024 11:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93510' , '11192' , 'VENITE CON ME 2 PARTE' , '50' , '-50' , '4' , '2.80' , '2.8' , '0' , '15' , '119.00' ) 08/10/2024 11:08:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93510' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.00' , '8' , '0' , '15' , '27.20' ) 08/10/2024 11:10:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 11:10:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2957' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.60' , NOW() , NOW() ) 08/10/2024 11:10:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93511' 08/10/2024 11:10:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93511' 08/10/2024 11:10:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93511' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 08/10/2024 11:13:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 11:13:42 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' , '2958' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '22.54' , NOW() , NOW() ) 08/10/2024 11:13:42 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 = '93512' 08/10/2024 11:13:42 am >> DELETE FROM ps_document_detail WHERE id_document = '93512' 08/10/2024 11:13:42 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 ( '93512' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 08/10/2024 11:13:42 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 ( '93512' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 08/10/2024 11:13:42 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 ( '93512' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 08/10/2024 11:15:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 11:15:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2959' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.30' , '6.80' , NOW() , NOW() ) 08/10/2024 11:15:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93513' 08/10/2024 11:15:18 am >> DELETE FROM ps_document_detail WHERE id_document = '93513' 08/10/2024 11:15:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93513' , '22546' , 'ROSARIO LEGNO - MM5 - R944' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 08/10/2024 11:15:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93513' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 08/10/2024 11:20:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 11:20:41 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' , '2960' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 08/10/2024 11:20:41 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 = '93514' 08/10/2024 11:20:41 am >> DELETE FROM ps_document_detail WHERE id_document = '93514' 08/10/2024 11:20:41 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 ( '93514' , '22051' , 'FINTA CANDELA COMPLETA 4X30 - 1140' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 08/10/2024 11:25:27 am >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 08/10/2024 11:25:27 am >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2024-07-22', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '56.00', price_tax_excluded = '53.26', date_upd = NOW() WHERE id_document = '92691' 08/10/2024 11:25: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 = '92691' 08/10/2024 11:25:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92691' 08/10/2024 11:25: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 ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 08/10/2024 11:25: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 ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 08/10/2024 11:25: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 ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 08/10/2024 11:25: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 ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 08/10/2024 11:25: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 ( '92691' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 08/10/2024 11:25: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 ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 08/10/2024 11:29:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 11:29:25 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' , '2961' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.20' , '13.28' , NOW() , NOW() ) 08/10/2024 11:29:25 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 = '93515' 08/10/2024 11:29:25 am >> DELETE FROM ps_document_detail WHERE id_document = '93515' 08/10/2024 11:29:25 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 ( '93515' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 08/10/2024 11:29:25 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 ( '93515' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 08/10/2024 01:19:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 01:19:10 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' , '2962' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.90' , '104.80' , NOW() , NOW() ) 08/10/2024 01:19: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 = '93516' 08/10/2024 01:19:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '93516' 08/10/2024 01:19: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 ( '93516' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '-2' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '99.80' ) 08/10/2024 01:19: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 ( '93516' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 08/10/2024 01:19: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 ( '93516' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/10/2024 01:19: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 ( '93516' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/10/2024 01:19: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 ( '93516' , '22963' , 'VINO ROSSO DOLCE MIGNON' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 08/10/2024 03:58:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2592' AND id_document != '93017' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 08/10/2024 03:58:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2592', document_date = '2024-09-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 = '69.67', price_tax_excluded = '69.00', date_upd = NOW() WHERE id_document = '93017' 08/10/2024 03:58: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 = '93017' 08/10/2024 03:58:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93017' 08/10/2024 03:58: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 ( '93017' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/10/2024 03:58: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 ( '93017' , '15580' , 'CHRISTUS VIVIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 08/10/2024 03:58: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 ( '93017' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 08/10/2024 03:58: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 ( '93017' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 08/10/2024 03:58: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 ( '93017' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 08/10/2024 03:58: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 ( '93017' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 08/10/2024 03:58: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 ( '93017' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 08/10/2024 03:58: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 ( '93017' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 08/10/2024 03:58: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 ( '93017' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/10/2024 03:58: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 ( '93017' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 08/10/2024 03:58: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 ( '93017' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 08/10/2024 03:58: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 ( '93017' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 08/10/2024 04:13:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '93264' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 08/10/2024 04:13:26 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2024-09-24', document_letter = '', id_customer = '351', id_supplier = '', id_address = '4673707', address1 = 'VIA MASSARENTI, 418 40138 BOLOGNA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '82.39', price_tax_excluded = '82.39', date_upd = NOW() WHERE id_document = '93264' 08/10/2024 04:13: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 = '93264' 08/10/2024 04:13:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '93264' 08/10/2024 04:13: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 ( '93264' , '17257' , 'IO TI BATTEZZO ' , '9' , '-9' , '4' , '1.7100' , '1.71' , '0' , '0' , '15.39' ) 08/10/2024 04:13: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 ( '93264' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '2' , '-2' , '4' , '11.00' , '11' , '0' , '15' , '18.70' ) 08/10/2024 04:13: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 ( '93264' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 08/10/2024 04:13: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 ( '93264' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 08/10/2024 04:13: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 ( '93264' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '-6' , '4' , '1' , '1' , '0' , '15' , '5.10' ) 08/10/2024 04:13: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 ( '93264' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.7' , '0.7' , '0' , '0' , '0.70' ) 08/10/2024 04:14:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '93274' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-24') 08/10/2024 04:14:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '123', document_date = '2024-09-24', document_letter = '', id_customer = '2320', id_supplier = '', id_address = '4677538', address1 = 'VIA CONVENTO, 12 75011 ACCETTURA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '17.90', price_tax_excluded = '17.90', date_upd = NOW() WHERE id_document = '93274' 08/10/2024 04:14: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 = '93274' 08/10/2024 04:14:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93274' 08/10/2024 04:14: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 ( '93274' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9000' , '2.9' , '' , '0' , '2.90' ) 08/10/2024 04:14: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 ( '93274' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 08/10/2024 04:18:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '93324' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-27') 08/10/2024 04:18:10 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '129', document_date = '2024-09-27', document_letter = '', id_customer = '3533', id_supplier = '', id_address = '4672868', address1 = 'VIALE FRENTANO 2 66030 MOZZAGROGNA', address2 = '', note = '', price_shipping = '2.85', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '137.46', price_tax_excluded = '137.46', date_upd = NOW() WHERE id_document = '93324' 08/10/2024 04:18: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 = '93324' 08/10/2024 04:18:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '93324' 08/10/2024 04:18: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 ( '93324' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 08/10/2024 04:18: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 ( '93324' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 08/10/2024 04:18: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 ( '93324' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '2' , '-2' , '4' , '7.5' , '7.5' , '0' , '0' , '15.00' ) 08/10/2024 04:18: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 ( '93324' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '2' , '-2' , '4' , '10.2' , '10.2' , '0' , '0' , '20.40' ) 08/10/2024 04:18: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 ( '93324' , '6629' , 'MIA PREGHIERA' , '20' , '-20' , '4' , '0.9000' , '0.9' , '0' , '15' , '15.30' ) 08/10/2024 04:18: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 ( '93324' , '15020' , 'PREGARE OGNI GIORNO' , '50' , '-50' , '4' , '1.0000' , '1' , '0' , '15' , '42.50' ) 08/10/2024 04:18: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 ( '93324' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '-2' , '4' , '6.2000' , '6.2' , '0' , '15' , '10.54' ) 08/10/2024 04:18: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 ( '93324' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '2' , '-2' , '4' , '5.1600' , '5.16' , '0' , '15' , '8.77' ) 08/10/2024 04:19:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '93331' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-28') 08/10/2024 04:19:16 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '130', document_date = '2024-09-28', document_letter = '', id_customer = '3045', id_supplier = '', id_address = '4679365', address1 = 'VIA MAESTRI DEL LAVORO 17 85100 POTENZA', 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 = '298.00', price_tax_excluded = '298.00', date_upd = NOW() WHERE id_document = '93331' 08/10/2024 04:19: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 = '93331' 08/10/2024 04:19:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93331' 08/10/2024 04:19: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 ( '93331' , '11193' , 'VENITE CON ME CAT.' , '25' , '-25' , '4' , '5.5000' , '5.5' , '0' , '10' , '123.75' ) 08/10/2024 04:19: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 ( '93331' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '25' , '-25' , '4' , '5.5000' , '5.5' , '0' , '10' , '123.75' ) 08/10/2024 04:19: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 ( '93331' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '15' , '42.50' ) 08/10/2024 04:19: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 ( '93331' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 08/10/2024 04:55:42 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'QyXB0mMlAkC9TZGM' , NOW() , NOW() ) 08/10/2024 04:55:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4126' , '1' ) 08/10/2024 04:55:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4126' , '2' ) 08/10/2024 04:55:42 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4126' , '3' ) 08/10/2024 04:57:41 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4126' 08/10/2024 04:57:41 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 ( '4126' , '10' , '219' , '' , 'PULICI' , 'NUNZIA' , 'VIA DEI CADUTI PER LA LIBERTA\' 90' , '' , '10037' , 'TORRAZZA PIEMONTE' , '' , '' , '3534376820' , '' , '' , NOW() , NOW() ) 08/10/2024 04:57:42 pm >> UPDATE ps_customer SET email = 'matteo.careggio@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4126' 08/10/2024 04:58:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '142' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 04:58:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '142' , '2024-10-08' , '' , '4126' , '0' , '4679382' , 'VIA DEI CADUTI PER LA LIBERTA\\\' 90 10037 TORRAZZA PIEMONTE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '34.17' , '34.17' , NOW() , NOW() ) 08/10/2024 04:58:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93517' 08/10/2024 04:58:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93517' 08/10/2024 04:58: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 ( '93517' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.23' , '5.23' , '0' , '' , '5.23' ) 08/10/2024 04:58: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 ( '93517' , '5457' , 'IO SONO CON VOI 1 PARTE' , '9' , '-9' , '4' , '2.80' , '2.8' , '0' , '5' , '23.94' ) 08/10/2024 04:59:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '143' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 04:59: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 ( '21' , '143' , '2024-10-08' , '' , '84' , '0' , '4679369' , 'VIA MANFREDI 30 29122 PIACENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '71.40' , '71.40' , NOW() , NOW() ) 08/10/2024 04:59: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 = '93518' 08/10/2024 04:59:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93518' 08/10/2024 04:59: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 ( '93518' , '5458' , 'IO SONO CON VOI 2 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 08/10/2024 05:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '92874' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-08-26') 08/10/2024 05:05:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '89/A', document_date = '2024-08-26', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '121.90', price_tax_excluded = '101.59', date_upd = NOW() WHERE id_document = '92874' 08/10/2024 05:05:25 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 = '92874' 08/10/2024 05:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92874' 08/10/2024 05:05: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 ( '92874' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 08/10/2024 05:05: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 ( '92874' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '5' , '-5' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '37.50' ) 08/10/2024 05:05: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 ( '92874' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 08/10/2024 05:05: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 ( '92874' , '14773' , 'BRACCIALE RIGATO - 0825N' , '3' , '-3' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '3.90' ) 08/10/2024 05:05: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 ( '92874' , '22651' , 'QUADRETTO S. FAMIGLIA - 25/101-22' , '2' , '-2' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '18.00' ) 08/10/2024 05:05: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 ( '92874' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/10/2024 05:05: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 ( '92874' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 08/10/2024 05:05: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 ( '92874' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/10/2024 05:05: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 ( '92874' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '41.40' ) 08/10/2024 05:43:33 pm >> DELETE FROM ps_document WHERE id_document = '93137' 08/10/2024 05:43:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93137' 08/10/2024 05:44:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 05:44:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2963' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '342.00' , '342.00' , NOW() , NOW() ) 08/10/2024 05:44:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93519' 08/10/2024 05:44:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93519' 08/10/2024 05:44:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93519' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '24' , '-24' , '4' , '15.00' , '15' , '0' , '5' , '342.00' ) 08/10/2024 05:56:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2916' AND id_document != '93457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-04') 08/10/2024 05:56:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2916', document_date = '2024-10-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 = '465.00', price_tax_excluded = '381.15', date_upd = NOW() WHERE id_document = '93457' 08/10/2024 05:56: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 = '93457' 08/10/2024 05:56:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93457' 08/10/2024 05:56: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 ( '93457' , '14362' , 'CAMICE SVASATO - 434/TPA' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 08/10/2024 05:56: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 ( '93457' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '3' , '-3' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '177.00' ) 08/10/2024 05:56: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 ( '93457' , '17991' , 'STOLA LINO/POL GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '148' , '121.31147540984' , '22' , '0' , '148.00' ) 08/10/2024 06:13:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 06:13:17 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' , '2964' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.00' , '129.51' , NOW() , NOW() ) 08/10/2024 06:13: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 = '93520' 08/10/2024 06:13:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93520' 08/10/2024 06:13: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 ( '93520' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 08/10/2024 06:13: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 ( '93520' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 08/10/2024 06:13: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 ( '93520' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '41.00' , '33.606557377049' , '22' , '0' , '41.00' ) 08/10/2024 06:13: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 ( '93520' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 08/10/2024 06:19:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 06:19: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' , '2965' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.21' , '40.21' , NOW() , NOW() ) 08/10/2024 06:19: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 = '93521' 08/10/2024 06:19:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93521' 08/10/2024 06:19: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 ( '93521' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/10/2024 06:19: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 ( '93521' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/10/2024 06:19: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 ( '93521' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/10/2024 06:19: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 ( '93521' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 08/10/2024 06:19: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 ( '93521' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 08/10/2024 06:19: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 ( '93521' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 08/10/2024 06:19: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 ( '93521' , '22556' , 'NUMERI DI DIO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 08/10/2024 06:23:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2839' AND id_document != '93347' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 08/10/2024 06:23:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2839', document_date = '2024-09-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '93347' 08/10/2024 06:23: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 = '93347' 08/10/2024 06:23:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93347' 08/10/2024 06:23: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 ( '93347' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 08/10/2024 06:23: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 ( '93347' , '17006' , 'SEGNALIBRO PR' , '10' , '-10' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '3.00' ) 08/10/2024 06:23:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2672' AND id_document != '93121' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-13') 08/10/2024 06:23:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2672', document_date = '2024-09-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '93121' 08/10/2024 06:23: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 = '93121' 08/10/2024 06:23:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93121' 08/10/2024 06:23: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 ( '93121' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 08/10/2024 06:23: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 ( '93121' , '17006' , 'SEGNALIBRO PR' , '10' , '-10' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '3.00' ) 08/10/2024 06:23:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2655' AND id_document != '93100' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-11') 08/10/2024 06:23:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2655', document_date = '2024-09-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA SAN LEONARDO 84100 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 = '391.54', price_tax_excluded = '336.12', date_upd = NOW() WHERE id_document = '93100' 08/10/2024 06:23: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 = '93100' 08/10/2024 06:23:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93100' 08/10/2024 06:23: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 ( '93100' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 08/10/2024 06:23: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 ( '93100' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '19.00' ) 08/10/2024 06:23: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 ( '93100' , '22712' , 'AMEN - OTT 24' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 08/10/2024 06:23: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 ( '93100' , '22713' , 'AMEN - SET 24' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 08/10/2024 06:23: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 ( '93100' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '3' , '-3' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '6.00' ) 08/10/2024 06:23: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 ( '93100' , '17006' , 'SEGNALIBRO PR' , '11' , '-11' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '3.30' ) 08/10/2024 06:23: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 ( '93100' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '7' , '-7' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '9.10' ) 08/10/2024 06:23: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 ( '93100' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '14' , '-14' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '18.20' ) 08/10/2024 06:23: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 ( '93100' , '19231' , 'CARD CARLO ACUTIS - RN93' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 08/10/2024 06:23: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 ( '93100' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 08/10/2024 06:23: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 ( '93100' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/10/2024 06:23: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 ( '93100' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 08/10/2024 06:23: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 ( '93100' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 08/10/2024 06:23: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 ( '93100' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 08/10/2024 06:23: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 ( '93100' , '21099' , 'BRACCIALE DECINA - BD008' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 08/10/2024 06:23: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 ( '93100' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 08/10/2024 06:23: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 ( '93100' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/10/2024 06:23: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 ( '93100' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 08/10/2024 06:23: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 ( '93100' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 08/10/2024 08:01:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-08') 08/10/2024 08:01:26 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' , '2966' , '2024-10-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.30' , '15.82' , NOW() , NOW() ) 08/10/2024 08:01: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 = '93522' 08/10/2024 08:01:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '93522' 08/10/2024 08:01: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 ( '93522' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 08/10/2024 08:01: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 ( '93522' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 08/10/2024 08:01: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 ( '93522' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' )