26/06/2024 08:23:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1358' AND id_document != '91524' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 26/06/2024 08:23:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1358', document_date = '2024-04-30', 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 = '91.15', price_tax_excluded = '84.69', date_upd = NOW() WHERE id_document = '91524' 26/06/2024 08:23: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 = '91524' 26/06/2024 08:23:53 am >> DELETE FROM ps_document_detail WHERE id_document = '91524' 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '4' , '-4' , '4' , '4' , '4' , '0' , '0' , '16.00' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11178' , 'VENI CREATOR - 16 - OGGETTI' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11379' , 'VIENI SPIRITO SANTO - 35 ' , '38' , '-38' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '5.70' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.50' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 26/06/2024 08:23:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '18129' , 'TAU COLORATO - T56' , '5' , '-5' , '1' , '1.0100' , '0.82786885245902' , '22' , '0' , '5.05' ) 26/06/2024 08:24:29 am >> SELECT document_num FROM ps_document WHERE document_num = '406' AND id_document != '90299' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 26/06/2024 08:24:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '406', document_date = '2024-02-08', 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 = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '90299' 26/06/2024 08: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 = '90299' 26/06/2024 08:24:30 am >> DELETE FROM ps_document_detail WHERE id_document = '90299' 26/06/2024 08: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 ( '90299' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '4.82' , '4.82' , '0' , '0' , '4.82' ) 26/06/2024 08: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 ( '90299' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '5' , '9.98' ) 26/06/2024 08: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 ( '90299' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '5' , '15.20' ) 26/06/2024 09:01:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2082' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 09:01:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2082' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 26/06/2024 09:01: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 = '92405' 26/06/2024 09:01:07 am >> DELETE FROM ps_document_detail WHERE id_document = '92405' 26/06/2024 09:01: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 ( '92405' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 26/06/2024 09:32:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2083' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 09:32:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2083' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 26/06/2024 09:32: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 = '92406' 26/06/2024 09:32:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92406' 26/06/2024 09:32: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 ( '92406' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/06/2024 09:32: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 ( '92406' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/06/2024 09:38:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2084' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 09:38:32 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' , '2084' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 26/06/2024 09:38:32 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 = '92407' 26/06/2024 09:38:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92407' 26/06/2024 09:38:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92407' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 26/06/2024 09:44:57 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '17299' 26/06/2024 09:44:57 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '17299' 26/06/2024 09:45:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2082' AND id_document != '92405' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 09:45:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2082', document_date = '2024-06-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.00', price_tax_excluded = '31.97', date_upd = NOW() WHERE id_document = '92405' 26/06/2024 09:45: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 = '92405' 26/06/2024 09:45:42 am >> DELETE FROM ps_document_detail WHERE id_document = '92405' 26/06/2024 09:45: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 ( '92405' , '18352' , 'COLLANA ROSARIO' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 26/06/2024 09:49:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '7290000098784' AND id_product != '16793' AND ean13 != '' 26/06/2024 09:49:34 am >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '7290000098784', date_upd = NOW() WHERE id_product = '16793' 26/06/2024 09:49:34 am >> UPDATE ps_product_lang SET name = 'SOPRACULLA 9X13', description = '' WHERE id_product = '16793' 26/06/2024 09:49:34 am >> UPDATE ps_product SET wholesale_price = '7.50', on_sale = '0', price = '14.754098360655737' WHERE id_product = '16793' 26/06/2024 09:49:34 am >> UPDATE ps_product_shop SET wholesale_price = '7.50', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '120', 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 = '16793' 26/06/2024 09:49:34 am >> DELETE FROM ps_specific_price WHERE id_product = '16793' 26/06/2024 09:51:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1587' AND id_document != '91802' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-14') 26/06/2024 09:51:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1587', document_date = '2024-05-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91802' 26/06/2024 09:51: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 = '91802' 26/06/2024 09:51:22 am >> DELETE FROM ps_document_detail WHERE id_document = '91802' 26/06/2024 09:51: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 ( '91802' , '18652' , 'CONFEZIONE MEDAGLIONE +PORTA CIUCCIO' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 26/06/2024 09:51: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 ( '91802' , '16695' , 'MEDAGLIONE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 26/06/2024 09:52:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1628' AND id_document != '91853' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 26/06/2024 09:52:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1628', document_date = '2024-05-16', 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 = '115.00', price_tax_excluded = '95.01', date_upd = NOW() WHERE id_document = '91853' 26/06/2024 09:52: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 = '91853' 26/06/2024 09:52:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91853' 26/06/2024 09:52: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 ( '91853' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '1.60' ) 26/06/2024 09:52: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 ( '91853' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 26/06/2024 09:52: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 ( '91853' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '3.30' ) 26/06/2024 09:52: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 ( '91853' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/06/2024 09:52: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 ( '91853' , '15500' , 'CROCE IN LEGNO CON BASE - CL44' , '1' , '-1' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '22.00' ) 26/06/2024 09:52: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 ( '91853' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 26/06/2024 09:52: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 ( '91853' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '1' , '-1' , '1' , '6.7000' , '5.4918032786885' , '22' , '0' , '6.70' ) 26/06/2024 09:52: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 ( '91853' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 26/06/2024 09:52: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 ( '91853' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.9000' , '4.8360655737705' , '22' , '0' , '5.90' ) 26/06/2024 09:52: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 ( '91853' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '1' , '-1' , '1' , '7.8000' , '6.3934426229508' , '22' , '0' , '7.80' ) 26/06/2024 09:52: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 ( '91853' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 26/06/2024 09:52: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 ( '91853' , '16791' , 'SOPRACULLA ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 26/06/2024 09:53:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1657' AND id_document != '91890' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-18') 26/06/2024 09:53:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1657', document_date = '2024-05-18', 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 = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '91890' 26/06/2024 09:53:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91890' 26/06/2024 09:53:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91890' 26/06/2024 09:53:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91890' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/06/2024 09:53:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91890' , '16792' , 'SOPRACULLA' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 26/06/2024 09:53:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91890' , '18651' , 'SOPRACULLA' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 26/06/2024 09:55:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2085' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 09:55: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' , '2085' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.25' , '71.25' , NOW() , NOW() ) 26/06/2024 09:55: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 = '92408' 26/06/2024 09:55:30 am >> DELETE FROM ps_document_detail WHERE id_document = '92408' 26/06/2024 09:55: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 ( '92408' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '5' , '71.25' ) 26/06/2024 10:08:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 10:08:01 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' , '2086' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 26/06/2024 10:08:01 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 = '92409' 26/06/2024 10:08:01 am >> DELETE FROM ps_document_detail WHERE id_document = '92409' 26/06/2024 10:08:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92409' , '18561' , 'FORMELLA SAGOMATA 26X26 ' , '1' , '-1' , '1' , '89.00' , '72.950819672131' , '22' , '0' , '89.00' ) 26/06/2024 10:15:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 10:15:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2087' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 26/06/2024 10:15:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92410' 26/06/2024 10:15:58 am >> DELETE FROM ps_document_detail WHERE id_document = '92410' 26/06/2024 10:15:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92410' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 26/06/2024 10:29:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 10:29:13 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' , '2088' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 26/06/2024 10:29:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92411' 26/06/2024 10:29:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92411' 26/06/2024 10:29:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92411' , '18276' , 'CINGOLO CON NODI - 3280' , '8' , '-8' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '28.00' ) 26/06/2024 10:38:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 10:38: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' , '2089' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.10' , '38.90' , NOW() , NOW() ) 26/06/2024 10:38: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 = '92412' 26/06/2024 10:38:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92412' 26/06/2024 10:38: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 ( '92412' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 26/06/2024 10:38: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 ( '92412' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 26/06/2024 10:42:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2054' AND id_document != '92369' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-21') 26/06/2024 10:42:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2054', document_date = '2024-06-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '239.00', price_tax_excluded = '196.41', date_upd = NOW() WHERE id_document = '92369' 26/06/2024 10:42: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 = '92369' 26/06/2024 10:42:47 am >> DELETE FROM ps_document_detail WHERE id_document = '92369' 26/06/2024 10:42: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 ( '92369' , '22295' , 'RELIQUIARIO DORATO CM 32' , '1' , '-1' , '1' , '198.0000' , '162.29508196721' , '22' , '0' , '198.00' ) 26/06/2024 10:42: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 ( '92369' , '18136' , 'CROCE - CC3' , '20' , '-20' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '26.00' ) 26/06/2024 10:42: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 ( '92369' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 26/06/2024 10:42: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 ( '92369' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 26/06/2024 10:42: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 ( '92369' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 26/06/2024 11:31:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 11:31: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' , '2090' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.40' , '3.61' , NOW() , NOW() ) 26/06/2024 11:31: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 = '92413' 26/06/2024 11:31:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92413' 26/06/2024 11:31: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 ( '92413' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '2' , '-2' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '4.40' ) 26/06/2024 11:36:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002109' AND id_product != '13160' AND ean13 != '' 26/06/2024 11:36:18 am >> UPDATE ps_product SET id_supplier = '101', reference = '', ean13 = '002109', date_upd = NOW() WHERE id_product = '13160' 26/06/2024 11:36:18 am >> UPDATE ps_product_lang SET name = 'CASULA MOD. CRISTOGRAMMA - CS12271', description = '' WHERE id_product = '13160' 26/06/2024 11:36:18 am >> UPDATE ps_product SET wholesale_price = '157.04', on_sale = '0', price = '425.40983606557376' WHERE id_product = '13160' 26/06/2024 11:36:18 am >> UPDATE ps_product_shop SET wholesale_price = '157.04', price = '425.40983606557376', id_tax_rules_group = '1', id_category_default = '414', 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 = '13160' 26/06/2024 11:36:18 am >> DELETE FROM ps_specific_price WHERE id_product = '13160' 26/06/2024 12:00:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 12:01:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 12:01:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2091' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 26/06/2024 12:01:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92414' 26/06/2024 12:01:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '92414' 26/06/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92414' , '22475' , 'AMEN - LUG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92414' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92414' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92414' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/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 ( '33' , '3413/00' , '2024-06-21' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1340.00' , '1340.00' , NOW() , NOW() ) 26/06/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 = '92415' 26/06/2024 12:13:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92415' 26/06/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 ( '92415' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '44' , '44' , '4' , '10.00' , '10' , '0' , '0' , '440.0000' ) 26/06/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 ( '92415' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '60' , '60' , '4' , '15.00' , '15' , '0' , '0' , '900.0000' ) 26/06/2024 12:14:25 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '3413/00', document_date = '2024-06-21', document_letter = '00', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RIENTRO', 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 = '1340.00', price_tax_excluded = '1340.00', date_upd = NOW() WHERE id_document = '92415' 26/06/2024 12:14:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92415' 26/06/2024 12:14:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92415' 26/06/2024 12:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92415' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '44' , '44' , '4' , '10.0000' , '10' , '0' , '0' , '440.00' ) 26/06/2024 12:14:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92415' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '60' , '60' , '4' , '15.0000' , '15' , '0' , '0' , '900.00' ) 26/06/2024 12:18:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 12:18: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' , '2092' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 26/06/2024 12:18: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 = '92416' 26/06/2024 12:18:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92416' 26/06/2024 12:18: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 ( '92416' , '16504' , 'ANELLO IN ARG. - 6614' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 26/06/2024 12:27:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2064' AND id_document != '92381' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-22') 26/06/2024 12:27:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2064', document_date = '2024-06-22', 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 = '129.00', price_tax_excluded = '105.74', date_upd = NOW() WHERE id_document = '92381' 26/06/2024 12:27:30 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 = '92381' 26/06/2024 12:27:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92381' 26/06/2024 12:27: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 ( '92381' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 26/06/2024 12:27: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 ( '92381' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '100' , '0.00' ) 26/06/2024 12:27: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 ( '92381' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 26/06/2024 12:27: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 ( '92381' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '100' , '0.00' ) 26/06/2024 12:27: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 ( '92381' , '16249' , 'PROFUMATORE' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 26/06/2024 12:27: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 ( '92381' , '22584' , 'CATENINA DORATA CON CROCE - WKSS-0136G' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 26/06/2024 12:27: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 ( '92381' , '22622' , 'BRACCIALE ARG CON CROCI - CRB-003S' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 26/06/2024 12:38:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 12:38: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' , '2093' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.38' , NOW() , NOW() ) 26/06/2024 12:38: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 = '92417' 26/06/2024 12:38:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92417' 26/06/2024 12:38: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 ( '92417' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 26/06/2024 12:38: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 ( '92417' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 26/06/2024 12:46:36 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' , '3412/00' , '2024-06-21' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RICHIAMO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2070.00' , '2070.00' , NOW() , NOW() ) 26/06/2024 12:46:36 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 = '14732' 26/06/2024 12:46:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '14732' 26/06/2024 12:46:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14732' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '115' , '115' , '4' , '18.00' , '18' , '0' , '0' , '2070.0000' ) 26/06/2024 03:48:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 03:48:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2094' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '15.87' , NOW() , NOW() ) 26/06/2024 03:48:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92418' 26/06/2024 03:48:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92418' 26/06/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92418' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 26/06/2024 03:48:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92418' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 26/06/2024 03:49:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 03:49: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' , '2095' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '88.52' , NOW() , NOW() ) 26/06/2024 03:49: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 = '92419' 26/06/2024 03:49:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92419' 26/06/2024 03:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92419' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 26/06/2024 03:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92419' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '73.00' ) 26/06/2024 04:00:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 04:00:56 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' , '2096' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.25' , '19.25' , NOW() , NOW() ) 26/06/2024 04:00: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 = '92420' 26/06/2024 04:00:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92420' 26/06/2024 04:00: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 ( '92420' , '21470' , 'UN GIORNO UNA PAROLA 2024' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 26/06/2024 04:00: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 ( '92420' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 26/06/2024 04:01:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 26/06/2024 04:01:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '15.70', price_tax_excluded = '15.70', date_upd = NOW() WHERE id_document = '89846' 26/06/2024 04:01:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 26/06/2024 04:01:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 26/06/2024 04:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 26/06/2024 04:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/06/2024 04:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 26/06/2024 04:01:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 26/06/2024 04:09:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2097' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 04:09: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' , '2097' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 26/06/2024 04:09: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 = '92421' 26/06/2024 04:09:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '92421' 26/06/2024 04:09: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 ( '92421' , '8163' , 'ASTUCCIO PORTA VIATICO DAMASCATO - 23' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 26/06/2024 04:55:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2098' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 04:55: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' , '2098' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.86' , NOW() , NOW() ) 26/06/2024 04:55: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 = '92422' 26/06/2024 04:55:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92422' 26/06/2024 04:55: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 ( '92422' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 26/06/2024 04:55: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 ( '92422' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 26/06/2024 05:18:24 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '8lzmXpn9GYYcH5OA' , NOW() , NOW() ) 26/06/2024 05:18:24 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4110' , '1' ) 26/06/2024 05:18:24 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4110' , '2' ) 26/06/2024 05:18:24 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4110' , '3' ) 26/06/2024 05:20:00 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4110' 26/06/2024 05:20:00 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 ( '4110' , '10' , '210' , '' , 'CARDARELLI' , 'ANNA ' , 'VIA F. SAVERIO NITTI' , '' , '84025' , 'EBOLI' , '' , '' , '' , '' , '' , NOW() , NOW() ) 26/06/2024 05:20:00 pm >> UPDATE ps_customer SET email = 'annacardarelli@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4110' 26/06/2024 05:20:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 05:20: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 ( '21' , '97' , '2024-06-26' , '' , '4110' , '0' , '4679330' , 'VIA F. SAVERIO NITTI 84025 EBOLI' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '17.73' , '17.73' , NOW() , NOW() ) 26/06/2024 05:20: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 = '92423' 26/06/2024 05:20:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92423' 26/06/2024 05:20: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 ( '92423' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 26/06/2024 05:20: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 ( '92423' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 26/06/2024 05:25:39 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4110' 26/06/2024 05:25:39 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 ( '4110' , '10' , '210' , '' , 'CARDARELLI' , 'ANNA ' , 'VIA F. SAVERIO NITTI' , '' , '84025' , 'EBOLI' , '' , '' , '3339707236' , '' , '' , NOW() , NOW() ) 26/06/2024 05:25:40 pm >> UPDATE ps_customer SET email = 'annacardarelli@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4110' 26/06/2024 05:32:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 05:32: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' , '2099' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 26/06/2024 05:32: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 = '92424' 26/06/2024 05:32:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92424' 26/06/2024 05:32: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 ( '92424' , '22240' , 'PERGAMENA CRESIMA' , '30' , '-30' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '21.00' ) 26/06/2024 05:56:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 05:56:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2100' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 26/06/2024 05:56:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92425' 26/06/2024 05:56:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92425' 26/06/2024 05:56:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92425' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/06/2024 05:56:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92425' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/06/2024 06:08:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 06:08:33 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' , '2101' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 26/06/2024 06:08:33 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 = '92426' 26/06/2024 06:08:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92426' 26/06/2024 06:08:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92426' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 06:08:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92426' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 06:08:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92426' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 06:08:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92426' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/06/2024 08:00:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 26/06/2024 08:00:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2102' , '2024-06-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.60' , '7.05' , NOW() , NOW() ) 26/06/2024 08:00:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92427' 26/06/2024 08:00:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92427' 26/06/2024 08:00:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92427' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 26/06/2024 08:00:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92427' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' )