26/02/2024 09:11:08 am >> SELECT document_num FROM ps_document WHERE document_num = '40' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 09:11:08 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' , '40' , '2024-02-26' , '' , '4021' , '0' , '4679056' , 'VIA GIACOMO LEOPARDI 80 97019 VITTORIA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '28.75' , '28.75' , NOW() , NOW() ) 26/02/2024 09:11:08 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 = '90494' 26/02/2024 09:11:08 am >> DELETE FROM ps_document_detail WHERE id_document = '90494' 26/02/2024 09:11:08 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 ( '90494' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 26/02/2024 09:12:19 am >> SELECT document_num FROM ps_document WHERE document_num = '40' AND id_document != '90494' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 09:12:19 am >> UPDATE ps_document SET id_document_type = '21', document_num = '40', document_date = '2024-02-26', document_letter = '', id_customer = '4021', id_supplier = '', id_address = '4679056', address1 = 'VIA GIACOMO LEOPARDI 80 97019 VITTORIA', address2 = '', note = '', price_shipping = '3.5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '29.00', price_tax_excluded = '29.00', date_upd = NOW() WHERE id_document = '90494' 26/02/2024 09:12: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 = '90494' 26/02/2024 09:12:19 am >> DELETE FROM ps_document_detail WHERE id_document = '90494' 26/02/2024 09:12: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 ( '90494' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 26/02/2024 09:12: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 ( '90494' , '' , 'spese contrassegno' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 26/02/2024 09:50:55 am >> UPDATE ps_address SET id_state = '210', lastname = 'VOLANTINOPIU\' SRL', address1 = 'VIA S. ALLENDE 161/D', address2 = '', postcode = '84131', dni = '', vat_number = '05756430657', city = 'SALERNO', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '186' 26/02/2024 09:50:55 am >> UPDATE ps_supplier SET email = 'amministrazione@volantinopiu.com', name = 'VOLANTINOPIU\' SRL', date_upd = NOW() WHERE id_supplier = '186' 26/02/2024 09:50:55 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '186' 26/02/2024 09:51:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3' , '2024-01-17' , '' , '0' , '186' , '4679210' , 'VIA S. ALLENDE 161/D 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8424.00' , '8100.00' , NOW() , NOW() ) 26/02/2024 09:51:57 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 = '90495' 26/02/2024 09:51:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90495' 26/02/2024 09:51:57 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 ( '90495' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '15000' , '15000' , '3' , '0.54' , '0.51923076923077' , '4' , '0' , '8424.0000' ) 26/02/2024 09:51:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '22028' AND id_supplier = '186' 26/02/2024 09:51:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22028' , '186' , '1' ) 26/02/2024 09:58:38 am >> SELECT document_num FROM ps_document WHERE document_num = '555' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 09:58: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' , '555' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 26/02/2024 09:58: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 = '90496' 26/02/2024 09:58:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90496' 26/02/2024 09:58: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 ( '90496' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '15' , '12.295081967213' , '22' , '0' , '60.00' ) 26/02/2024 09:58: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 ( '90496' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '16' , '-16' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '8.00' ) 26/02/2024 10:17:49 am >> SELECT document_num FROM ps_document WHERE document_num = '556' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 10:17: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' , '556' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.00' , '72.95' , NOW() , NOW() ) 26/02/2024 10:17: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 = '90497' 26/02/2024 10:17:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90497' 26/02/2024 10:17: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 ( '90497' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 26/02/2024 10:17: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 ( '90497' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 26/02/2024 10:20: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 ( '32' , '67' , '2024-02-23' , '' , '0' , '186' , '4679210' , 'VIA S. ALLENDE 161/D 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '8424.00' , '8100.00' , NOW() , NOW() ) 26/02/2024 10:20: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 = '90498' 26/02/2024 10:20:03 am >> DELETE FROM ps_document_detail WHERE id_document = '90498' 26/02/2024 10:20: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 ( '90498' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '15000' , '0' , '3' , '0.54' , '0.51923076923077' , '4' , '0' , '8424.0000' ) 26/02/2024 10:20:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '22028' AND id_supplier = '186' 26/02/2024 10:20:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22028' , '186' , '1' ) 26/02/2024 10:30:11 am >> SELECT document_num FROM ps_document WHERE document_num = '557' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 10:30:11 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' , '557' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 26/02/2024 10:30:11 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 = '90499' 26/02/2024 10:30:11 am >> DELETE FROM ps_document_detail WHERE id_document = '90499' 26/02/2024 10:30:11 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 ( '90499' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 26/02/2024 10:30:11 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 ( '90499' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 26/02/2024 10:35:55 am >> SELECT document_num FROM ps_document WHERE document_num = '558' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 10:35:55 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' , '558' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 26/02/2024 10:35:55 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 = '90500' 26/02/2024 10:35:55 am >> DELETE FROM ps_document_detail WHERE id_document = '90500' 26/02/2024 10:35:55 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 ( '90500' , '18357' , 'MIE PREGHIERINE N.E.' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '0' , '4.50' ) 26/02/2024 10:37:10 am >> SELECT document_num FROM ps_document WHERE document_num = '559' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 10:37:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '559' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 26/02/2024 10:37:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90501' 26/02/2024 10:37:10 am >> DELETE FROM ps_document_detail WHERE id_document = '90501' 26/02/2024 10:37:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90501' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 26/02/2024 10:45:41 am >> SELECT document_num FROM ps_document WHERE document_num = '560' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 10:45: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' , '560' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '54.00' , NOW() , NOW() ) 26/02/2024 10:45: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 = '90502' 26/02/2024 10:45:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90502' 26/02/2024 10:45: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 ( '90502' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 26/02/2024 10:45: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 ( '90502' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '24' , '24' , '0' , '0' , '24.00' ) 26/02/2024 11:04:20 am >> SELECT document_num FROM ps_document WHERE document_num = '561' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 11:04:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '561' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.00' , '95.16' , NOW() , NOW() ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90503' 26/02/2024 11:04:20 am >> DELETE FROM ps_document_detail WHERE id_document = '90503' 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 26/02/2024 11:04:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90503' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 26/02/2024 11:58:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000149' AND id_product != '1427' AND ean13 != '' 26/02/2024 11:58:02 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000149', date_upd = NOW() WHERE id_product = '1427' 26/02/2024 11:58:02 am >> UPDATE ps_product_lang SET name = 'BUSTE PER PALMA BENEDETTA - PZ 200 ', description = '' WHERE id_product = '1427' 26/02/2024 11:58:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.426229508196721' WHERE id_product = '1427' 26/02/2024 11:58:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.426229508196721', id_tax_rules_group = '1', id_category_default = '95', 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 = '1427' 26/02/2024 11:58:02 am >> DELETE FROM ps_specific_price WHERE id_product = '1427' 26/02/2024 11:59:55 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/02/2024 11:59:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22198' , '1' , '' , 'nuovo-prodotto' ) 26/02/2024 11:59:55 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22198' , '1' , '1' , '2' , NOW() , NOW() ) 26/02/2024 11:59:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22198' , '0' , '1' , '0' , '0' ) 26/02/2024 12:00:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400221305' AND id_product != '22198' AND ean13 != '' 26/02/2024 12:00:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400221305', date_upd = NOW() WHERE id_product = '22198' 26/02/2024 12:00:56 pm >> UPDATE ps_product_lang SET name = 'CORONCINA PRIMA COMUNIONE - 3313', description = '' WHERE id_product = '22198' 26/02/2024 12:00:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.967213114754099' WHERE id_product = '22198' 26/02/2024 12:00:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.967213114754099', id_tax_rules_group = '1', id_category_default = '95', 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 = '22198' 26/02/2024 12:00:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22198' 26/02/2024 12:00:58 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22198' 26/02/2024 12:00:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22199' , '1' , '' , 'nuovo-prodotto' ) 26/02/2024 12:00:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22199' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22198' 26/02/2024 12:00:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22199' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22198' 26/02/2024 12:02:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400221305' AND id_product != '22198' AND ean13 != '' 26/02/2024 12:02:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400221305', date_upd = NOW() WHERE id_product = '22198' 26/02/2024 12:02:28 pm >> UPDATE ps_product_lang SET name = 'CORONCINA PRIMA COMUNIONE - 3313', description = '' WHERE id_product = '22198' 26/02/2024 12:02:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.557377049180328' WHERE id_product = '22198' 26/02/2024 12:02:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.557377049180328', id_tax_rules_group = '1', id_category_default = '95', 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 = '22198' 26/02/2024 12:02:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22198' 26/02/2024 12:02: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 ( '31' , 'A668' , '2024-02-26' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '372.53' , '305.35' , NOW() , NOW() ) 26/02/2024 12:02: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 = '90504' 26/02/2024 12:02:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90504' 26/02/2024 12:02: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 ( '90504' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '50' , '50' , '1' , '4.6' , '3.7704918032787' , '22' , '0' , '280.6000' ) 26/02/2024 12:02:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1427' AND id_supplier = '28' 26/02/2024 12:02:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1427' , '28' , '1' ) 26/02/2024 12:02: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 ( '90504' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '5' , '5' , '1' , '4.53' , '3.7131147540984' , '22' , '0' , '27.6330' ) 26/02/2024 12:02:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21096' AND id_supplier = '28' 26/02/2024 12:02:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21096' , '28' , '1' ) 26/02/2024 12:02: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 ( '90504' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '10' , '10' , '1' , '3.15' , '2.5819672131148' , '22' , '0' , '38.4300' ) 26/02/2024 12:02:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22198' AND id_supplier = '28' 26/02/2024 12:02:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22198' , '28' , '1' ) 26/02/2024 12:02: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 ( '90504' , '16450' , 'ANGELO SUONANTE IN RESINA CM 18,5 - 4127' , '2' , '2' , '1' , '10.6' , '8.6885245901639' , '22' , '0' , '25.8640' ) 26/02/2024 12:02:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16450' AND id_supplier = '28' 26/02/2024 12:02:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16450' , '28' , '1' ) 26/02/2024 12:26:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '562' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 12:26: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' , '562' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.98' , '10.44' , NOW() , NOW() ) 26/02/2024 12:26: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 = '90505' 26/02/2024 12:26:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '90505' 26/02/2024 12:26: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 ( '90505' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '5' , '7.98' ) 26/02/2024 12:26: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 ( '90505' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 26/02/2024 12:29:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '563' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 12:29: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' , '563' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.20' , '58.64' , NOW() , NOW() ) 26/02/2024 12:29: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 = '90506' 26/02/2024 12:29:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90506' 26/02/2024 12:29: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 ( '90506' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 26/02/2024 12:29: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 ( '90506' , '14721' , 'STOLA POLIESTERE - ART. 79' , '1' , '-1' , '1' , '53.00' , '43.44262295082' , '22' , '0' , '53.00' ) 26/02/2024 12:35:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '564' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 12:35: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' , '564' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.95' , '35.95' , NOW() , NOW() ) 26/02/2024 12:35: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 = '90507' 26/02/2024 12:35:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '90507' 26/02/2024 12:35: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 ( '90507' , '21906' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2.70' , '2.7' , '0' , '0' , '2.70' ) 26/02/2024 12:35: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 ( '90507' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 26/02/2024 12:49:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 12:49:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '565' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.56' , '28.56' , NOW() , NOW() ) 26/02/2024 12:49:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90508' 26/02/2024 12:49:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90508' 26/02/2024 12:49:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90508' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '12' , '-12' , '4' , '2.50' , '2.5' , '0' , '5' , '28.56' ) 26/02/2024 01:00:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '566' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 01: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' , '566' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '222.90' , '215.70' , NOW() , NOW() ) 26/02/2024 01: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 = '90509' 26/02/2024 01:00:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90509' 26/02/2024 01: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 ( '90509' , '21919' , 'AMEN - APR 24' , '6' , '-6' , '4' , '2.90' , '2.9' , '0' , '0' , '17.40' ) 26/02/2024 01: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 ( '90509' , '21920' , 'AMEN - MAR 24' , '6' , '-6' , '4' , '2.90' , '2.9' , '0' , '0' , '17.40' ) 26/02/2024 01: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 ( '90509' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 26/02/2024 01: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 ( '90509' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '28' , '-28' , '4' , '5.00' , '5' , '0' , '5' , '133.00' ) 26/02/2024 01: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 ( '90509' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 26/02/2024 01: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 ( '90509' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 26/02/2024 02:44:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 02:44: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 ( '21' , '41' , '2024-02-26' , '' , '4081' , '0' , '4679276' , 'VIA PAZZIGNO 6 80146 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '57.38' , '57.38' , NOW() , NOW() ) 26/02/2024 02:44: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 = '90510' 26/02/2024 02:44:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '90510' 26/02/2024 02:44: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 ( '90510' , '22188' , 'UN SILENZIO TRATTENUTO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 26/02/2024 02:44: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 ( '90510' , '22183' , 'SANTO ROSARIO CON GAETANO TANTALO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/02/2024 02:44: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 ( '90510' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 26/02/2024 02:44: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 ( '90510' , '22152' , 'A TE RICORRIAMO' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 26/02/2024 02:44: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 ( '90510' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.07' ) 26/02/2024 02:44: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 ( '90510' , '22001' , 'VERRO A TROVARTI TUTTE LE VOLTE CHE VORRAI - S. ZAMPA' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 26/02/2024 02:45:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '90510' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 02:45:01 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '41', document_date = '2024-02-26', document_letter = '', id_customer = '4081', id_supplier = '', id_address = '4679276', address1 = 'VIA PAZZIGNO 6 80146 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '60.28', price_tax_excluded = '60.28', date_upd = NOW() WHERE id_document = '90510' 26/02/2024 02:45: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 = '90510' 26/02/2024 02:45:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '90510' 26/02/2024 02:45:02 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 ( '90510' , '22188' , 'UN SILENZIO TRATTENUTO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 26/02/2024 02:45:02 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 ( '90510' , '22183' , 'SANTO ROSARIO CON GAETANO TANTALO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/02/2024 02:45:02 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 ( '90510' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 26/02/2024 02:45:02 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 ( '90510' , '22152' , 'A TE RICORRIAMO' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '5' , '5.70' ) 26/02/2024 02:45:02 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 ( '90510' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.07' ) 26/02/2024 02:45:02 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 ( '90510' , '22001' , 'VERRO A TROVARTI TUTTE LE VOLTE CHE VORRAI - S. ZAMPA' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 26/02/2024 02:45:02 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 ( '90510' , '' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9' , '2.9' , '' , '0' , '2.90' ) 26/02/2024 02:59:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002225' AND id_product != '22199' AND ean13 != '' 26/02/2024 02:59:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002225', date_upd = NOW() WHERE id_product = '22199' 26/02/2024 02:59:47 pm >> UPDATE ps_product_lang SET name = 'VINO LIQUOROSO ROSSO ', description = '' WHERE id_product = '22199' 26/02/2024 02:59:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.475409836065574' WHERE id_product = '22199' 26/02/2024 02:59:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.475409836065574', id_tax_rules_group = '1', id_category_default = '387', 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 = '22199' 26/02/2024 02:59:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22199' 26/02/2024 02:59:47 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22199' 26/02/2024 02:59:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22200' , '1' , '' , 'nuovo-prodotto' ) 26/02/2024 02:59:47 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22200' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22199' 26/02/2024 02:59:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22200' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22199' 26/02/2024 03:00:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '182' , '2024-02-19' , '' , '0' , '80' , '2687' , 'via Trapani, C.DA Venera, 7 91025 MARSALA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '2352.04' , '1927.90' , NOW() , NOW() ) 26/02/2024 03:00:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90511' 26/02/2024 03:00:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90511' 26/02/2024 03:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90511' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '264' , '264' , '1' , '3.8247' , '3.135' , '22' , '0' , '1231.8594' ) 26/02/2024 03:00:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '80' 26/02/2024 03:00:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '80' , '1' ) 26/02/2024 03:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90511' , '11756' , 'VINO BIANCO SECCO - 14%' , '90' , '90' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '307.4400' ) 26/02/2024 03:00:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '80' 26/02/2024 03:00:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '80' , '1' ) 26/02/2024 03:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90511' , '22199' , 'VINO LIQUOROSO ROSSO ' , '180' , '180' , '1' , '3.701' , '3.033606557377' , '22' , '0' , '812.7396' ) 26/02/2024 03:00:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22199' AND id_supplier = '80' 26/02/2024 03:00:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22199' , '80' , '1' ) 26/02/2024 03:02:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '89869' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-09') 26/02/2024 03:02:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2024-01-09', document_letter = 'A', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', 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 = '533.00', price_tax_excluded = '533.00', date_upd = NOW() WHERE id_document = '89869' 26/02/2024 03:02:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89869' 26/02/2024 03:02:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '89869' 26/02/2024 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '15020' , 'PREGARE OGNI GIORNO' , '500' , '-500' , '4' , '1.0000' , '1' , '0' , '25' , '375.00' ) 26/02/2024 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '15293' , 'BENEDIZIONI - RISURREZIONE A' , '200' , '-200' , '4' , '0.1500' , '0.15' , '0' , '0' , '30.00' ) 26/02/2024 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' , '1.0000' , '1' , '0' , '15' , '42.50' ) 26/02/2024 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '19' , '-19' , '4' , '3.0000' , '3' , '0' , '5' , '54.15' ) 26/02/2024 03:02:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '11' , '-11' , '4' , '3.00' , '3' , '0' , '5' , '31.35' ) 26/02/2024 03:05:26 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '182', document_date = '2024-02-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2687', address1 = 'via Trapani, C.DA Venera, 7 91025 MARSALA', address2 = '', note = '', price_shipping = '1.82', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '2354.26', price_tax_excluded = '1929.72', date_upd = NOW() WHERE id_document = '90511' 26/02/2024 03:05:26 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 = '90511' 26/02/2024 03:05:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '90511' 26/02/2024 03:05:26 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 ( '90511' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '264' , '264' , '1' , '3.8247' , '3.135' , '22' , '0' , '1231.86' ) 26/02/2024 03:05:26 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 ( '90511' , '11756' , 'VINO BIANCO SECCO - 14%' , '90' , '90' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '307.44' ) 26/02/2024 03:05:26 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 ( '90511' , '22199' , 'VINO LIQUOROSO ROSSO ' , '180' , '180' , '1' , '3.7010' , '3.033606557377' , '22' , '0' , '812.74' ) 26/02/2024 03:13:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 03:13:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '8/E' , '2024-02-26' , 'E' , '31' , '0' , '4670717' , 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '268.80' , '268.80' , NOW() , NOW() ) 26/02/2024 03:13:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90512' 26/02/2024 03:13:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90512' 26/02/2024 03:13:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90512' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '160' , '-160' , '4' , '2.80' , '2.8' , '0' , '40' , '268.80' ) 26/02/2024 03:31:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '42' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 03:31: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 ( '21' , '42' , '2024-02-26' , '' , '2755' , '0' , '4677545' , 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '55.87' , '55.87' , NOW() , NOW() ) 26/02/2024 03:31: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 = '90513' 26/02/2024 03:31:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '90513' 26/02/2024 03:31: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 ( '90513' , '22050' , 'E RISORTO, NON E QUI' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 26/02/2024 03:31: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 ( '90513' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 26/02/2024 03:31: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 ( '90513' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 26/02/2024 03:31: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 ( '90513' , '21390' , 'ROSARIO EUCARISTICO - F. STANO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 26/02/2024 03:31: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 ( '90513' , '19870' , 'QUANDO LE CAMPANE SUONANO A FESTA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 26/02/2024 03:31: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 ( '90513' , '18009' , 'SCALA PIU CORTA PER SALIRE IN CIELO - 8011' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/02/2024 03:31:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90513' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 26/02/2024 03:31:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90513' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 26/02/2024 03:31:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90513' , '15471' , 'ADORAZIONE EUCARISTICA SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 26/02/2024 03:31:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90513' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 26/02/2024 03:56:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/E' AND id_document != '90512' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 03:56:11 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '8/E', document_date = '2024-02-26', document_letter = 'E', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '268.80', price_tax_excluded = '268.80', date_upd = NOW() WHERE id_document = '90512' 26/02/2024 03:56:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90512' 26/02/2024 03:56:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90512' 26/02/2024 03:56:12 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 ( '90512' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '160' , '-160' , '4' , '2.8000' , '2.8' , '0' , '40' , '268.80' ) 26/02/2024 04:08:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '567' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 04:08: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' , '567' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.00' , '73.00' , NOW() , NOW() ) 26/02/2024 04:08: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 = '90514' 26/02/2024 04:08:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '90514' 26/02/2024 04:08: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 ( '90514' , '18075' , 'PER CRUCEM AD LUCEM - J. RATZINGER' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 26/02/2024 04:08: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 ( '90514' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 26/02/2024 04:08: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 ( '90514' , '1813' , 'CATECHESI TRADENDAE: EDUCARE ALLA FEDE OGGI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 26/02/2024 04:08: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 ( '90514' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '-1' , '4' , '2.45' , '2.45' , '0' , '0' , '2.45' ) 26/02/2024 04:08: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 ( '90514' , '5530' , 'LUOMO SPIRITO INCARNATO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 26/02/2024 04:08: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 ( '90514' , '21679' , 'LAUDATE DEUM - 8583' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 26/02/2024 04:08: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 ( '90514' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 26/02/2024 04:08: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 ( '90514' , '3289' , 'DAI FRAMMENTI ALLA STORIA - GALVAGNO/GIUNTOLI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 26/02/2024 05:31:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '568' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 05:31: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' , '568' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 26/02/2024 05:31: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 = '90515' 26/02/2024 05:31:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90515' 26/02/2024 05:31: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 ( '90515' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 26/02/2024 05:31: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 ( '90515' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 26/02/2024 06:00:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '569' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 06:00:24 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' , '569' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 26/02/2024 06:00:24 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 = '90516' 26/02/2024 06:00:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '90516' 26/02/2024 06:00:24 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 ( '90516' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 26/02/2024 06:17:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '570' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 06:17:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '570' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 26/02/2024 06:17:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90517' 26/02/2024 06:17:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90517' 26/02/2024 06:18:00 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 ( '90517' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 26/02/2024 06:52:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '571' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 06:52:23 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' , '571' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.40' , '35.16' , NOW() , NOW() ) 26/02/2024 06:52:23 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 = '90518' 26/02/2024 06:52:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90518' 26/02/2024 06:52:23 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 ( '90518' , '3227' , 'CUORE DI PADRE PIO - 8109' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 26/02/2024 06:52:23 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 ( '90518' , '7105' , 'NOVENA A SAN PIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 26/02/2024 06:52:23 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 ( '90518' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 26/02/2024 06:52:23 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 ( '90518' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '12.40' ) 26/02/2024 07:25:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '572' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 26/02/2024 07:25:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '572' , '2024-02-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 26/02/2024 07:25:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90519' 26/02/2024 07:25:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90519' 26/02/2024 07:25:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90519' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' )