28/10/2024 08:00:14 am >> DELETE FROM ps_document WHERE id_document = '92874' 28/10/2024 08:00:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92874' 28/10/2024 09:13:16 am >> SELECT document_num FROM ps_document WHERE document_num = '113/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:13:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '113/A' , '2024-10-28' , 'A' , '283' , '0' , '4673604' , 'VIA PALMIERI 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '8.40' , NOW() , NOW() ) 28/10/2024 09:13:16 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 = '93881' 28/10/2024 09:13:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93881' 28/10/2024 09:13:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93881' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '0' , '8.40' ) 28/10/2024 09:21:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:21:47 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' , '3216' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '21.61' , NOW() , NOW() ) 28/10/2024 09:21:47 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 = '93882' 28/10/2024 09:21:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93882' 28/10/2024 09:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 28/10/2024 09:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/10/2024 09:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/10/2024 09:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 28/10/2024 09:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 28/10/2024 09:21:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 28/10/2024 09:24:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3216' AND id_document != '93882' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:24:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3216', document_date = '2024-10-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '24.70', price_tax_excluded = '21.61', date_upd = NOW() WHERE id_document = '93882' 28/10/2024 09:24:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93882' 28/10/2024 09:24:29 am >> DELETE FROM ps_document_detail WHERE id_document = '93882' 28/10/2024 09:24:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 28/10/2024 09:24:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/10/2024 09:24:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 28/10/2024 09:24:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 28/10/2024 09:24:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93882' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 28/10/2024 09:24: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 ( '93882' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 28/10/2024 09:24: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 ( '93882' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '12' , '-12' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '3.00' ) 28/10/2024 09:24: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 ( '93882' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '12' , '-12' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '3.00' ) 28/10/2024 09:24: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 ( '93882' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '12' , '-12' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '3.00' ) 28/10/2024 09:24: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 ( '93882' , '3175' , 'CROCETTA S. BENEDETTO METALLO OX CM 3,5X2 - PG350-N' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 28/10/2024 09:42:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:42:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3217' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 28/10/2024 09:42:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93883' 28/10/2024 09:42:17 am >> DELETE FROM ps_document_detail WHERE id_document = '93883' 28/10/2024 09:42:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93883' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 28/10/2024 09:44:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:44:16 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' , '3218' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.25' , '51.36' , NOW() , NOW() ) 28/10/2024 09:44:16 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 = '93884' 28/10/2024 09:44:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93884' 28/10/2024 09:44:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93884' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '5' , '42.75' ) 28/10/2024 09:44:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93884' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 28/10/2024 09:44:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:44:40 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' , '3219' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 28/10/2024 09:44:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93885' 28/10/2024 09:44:40 am >> DELETE FROM ps_document_detail WHERE id_document = '93885' 28/10/2024 09:44:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93885' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 28/10/2024 09:49:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:49:26 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' , '3220' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 28/10/2024 09:49:26 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 = '93886' 28/10/2024 09:49:26 am >> DELETE FROM ps_document_detail WHERE id_document = '93886' 28/10/2024 09:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93886' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 28/10/2024 09:55:07 am >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:55: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 ( '21' , '190' , '2024-10-28' , '' , '1127' , '0' , '4672060' , 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '231.20' , '231.20' , NOW() , NOW() ) 28/10/2024 09:55: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 = '93887' 28/10/2024 09:55:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93887' 28/10/2024 09:55: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 ( '93887' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 28/10/2024 09:55: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 ( '93887' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 28/10/2024 09:55: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 ( '93887' , '5458' , 'IO SONO CON VOI 2 PARTE' , '12' , '-12' , '4' , '2.80' , '2.8' , '0' , '15' , '28.56' ) 28/10/2024 09:55: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 ( '93887' , '11191' , 'VENITE CON ME 1 PARTE' , '13' , '-13' , '4' , '2.80' , '2.8' , '0' , '15' , '30.94' ) 28/10/2024 09:55: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 ( '93887' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '15' , '14.28' ) 28/10/2024 09:55: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 ( '93887' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '-6' , '4' , '2.40' , '2.4' , '0' , '15' , '12.24' ) 28/10/2024 09:55: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 ( '93887' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 28/10/2024 09:55: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 ( '93887' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 28/10/2024 09:55: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 ( '93887' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 28/10/2024 09:55: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 ( '93887' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 28/10/2024 09:55: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 ( '93887' , '11191' , 'VENITE CON ME 1 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 28/10/2024 09:56:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:56: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' , '3221' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.52' , '125.52' , NOW() , NOW() ) 28/10/2024 09:56: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 = '93888' 28/10/2024 09:56:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93888' 28/10/2024 09:56: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 ( '93888' , '5444' , 'IO SONO CON VOI - CAT.' , '11' , '-11' , '4' , '5.50' , '5.5' , '0' , '5' , '57.53' ) 28/10/2024 09:56: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 ( '93888' , '11193' , 'VENITE CON ME CAT.' , '11' , '-11' , '4' , '5.50' , '5.5' , '0' , '5' , '57.53' ) 28/10/2024 09:56: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 ( '93888' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 28/10/2024 09:57:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:57:10 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' , '3222' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/10/2024 09:57:10 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 = '93889' 28/10/2024 09:57:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93889' 28/10/2024 09:57:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93889' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 09:57:49 am >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '93887' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 09:57:49 am >> UPDATE ps_document SET id_document_type = '21', document_num = '190', document_date = '2024-10-28', document_letter = '', id_customer = '1127', id_supplier = '', id_address = '4672060', address1 = 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO', 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 = '231.20', price_tax_excluded = '231.20', date_upd = NOW() WHERE id_document = '93887' 28/10/2024 09:57: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 = '93887' 28/10/2024 09:57:49 am >> DELETE FROM ps_document_detail WHERE id_document = '93887' 28/10/2024 09:57: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 ( '93887' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 28/10/2024 09:57: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 ( '93887' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.8000' , '2.8' , '0' , '15' , '35.70' ) 28/10/2024 09:57: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 ( '93887' , '5458' , 'IO SONO CON VOI 2 PARTE' , '12' , '-12' , '4' , '2.8000' , '2.8' , '0' , '15' , '28.56' ) 28/10/2024 09:57: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 ( '93887' , '11191' , 'VENITE CON ME 1 PARTE' , '13' , '-13' , '4' , '2.8000' , '2.8' , '0' , '15' , '30.94' ) 28/10/2024 09:57: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 ( '93887' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '15' , '14.28' ) 28/10/2024 09:57: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 ( '93887' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '-6' , '4' , '2.4000' , '2.4' , '0' , '15' , '12.24' ) 28/10/2024 09:57: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 ( '93887' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 28/10/2024 09:57: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 ( '93887' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 28/10/2024 09:57: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 ( '93887' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 28/10/2024 09:57: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 ( '93887' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '15' , '2.38' ) 28/10/2024 09:57: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 ( '93887' , '11191' , 'VENITE CON ME 1 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 28/10/2024 10:33:37 am >> 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') 28/10/2024 10:33:37 am >> 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 = '75.80', price_tax_excluded = '66.72', date_upd = NOW() WHERE id_document = '93792' 28/10/2024 10:33:37 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 = '93792' 28/10/2024 10:33:37 am >> DELETE FROM ps_document_detail WHERE id_document = '93792' 28/10/2024 10:33:37 am >> INSERT INTO ps_document_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' ) 28/10/2024 10:33:37 am >> INSERT INTO ps_document_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' ) 28/10/2024 10:33:37 am >> INSERT INTO ps_document_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' ) 28/10/2024 10:33:37 am >> INSERT INTO ps_document_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' ) 28/10/2024 10:33:37 am >> INSERT INTO ps_document_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' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 28/10/2024 10:51:23 am >> SELECT document_num FROM ps_document WHERE document_num = '161' AND id_document != '93673' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-17') 28/10/2024 10:51:23 am >> UPDATE ps_document SET id_document_type = '21', document_num = '161', document_date = '2024-10-17', document_letter = '', id_customer = '3356', id_supplier = '0', id_address = '4671990', address1 = 'VIA LUIGI SALERNO, 2 84049 CASTEL SAN LORENZO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '79.22', price_tax_excluded = '79.22', date_upd = NOW() WHERE id_document = '93673' 28/10/2024 10:51:23 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 = '93673' 28/10/2024 10:51:24 am >> DELETE FROM ps_document_detail WHERE id_document = '93673' 28/10/2024 10:51:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93673' , '13397' , 'MIO GESU\'' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 28/10/2024 10:51:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93673' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '10' , '-10' , '4' , '3.4000' , '3.4' , '0' , '15' , '28.90' ) 28/10/2024 10:51:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93673' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.4000' , '2.4' , '0' , '15' , '26.52' ) 28/10/2024 10:55:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 10:55: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' , '3223' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 28/10/2024 10:55: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 = '93890' 28/10/2024 10:55:22 am >> DELETE FROM ps_document_detail WHERE id_document = '93890' 28/10/2024 10:55: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 ( '93890' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/10/2024 11:03:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:03:47 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' , '3224' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 28/10/2024 11:03:47 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 = '93891' 28/10/2024 11:03:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93891' 28/10/2024 11:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93891' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 28/10/2024 11:09:50 am >> SELECT document_num FROM ps_document WHERE document_num = '114/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:09:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '114/A' , '2024-10-28' , 'A' , '3975' , '0' , '4678464' , 'VIA VESCOVADO 4 84014 NOCERA INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '216.00' , '216.00' , NOW() , NOW() ) 28/10/2024 11:09:50 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 = '93892' 28/10/2024 11:09:50 am >> DELETE FROM ps_document_detail WHERE id_document = '93892' 28/10/2024 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93892' , '23080' , 'ALDO MORO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 28/10/2024 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93892' , '23078' , 'DELITTO MATTEOTTI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 28/10/2024 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93892' , '23078' , 'DELITTO MATTEOTTI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '0' , '26.00' ) 28/10/2024 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93892' , '23079' , 'JOHN HENRY NEWMAN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 28/10/2024 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93892' , '23077' , 'ANDREOTTI' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '0' , '28.00' ) 28/10/2024 11:09:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93892' , '23076' , 'DALLA DEMOCRAZIA INCOMPIUTA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 28/10/2024 11:09: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 ( '93892' , '23075' , 'ITALIA DELLA SVOLTA' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 28/10/2024 11:09: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 ( '93892' , '23074' , '1968 UN ANNO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 28/10/2024 11:09: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 ( '93892' , '23073' , 'COME MUORE UN REGIME' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 28/10/2024 11:10:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:10:10 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' , '3225' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.90' , '12.24' , NOW() , NOW() ) 28/10/2024 11:10:10 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 = '93893' 28/10/2024 11:10:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93893' 28/10/2024 11:10:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93893' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 28/10/2024 11:10:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93893' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 28/10/2024 11:11:22 am >> SELECT document_num FROM ps_document WHERE document_num = '114/A' AND id_document != '93892' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:11:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '114/A', document_date = '2024-10-28', document_letter = 'A', id_customer = '3975', id_supplier = '', id_address = '4678464', address1 = 'VIA VESCOVADO 4 84014 NOCERA INFERIORE', 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 = '190.00', price_tax_excluded = '190.00', date_upd = NOW() WHERE id_document = '93892' 28/10/2024 11:11: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 = '93892' 28/10/2024 11:11:22 am >> DELETE FROM ps_document_detail WHERE id_document = '93892' 28/10/2024 11:11: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 ( '93892' , '23080' , 'ALDO MORO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 28/10/2024 11:11: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 ( '93892' , '23078' , 'DELITTO MATTEOTTI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 28/10/2024 11:11: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 ( '93892' , '23079' , 'JOHN HENRY NEWMAN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 28/10/2024 11:11: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 ( '93892' , '23077' , 'ANDREOTTI' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 28/10/2024 11:11: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 ( '93892' , '23076' , 'DALLA DEMOCRAZIA INCOMPIUTA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 28/10/2024 11:11: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 ( '93892' , '23075' , 'ITALIA DELLA SVOLTA' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 28/10/2024 11:11: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 ( '93892' , '23074' , '1968 UN ANNO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 28/10/2024 11:11: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 ( '93892' , '23073' , 'COME MUORE UN REGIME' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 28/10/2024 11:13:51 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '92760' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-07-29') 28/10/2024 11:13:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21', document_date = '2024-07-29', document_letter = '', id_customer = '3975', id_supplier = '', id_address = '4678464', address1 = 'VIA CHIESA MADRE 25 84018 SCAFATI', address2 = '', note = 'integra fattura 26/L del 14/12/2023', 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 = '1505.10', price_tax_excluded = '1505.10', date_upd = NOW() WHERE id_document = '92760' 28/10/2024 11:13: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 = '92760' 28/10/2024 11:13:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92760' 28/10/2024 11:13: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 ( '92760' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '-2' , '4' , '29.0000' , '29' , '0' , '0' , '58.00' ) 28/10/2024 11:13: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 ( '92760' , '21725' , 'GIOVANNI AMENDOLA UNA VITA ....' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 28/10/2024 11:13: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 ( '92760' , '22786' , 'RASSEGNA STORICA SALERNITANA 81' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 28/10/2024 11:13: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 ( '92760' , '22787' , 'GIUSEPPE CASALE' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 28/10/2024 11:13: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 ( '92760' , '22788' , 'ALBERTA MARESCA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 28/10/2024 11:13: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 ( '92760' , '22789' , 'GIUSEPPE CACCIATORE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 28/10/2024 11:13: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 ( '92760' , '22790' , 'GRAS' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 28/10/2024 11:13: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 ( '92760' , '22792' , 'STUDIIS FLORENS' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 28/10/2024 11:13: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 ( '92760' , '22793' , 'RINVENIMENTI MONETALI' , '1' , '-1' , '4' , '59.0000' , '59' , '0' , '0' , '59.00' ) 28/10/2024 11:13: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 ( '92760' , '22794' , 'PROFUMI NELLE SOCIETA ANTICHE' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 28/10/2024 11:13: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 ( '92760' , '22795' , 'LONGO' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 28/10/2024 11:13: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 ( '92760' , '22795' , 'POTRANDOLFO' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 28/10/2024 11:13: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 ( '92760' , '22797' , 'FRATTE' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 28/10/2024 11:13: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 ( '92760' , '22798' , 'FRATTE LE TERRECOTTE' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 28/10/2024 11:13: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 ( '92760' , '22799' , 'CUOZZO' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 28/10/2024 11:13: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 ( '92760' , '22800' , 'DIALOGHI SULL\'ARCHEOLOGIA' , '1' , '-1' , '4' , '120.0000' , '120' , '0' , '0' , '120.00' ) 28/10/2024 11:13: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 ( '92760' , '22801' , 'DIALOGHI SULLARCHEOLOGIA II' , '1' , '-1' , '4' , '180.0000' , '180' , '0' , '0' , '180.00' ) 28/10/2024 11:13: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 ( '92760' , '22802' , 'ETERNA CONTEMPORANEITA' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 28/10/2024 11:13: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 ( '92760' , '22960' , 'POMPEI LA FONDAZIONE' , '1' , '-1' , '4' , '99.0000' , '99' , '0' , '0' , '99.00' ) 28/10/2024 11:13: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 ( '92760' , '23009' , 'DEMOCRAZIA CONTRO LA REALTA ' , '1' , '-1' , '4' , '14.6000' , '14.6' , '0' , '0' , '14.60' ) 28/10/2024 11:13: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 ( '92760' , '22229' , 'DON PEPPINO DIANA - S. TANZARELLA' , '4' , '-4' , '4' , '18.0000' , '18' , '0' , '0' , '72.00' ) 28/10/2024 11:13: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 ( '92760' , '23010' , 'RELIGIONE E DEMOCRAZIA' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 28/10/2024 11:13: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 ( '92760' , '23007' , 'GRANDE AMICO - S. PINNA' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 28/10/2024 11:13: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 ( '92760' , '23011' , 'JACQUES MARITAIN AMBASCIATORE' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '22935' , 'DIPLOMAZIA DELLA SPERANZA - E. FATTORINI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '22936' , 'STORIA DELLA DEMOCRAZIA CRISTIANA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23008' , 'STORIA RELIGIOSA DELLA FRANCIA' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23080' , 'ALDO MORO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23078' , 'DELITTO MATTEOTTI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23079' , 'JOHN HENRY NEWMAN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23077' , 'ANDREOTTI' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23076' , 'DALLA DEMOCRAZIA INCOMPIUTA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23075' , 'ITALIA DELLA SVOLTA' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23074' , '1968 UN ANNO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 28/10/2024 11:13:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92760' , '23073' , 'COME MUORE UN REGIME' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 28/10/2024 11:15:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:15:20 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' , '3226' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.74' , '33.74' , NOW() , NOW() ) 28/10/2024 11:15:20 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 = '93894' 28/10/2024 11:15:20 am >> DELETE FROM ps_document_detail WHERE id_document = '93894' 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '9610' , 'SANTA TERESA DI GESÙ DAVILA - G.PESENTI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '3660' , 'DON TONINO BELLO - V.SALVOLDI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '1716' , 'CARDINALE CARLO MARIA MARTINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '11962' , 'DON GIUSEPPE DOSSETTI - M. GHITTI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '4926' , 'IGNAZIO DI LOYOLA - F. OCCHETTA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '9532' , 'SANTALFONSO MARIA DE LIGUORI - E. MARCELLI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '1000' , 'BEATO BARTOLO LONGO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 28/10/2024 11:15:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93894' , '9569' , 'SANTA GIUSEPPINA BAKHITA - M.ARAMINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 28/10/2024 11:18:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:18:16 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' , '3227' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 28/10/2024 11:18:16 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 = '93895' 28/10/2024 11:18:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93895' 28/10/2024 11:18:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93895' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/10/2024 11:24:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:24:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3228' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.60' , '2.13' , NOW() , NOW() ) 28/10/2024 11:24: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 = '93896' 28/10/2024 11:24:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93896' 28/10/2024 11:24: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 ( '93896' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 28/10/2024 11:25:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:25:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3229' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '17.00' , NOW() , NOW() ) 28/10/2024 11:25:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93897' 28/10/2024 11:25:53 am >> DELETE FROM ps_document_detail WHERE id_document = '93897' 28/10/2024 11:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93897' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 28/10/2024 11:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93897' , '22507' , 'SPES NON CONFUNDIT' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '0' , '10.00' ) 28/10/2024 11:26:21 am >> SELECT document_num FROM ps_document WHERE document_num = '191' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:26: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 ( '21' , '191' , '2024-10-28' , '' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '65.45' , '65.45' , NOW() , NOW() ) 28/10/2024 11:26: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 = '93898' 28/10/2024 11:26:21 am >> DELETE FROM ps_document_detail WHERE id_document = '93898' 28/10/2024 11:26: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 ( '93898' , '2679' , 'CONOSCERE GESU' , '22' , '-22' , '4' , '3.50' , '3.5' , '0' , '15' , '65.45' ) 28/10/2024 11:33:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:33: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 ( '11' , '3230' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 28/10/2024 11:33: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 = '93899' 28/10/2024 11:33:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93899' 28/10/2024 11:33: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 ( '93899' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '34.00' ) 28/10/2024 11:36:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:36:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3231' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 28/10/2024 11:36:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93900' 28/10/2024 11:36:19 am >> DELETE FROM ps_document_detail WHERE id_document = '93900' 28/10/2024 11:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93900' , '19231' , 'CARD CARLO ACUTIS - RN93' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 28/10/2024 11:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93900' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/10/2024 11:36:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93900' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 28/10/2024 11:38:30 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/10/2024 11:38:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23107' , '1' , '' , 'nuovo-prodotto' ) 28/10/2024 11:38:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23107' , '1' , '1' , '2' , NOW() , NOW() ) 28/10/2024 11:38:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23107' , '0' , '1' , '0' , '0' ) 28/10/2024 11:39:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821564758' AND id_product != '23107' AND ean13 != '' 28/10/2024 11:39:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788821564758', date_upd = NOW() WHERE id_product = '23107' 28/10/2024 11:39:53 am >> UPDATE ps_product_lang SET name = 'OPERE SPIRITUALI CHARLES DE FOUCAULD', description = '' WHERE id_product = '23107' 28/10/2024 11:39:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23107' 28/10/2024 11:39:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23107' 28/10/2024 11:39:53 am >> DELETE FROM ps_specific_price WHERE id_product = '23107' 28/10/2024 11:39:56 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 = '23107' 28/10/2024 11:39:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23108' , '1' , '' , 'nuovo-prodotto' ) 28/10/2024 11:39:56 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 '23108' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23107' 28/10/2024 11:39:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23108' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23107' 28/10/2024 11:44:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:44:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3232' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '23.99' , NOW() , NOW() ) 28/10/2024 11:44: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 = '93901' 28/10/2024 11:44:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93901' 28/10/2024 11:44: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 ( '93901' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/10/2024 11:44: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 ( '93901' , '21731' , 'CROCE TRILOBATA CM 35 - CL58' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 28/10/2024 11:51:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871748' AND id_product != '23108' AND ean13 != '' 28/10/2024 11:51:53 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892871748', date_upd = NOW() WHERE id_product = '23108' 28/10/2024 11:51:53 am >> UPDATE ps_product_lang SET name = 'SUB TUUM PRAESIDIUM', description = '' WHERE id_product = '23108' 28/10/2024 11:51:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23108' 28/10/2024 11:51:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23108' 28/10/2024 11:51:53 am >> DELETE FROM ps_specific_price WHERE id_product = '23108' 28/10/2024 11:51:53 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 = '23108' 28/10/2024 11:51:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23109' , '1' , '' , 'nuovo-prodotto' ) 28/10/2024 11:51:54 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 '23109' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23108' 28/10/2024 11:51:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23109' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23108' 28/10/2024 11:52:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 11:52: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' , '3233' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 28/10/2024 11:52: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 = '93902' 28/10/2024 11:52:22 am >> DELETE FROM ps_document_detail WHERE id_document = '93902' 28/10/2024 11:52: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 ( '93902' , '17447' , 'SCARPE SOTTO IL LETTO - B. FERRERO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 11:52: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 ( '93902' , '18726' , 'LISTA DI DIO - B. FERRERO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 11:52: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 ( '93902' , '22980' , 'UOMO CHE SI FUMO LA BIBBIA - B. FERRERO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 11:52: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 ( '93902' , '21750' , 'SEGRETO DEL BAMBU - B. FERRERO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 11:53:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871731' AND id_product != '23109' AND ean13 != '' 28/10/2024 11:53:34 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892871731', date_upd = NOW() WHERE id_product = '23109' 28/10/2024 11:53:34 am >> UPDATE ps_product_lang SET name = 'PIETRO IL PESCATORE', description = '' WHERE id_product = '23109' 28/10/2024 11:53:34 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23109' 28/10/2024 11:53:34 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23109' 28/10/2024 11:53:34 am >> DELETE FROM ps_specific_price WHERE id_product = '23109' 28/10/2024 11:53:35 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 = '23109' 28/10/2024 11:53:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23110' , '1' , '' , 'nuovo-prodotto' ) 28/10/2024 11:53:35 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 '23110' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23109' 28/10/2024 11:53:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23110' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23109' 28/10/2024 11:53:45 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 ( '33' , '678965' , '2024-10-25' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '154.14' , '134.56' , NOW() , NOW() ) 28/10/2024 11:53:45 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 = '93903' 28/10/2024 11:53:45 am >> DELETE FROM ps_document_detail WHERE id_document = '93903' 28/10/2024 11:53:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93903' , '23088' , 'CAMPANA DEL GIUBILEO' , '10' , '10' , '1' , '8.9' , '7.2950819672131' , '22' , '0' , '108.5800' ) 28/10/2024 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '23088' AND id_supplier = '7' 28/10/2024 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23088' , '7' , '1' ) 28/10/2024 11:53:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93903' , '23107' , 'OPERE SPIRITUALI CHARLES DE FOUCAULD' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 28/10/2024 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '23107' AND id_supplier = '7' 28/10/2024 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23107' , '7' , '1' ) 28/10/2024 11:53:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93903' , '19618' , 'CARLO ACUTIS' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 28/10/2024 11:53:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19618' AND id_supplier = '7' 28/10/2024 11:53:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19618' , '7' , '1' ) 28/10/2024 11:53:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93903' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '30' , '1.3300' ) 28/10/2024 11:53:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '7' 28/10/2024 11:53:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '7' , '1' ) 28/10/2024 11:53: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 ( '93903' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 28/10/2024 11:53:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '23069' AND id_supplier = '7' 28/10/2024 11:53:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23069' , '7' , '1' ) 28/10/2024 11:53: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 ( '93903' , '23108' , 'SUB TUUM PRAESIDIUM' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 28/10/2024 11:53:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '23108' AND id_supplier = '7' 28/10/2024 11:53:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23108' , '7' , '1' ) 28/10/2024 11:53: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 ( '93903' , '23109' , 'PIETRO IL PESCATORE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 28/10/2024 11:53:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '23109' AND id_supplier = '7' 28/10/2024 11:53:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23109' , '7' , '1' ) 28/10/2024 12:01:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:01:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3234' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.31' , '38.88' , NOW() , NOW() ) 28/10/2024 12:01:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93904' 28/10/2024 12:01:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '93904' 28/10/2024 12:01:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93904' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '5' , '19.00' ) 28/10/2024 12:01:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93904' , '23106' , 'DILEXIT NOS' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '5' , '23.31' ) 28/10/2024 12:03:01 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'FNNugarCAx1ErV13' , NOW() , NOW() ) 28/10/2024 12:03:01 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4132' , '1' ) 28/10/2024 12:03:01 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4132' , '2' ) 28/10/2024 12:03:01 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4132' , '3' ) 28/10/2024 12:05:30 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4132' 28/10/2024 12:05:30 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 ( '4132' , '10' , '158' , 'PARR. SANTA MARIA DELLE GRAZIE' , 'IERVOLINO' , 'DON CELESTINO' , 'VIA SANTA CROCE 23' , '' , '71019' , 'VIESTE' , '' , '' , '3402307617' , '' , '92004240716' , NOW() , NOW() ) 28/10/2024 12:05:30 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4132' 28/10/2024 12:06:57 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4132' 28/10/2024 12:06:57 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 ( '4132' , '10' , '158' , 'PARR. SANTA MARIA DELLE GRAZIE' , 'IERVOLINO' , 'DON CELESTINO' , 'VIA SANTA CROCE 23' , '' , '71019' , 'VIESTE' , '' , '' , '3402307617' , '' , '92004240716' , NOW() , NOW() ) 28/10/2024 12:06:57 pm >> UPDATE ps_customer SET email = 'doncelestino@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4132' 28/10/2024 12:07:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '192' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:07:11 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' , '192' , '2024-10-28' , '' , '4132' , '0' , '4679400' , 'VIA SANTA CROCE 23 71019 VIESTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '81.60' , '81.60' , NOW() , NOW() ) 28/10/2024 12:07:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93905' 28/10/2024 12:07:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93905' 28/10/2024 12:07:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93905' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '30' , '-30' , '4' , '2.40' , '2.4' , '0' , '15' , '61.20' ) 28/10/2024 12:07:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93905' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '15' , '20.40' ) 28/10/2024 12:10:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:10:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3235' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.50' , NOW() , NOW() ) 28/10/2024 12:10: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 = '93906' 28/10/2024 12:10:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93906' 28/10/2024 12:10:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93906' , '23106' , 'DILEXIT NOS' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '0' , '10.50' ) 28/10/2024 12:11:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:11:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3236' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 28/10/2024 12:11:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93907' 28/10/2024 12:11:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93907' 28/10/2024 12:11: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 ( '93907' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/10/2024 12:11: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 ( '93907' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/10/2024 12:13:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:13:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3237' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.30' , '14.79' , NOW() , NOW() ) 28/10/2024 12:13: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 = '93908' 28/10/2024 12:13:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93908' 28/10/2024 12:13: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 ( '93908' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/10/2024 12:13: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 ( '93908' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 28/10/2024 12:13:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:13:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3238' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '9.00' , NOW() , NOW() ) 28/10/2024 12:13:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93909' 28/10/2024 12:13:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93909' 28/10/2024 12:13:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93909' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '0' , '7.00' ) 28/10/2024 12:13:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93909' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/10/2024 12:16:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:16:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3239' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 28/10/2024 12:16: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 = '93910' 28/10/2024 12:16:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '93910' 28/10/2024 12:16: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 ( '93910' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/10/2024 12:24:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '115/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:24: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 ( '24' , '115/A' , '2024-10-28' , 'A' , '2893' , '0' , '4672074' , 'VIA CONVENTO 83025 MONTORO' , '' , 'conto visione' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.10' , '68.10' , NOW() , NOW() ) 28/10/2024 12:24: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 = '93911' 28/10/2024 12:24:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '93911' 28/10/2024 12:24: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 ( '93911' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 28/10/2024 12:24: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 ( '93911' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 28/10/2024 12:24: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 ( '93911' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.45' ) 28/10/2024 12:24: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 ( '93911' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.45' ) 28/10/2024 12:24: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 ( '93911' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 28/10/2024 12:24: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 ( '93911' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 28/10/2024 12:24: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 ( '93911' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 28/10/2024 12:24: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 ( '93911' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 28/10/2024 12:24: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 ( '93911' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '15' , '13.60' ) 28/10/2024 12:24: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 ( '93911' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '0' , '16.00' ) 28/10/2024 12:26:14 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1213' 28/10/2024 12:26:14 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 ( '1213' , '10' , '130' , 'PARROCCHIA MARIA SS DEL CARMINE E SAN FELICE' , 'ROMEO' , 'DON MICHELE' , 'VIA MARCONI 115' , '' , '83025' , 'MONTORO INFERIORE' , '' , '' , '3297220911' , '' , '' , NOW() , NOW() ) 28/10/2024 12:26:14 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1213' 28/10/2024 12:26:25 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1213' 28/10/2024 12:26:25 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 ( '1213' , '10' , '130' , 'PARROCCHIA MARIA SS DEL CARMINE E SAN FELICE' , 'ROMEO' , 'DON MICHELE' , 'VIA MARCONI 115' , '' , '83025' , 'MONTORO INFERIORE' , '' , '' , '3297220911' , '' , '01669090647' , NOW() , NOW() ) 28/10/2024 12:26:25 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1213' 28/10/2024 12:27:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:27:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3240' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 28/10/2024 12:27:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93912' 28/10/2024 12:27:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '93912' 28/10/2024 12:27:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93912' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 28/10/2024 12:31:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:31:29 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' , '3241' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.00' , '109.02' , NOW() , NOW() ) 28/10/2024 12:31:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93913' 28/10/2024 12:31:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93913' 28/10/2024 12:31:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93913' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '133' , '109.01639344262' , '22' , '0' , '133.00' ) 28/10/2024 12:34:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 12:34:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3242' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.98' , '16.38' , NOW() , NOW() ) 28/10/2024 12:34:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93914' 28/10/2024 12:34:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93914' 28/10/2024 12:34:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93914' , '9259' , 'SACRA FAMIGLIA - 187B ' , '6' , '-6' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '19.98' ) 28/10/2024 12:36:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3178' AND id_document != '93829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 28/10/2024 12:36:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3178', document_date = '2024-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '148.00', price_tax_excluded = '126.72', date_upd = NOW() WHERE id_document = '93829' 28/10/2024 12:36:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93829' 28/10/2024 12:36:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93829' 28/10/2024 12:36: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 ( '93829' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 28/10/2024 12:36: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 ( '93829' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 28/10/2024 12:36: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 ( '93829' , '15537' , 'AMITTO PURO LINO RICAMO A MANO' , '1' , '-1' , '1' , '69.0000' , '56.55737704918' , '22' , '0' , '69.00' ) 28/10/2024 12:47:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871779' AND id_product != '23110' AND ean13 != '' 28/10/2024 12:47:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788892871779', date_upd = NOW() WHERE id_product = '23110' 28/10/2024 12:47:32 pm >> UPDATE ps_product_lang SET name = 'CATECHESI PER LA VITA', description = '' WHERE id_product = '23110' 28/10/2024 12:47:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '23110' 28/10/2024 12:47:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23110' 28/10/2024 12:47:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '23110' 28/10/2024 12:47:32 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 = '23110' 28/10/2024 12:47:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23111' , '1' , '' , 'nuovo-prodotto' ) 28/10/2024 12:47:32 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 '23111' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23110' 28/10/2024 12:47:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23111' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23110' 28/10/2024 12:48:08 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '678965', document_date = '2024-10-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '4.11', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '177.15', price_tax_excluded = '157.57', date_upd = NOW() WHERE id_document = '93903' 28/10/2024 12:48: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 = '93903' 28/10/2024 12:48:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '93903' 28/10/2024 12:48: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 ( '93903' , '23088' , 'CAMPANA DEL GIUBILEO' , '10' , '10' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '108.58' ) 28/10/2024 12:48: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 ( '93903' , '23107' , 'OPERE SPIRITUALI CHARLES DE FOUCAULD' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 28/10/2024 12:48: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 ( '93903' , '19618' , 'CARLO ACUTIS' , '1' , '1' , '4' , '4.9000' , '4.9' , '0' , '30' , '3.43' ) 28/10/2024 12:48: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 ( '93903' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '1' , '4' , '1.9000' , '1.9' , '0' , '30' , '1.33' ) 28/10/2024 12:48: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 ( '93903' , '23069' , 'PAROLA DI OGNI GIORNO 2025' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 28/10/2024 12:48: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 ( '93903' , '23108' , 'SUB TUUM PRAESIDIUM' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 28/10/2024 12:48: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 ( '93903' , '23109' , 'PIETRO IL PESCATORE' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 28/10/2024 12:48: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 ( '93903' , '23110' , 'CATECHESI PER LA VITA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 28/10/2024 12:48: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 ( '93903' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 28/10/2024 02:21:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 02:21: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 ( '21' , '193' , '2024-10-28' , '' , '4056' , '0' , '4679190' , 'VIA ROMA 8 25050 PASPARDO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.15' , '73.15' , NOW() , NOW() ) 28/10/2024 02:21: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 = '93915' 28/10/2024 02:21:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93915' 28/10/2024 02:21: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 ( '93915' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '5' , '33.25' ) 28/10/2024 02:21: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 ( '93915' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' ) 28/10/2024 02:21: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 ( '93915' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '15' , '-15' , '4' , '2.00' , '2' , '0' , '5' , '28.50' ) 28/10/2024 02:22:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '93915' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 02:22:40 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '193', document_date = '2024-10-28', document_letter = '', id_customer = '4056', id_supplier = '', id_address = '4679190', address1 = 'VIA ROMA 8 25050 PASPARDO', 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 = '73.15', price_tax_excluded = '73.15', date_upd = NOW() WHERE id_document = '93915' 28/10/2024 02:22: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 = '93915' 28/10/2024 02:22:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93915' 28/10/2024 02:22: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 ( '93915' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '5' , '33.25' ) 28/10/2024 02:22: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 ( '93915' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '5' , '11.40' ) 28/10/2024 02:22: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 ( '93915' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '15' , '-15' , '4' , '2.0000' , '2' , '0' , '5' , '28.50' ) 28/10/2024 02:31:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2581' AND id_document != '93004' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-04') 28/10/2024 02:31:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2581', document_date = '2024-09-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 = '240.75', price_tax_excluded = '204.53', date_upd = NOW() WHERE id_document = '93004' 28/10/2024 02:31:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93004' 28/10/2024 02:31:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93004' 28/10/2024 02:31:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93004' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 28/10/2024 02:31:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93004' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/10/2024 02:31:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93004' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 28/10/2024 02:31:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93004' , '21377' , 'CASULA POLIESTERE IHS' , '4' , '-4' , '1' , '50' , '40.983606557377' , '22' , '0' , '200.00' ) 28/10/2024 02:38:40 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') 28/10/2024 02:38:40 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' 28/10/2024 02:38: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 = '93600' 28/10/2024 02:38:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93600' 28/10/2024 02:38: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 ( '93600' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 28/10/2024 02:38: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 ( '93600' , '22912' , 'CALENDARIO DA TAVOLO 2025 - 40825' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 28/10/2024 02:38: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 ( '93600' , '22985' , 'CHE PESCI PIGLIARE ' , '1' , '-1' , '4' , '11.5000' , '11.5' , '0' , '5' , '10.93' ) 28/10/2024 02:38: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 ( '93600' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '50' , '-50' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '35.00' ) 28/10/2024 02:38: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 ( '93600' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/10/2024 02:38: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 ( '93600' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '21.00' ) 28/10/2024 02:38: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 ( '93600' , '6019' , 'LUMINO ROSSO - 10B' , '384' , '-384' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '192.00' ) 28/10/2024 02:38: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 ( '93600' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 28/10/2024 02:38: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 ( '93600' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 28/10/2024 02:38: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 ( '93600' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '14' , '-14' , '4' , '5.0000' , '5' , '0' , '5' , '66.50' ) 28/10/2024 02:38: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 ( '93600' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 28/10/2024 02:38: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 ( '93600' , '23023' , 'ABBI CURA DI TE STESSO - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 28/10/2024 02:38: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 ( '93600' , '22876' , 'AMEN - NOV 24' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 28/10/2024 02:38: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 ( '93600' , '22875' , 'AMEN - DIC 24' , '2' , '-2' , '4' , '3.9000' , '3.9' , '0' , '5' , '7.42' ) 28/10/2024 02:38: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 ( '93600' , '22902' , 'PREGARE CON IL CORPO - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/10/2024 02:38: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 ( '93600' , '22898' , 'VIGILANZA QUOTIDIANA - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/10/2024 02:38: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 ( '93600' , '22901' , 'ORAZIONE MENTALE - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/10/2024 02:38: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 ( '93600' , '22900' , 'LECTIO DIVINA - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/10/2024 02:38: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 ( '93600' , '22899' , 'SILENZIO - G. FORLAI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 28/10/2024 02:38: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 ( '93600' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 28/10/2024 02:38: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 ( '93600' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '3' , '-3' , '4' , '20.0000' , '20' , '0' , '5' , '57.00' ) 28/10/2024 02:38: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 ( '93600' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 28/10/2024 02:38: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 ( '93600' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '223.61' , '223.61' , '0' , '0' , '223.61' ) 28/10/2024 03:16:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 03:16:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3243' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 28/10/2024 03:16:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93916' 28/10/2024 03:16:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93916' 28/10/2024 03:16:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93916' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/10/2024 04:10:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '194' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 04:10:28 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' , '194' , '2024-10-28' , '' , '161' , '0' , '4679379' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '88.90' , '88.90' , NOW() , NOW() ) 28/10/2024 04:10:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93917' 28/10/2024 04:10:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '93917' 28/10/2024 04:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93917' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '35' , '-35' , '4' , '2.40' , '2.4' , '0' , '15' , '71.40' ) 28/10/2024 04:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93917' , '23106' , 'DILEXIT NOS' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '0' , '17.50' ) 28/10/2024 04:33:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2630' AND id_document != '93061' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-09') 28/10/2024 04:33:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2630', document_date = '2024-09-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '125.00', price_tax_excluded = '102.46', date_upd = NOW() WHERE id_document = '93061' 28/10/2024 04:33:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93061' 28/10/2024 04:33:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93061' 28/10/2024 04:33:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93061' , '16657' , 'CLERGY DENIM - ML ' , '2' , '-2' , '1' , '62.50' , '51.229508196721' , '22' , '0' , '125.00' ) 28/10/2024 04:34:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '195' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 04:34:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '195' , '2024-10-28' , '' , '4113' , '0' , '4679349' , 'VIA GERMONIO 6 10095 GRUGLIASCO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '17.75' , '17.75' , NOW() , NOW() ) 28/10/2024 04:34: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 = '93918' 28/10/2024 04:34:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93918' 28/10/2024 04:34: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 ( '93918' , '4154' , 'FESTA DEL PERDONO' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '15' , '12.75' ) 28/10/2024 04:42:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 04:42:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3244' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 28/10/2024 04:42:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93919' 28/10/2024 04:42:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93919' 28/10/2024 04:42:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93919' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 04:42:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93919' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 04:43:55 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'zYdwIwXI0NtRxFzQ' , NOW() , NOW() ) 28/10/2024 04:43:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4133' , '1' ) 28/10/2024 04:43:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4133' , '2' ) 28/10/2024 04:43:55 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4133' , '3' ) 28/10/2024 04:45:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '196' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 04:45:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '196' , '2024-10-28' , '' , '260' , '0' , '4670956' , 'PIAZZA UMBERTO I, 2 03032 ARCE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '35.60' , '35.60' , NOW() , NOW() ) 28/10/2024 04:45: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 = '93920' 28/10/2024 04:45:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '93920' 28/10/2024 04:45: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 ( '93920' , '6629' , 'MIA PREGHIERA' , '40' , '-40' , '4' , '0.90' , '0.9' , '0' , '15' , '30.60' ) 28/10/2024 04:48:07 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '260' 28/10/2024 04:48:07 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 ( '260' , '10' , '160' , 'PARR. DEI SANTI PIETRO E PAOLO' , 'D\'ANASTASIO ' , 'DON ARCANGELO' , 'PIAZZA UMBERTO I, 2' , '' , '03032' , 'ARCE' , 'arceparrocchia@gmail.com' , '3495764904' , '' , '' , '82006060600' , NOW() , NOW() ) 28/10/2024 04:48:07 pm >> UPDATE ps_customer SET email = 'donarki@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '260' 28/10/2024 04:55:35 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4056' 28/10/2024 04:55:35 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 ( '4056' , '10' , '139' , '' , 'LANDRINI' , 'GLISENTE' , 'VIA ROMA 8' , '' , '25050' , 'PASPARDO' , '' , '' , '3356354061' , '' , '' , NOW() , NOW() ) 28/10/2024 04:55:35 pm >> UPDATE ps_customer SET email = 'glisente@glisente.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4056' 28/10/2024 05:03:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 05:03: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 ( '11' , '3245' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/10/2024 05:03: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 = '93921' 28/10/2024 05:03:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93921' 28/10/2024 05:03: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 ( '93921' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2024 05:29:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '275/X' , '2024-10-23' , 'X' , '0' , '73' , '2668' , 'VIA P. TRIBOLDI, 4 26015 SORESINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 28/10/2024 05:29: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 = '93922' 28/10/2024 05:29:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '93922' 28/10/2024 05:29: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 ( '93922' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '25' , '25' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 28/10/2024 05:29:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20438' AND id_supplier = '73' 28/10/2024 05:29:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20438' , '73' , '1' ) 28/10/2024 05:29: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 ( '93922' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '7' , '7' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 28/10/2024 05:29:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20438' AND id_supplier = '73' 28/10/2024 05:29:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20438' , '73' , '1' ) 28/10/2024 05:29: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 ( '93922' , '15210' , 'CERO PASQUALE API 80X120' , '30' , '30' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 28/10/2024 05:29:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15210' AND id_supplier = '73' 28/10/2024 05:29:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15210' , '73' , '1' ) 28/10/2024 05:29: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 ( '93922' , '19150' , 'MOCCOLO 70X200' , '24' , '24' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 28/10/2024 05:29:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '73' 28/10/2024 05:29:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '73' , '1' ) 28/10/2024 05:29: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 ( '93922' , '6001' , 'LUMELLA ALLUMINIO 4AR F - 50 PZ' , '10' , '10' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 28/10/2024 05:29:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6001' AND id_supplier = '73' 28/10/2024 05:29:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6001' , '73' , '1' ) 28/10/2024 05:35:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 05:35:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '50/E' , '2024-10-28' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '15' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '225.80' , '225.80' , NOW() , NOW() ) 28/10/2024 05:35:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93923' 28/10/2024 05:35:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93923' 28/10/2024 05:35:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93923' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '100' , '-100' , '4' , '3.40' , '3.4' , '0' , '38' , '210.80' ) 28/10/2024 05:37:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 05:37:47 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' , '3246' , '2024-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 28/10/2024 05:37:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93924' 28/10/2024 05:37:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '93924' 28/10/2024 05:37:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93924' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '24' , '19.672131147541' , '22' , '0' , '24.00' ) 28/10/2024 05:45:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/E' AND id_document != '93923' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 05:45:07 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '50/E', document_date = '2024-10-28', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '0', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '232.00', price_tax_excluded = '232.00', date_upd = NOW() WHERE id_document = '93923' 28/10/2024 05:45:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93923' 28/10/2024 05:45:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '93923' 28/10/2024 05:45:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93923' , '2679' , 'CONOSCERE GESU\'' , '100' , '-100' , '4' , '3.5' , '3.5' , '0' , '38' , '217.00' ) 28/10/2024 05:45: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 ( '93923' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 28/10/2024 05:48:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/E' AND id_document != '93923' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 05:48:15 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '50/E', document_date = '2024-10-28', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 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 = '230.00', price_tax_excluded = '230.00', date_upd = NOW() WHERE id_document = '93923' 28/10/2024 05:48: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 = '93923' 28/10/2024 05:48:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '93923' 28/10/2024 05:48: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 ( '93923' , '2679' , 'CONOSCERE GESU\'' , '100' , '-100' , '4' , '3.5000' , '3.5' , '0' , '38' , '217.00' ) 28/10/2024 05:48: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 ( '93923' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '13' , '13' , '0' , '0' , '13.00' ) 28/10/2024 07:47:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3242' AND id_document != '93914' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-28') 28/10/2024 07:47:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3242', document_date = '2024-10-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.98', price_tax_excluded = '16.38', date_upd = NOW() WHERE id_document = '93914' 28/10/2024 07:47:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93914' 28/10/2024 07:47:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93914' 28/10/2024 07:47: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 ( '93914' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '19.98' )