02/08/2024 09:01:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 09:01:03 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' , '2408' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.90' , '30.67' , NOW() , NOW() ) 02/08/2024 09:01:03 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 = '92800' 02/08/2024 09:01:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92800' 02/08/2024 09:01:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92800' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 02/08/2024 09:01:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92800' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/08/2024 09:01:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92800' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 02/08/2024 09:42:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 09:42:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2409' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 02/08/2024 09:42:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92801' 02/08/2024 09:42:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92801' 02/08/2024 09:42:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92801' , '22303' , 'TURIBOLO PLACCATO ARG. CM 26' , '1' , '-1' , '1' , '125.00' , '102.45901639344' , '22' , '0' , '125.00' ) 02/08/2024 09:56:37 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 ( '32' , '6224737623' , '2024-07-31' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.05' , '81.05' , NOW() , NOW() ) 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92802' 02/08/2024 09:56:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92802' 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92802' , '22761' , 'BREVE CATECHESI SUL MATRIMONIO - A. SICARI' , '1' , '0' , '4' , '9.6' , '9.6' , '0' , '0' , '9.6000' ) 02/08/2024 09:56:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22761' AND id_supplier = '177' 02/08/2024 09:56:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22761' , '177' , '1' ) 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92802' , '22429' , 'DAVIDE IL BAMBINO - C. SIGNORELLI' , '1' , '0' , '4' , '12' , '12' , '0' , '0' , '12.0000' ) 02/08/2024 09:56:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22429' AND id_supplier = '177' 02/08/2024 09:56:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22429' , '177' , '1' ) 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92802' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '0' , '4' , '19.92' , '19.92' , '0' , '0' , '19.9200' ) 02/08/2024 09:56:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22334' AND id_supplier = '177' 02/08/2024 09:56:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22334' , '177' , '1' ) 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92802' , '22763' , 'DOVE TERRA E CIELO SI INCONTRANO - EPICOCO/REGOLO' , '1' , '0' , '4' , '13.63' , '13.63' , '0' , '0' , '13.6300' ) 02/08/2024 09:56:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22763' AND id_supplier = '177' 02/08/2024 09:56:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22763' , '177' , '1' ) 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92802' , '22764' , 'FINE DELLA CRISTIANITA E IL RITORNO DEL PAGANESIMO - C. DELSOL' , '1' , '0' , '4' , '13.59' , '13.59' , '0' , '0' , '13.5900' ) 02/08/2024 09:56:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22764' AND id_supplier = '177' 02/08/2024 09:56:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22764' , '177' , '1' ) 02/08/2024 09:56:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92802' , '22762' , 'SAN CHARBEL IL MISTERO DEL CORPO INTATTO - P. CATTANEO' , '1' , '0' , '4' , '12.31' , '12.31' , '0' , '0' , '12.3100' ) 02/08/2024 09:56:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22762' AND id_supplier = '177' 02/08/2024 09:56:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22762' , '177' , '1' ) 02/08/2024 10:46:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 10:46:29 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' , '2410' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.60' , '25.60' , NOW() , NOW() ) 02/08/2024 10:46:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92803' 02/08/2024 10:46:29 am >> DELETE FROM ps_document_detail WHERE id_document = '92803' 02/08/2024 10:46:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92803' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 02/08/2024 11:04:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 11:04:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2411' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 02/08/2024 11:04:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92804' 02/08/2024 11:04:46 am >> DELETE FROM ps_document_detail WHERE id_document = '92804' 02/08/2024 11:04:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92804' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '5' , '8.55' ) 02/08/2024 11:48:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 11:48:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2412' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 02/08/2024 11:48: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 = '92805' 02/08/2024 11:48:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92805' 02/08/2024 11:48:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92805' , '21558' , 'ANELLO DECINA ARG - M043' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 02/08/2024 12:11:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 12:11: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' , '2413' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 02/08/2024 12:11: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 = '92806' 02/08/2024 12:11:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '92806' 02/08/2024 12:11: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 ( '92806' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 02/08/2024 02:19:44 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'VgOSQZD7MH0wxWRH' , NOW() , NOW() ) 02/08/2024 02:19:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7104' , '1' ) 02/08/2024 02:19:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7104' , '2' ) 02/08/2024 02:19:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7104' , '3' ) 02/08/2024 02:21:46 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7104' 02/08/2024 02:21:46 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 ( '7104' , '10' , '229' , '' , 'VALDAN' , 'CRISTINA' , 'VIA DELL\'ADIGE 26' , '' , '37020' , 'VALARGNE' , '' , '' , '' , '' , '' , NOW() , NOW() ) 02/08/2024 02:21:47 pm >> UPDATE ps_customer SET email = 'cristina.valdan@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7104' 02/08/2024 02:26:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 02:26:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '28' , '2024-08-02' , '' , '7104' , '0' , '177359037' , 'VIA DELL\\\'ADIGE 26 37020 VALARGNE' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '41.10' , '41.10' , NOW() , NOW() ) 02/08/2024 02:26:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14740' 02/08/2024 02:26:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '14740' 02/08/2024 02:26:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14740' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 02/08/2024 02:26:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14740' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 02/08/2024 03:56:48 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') 02/08/2024 03:56:48 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 = '31.10', price_tax_excluded = '31.10', date_upd = NOW() WHERE id_document = '89846' 02/08/2024 03:56: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 = '89846' 02/08/2024 03:56:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 02/08/2024 03:56: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 ( '89846' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 02/08/2024 03:56: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 ( '89846' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 02/08/2024 03:56: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 ( '89846' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 02/08/2024 03:56: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 ( '89846' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/08/2024 03:56: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 ( '89846' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/08/2024 03:56: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 ( '89846' , '22808' , 'GIONA - L. SANDRIN' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '0' , '12.50' ) 02/08/2024 05:17:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 05:17:35 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' , '2414' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 02/08/2024 05:17:35 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 = '92807' 02/08/2024 05:17:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '92807' 02/08/2024 05:17: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 ( '92807' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 02/08/2024 07:12:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-02') 02/08/2024 07:12:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2415' , '2024-08-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.30' , '13.36' , NOW() , NOW() ) 02/08/2024 07:12:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92808' 02/08/2024 07:12:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '92808' 02/08/2024 07:12:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92808' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '13.80' ) 02/08/2024 07:12:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92808' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' )