24/10/2024 09:26:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 09:26:27 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' , '3161' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 24/10/2024 09:26: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 = '93795' 24/10/2024 09:26:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93795' 24/10/2024 09:26: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 ( '93795' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 24/10/2024 09:26:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 09:26:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3162' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '12.50' , NOW() , NOW() ) 24/10/2024 09:26:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93796' 24/10/2024 09:26:49 am >> DELETE FROM ps_document_detail WHERE id_document = '93796' 24/10/2024 09:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93796' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 24/10/2024 09:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93796' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 24/10/2024 09:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93796' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 24/10/2024 09:52:36 am >> SELECT document_num FROM ps_document WHERE document_num = '177' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 09:52:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '177' , '2024-10-24' , '' , '3191' , '0' , '4679345' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.20' , '112.20' , NOW() , NOW() ) 24/10/2024 09:52:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93797' 24/10/2024 09:52:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93797' 24/10/2024 09:52:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93797' , '4154' , 'FESTA DEL PERDONO' , '22' , '-22' , '4' , '3.00' , '3' , '0' , '15' , '56.10' ) 24/10/2024 09:52:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93797' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '11' , '-11' , '4' , '6.00' , '6' , '0' , '15' , '56.10' ) 24/10/2024 09:53:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 09:53:07 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' , '3163' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.30' , '51.30' , NOW() , NOW() ) 24/10/2024 09:53:07 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 = '93798' 24/10/2024 09:53:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93798' 24/10/2024 09:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93798' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/10/2024 09:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93798' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '17' , '-17' , '4' , '3.00' , '3' , '0' , '5' , '48.45' ) 24/10/2024 09:53:57 am >> SELECT document_num FROM ps_document WHERE document_num = '177' AND id_document != '93797' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 09:53:57 am >> UPDATE ps_document SET id_document_type = '21', document_num = '177', document_date = '2024-10-24', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4679345', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '88.83', price_tax_excluded = '88.83', date_upd = NOW() WHERE id_document = '93797' 24/10/2024 09:53: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 = '93797' 24/10/2024 09:53:57 am >> DELETE FROM ps_document_detail WHERE id_document = '93797' 24/10/2024 09:53: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 ( '93797' , '4154' , 'FESTA DEL PERDONO' , '22' , '-22' , '4' , '3.0000' , '3' , '0' , '15' , '56.10' ) 24/10/2024 09:53: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 ( '93797' , '2679' , 'CONOSCERE GESU\'' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '15' , '32.73' ) 24/10/2024 09:57:30 am >> SELECT document_num FROM ps_document WHERE document_num = '177' AND id_document != '93797' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 09:57:30 am >> UPDATE ps_document SET id_document_type = '21', document_num = '177', document_date = '2024-10-24', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4679345', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '88.83', price_tax_excluded = '88.83', date_upd = NOW() WHERE id_document = '93797' 24/10/2024 09:57: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 = '93797' 24/10/2024 09:57:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93797' 24/10/2024 09:57: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 ( '93797' , '4154' , 'FESTA DEL PERDONO' , '22' , '-22' , '4' , '3.0000' , '3' , '0' , '15' , '56.10' ) 24/10/2024 09:57: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 ( '93797' , '2679' , 'CONOSCERE GESU\'' , '11' , '-11' , '4' , '3.5000' , '3.5' , '0' , '15' , '32.73' ) 24/10/2024 10:08:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:08:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3164' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '89.77' , NOW() , NOW() ) 24/10/2024 10:08:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93799' 24/10/2024 10:08:15 am >> DELETE FROM ps_document_detail WHERE id_document = '93799' 24/10/2024 10:08:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93799' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 24/10/2024 10:08:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93799' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 24/10/2024 10:08:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93799' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 24/10/2024 10:08:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93799' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 24/10/2024 10:10:51 am >> SELECT document_num FROM ps_document WHERE document_num = '178' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:10:51 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' , '178' , '2024-10-24' , '' , '1155' , '0' , '4672061' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.71' , '129.71' , NOW() , NOW() ) 24/10/2024 10:10:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93800' 24/10/2024 10:10:51 am >> DELETE FROM ps_document_detail WHERE id_document = '93800' 24/10/2024 10:10:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.45' ) 24/10/2024 10:10:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '11191' , 'VENITE CON ME 1 PARTE' , '23' , '-23' , '4' , '2.80' , '2.8' , '0' , '15' , '54.74' ) 24/10/2024 10:10:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 24/10/2024 10:10:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '5458' , 'IO SONO CON VOI 2 PARTE' , '4' , '-4' , '4' , '2.80' , '2.8' , '0' , '15' , '9.52' ) 24/10/2024 10:10:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '18' , '-18' , '4' , '3.40' , '3.4' , '0' , '15' , '52.02' ) 24/10/2024 10:14:44 am >> SELECT document_num FROM ps_document WHERE document_num = '178' AND id_document != '93800' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:14:44 am >> UPDATE ps_document SET id_document_type = '21', document_num = '178', document_date = '2024-10-24', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '4672061', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', 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 = '129.71', price_tax_excluded = '129.71', date_upd = NOW() WHERE id_document = '93800' 24/10/2024 10:14:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93800' 24/10/2024 10:14:44 am >> DELETE FROM ps_document_detail WHERE id_document = '93800' 24/10/2024 10:14:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '5' , '10.45' ) 24/10/2024 10:14:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '11191' , 'VENITE CON ME 1 PARTE' , '23' , '-23' , '4' , '2.8000' , '2.8' , '0' , '15' , '54.74' ) 24/10/2024 10:14:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 24/10/2024 10:14:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '5458' , 'IO SONO CON VOI 2 PARTE' , '4' , '-4' , '4' , '2.8000' , '2.8' , '0' , '15' , '9.52' ) 24/10/2024 10:14:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93800' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '18' , '-18' , '4' , '3.4000' , '3.4' , '0' , '15' , '52.02' ) 24/10/2024 10:24:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3165' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:24:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3165' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 24/10/2024 10:24:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93801' 24/10/2024 10:24:09 am >> DELETE FROM ps_document_detail WHERE id_document = '93801' 24/10/2024 10:24:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93801' , '13506' , 'SANTO ROSARIO' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 24/10/2024 10:24:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93801' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '43' , '-43' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '12.90' ) 24/10/2024 10:24:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93801' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '7' , '-7' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '2.10' ) 24/10/2024 10:24:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3166' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:24:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3166' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 24/10/2024 10:24:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93802' 24/10/2024 10:24:22 am >> DELETE FROM ps_document_detail WHERE id_document = '93802' 24/10/2024 10:24:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93802' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 24/10/2024 10:27:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3167' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:27: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' , '3167' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.43' , NOW() , NOW() ) 24/10/2024 10:27: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 = '93803' 24/10/2024 10:27:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93803' 24/10/2024 10:27: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 ( '93803' , '22896' , 'CALENDARIO DELLA FAMIGLIA 2025' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 24/10/2024 10:27: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 ( '93803' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 24/10/2024 10:36:46 am >> SELECT document_num FROM ps_document WHERE document_num = '179' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:36:46 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' , '179' , '2024-10-24' , '' , '1207' , '0' , '4672082' , 'VIA SS. SALVATORE, 2 84080 CALVANICO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '322.58' , '322.58' , NOW() , NOW() ) 24/10/2024 10:36:46 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 = '93804' 24/10/2024 10:36:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93804' 24/10/2024 10:36:46 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 ( '93804' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 24/10/2024 10:36:46 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 ( '93804' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '15' , '-15' , '4' , '3.40' , '3.4' , '0' , '15' , '43.35' ) 24/10/2024 10:36:46 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 ( '93804' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.40' , '2.4' , '0' , '15' , '40.80' ) 24/10/2024 10:36:46 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 ( '93804' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.80' , '3.8' , '0' , '15' , '64.60' ) 24/10/2024 10:36:46 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 ( '93804' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.80' , '3.8' , '0' , '15' , '64.60' ) 24/10/2024 10:36:46 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 ( '93804' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '-20' , '4' , '3.80' , '3.8' , '0' , '15' , '64.60' ) 24/10/2024 10:48:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3168' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 10:48:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3168' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.78' , '78.58' , NOW() , NOW() ) 24/10/2024 10:48: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 = '93805' 24/10/2024 10:48:11 am >> DELETE FROM ps_document_detail WHERE id_document = '93805' 24/10/2024 10:48: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 ( '93805' , '22915' , 'CINQUE PANI DORZO 2025' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 24/10/2024 10:48: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 ( '93805' , '21596' , 'CARTOLINE PREGHIERE' , '25' , '-25' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '7.50' ) 24/10/2024 10:48: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 ( '93805' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/10/2024 10:48: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 ( '93805' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 24/10/2024 10:48: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 ( '93805' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 24/10/2024 10:48: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 ( '93805' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 24/10/2024 10:48: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 ( '93805' , '23088' , 'CAMPANA DEL GIUBILEO' , '2' , '-2' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '40.00' ) 24/10/2024 10:48: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 ( '93805' , '22916' , 'SACCA GIUBILEO ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 24/10/2024 10:57:54 am >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '89371' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 24/10/2024 10:57:54 am >> UPDATE ps_document SET id_document_type = '24', document_num = '52', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca del Convento dei Padri minimi di Santa Maria della Stella\r\nv. Stella 25 - 80137 Napoli \r\n', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '89371' 24/10/2024 10:57: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 = '89371' 24/10/2024 10:57:54 am >> DELETE FROM ps_document_detail WHERE id_document = '89371' 24/10/2024 10:57: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 ( '89371' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 24/10/2024 10:57: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 ( '89371' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 24/10/2024 10:57: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 ( '89371' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 24/10/2024 10:57: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 ( '89371' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/10/2024 10:57: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 ( '89371' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/10/2024 10:57: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 ( '89371' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57: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 ( '89371' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57: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 ( '89371' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57: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 ( '89371' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/10/2024 10:57: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 ( '89371' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/10/2024 10:57: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 ( '89371' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/10/2024 10:57: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 ( '89371' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 24/10/2024 10:57: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 ( '89371' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 24/10/2024 10:57: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 ( '89371' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/10/2024 10:57: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 ( '89371' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/10/2024 10:57: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 ( '89371' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/10/2024 10:57: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 ( '89371' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57: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 ( '89371' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57: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 ( '89371' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 24/10/2024 10:57: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 ( '89371' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57: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 ( '89371' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/10/2024 10:57: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 ( '89371' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/10/2024 10:57: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 ( '89371' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 24/10/2024 10:57: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 ( '89371' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57: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 ( '89371' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57: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 ( '89371' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57: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 ( '89371' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57: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 ( '89371' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57: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 ( '89371' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20610' , 'SOLE ANCHE DI NOTTE - D. BLAIN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '22039' , 'VANGELO DI LUCA - G. ROSSE' , '1' , '-1' , '4' , '69.5000' , '69.5' , '0' , '0' , '69.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '22043' , 'MATTEO - R. FABRIS' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '22044' , 'GIOVANNI - R.E. BROWN' , '1' , '-1' , '4' , '66.5000' , '66.5' , '0' , '0' , '66.50' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '3596' , 'DIZIONARIO DI OMILETICA - SODI/TRICCA' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '20985' , 'BIBBIA E LITURGIA - O. VEZZOLI' , '1' , '-1' , '4' , '33.0000' , '33' , '0' , '0' , '33.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '17421' , 'DIALOGO DELLA DIVINA PROVVIDENZA ' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 24/10/2024 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89371' , '19054' , 'GRANDE LIBRO DELLE FIABE' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '0' , '39.00' ) 24/10/2024 10:57:56 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 ( '89371' , '10565' , 'TEOLOGIA DELLA LITURGIA - J. RATZINGER' , '1' , '-1' , '4' , '55.0000' , '55' , '0' , '0' , '55.00' ) 24/10/2024 10:57:56 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 ( '89371' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 24/10/2024 10:57:56 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 ( '89371' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 24/10/2024 10:57:56 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 ( '89371' , '15122' , 'PREGHIERE PER OGNI GIORNO DELL\'ANNO - 8738' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 24/10/2024 10:57:56 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 ( '89371' , '19326' , 'SUL DOLORE - P. CURTAZ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 24/10/2024 10:57:56 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 ( '89371' , '13132' , 'IDEA DI RIVELAZIONE - OPERA OMNIA - RATZINGER' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 24/10/2024 10:57:56 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 ( '89371' , '14418' , 'MISSALE ROMANUM EDITIO TERTIA' , '1' , '-1' , '4' , '200.0000' , '200' , '0' , '0' , '200.00' ) 24/10/2024 10:57:56 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 ( '89371' , '3733' , 'E DANZANDO CANTERANNO VAL.' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 24/10/2024 10:57:56 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 ( '89371' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '-1' , '4' , '63.00' , '63' , '0' , '0' , '63.00' ) 24/10/2024 10:57:56 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 ( '89371' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '794.5' , '794.5' , '0' , '0' , '794.50' ) 24/10/2024 11:05:13 am >> SELECT document_num FROM ps_document WHERE document_num = '179' AND id_document != '93804' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 11:05:13 am >> UPDATE ps_document SET id_document_type = '21', document_num = '179', document_date = '2024-10-24', document_letter = '', id_customer = '1207', id_supplier = '', id_address = '4672082', address1 = 'VIA SS. SALVATORE, 2 84080 CALVANICO', 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 = '322.58', price_tax_excluded = '322.58', date_upd = NOW() WHERE id_document = '93804' 24/10/2024 11:05:13 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 = '93804' 24/10/2024 11:05:13 am >> DELETE FROM ps_document_detail WHERE id_document = '93804' 24/10/2024 11:05:13 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 ( '93804' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 24/10/2024 11:05:13 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 ( '93804' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '15' , '-15' , '4' , '3.4000' , '3.4' , '0' , '15' , '43.35' ) 24/10/2024 11:05:13 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 ( '93804' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 24/10/2024 11:05:13 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 ( '93804' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.8000' , '3.8' , '0' , '15' , '64.60' ) 24/10/2024 11:05:13 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 ( '93804' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.8000' , '3.8' , '0' , '15' , '64.60' ) 24/10/2024 11:05:13 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 ( '93804' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '-20' , '4' , '3.8000' , '3.8' , '0' , '15' , '64.60' ) 24/10/2024 11:23:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 11:23:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3169' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.75' , '102.73' , NOW() , NOW() ) 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93806' 24/10/2024 11:23:28 am >> DELETE FROM ps_document_detail WHERE id_document = '93806' 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93806' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93806' , '22722' , 'FRANCESCO CHIARA ANTONIO PICCOLE LETTURE ' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93806' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93806' , '18791' , 'OGGI SARAI CON ME IN PARADISO - M. ANDINA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93806' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 24/10/2024 11:23:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93806' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 24/10/2024 11:26:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2919' AND id_document != '93460' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-04') 24/10/2024 11:26:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2919', 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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '93460' 24/10/2024 11:26: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 = '93460' 24/10/2024 11:26:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93460' 24/10/2024 11:26: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 ( '93460' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 24/10/2024 11:26: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 ( '93460' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '82.00' , '67.213114754098' , '22' , '0' , '82.00' ) 24/10/2024 11:32:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042774' AND id_product != '7896' AND ean13 != '' 24/10/2024 11:32:16 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884042774', date_upd = NOW() WHERE id_product = '7896' 24/10/2024 11:32:16 am >> UPDATE ps_product_lang SET name = 'PERDONO GUARISCE', description = '' WHERE id_product = '7896' 24/10/2024 11:32:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0000' WHERE id_product = '7896' 24/10/2024 11:32:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7896' 24/10/2024 11:32:16 am >> DELETE FROM ps_specific_price WHERE id_product = '7896' 24/10/2024 11:38:42 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 24/10/2024 11:38:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23090' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 11:38:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23090' , '1' , '1' , '2' , NOW() , NOW() ) 24/10/2024 11:38:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23090' , '0' , '1' , '0' , '0' ) 24/10/2024 11:39:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'AC5' AND id_product != '23090' AND ean13 != '' 24/10/2024 11:39:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'AC5', date_upd = NOW() WHERE id_product = '23090' 24/10/2024 11:39:40 am >> UPDATE ps_product_lang SET name = 'ALBERO CON PRESEPE ', description = '' WHERE id_product = '23090' 24/10/2024 11:39:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '23090' 24/10/2024 11:39:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23090' 24/10/2024 11:39:40 am >> DELETE FROM ps_specific_price WHERE id_product = '23090' 24/10/2024 11:40:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23090' 24/10/2024 11:40:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23091' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 11:40:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23091' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23090' 24/10/2024 11:40:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23091' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23090' 24/10/2024 11:40:50 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8186' 24/10/2024 11:40:50 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8186' 24/10/2024 11:41:04 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8188' 24/10/2024 11:41:04 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8188' 24/10/2024 11:42:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'PFN' AND id_product != '23091' AND ean13 != '' 24/10/2024 11:42:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PFN', date_upd = NOW() WHERE id_product = '23091' 24/10/2024 11:42:27 am >> UPDATE ps_product_lang SET name = 'PORTAFOTO CON COFANETTO', description = '' WHERE id_product = '23091' 24/10/2024 11:42:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.934426229508198' WHERE id_product = '23091' 24/10/2024 11:42:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23091' 24/10/2024 11:42:27 am >> DELETE FROM ps_specific_price WHERE id_product = '23091' 24/10/2024 11:44: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 ( '31' , '782' , '2024-10-21' , '' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '381.86' , '313.00' , NOW() , NOW() ) 24/10/2024 11:44: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 = '93807' 24/10/2024 11:44:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93807' 24/10/2024 11:44: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 ( '93807' , '23090' , 'ALBERO CON PRESEPE ' , '11' , '11' , '1' , '10' , '8.1967213114754' , '22' , '0' , '134.2000' ) 24/10/2024 11:44:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '23090' AND id_supplier = '50' 24/10/2024 11:44:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23090' , '50' , '1' ) 24/10/2024 11:44: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 ( '93807' , '23091' , 'PORTAFOTO CON COFANETTO' , '4' , '4' , '1' , '7' , '5.7377049180328' , '22' , '0' , '34.1600' ) 24/10/2024 11:44:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '23091' AND id_supplier = '50' 24/10/2024 11:44:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23091' , '50' , '1' ) 24/10/2024 11:44: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 ( '93807' , '22257' , 'QUADRO DECORATO 36X22' , '5' , '5' , '1' , '17' , '13.934426229508' , '22' , '0' , '103.7000' ) 24/10/2024 11:44:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22257' AND id_supplier = '50' 24/10/2024 11:44:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22257' , '50' , '1' ) 24/10/2024 11:44: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 ( '93807' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '8' , '8' , '1' , '10' , '8.1967213114754' , '22' , '0' , '97.6000' ) 24/10/2024 11:45:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '13611' AND id_supplier = '50' 24/10/2024 11:45:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13611' , '50' , '1' ) 24/10/2024 11:49:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 11:49:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3170' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.53' , '36.16' , NOW() , NOW() ) 24/10/2024 11:49:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93808' 24/10/2024 11:49:21 am >> DELETE FROM ps_document_detail WHERE id_document = '93808' 24/10/2024 11:49:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93808' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 24/10/2024 11:49:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93808' , '22943' , 'AVVENTO 2024' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/10/2024 11:49:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93808' , '4943' , 'IMITAZIONE DI CRISTO - 8123' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 24/10/2024 11:49:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93808' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '7.60' ) 24/10/2024 12:07:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '47/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 12:07:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '47/E' , '2024-10-24' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '939.92' , '939.92' , NOW() , NOW() ) 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93809' 24/10/2024 12:07:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '93809' 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93809' , '5457' , 'IO SONO CON VOI 1 PARTE' , '280' , '-280' , '4' , '2.80' , '2.8' , '0' , '38' , '486.08' ) 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93809' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.40' , '3.4' , '0' , '38' , '63.24' ) 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93809' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '-10' , '4' , '6.00' , '6' , '0' , '38' , '37.20' ) 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93809' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '38' , '117.80' ) 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93809' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '38' , '117.80' ) 24/10/2024 12:07:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93809' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '38' , '117.80' ) 24/10/2024 12:09:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 12:09:40 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' , '3171' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.17' , NOW() , NOW() ) 24/10/2024 12:09:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93810' 24/10/2024 12:09:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93810' 24/10/2024 12:09:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93810' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 24/10/2024 12:15:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2692' AND id_document != '93147' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-14') 24/10/2024 12:15:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2692', document_date = '2024-09-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '93147' 24/10/2024 12:15: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 = '93147' 24/10/2024 12:15:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93147' 24/10/2024 12:15: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 ( '93147' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '11' , '-11' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '2.20' ) 24/10/2024 12:15: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 ( '93147' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '190.0000' , '155.73770491803' , '22' , '0' , '190.00' ) 24/10/2024 12:15: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 ( '93147' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '2' , '-2' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '5.80' ) 24/10/2024 12:15: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 ( '93147' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 24/10/2024 12:18:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 12:18:04 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 ( '23' , '22/S' , '2024-10-24' , 'S' , '3730' , '0' , '4681792' , 'VIA NAZIONALE APPIA 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '297.60' , '297.60' , NOW() , NOW() ) 24/10/2024 12:18:04 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 = '14762' 24/10/2024 12:18:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 12:18:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14762' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '6.00' , '6' , '0' , '38' , '297.60' ) 24/10/2024 12:21:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2364' AND id_document != '92744' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 24/10/2024 12:21:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2364', document_date = '2024-07-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '92744' 24/10/2024 12:21:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92744' 24/10/2024 12:21:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92744' 24/10/2024 12:21:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92744' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 24/10/2024 12:21:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92744' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 24/10/2024 03:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '30' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 03:26:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '30' , '2024-10-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '3' , '3278.00' , '3278.00' , NOW() , NOW() ) 24/10/2024 03:26:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93811' 24/10/2024 03:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '93811' 24/10/2024 03:26: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 ( '93811' , '11183' , 'VENITE CON ME - GUIDA' , '42' , '-42' , '4' , '8.00' , '8' , '0' , '0' , '336.00' ) 24/10/2024 03:26: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 ( '93811' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '230' , '-230' , '4' , '3.40' , '3.4' , '0' , '0' , '782.00' ) 24/10/2024 03:26: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 ( '93811' , '8408' , 'PRENDETE E MANGIATE' , '600' , '-600' , '4' , '3.00' , '3' , '0' , '0' , '1800.00' ) 24/10/2024 03:26: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 ( '93811' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '360' , '-360' , '4' , '1.00' , '1' , '0' , '0' , '360.00' ) 24/10/2024 03:28:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '48/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 03:28:59 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 ( '23' , '48/E' , '2024-10-24' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '288.00' , '236.07' , NOW() , NOW() ) 24/10/2024 03:28:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93812' 24/10/2024 03:28:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93812' 24/10/2024 03:28:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93812' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 24/10/2024 03:54:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3172' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 03:54:55 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' , '3172' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '564.50' , '488.45' , NOW() , NOW() ) 24/10/2024 03:54:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93813' 24/10/2024 03:54:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93813' 24/10/2024 03:54:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 24/10/2024 03:54:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/10/2024 03:54:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '12' , '9.8360655737705' , '22' , '0' , '24.00' ) 24/10/2024 03:54:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 24/10/2024 03:54:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 24/10/2024 03:54:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '21.50' ) 24/10/2024 03:54:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '40' , '-40' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '140.00' ) 24/10/2024 03:54:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93813' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 24/10/2024 04:00:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '93792' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-23') 24/10/2024 04:00:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '110/A', document_date = '2024-10-23', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '33.80', price_tax_excluded = '32.30', date_upd = NOW() WHERE id_document = '93792' 24/10/2024 04:00: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 = '93792' 24/10/2024 04:00:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93792' 24/10/2024 04:00: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 ( '93792' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 24/10/2024 04:00: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 ( '93792' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 24/10/2024 04:00: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 ( '93792' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 24/10/2024 04:00: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 ( '93792' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 24/10/2024 04:22:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:22:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3173' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 24/10/2024 04:22:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93814' 24/10/2024 04:22:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '93814' 24/10/2024 04:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93814' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 24/10/2024 04:22:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93814' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 24/10/2024 04:22:30 pm >> DELETE FROM ps_document WHERE id_document = '93814' 24/10/2024 04:22:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93814' 24/10/2024 04:23:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:23:05 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' , '3173' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 24/10/2024 04:23:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93815' 24/10/2024 04:23:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '93815' 24/10/2024 04:23:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93815' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '0' , '85.00' ) 24/10/2024 04:23:14 pm >> DELETE FROM ps_document WHERE id_document = '93815' 24/10/2024 04:23:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '93815' 24/10/2024 04:25:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:25:43 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' , '3173' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 24/10/2024 04:25:43 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 = '93816' 24/10/2024 04:25:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93816' 24/10/2024 04:25:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93816' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 24/10/2024 04:31:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:31:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '9' , '2024-10-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2345.00' , '2345.00' , NOW() , NOW() ) 24/10/2024 04:31:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14763' 24/10/2024 04:31:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '14763' 24/10/2024 04:31:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14763' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '240' , '-240' , '4' , '2.00' , '2' , '0' , '0' , '480.00' ) 24/10/2024 04:31:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14763' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '170' , '-170' , '4' , '2.50' , '2.5' , '0' , '0' , '425.00' ) 24/10/2024 04:31:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14763' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '48' , '-48' , '4' , '30.00' , '30' , '0' , '0' , '1440.00' ) 24/10/2024 04:33:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '14762' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:33:41 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '22/S', document_date = '2024-10-24', document_letter = 'S', id_customer = '3730', id_supplier = '', id_address = '4681792', address1 = 'VIA NAZIONALE APPIA 81022 CASAGIOVE', 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 = '297.60', price_tax_excluded = '297.60', date_upd = NOW() WHERE id_document = '14762' 24/10/2024 04:33:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 04:33:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 04:33:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14762' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '6.0000' , '6' , '0' , '38' , '297.60' ) 24/10/2024 04:51:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3174' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:51:01 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' , '3174' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 24/10/2024 04:51:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93817' 24/10/2024 04:51:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '93817' 24/10/2024 04:51:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93817' , '18962' , 'POLO MISTO VISCOSA ML ' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 24/10/2024 04:59:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '111/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 04:59:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '111/A' , '2024-10-24' , 'A' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.40' , '86.15' , NOW() , NOW() ) 24/10/2024 04:59: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 = '93818' 24/10/2024 04:59:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93818' 24/10/2024 04:59: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 ( '93818' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 24/10/2024 04:59: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 ( '93818' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 24/10/2024 04:59: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 ( '93818' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 24/10/2024 05:02:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '14762' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 05:02:08 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '22/S', document_date = '2024-10-24', document_letter = 'S', id_customer = '189', id_supplier = '0', id_address = '4670060', address1 = 'VIA NAZIONALE APPIA 81022 CASAGIOVE', 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 = '297.60', price_tax_excluded = '297.60', date_upd = NOW() WHERE id_document = '14762' 24/10/2024 05:02:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 05:02:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 05:02:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14762' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '6.0000' , '6' , '0' , '38' , '297.60' ) 24/10/2024 05:02:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '14762' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 05:02:31 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '22/S', document_date = '2024-10-24', document_letter = 'S', id_customer = '189', id_supplier = '', id_address = '4670060', address1 = 'VIA NAZIONALE APPIA 81022 CASAGIOVE', 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 = '297.60', price_tax_excluded = '297.60', date_upd = NOW() WHERE id_document = '14762' 24/10/2024 05:02:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 05:02:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 05:02:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14762' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '6.0000' , '6' , '0' , '38' , '297.60' ) 24/10/2024 05:16:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '14762' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 05:16:52 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '22/S', document_date = '2024-10-24', document_letter = 'S', id_customer = '189', id_supplier = '', id_address = '4670060', address1 = 'VIA NAZIONALE APPIA 81022 CASAGIOVE', 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 = '297.60', price_tax_excluded = '297.60', date_upd = NOW() WHERE id_document = '14762' 24/10/2024 05:16: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 = '14762' 24/10/2024 05:16:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '14762' 24/10/2024 05:16: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 ( '14762' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '6.0000' , '6' , '0' , '38' , '297.60' ) 24/10/2024 05:30:00 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 24/10/2024 05:30:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23092' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 05:30:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23092' , '1' , '1' , '2' , NOW() , NOW() ) 24/10/2024 05:30:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23092' , '0' , '1' , '0' , '0' ) 24/10/2024 05:34:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736444' AND id_product != '23092' AND ean13 != '' 24/10/2024 05:34:05 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9791280736444', date_upd = NOW() WHERE id_product = '23092' 24/10/2024 05:34:05 pm >> UPDATE ps_product_lang SET name = 'SPERANZA CHE E\' IN NOI', description = '

Sussidio in preparazione al Giubileo 2025: «Pellegrini di speranza». Il 2024 è l’anno dedicato alla preghiera per preparare i pellegrini a vivere il Giubileo 2025. Questo libretto vuole rafforzare la speranza dei cristiani, fondata su Gesù Cristo, per testimoniare, con gioia e senza paura, il Vangelo che si traduce nell\'amore verso Dio e verso il prossimo, impegnandoci a cambiare in meglio il mondo. 

' WHERE id_product = '23092' 24/10/2024 05:34:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '23092' 24/10/2024 05:34:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '23', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23092' 24/10/2024 05:34:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '23092' 24/10/2024 05:34:24 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23092' 24/10/2024 05:47:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '31' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 05:47:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '31' , '2024-10-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI - SPEDITI DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '3' , '3150.00' , '3150.00' , NOW() , NOW() ) 24/10/2024 05:47:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93819' 24/10/2024 05:47:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '93819' 24/10/2024 05:47:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93819' , '23092' , 'SPERANZA CHE E\' IN NOI' , '900' , '-900' , '4' , '3.50' , '3.5' , '0' , '0' , '3150.00' ) 24/10/2024 05:49:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '481' , '2024-10-23' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , 'SPEDITI A BYBLOS' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 24/10/2024 05:49:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93820' 24/10/2024 05:49:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '93820' 24/10/2024 05:49:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93820' , '23092' , 'SPERANZA CHE E\' IN NOI' , '900' , '900' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 24/10/2024 05:49:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23092' AND id_supplier = '145' 24/10/2024 05:49:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23092' , '145' , '1' ) 24/10/2024 05:50:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3122' AND id_document != '93741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-21') 24/10/2024 05:50:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3122', document_date = '2024-10-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '93741' 24/10/2024 05:50:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93741' 24/10/2024 05:50:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '93741' 24/10/2024 05:50:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93741' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 24/10/2024 05:50:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93741' , '23090' , 'ALBERO CON PRESEPE ' , '4' , '-4' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '100.00' ) 24/10/2024 05:54:39 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'M2bkOEzobAKPjEpS' , NOW() , NOW() ) 24/10/2024 05:54:39 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4130' , '1' ) 24/10/2024 05:54:39 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4130' , '2' ) 24/10/2024 05:54:39 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4130' , '3' ) 24/10/2024 05:55:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4130' 24/10/2024 05:55:37 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 ( '4130' , '10' , '208' , '' , 'BALLARDINI' , 'ALVISE' , 'VIA MONPEO 23' , '' , '00189' , 'ROMA' , '' , '' , '3334086856' , '' , '' , NOW() , NOW() ) 24/10/2024 05:55:37 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4130' 24/10/2024 05:56:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '180' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 05:56:43 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' , '180' , '2024-10-24' , '' , '4130' , '0' , '4679398' , 'VIA MONPEO 23 00189 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '80.75' , '80.75' , NOW() , NOW() ) 24/10/2024 05:56:43 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 = '93821' 24/10/2024 05:56:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93821' 24/10/2024 05:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93821' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 24/10/2024 05:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93821' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 24/10/2024 05:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93821' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 24/10/2024 05:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93821' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 24/10/2024 06:12:44 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 24/10/2024 06:12:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23093' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:12:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23093' , '1' , '1' , '2' , NOW() , NOW() ) 24/10/2024 06:12:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23093' , '0' , '1' , '0' , '0' ) 24/10/2024 06:14:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400306644' AND id_product != '23093' AND ean13 != '' 24/10/2024 06:14:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400306644', date_upd = NOW() WHERE id_product = '23093' 24/10/2024 06:14:54 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE CAPANNA - P622-ITA', description = '' WHERE id_product = '23093' 24/10/2024 06:14:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9836065573770492' WHERE id_product = '23093' 24/10/2024 06:14:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9836065573770492', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23093' 24/10/2024 06:14:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '23093' 24/10/2024 06:14:56 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23093' 24/10/2024 06:14:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23094' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:14:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23094' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23093' 24/10/2024 06:14:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23094' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23093' 24/10/2024 06:16:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400317343' AND id_product != '23094' AND ean13 != '' 24/10/2024 06:16:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400317343', date_upd = NOW() WHERE id_product = '23094' 24/10/2024 06:16:30 pm >> UPDATE ps_product_lang SET name = 'CANDELA NATIVITA\' - P690', description = '' WHERE id_product = '23094' 24/10/2024 06:16:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.2950819672131146' WHERE id_product = '23094' 24/10/2024 06:16:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.2950819672131146', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23094' 24/10/2024 06:16:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '23094' 24/10/2024 06:16:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23094' 24/10/2024 06:16:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23095' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:16:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23095' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23094' 24/10/2024 06:16:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23095' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23094' 24/10/2024 06:17:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400288582' AND id_product != '23095' AND ean13 != '' 24/10/2024 06:17:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400288582', date_upd = NOW() WHERE id_product = '23095' 24/10/2024 06:17:22 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI GIUBILEO - G1878', description = '' WHERE id_product = '23095' 24/10/2024 06:17:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9672131147540983' WHERE id_product = '23095' 24/10/2024 06:17:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9672131147540983', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23095' 24/10/2024 06:17:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '23095' 24/10/2024 06:17:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400288582' AND id_product != '23095' AND ean13 != '' 24/10/2024 06:17:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400288582', date_upd = NOW() WHERE id_product = '23095' 24/10/2024 06:17:45 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI GIUBILEO - G1878', description = '' WHERE id_product = '23095' 24/10/2024 06:17:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9672131147540983' WHERE id_product = '23095' 24/10/2024 06:17:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9672131147540983', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23095' 24/10/2024 06:17:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '23095' 24/10/2024 06:17:46 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23095' 24/10/2024 06:17:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23096' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:17:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23096' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23095' 24/10/2024 06:17:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23096' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23095' 24/10/2024 06:18:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400324235' AND id_product != '23096' AND ean13 != '' 24/10/2024 06:18:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400324235', date_upd = NOW() WHERE id_product = '23096' 24/10/2024 06:18:54 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO EFFETTO CERAMICA - P734/F38', description = '' WHERE id_product = '23096' 24/10/2024 06:18:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '23096' 24/10/2024 06:18:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23096' 24/10/2024 06:18:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '23096' 24/10/2024 06:18:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23096' 24/10/2024 06:18:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23097' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:18:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23097' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23096' 24/10/2024 06:18:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23097' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23096' 24/10/2024 06:19:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400074178' AND id_product != '23097' AND ean13 != '' 24/10/2024 06:19:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400074178', date_upd = NOW() WHERE id_product = '23097' 24/10/2024 06:19:59 pm >> UPDATE ps_product_lang SET name = 'CIONDOLO ANCORA GIUBILEO - G3119', description = '' WHERE id_product = '23097' 24/10/2024 06:19:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.6229508196721314' WHERE id_product = '23097' 24/10/2024 06:19:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.6229508196721314', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23097' 24/10/2024 06:19:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '23097' 24/10/2024 06:20:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23097' 24/10/2024 06:20:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23098' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:20:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23098' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23097' 24/10/2024 06:20:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23098' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23097' 24/10/2024 06:24:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400072297' AND id_product != '23098' AND ean13 != '' 24/10/2024 06:24:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400072297', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:24:36 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC', description = '' WHERE id_product = '23098' 24/10/2024 06:24:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '23098' 24/10/2024 06:24:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:24:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '23098' 24/10/2024 06:25:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400072297' AND id_product != '23098' AND ean13 != '' 24/10/2024 06:25:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400072297', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:25:39 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC', description = '' WHERE id_product = '23098' 24/10/2024 06:25:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '23098' 24/10/2024 06:25:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:25:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '23098' 24/10/2024 06:30:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400072297' AND id_product != '23098' AND ean13 != '' 24/10/2024 06:30:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400072297', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:30:34 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC', description = '' WHERE id_product = '23098' 24/10/2024 06:30:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '23098' 24/10/2024 06:30:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:30:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23098' 24/10/2024 06:30:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23098' 24/10/2024 06:30:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23099' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:30:37 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23099' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23098' 24/10/2024 06:30:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23099' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23098' 24/10/2024 06:32:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400190366' AND id_product != '23099' AND ean13 != '' 24/10/2024 06:32:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400190366', date_upd = NOW() WHERE id_product = '23099' 24/10/2024 06:32:11 pm >> UPDATE ps_product_lang SET name = 'TELA 18X25 ACUTIS - 2963/S0342NC', description = '' WHERE id_product = '23099' 24/10/2024 06:32:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '23099' 24/10/2024 06:32:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23099' 24/10/2024 06:32:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23099' 24/10/2024 06:32:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400190366' AND id_product != '23099' AND ean13 != '' 24/10/2024 06:32:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400190366', date_upd = NOW() WHERE id_product = '23099' 24/10/2024 06:32:42 pm >> UPDATE ps_product_lang SET name = 'TELA 18X25 ACUTIS - 2963/S0342NC', description = '' WHERE id_product = '23099' 24/10/2024 06:32:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '23099' 24/10/2024 06:32:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23099' 24/10/2024 06:32:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '23099' 24/10/2024 06:32:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23099' 24/10/2024 06:32:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23100' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:32:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23100' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23099' 24/10/2024 06:32:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23100' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23099' 24/10/2024 06:35:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002312' AND id_product != '23100' AND ean13 != '' 24/10/2024 06:35:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002312', date_upd = NOW() WHERE id_product = '23100' 24/10/2024 06:35:08 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MIRACOLOSA ARG. MEDIA - M057', description = '' WHERE id_product = '23100' 24/10/2024 06:35:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.147540983606557' WHERE id_product = '23100' 24/10/2024 06:35:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23100' 24/10/2024 06:35:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '23100' 24/10/2024 06:35:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23100' 24/10/2024 06:35:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23101' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:35:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23101' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23100' 24/10/2024 06:35:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23101' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23100' 24/10/2024 06:40:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002313' AND id_product != '23101' AND ean13 != '' 24/10/2024 06:40:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002313', date_upd = NOW() WHERE id_product = '23101' 24/10/2024 06:40:19 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI DECINA GIUBILEO - 1704D', description = '' WHERE id_product = '23101' 24/10/2024 06:40:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '23101' 24/10/2024 06:40:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23101' 24/10/2024 06:40:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '23101' 24/10/2024 06:40:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23101' 24/10/2024 06:40:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23102' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:40:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23102' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23101' 24/10/2024 06:40:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23102' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23101' 24/10/2024 06:42:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002314' AND id_product != '23102' AND ean13 != '' 24/10/2024 06:42:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002314', date_upd = NOW() WHERE id_product = '23102' 24/10/2024 06:42:34 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE DECINA GIUBILEO - 4618D', description = '' WHERE id_product = '23102' 24/10/2024 06:42:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8852459016393441' WHERE id_product = '23102' 24/10/2024 06:42:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8852459016393441', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23102' 24/10/2024 06:42:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23102' 24/10/2024 06:42:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23102' 24/10/2024 06:42:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23103' , '1' , '' , 'nuovo-prodotto' ) 24/10/2024 06:42:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23103' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23102' 24/10/2024 06:42:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23103' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23102' 24/10/2024 06:44:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400072297' AND id_product != '23098' AND ean13 != '' 24/10/2024 06:44:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400072297', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:44:31 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC', description = '' WHERE id_product = '23098' 24/10/2024 06:44:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '23098' 24/10/2024 06:44:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23098' 24/10/2024 06:44:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '23098' 24/10/2024 06:46:03 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 ( '31' , 'A4068' , '2024-10-24' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '565.71' , '463.70' , NOW() , NOW() ) 24/10/2024 06:46:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93822' 24/10/2024 06:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93822' 24/10/2024 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '100' , '100' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '109.8000' ) 24/10/2024 06:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23095' AND id_supplier = '28' 24/10/2024 06:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23095' , '28' , '1' ) 24/10/2024 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '100' , '100' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '146.4000' ) 24/10/2024 06:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23097' AND id_supplier = '28' 24/10/2024 06:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23097' , '28' , '1' ) 24/10/2024 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23102' , 'BRACCIALE DECINA GIUBILEO - 4618D' , '50' , '50' , '1' , '0.84' , '0.68852459016393' , '22' , '0' , '51.2400' ) 24/10/2024 06:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23102' AND id_supplier = '28' 24/10/2024 06:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23102' , '28' , '1' ) 24/10/2024 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '50' , '50' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '48.8000' ) 24/10/2024 06:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23101' AND id_supplier = '28' 24/10/2024 06:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23101' , '28' , '1' ) 24/10/2024 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23098' , 'QUADRETTO SMUSSATO ACUTIS - 1269/S0342NC' , '25' , '25' , '1' , '1' , '0.81967213114754' , '22' , '0' , '30.5000' ) 24/10/2024 06:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23098' AND id_supplier = '28' 24/10/2024 06:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23098' , '28' , '1' ) 24/10/2024 06:46:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '100' , '100' , '1' , '0.42' , '0.34426229508197' , '22' , '0' , '51.2400' ) 24/10/2024 06:46:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23093' AND id_supplier = '28' 24/10/2024 06:46:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23093' , '28' , '1' ) 24/10/2024 06:46:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23094' , 'CANDELA NATIVITA\' - P690' , '50' , '50' , '1' , '1.04' , '0.85245901639344' , '22' , '0' , '63.4400' ) 24/10/2024 06:46:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23094' AND id_supplier = '28' 24/10/2024 06:46:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23094' , '28' , '1' ) 24/10/2024 06:46:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23096' , 'QUADRETTO EFFETTO CERAMICA - P734/F38' , '12' , '12' , '1' , '1.6' , '1.3114754098361' , '22' , '0' , '23.4240' ) 24/10/2024 06:46:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23096' AND id_supplier = '28' 24/10/2024 06:46:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23096' , '28' , '1' ) 24/10/2024 06:46:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '2' , '2' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '9.1500' ) 24/10/2024 06:46:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23099' AND id_supplier = '28' 24/10/2024 06:46:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23099' , '28' , '1' ) 24/10/2024 06:46:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93822' , '23100' , 'MEDAGLIA MIRACOLOSA ARG. MEDIA - M057' , '10' , '10' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '31.7200' ) 24/10/2024 06:46:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23100' AND id_supplier = '28' 24/10/2024 06:46:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23100' , '28' , '1' ) 24/10/2024 07:13:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 07:13:41 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' , '3175' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 24/10/2024 07:13:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93823' 24/10/2024 07:13:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '93823' 24/10/2024 07:13:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93823' , '16132' , 'DECINA IN METALLO - M0123' , '40' , '-40' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '16.00' ) 24/10/2024 07:15:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 07:15:01 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' , '3176' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 24/10/2024 07:15:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93824' 24/10/2024 07:15:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '93824' 24/10/2024 07:15:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93824' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 24/10/2024 07:18:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '93626' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-15') 24/10/2024 07:18:27 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '156', document_date = '2024-10-15', document_letter = '', id_customer = '1138', id_supplier = '', id_address = '4672220', address1 = 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.51', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '48.96', price_tax_excluded = '48.96', date_upd = NOW() WHERE id_document = '93626' 24/10/2024 07:18: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 = '93626' 24/10/2024 07:18:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93626' 24/10/2024 07:18: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 ( '93626' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '19' , '-19' , '4' , '3.00' , '3' , '0' , '15' , '48.45' ) 24/10/2024 07:21:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2938' AND id_document != '93485' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-07') 24/10/2024 07:21:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2938', document_date = '2024-10-07', 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 = '63.00', price_tax_excluded = '61.74', date_upd = NOW() WHERE id_document = '93485' 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93485' 24/10/2024 07:21:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93485' 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '22507' , 'SPES NON CONFUNDIT' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '5' , '38.00' ) 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.8' , '2.8' , '0' , '0' , '2.80' ) 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 24/10/2024 07:21:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93485' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 24/10/2024 07:21:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3105' AND id_document != '93713' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 24/10/2024 07:21:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3105', document_date = '2024-10-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '93713' 24/10/2024 07:21: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 = '93713' 24/10/2024 07:21:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93713' 24/10/2024 07:21: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 ( '93713' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '10' , '-10' , '4' , '4' , '4' , '0' , '0' , '40.00' ) 24/10/2024 07:23:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3026' AND id_document != '93600' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 24/10/2024 07:23:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3026', document_date = '2024-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '828.33', price_tax_excluded = '768.57', date_upd = NOW() WHERE id_document = '93600' 24/10/2024 07:23:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93600' 24/10/2024 07:23:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93600' 24/10/2024 07:23:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/10/2024 07:23:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22912' , 'CALENDARIO DA TAVOLO 2025 - 40825' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 24/10/2024 07:23:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22985' , 'CHE PESCI PIGLIARE ' , '1' , '-1' , '4' , '11.5000' , '11.5' , '0' , '5' , '10.93' ) 24/10/2024 07:23:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '50' , '-50' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '35.00' ) 24/10/2024 07:23: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 ( '93600' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 24/10/2024 07:23: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 ( '93600' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '21.00' ) 24/10/2024 07:23: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 ( '93600' , '6019' , 'LUMINO ROSSO - 10B' , '384' , '-384' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '192.00' ) 24/10/2024 07:23: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 ( '93600' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 24/10/2024 07:23: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 ( '93600' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 24/10/2024 07:23: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 ( '93600' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 24/10/2024 07:23: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 ( '93600' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '394.25' , '394.25' , '0' , '0' , '394.25' ) 24/10/2024 07:31:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 07:31:57 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' , '3177' , '2024-10-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.72' , '58.72' , NOW() , NOW() ) 24/10/2024 07:31:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93825' 24/10/2024 07:31:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '93825' 24/10/2024 07:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '3603' , 'DOCAT' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 24/10/2024 07:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '22099' , 'YOUCAT' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 24/10/2024 07:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '15763' , 'YOUCAT FOR KIDS' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 24/10/2024 07:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '12908' , 'Y BIBBIA' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 24/10/2024 07:56:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3177' AND id_document != '93825' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 24/10/2024 07:56:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3177', document_date = '2024-10-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '58.72', price_tax_excluded = '58.72', date_upd = NOW() WHERE id_document = '93825' 24/10/2024 07:56: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 = '93825' 24/10/2024 07:56:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93825' 24/10/2024 07:56: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 ( '93825' , '3603' , 'DOCAT' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 24/10/2024 07:56: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 ( '93825' , '22099' , 'YOUCAT' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 24/10/2024 07:56: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 ( '93825' , '15763' , 'YOUCAT FOR KIDS' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 24/10/2024 07:56: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 ( '93825' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.16' , '14.16' , '0' , '0' , '14.16' )