08/03/2024 10:31:04 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'zSEXMson8uUSrNfm' , NOW() , NOW() ) 08/03/2024 10:31:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7089' , '1' ) 08/03/2024 10:31:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7089' , '2' ) 08/03/2024 10:31:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7089' , '3' ) 08/03/2024 10:32:10 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7089' 08/03/2024 10:32:10 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7089' , '10' , '208' , '' , 'BARGELLINI' , 'ELVIRA' , 'VIA LAURENTINA 1145' , '' , '00134' , 'ROMA' , '' , '' , '' , '' , '' , NOW() , NOW() ) 08/03/2024 10:32:10 am >> UPDATE ps_customer SET email = 'elvirabargellini@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7089' 08/03/2024 10:32:40 am >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 10:32: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 ( '21' , '16' , '2024-03-08' , '' , '7089' , '0' , '172691790' , 'VIA LAURENTINA 1145 00134 ROMA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '54.40' , '54.40' , NOW() , NOW() ) 08/03/2024 10:32: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 = '14200' 08/03/2024 10:32:40 am >> DELETE FROM ps_document_detail WHERE id_document = '14200' 08/03/2024 10:32:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14200' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '5' , '47.50' ) 08/03/2024 10:50:51 am >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '89917' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-12') 08/03/2024 10:50:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2024-01-12', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '211.30', price_tax_excluded = '180.63', date_upd = NOW() WHERE id_document = '89917' 08/03/2024 10:50: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 = '89917' 08/03/2024 10:50:51 am >> DELETE FROM ps_document_detail WHERE id_document = '89917' 08/03/2024 10:50: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 ( '89917' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 08/03/2024 10:50: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 ( '89917' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/03/2024 10:50: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 ( '89917' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 08/03/2024 10:50: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 ( '89917' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 08/03/2024 10:50: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 ( '89917' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 08/03/2024 10:50: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 ( '89917' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 08/03/2024 10:50: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 ( '89917' , '' , '08/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 08/03/2024 10:50: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 ( '89917' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 08/03/2024 10:50: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 ( '89917' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 08/03/2024 10:50: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 ( '89917' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '13.00' ) 08/03/2024 11:09:50 am >> SELECT document_num FROM ps_document WHERE document_num = '695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 11:09:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '695' , '2024-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '201.05' , '201.05' , NOW() , NOW() ) 08/03/2024 11:09: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 = '90685' 08/03/2024 11:09:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90685' 08/03/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 ( '90685' , '5929' , 'LODI E VESPRI' , '20' , '-20' , '4' , '4.50' , '4.5' , '0' , '5' , '85.60' ) 08/03/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 ( '90685' , '19158' , 'SETTIMANA SANTA - N.E.' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 08/03/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 ( '90685' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '2' , '-2' , '4' , '14.00' , '14' , '0' , '10' , '25.20' ) 08/03/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 ( '90685' , '18410' , 'SAN GIUSEPPE IL CUSTODE DELLAMORE - D. DEL GAUDIO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 08/03/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 ( '90685' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 08/03/2024 11:34:42 am >> SELECT document_num FROM ps_document WHERE document_num = '696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 11:34:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '696' , '2024-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 08/03/2024 11:34:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90686' 08/03/2024 11:34:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90686' 08/03/2024 11:34:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90686' , '19104' , 'LUMINELLI A OLIO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/03/2024 11:56:48 am >> SELECT document_num FROM ps_document WHERE document_num = '697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 11:56:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '697' , '2024-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.00' , '195.25' , NOW() , NOW() ) 08/03/2024 11:56:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90687' 08/03/2024 11:56:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90687' 08/03/2024 11:56:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90687' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '15' , '15' , '0' , '0' , '60.00' ) 08/03/2024 11:56:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90687' , '18021' , 'MENORA H 35' , '1' , '-1' , '1' , '112.5' , '92.213114754098' , '22' , '0' , '112.50' ) 08/03/2024 11:56:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90687' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '7' , '-7' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '52.50' ) 08/03/2024 12:05:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 12:05:58 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' , '33/A' , '2024-03-08' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '2000.00' , '1639.34' , NOW() , NOW() ) 08/03/2024 12:05:58 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 = '90688' 08/03/2024 12:05:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90688' 08/03/2024 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90688' , '22217' , 'CALICE MALTA SATINATO - 345' , '1' , '-1' , '1' , '370' , '303.27868852459' , '22' , '0' , '370.00' ) 08/03/2024 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90688' , '' , 'pisside 346' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 08/03/2024 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90688' , '' , 'CANDELIERI - 631 CON FINTA CANDELA COMPLETA' , '6' , '-6' , '1' , '230' , '188.52459016393' , '22' , '0' , '1380.00' ) 08/03/2024 12:07:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 12:07:49 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' , '698' , '2024-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 08/03/2024 12:07:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90689' 08/03/2024 12:07:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '90689' 08/03/2024 12:07: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 ( '90689' , '22229' , 'DON PEPPINO DIANA - S. TANZARELLA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 08/03/2024 12:34:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 12:34:45 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' , '49' , '2024-03-08' , '' , '249' , '0' , '4676358' , 'VIA N. PETROSINO, 33 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '51.00' , NOW() , NOW() ) 08/03/2024 12:34:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90690' 08/03/2024 12:34:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90690' 08/03/2024 12:34:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90690' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '30' , '-30' , '4' , '2.00' , '2' , '0' , '15' , '51.00' ) 08/03/2024 12:37:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 12:37:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '699' , '2024-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '387.00' , '317.21' , NOW() , NOW() ) 08/03/2024 12:37:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90691' 08/03/2024 12:37:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '90691' 08/03/2024 12:37:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90691' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '15' , '-15' , '1' , '10' , '8.1967213114754' , '22' , '0' , '150.00' ) 08/03/2024 12:37:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90691' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '4' , '-4' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '60.00' ) 08/03/2024 12:37:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90691' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 08/03/2024 12:37:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90691' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 08/03/2024 12:37:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90691' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '17.00' ) 08/03/2024 02:29:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '90690' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 02:29:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '49', document_date = '2024-03-08', document_letter = '', id_customer = '249', id_supplier = '', id_address = '4676358', address1 = 'VIA N. PETROSINO, 33 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '51.00', price_tax_excluded = '51.00', date_upd = NOW() WHERE id_document = '90690' 08/03/2024 02: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 = '90690' 08/03/2024 02:29:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90690' 08/03/2024 02: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 ( '90690' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '30' , '-30' , '4' , '2.0000' , '2' , '0' , '15' , '51.00' ) 08/03/2024 02:53:04 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/03/2024 02:53:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22245' , '1' , '' , 'nuovo-prodotto' ) 08/03/2024 02:53:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22245' , '1' , '1' , '2' , NOW() , NOW() ) 08/03/2024 02:53:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22245' , '0' , '1' , '0' , '0' ) 08/03/2024 02:53:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831282024' AND id_product != '22245' AND ean13 != '' 08/03/2024 02:53:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831282024', date_upd = NOW() WHERE id_product = '22245' 08/03/2024 02:53:43 pm >> UPDATE ps_product_lang SET name = 'QUARESIMA ', description = '' WHERE id_product = '22245' 08/03/2024 02:53:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22245' 08/03/2024 02:53:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '249', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22245' 08/03/2024 02:53:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22245' 08/03/2024 02:53:44 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 = '22245' 08/03/2024 02:53:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22246' , '1' , '' , 'nuovo-prodotto' ) 08/03/2024 02:53:44 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 '22246' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22245' 08/03/2024 02:53:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22246' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22245' 08/03/2024 02:54:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788859027638' AND id_product != '22246' AND ean13 != '' 08/03/2024 02:54:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788859027638', date_upd = NOW() WHERE id_product = '22246' 08/03/2024 02:54:55 pm >> UPDATE ps_product_lang SET name = 'ALLENARE LE FUNZIONI...', description = '' WHERE id_product = '22246' 08/03/2024 02:54:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23.5' WHERE id_product = '22246' 08/03/2024 02:54:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23.5', id_tax_rules_group = '4', id_category_default = '409', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22246' 08/03/2024 02:54:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '22246' 08/03/2024 02:54:57 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 = '22246' 08/03/2024 02:54:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22247' , '1' , '' , 'nuovo-prodotto' ) 08/03/2024 02:54:58 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 '22247' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22246' 08/03/2024 02:54:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22247' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22246' 08/03/2024 02:55:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856692143' AND id_product != '22247' AND ean13 != '' 08/03/2024 02:55:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788856692143', date_upd = NOW() WHERE id_product = '22247' 08/03/2024 02:55:47 pm >> UPDATE ps_product_lang SET name = 'CAMMINA VIVI AMATI - S. BANZATO', description = '' WHERE id_product = '22247' 08/03/2024 02:55:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '22247' 08/03/2024 02:55:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22247' 08/03/2024 02:55:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22247' 08/03/2024 03:41:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856692143' AND id_product != '22247' AND ean13 != '' 08/03/2024 03:41:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788856692143', date_upd = NOW() WHERE id_product = '22247' 08/03/2024 03:41:47 pm >> UPDATE ps_product_lang SET name = 'CAMMINA VIVI AMATI - S. BANZATO', description = '' WHERE id_product = '22247' 08/03/2024 03:41:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '22247' 08/03/2024 03:41:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22247' 08/03/2024 03:41:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '22247' 08/03/2024 03:47:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1314229' , '2024-03-06' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.00' , '112.00' , NOW() , NOW() ) 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90692' 08/03/2024 03:47:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90692' 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90692' , '22246' , 'ALLENARE LE FUNZIONI...' , '1' , '1' , '4' , '23.50' , '23.5' , '0' , '0' , '23.50' ) 08/03/2024 03:47:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22246' AND id_supplier = '177' 08/03/2024 03:47:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22246' , '177' , '1' ) 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90692' , '22247' , 'CAMMINA VIVI AMATI - S. BANZATO' , '2' , '2' , '4' , '16.90' , '16.9' , '0' , '0' , '33.8000' ) 08/03/2024 03:47:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22247' AND id_supplier = '177' 08/03/2024 03:47:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22247' , '177' , '1' ) 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90692' , '13249' , 'PICCOLO PRINCIPE' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '0' , '5.90' ) 08/03/2024 03:47:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13249' AND id_supplier = '177' 08/03/2024 03:47:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13249' , '177' , '1' ) 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90692' , '22245' , 'QUARESIMA ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 08/03/2024 03:47:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22245' AND id_supplier = '177' 08/03/2024 03:47:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22245' , '177' , '1' ) 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90692' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 08/03/2024 03:47:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21934' AND id_supplier = '177' 08/03/2024 03:47:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21934' , '177' , '1' ) 08/03/2024 03:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90692' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 08/03/2024 03:47:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '177' 08/03/2024 03:47:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '177' , '1' ) 08/03/2024 03:57:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '89799' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-03') 08/03/2024 03:57:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '24', document_date = '2024-01-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '89799' 08/03/2024 03:57:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89799' 08/03/2024 03:57:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89799' 08/03/2024 03:57:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89799' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 08/03/2024 03:57:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89799' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 08/03/2024 03:57:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89799' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 08/03/2024 04:00:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 04:00:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '700' , '2024-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.66' , '23.15' , NOW() , NOW() ) 08/03/2024 04:00:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90693' 08/03/2024 04:00:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90693' 08/03/2024 04:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90693' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 08/03/2024 04:00:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90693' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 08/03/2024 04:01:29 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1155' 08/03/2024 04:01:29 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 ( '1155' , '10' , '210' , 'PARROCCHIA S. MARIA DELLE GRAZIE' , 'IANNONE ' , 'DON GIUSEPPE' , 'C.SO DIAZ, 83' , '' , '84085' , 'MERCATO S. SEVERINO' , '' , '089/825436' , '3295693839' , '' , '95022800650' , NOW() , NOW() ) 08/03/2024 04:01:29 pm >> UPDATE ps_customer SET email = 'giuseppeiannone2007@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1155' 08/03/2024 04:01:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 04:01: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 ( '21' , '17' , '2024-03-08' , '' , '1155' , '0' , '2487802' , 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.00' , '87.00' , NOW() , NOW() ) 08/03/2024 04:01: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 = '14201' 08/03/2024 04:01:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '14201' 08/03/2024 04:01: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 ( '14201' , '126' , 'SACRAMENTO DEL PERDONO' , '50' , '-50' , '4' , '2.00' , '2' , '0' , '15' , '85.00' ) 08/03/2024 04:01: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 ( '14201' , '50' , 'PERDONAMI SIGNORE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 08/03/2024 04:03:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '14201' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-08') 08/03/2024 04:03:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '17', document_date = '2024-03-08', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '2487802', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '87.00', price_tax_excluded = '87.00', date_upd = NOW() WHERE id_document = '14201' 08/03/2024 04:03:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14201' 08/03/2024 04:03:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '14201' 08/03/2024 04:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14201' , '126' , 'SACRAMENTO DEL PERDONO' , '50' , '-50' , '4' , '2.0000' , '2' , '0' , '15' , '85.00' ) 08/03/2024 04:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14201' , '50' , 'PERDONAMI SIGNORE' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 08/03/2024 04:08:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '46' AND id_document != '89824' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-05') 08/03/2024 04:08:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '46', document_date = '2024-01-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '89824' 08/03/2024 04:08:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89824' 08/03/2024 04:08:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89824' 08/03/2024 04:08: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 ( '89824' , '17841' , 'QUADRO DECORATO 42X32' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 08/03/2024 04:08: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 ( '89824' , '19150' , 'MOCCOLO 70X200' , '5' , '-5' , '1' , '8' , '6.5573770491803' , '22' , '0' , '40.00' ) 08/03/2024 06:03:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60/3111' AND id_product != '21042' AND ean13 != '' 08/03/2024 06:03:34 pm >> UPDATE ps_product SET id_supplier = '129', reference = '', ean13 = '60/3111', date_upd = NOW() WHERE id_product = '21042' 08/03/2024 06:03:34 pm >> UPDATE ps_product_lang SET name = 'AMITTO MISTO LANA - 60/3111', description = '' WHERE id_product = '21042' 08/03/2024 06:03:34 pm >> UPDATE ps_product SET wholesale_price = '14.07', on_sale = '0', price = '28.6885' WHERE id_product = '21042' 08/03/2024 06:03:34 pm >> UPDATE ps_product_shop SET wholesale_price = '14.07', price = '28.6885', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21042' 08/03/2024 06:03:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '21042' 08/03/2024 06:27:16 pm >> DELETE FROM ps_product WHERE id_product = '40' 08/03/2024 06:27:16 pm >> DELETE FROM ps_product_shop WHERE id_product = '40' 08/03/2024 06:27:16 pm >> DELETE FROM ps_product_lang WHERE id_product = '40' 08/03/2024 06:27:16 pm >> DELETE FROM ps_stock_available WHERE id_product = '40' 08/03/2024 06:32:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60/1010' AND id_product != '21041' AND ean13 != '' 08/03/2024 06:32:23 pm >> UPDATE ps_product SET id_supplier = '129', reference = '', ean13 = '60/1010', date_upd = NOW() WHERE id_product = '21041' 08/03/2024 06:32:23 pm >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA LINO RIC. A MANO - 60/1010', description = '' WHERE id_product = '21041' 08/03/2024 06:32:23 pm >> UPDATE ps_product SET wholesale_price = '97.97', on_sale = '0', price = '200.8197' WHERE id_product = '21041' 08/03/2024 06:32:23 pm >> UPDATE ps_product_shop SET wholesale_price = '97.97', price = '200.8197', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21041' 08/03/2024 06:32:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21041' 08/03/2024 07:15:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '14190' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-01') 08/03/2024 07:15:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '12', document_date = '2024-02-01', document_letter = '', id_customer = '7084', id_supplier = '', id_address = '172691778', address1 = 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '57.20', price_tax_excluded = '57.20', date_upd = NOW() WHERE id_document = '14190' 08/03/2024 07:15:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14190' 08/03/2024 07:15:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '14190' 08/03/2024 07:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14190' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '0' , '20.00' ) 08/03/2024 07:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14190' , '88' , 'GESÙ È RISORTO' , '5' , '-5' , '4' , '2.0000' , '2' , '0' , '0' , '10.00' ) 08/03/2024 07:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14190' , '126' , 'SACRAMENTO DEL PERDONO' , '8' , '-8' , '4' , '2.00' , '2' , '0' , '0' , '16.00' ) 08/03/2024 07:15:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14190' , '17' , 'LA FEDE NELLO ZAINETTO' , '2' , '-2' , '4' , '5.6' , '5.6' , '0' , '0' , '11.20' )