24/11/2023 08:15:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3709' AND id_document != '89116' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 24/11/2023 08:15:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3709', document_date = '2023-11-23', 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 = '29.00', price_tax_excluded = '23.77', date_upd = NOW() WHERE id_document = '89116' 24/11/2023 08:15: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 = '89116' 24/11/2023 08:15:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89116' 24/11/2023 08:15: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 ( '89116' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 24/11/2023 08:37:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '75' 24/11/2023 08:37:12 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '75' , '10' , '210' , 'PARROCCHIA S. MARIA DI PORTO SALVO' , 'Chukwuemeka' , 'P. CIRIACO' , 'VIA STRETTOLA' , '' , '84019' , 'MARINA DI VIETRI' , '' , '' , '' , '' , '95015440654' , NOW() , NOW() ) 24/11/2023 08:37:12 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '75' 24/11/2023 08:38:05 am >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 08:38:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '288' , '2023-11-24' , '' , '75' , '0' , '4679204' , 'VIA STRETTOLA 84019 MARINA DI VIETRI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '26.78' , '26.78' , NOW() , NOW() ) 24/11/2023 08:38:05 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 = '89118' 24/11/2023 08:38:05 am >> DELETE FROM ps_document_detail WHERE id_document = '89118' 24/11/2023 08:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89118' , '2679' , 'CONOSCERE GESU' , '9' , '-9' , '4' , '3.50' , '3.5' , '0' , '15' , '26.78' ) 24/11/2023 08:53:15 am >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '89118' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 08:53:15 am >> UPDATE ps_document SET id_document_type = '21', document_num = '288', document_date = '2023-11-24', document_letter = '', id_customer = '75', id_supplier = '', id_address = '4679204', address1 = 'VIA STRETTOLA 84019 MARINA DI VIETRI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '26.78', price_tax_excluded = '26.78', date_upd = NOW() WHERE id_document = '89118' 24/11/2023 08:53:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89118' 24/11/2023 08:53:15 am >> DELETE FROM ps_document_detail WHERE id_document = '89118' 24/11/2023 08:53:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89118' , '2679' , 'CONOSCERE GESU' , '9' , '-9' , '4' , '3.5000' , '3.5' , '0' , '15' , '26.78' ) 24/11/2023 10:40:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 10:40:38 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' , '3711' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.41' , '28.41' , NOW() , NOW() ) 24/11/2023 10:40:38 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 = '89119' 24/11/2023 10:40:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89119' 24/11/2023 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89119' , '21894' , 'BENE-DICI O TACI - E. ANTENUCCI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 24/11/2023 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89119' , '20947' , 'MIA BIBBIA DELLA BUONA NOTTE' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 24/11/2023 10:40:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89119' , '16394' , 'GIOCA INSIEME AL BAMBINO GESU ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 24/11/2023 10:41:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 10:41:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3712' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 24/11/2023 10:41:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89120' 24/11/2023 10:41:59 am >> DELETE FROM ps_document_detail WHERE id_document = '89120' 24/11/2023 10:41:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89120' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 24/11/2023 10:54:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 10:54:04 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' , '3713' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 24/11/2023 10:54:04 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 = '89121' 24/11/2023 10:54:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89121' 24/11/2023 10:54:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89121' , '19795' , 'STOLA IN ASSISI CON RICAMO - 633' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 24/11/2023 12:38:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 12:38:34 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' , '3714' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 24/11/2023 12:38:34 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 = '89122' 24/11/2023 12:38:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '89122' 24/11/2023 12:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89122' , '21740' , 'ILLUMINA IL CAMMINO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 24/11/2023 12:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89122' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/11/2023 12:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89122' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.16' , '2.16' , '0' , '0' , '2.16' ) 24/11/2023 12:52:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 12:52:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3715' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '25.96' , NOW() , NOW() ) 24/11/2023 12:52:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89123' 24/11/2023 12:52:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89123' 24/11/2023 12:52:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89123' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 24/11/2023 12:52:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89123' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 24/11/2023 03:11:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 03:11:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3716' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.97' , '40.97' , NOW() , NOW() ) 24/11/2023 03:11:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89124' 24/11/2023 03:11:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89124' 24/11/2023 03:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89124' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 24/11/2023 03:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89124' , '1090' , 'BIBBIA' , '4' , '-4' , '4' , '9.90' , '9.9' , '0' , '5' , '37.64' ) 24/11/2023 03:51:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 03:51:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3717' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.25' , '46.25' , NOW() , NOW() ) 24/11/2023 03:51:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89125' 24/11/2023 03:51:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '89125' 24/11/2023 03:51:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89125' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '22.5' , '22.5' , '0' , '0' , '22.50' ) 24/11/2023 03:51:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89125' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 24/11/2023 04:07:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 04:07: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' , '3718' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 24/11/2023 04:07: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 = '89126' 24/11/2023 04:07:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '89126' 24/11/2023 04:07: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 ( '89126' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 24/11/2023 04:43:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 04:43:13 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' , '3719' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 24/11/2023 04:43:13 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 = '89127' 24/11/2023 04:43:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89127' 24/11/2023 04:43:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89127' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 24/11/2023 05:17:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 05:17: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 ( '11' , '3720' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '9.90' , NOW() , NOW() ) 24/11/2023 05:17: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 = '89128' 24/11/2023 05:17:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '89128' 24/11/2023 05:17:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89128' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 24/11/2023 05:45:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 05:45:30 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' , '3721' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 24/11/2023 05:45: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 = '89129' 24/11/2023 05:45:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '89129' 24/11/2023 05:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89129' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 24/11/2023 05:55:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 05:55:42 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' , '3722' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.10' , '45.16' , NOW() , NOW() ) 24/11/2023 05:55:42 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 = '89130' 24/11/2023 05:55:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89130' 24/11/2023 05:55:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89130' , '20027' , 'CANDELA ALTARE 20X500' , '29' , '-29' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '55.10' ) 24/11/2023 05:56:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 05:56:14 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' , '3723' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.17' , NOW() , NOW() ) 24/11/2023 05:56:14 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 = '89131' 24/11/2023 05:56:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89131' 24/11/2023 05:56:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89131' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 24/11/2023 05:57:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 05:57: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' , '3724' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '17.50' , NOW() , NOW() ) 24/11/2023 05:57: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 = '89132' 24/11/2023 05:57:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '89132' 24/11/2023 05:57: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 ( '89132' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '17.5' , '17.5' , '0' , '0' , '17.50' ) 24/11/2023 06:09:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 06:09:27 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' , '3725' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 24/11/2023 06:09:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89133' 24/11/2023 06:09:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89133' 24/11/2023 06:09:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89133' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 24/11/2023 06:09:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89133' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 24/11/2023 06:31:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 06:31:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3726' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.20' , '12.67' , NOW() , NOW() ) 24/11/2023 06:31:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89134' 24/11/2023 06:31:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89134' 24/11/2023 06:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89134' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 24/11/2023 06:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89134' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 24/11/2023 06:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89134' , '20026' , 'CANDELA VOTIVA 20X30' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 24/11/2023 06:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89134' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 24/11/2023 06:34:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '289' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 06:34:27 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' , '289' , '2023-11-24' , '' , '2441' , '0' , '4673030' , 'VIA GIULIANI, 136 84069 ROCCADASPIDE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '44.63' , '44.63' , NOW() , NOW() ) 24/11/2023 06:34:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89135' 24/11/2023 06:34:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89135' 24/11/2023 06:34:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89135' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '15' , '8.93' ) 24/11/2023 06:34:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89135' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 24/11/2023 06:39:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 06:39: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' , '3727' , '2023-11-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '94.12' , NOW() , NOW() ) 24/11/2023 06:39: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 = '89136' 24/11/2023 06:39:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '89136' 24/11/2023 06:39: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 ( '89136' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 24/11/2023 06:39: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 ( '89136' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '24.00' ) 24/11/2023 06:39: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 ( '89136' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '21' , '21' , '0' , '0' , '21.00' ) 24/11/2023 06:39: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 ( '89136' , '15497' , 'CROCE PLEX - 086' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 24/11/2023 06:53:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3726' AND id_document != '89134' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-24') 24/11/2023 06:53:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3726', document_date = '2023-11-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.20', price_tax_excluded = '12.67', date_upd = NOW() WHERE id_document = '89134' 24/11/2023 06:53: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 = '89134' 24/11/2023 06:53:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '89134' 24/11/2023 06:53: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 ( '89134' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 24/11/2023 06:53: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 ( '89134' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 24/11/2023 06:53: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 ( '89134' , '20026' , 'CANDELA VOTIVA 20X30' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 24/11/2023 06:53: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 ( '89134' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 24/11/2023 06:53: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 ( '89134' , '20027' , 'CANDELA ALTARE 20X500' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' )