13/07/2022 08:27:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1938' AND id_document != '58782' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 13/07/2022 08:27:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1938', document_date = '2022-06-15', 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 = '20.69', price_tax_excluded = '20.69', date_upd = NOW() WHERE id_document = '58782' 13/07/2022 08:27:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58782' 13/07/2022 08:27:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58782' 13/07/2022 08:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '16050' AND id_supplier = '' 13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16050' , '' , '1' ) 13/07/2022 08:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 13/07/2022 08:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' , '9.3000' , '9.3' , '0' , '5' , '8.84' ) 13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11202' AND id_supplier = '' 13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11202' , '' , '1' ) 13/07/2022 08:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '-1' , '4' , '6.14' , '6.14' , '0' , '0' , '6.14' ) 13/07/2022 08:27:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '8340' AND id_supplier = '' 13/07/2022 08:27:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8340' , '' , '1' ) 13/07/2022 08:28:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2061' AND id_document != '58921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 13/07/2022 08:28:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2061', document_date = '2022-06-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '71.12', price_tax_excluded = '60.95', date_upd = NOW() WHERE id_document = '58921' 13/07/2022 08:28:36 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 = '58921' 13/07/2022 08:28:36 am >> DELETE FROM ps_document_detail WHERE id_document = '58921' 13/07/2022 08:28:36 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 ( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/07/2022 08:28:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/07/2022 08:28:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/07/2022 08:28:36 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 ( '58921' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 13/07/2022 08:28:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/07/2022 08:28:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/07/2022 08:28:36 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 ( '58921' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '8.72' , '8.72' , '0' , '0' , '8.72' ) 13/07/2022 08:28:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = '' 13/07/2022 08:28:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '' , '1' ) 13/07/2022 08:29:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2042' AND id_document != '58899' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-25') 13/07/2022 08:29:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2042', document_date = '2022-06-25', 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 = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '58899' 13/07/2022 08:29:06 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 = '58899' 13/07/2022 08:29:06 am >> DELETE FROM ps_document_detail WHERE id_document = '58899' 13/07/2022 08:29:06 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 ( '58899' , '19377' , 'VANGELO SECONDO MARCO - L. BRUNI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 13/07/2022 08:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19377' AND id_supplier = '' 13/07/2022 08:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19377' , '' , '1' ) 13/07/2022 08:29:30 am >> DELETE FROM ps_document WHERE id_document = '59132' 13/07/2022 08:29:30 am >> DELETE FROM ps_document_detail WHERE id_document = '59132' 13/07/2022 09:20:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 09:20:39 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' , '2250' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 13/07/2022 09:20:39 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 = '59152' 13/07/2022 09:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '59152' 13/07/2022 09:20:39 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 ( '59152' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '36' , '29.508196721311' , '22' , '0' , '72.00' ) 13/07/2022 09:20:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 13/07/2022 09:20:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 13/07/2022 09:39:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1279' AND id_document != '56455' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-27') 13/07/2022 09:39:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1279', document_date = '2022-04-27', 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 = '78.00', price_tax_excluded = '63.93', date_upd = NOW() WHERE id_document = '56455' 13/07/2022 09:39:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56455' 13/07/2022 09:39:58 am >> DELETE FROM ps_document_detail WHERE id_document = '56455' 13/07/2022 09:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56455' , '18259' , 'CLERGY GRIGIO NIDO DAPE MM - L' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 13/07/2022 09:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18259' AND id_supplier = '' 13/07/2022 09:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18259' , '' , '1' ) 13/07/2022 09:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56455' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '15' , '-15' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '3.00' ) 13/07/2022 09:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '6356' AND id_supplier = '' 13/07/2022 09:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6356' , '' , '1' ) 13/07/2022 09:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56455' , '11756' , 'VINO BIANCO SECCO - 14%' , '7' , '-7' , '1' , '5' , '4.0983606557377' , '22' , '0' , '35.00' ) 13/07/2022 09:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/07/2022 09:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/07/2022 09:40:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1230' AND id_document != '55886' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 13/07/2022 09:40:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1230', document_date = '2022-04-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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '55886' 13/07/2022 09:40:35 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 = '55886' 13/07/2022 09:40:35 am >> DELETE FROM ps_document_detail WHERE id_document = '55886' 13/07/2022 09:40:35 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 ( '55886' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '5' , '-5' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.00' ) 13/07/2022 09:40:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 13/07/2022 09:40:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 13/07/2022 09:40:36 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 ( '55886' , '11756' , 'VINO BIANCO SECCO - 14%' , '9' , '-9' , '1' , '5' , '4.0983606557377' , '22' , '0' , '45.00' ) 13/07/2022 09:40:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/07/2022 09:40:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/07/2022 09:41:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1201' AND id_document != '55339' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-21') 13/07/2022 09:41:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1201', document_date = '2022-04-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.00', price_tax_excluded = '34.43', date_upd = NOW() WHERE id_document = '55339' 13/07/2022 09:41:17 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 = '55339' 13/07/2022 09:41:17 am >> DELETE FROM ps_document_detail WHERE id_document = '55339' 13/07/2022 09:41:17 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 ( '55339' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '22.00' ) 13/07/2022 09:41:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/07/2022 09:41:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/07/2022 09:41:17 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 ( '55339' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '7.00' ) 13/07/2022 09:41:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 13/07/2022 09:41:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 13/07/2022 09:41:17 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 ( '55339' , '11264' , 'VESTINA BATTESIMALE' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 13/07/2022 09:41:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '11264' AND id_supplier = '' 13/07/2022 09:41:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11264' , '' , '1' ) 13/07/2022 09:41:18 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 ( '55339' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 13/07/2022 09:41:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '9125' AND id_supplier = '' 13/07/2022 09:41:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9125' , '' , '1' ) 13/07/2022 09:41:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '56543' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 13/07/2022 09:41:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1356', document_date = '2022-05-02', 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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '56543' 13/07/2022 09:41:43 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 = '56543' 13/07/2022 09:41:43 am >> DELETE FROM ps_document_detail WHERE id_document = '56543' 13/07/2022 09:41:43 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 ( '56543' , '11756' , 'VINO BIANCO SECCO - 14%' , '4' , '-4' , '1' , '5' , '4.0983606557377' , '22' , '0' , '20.00' ) 13/07/2022 09:41:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 13/07/2022 09:41:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 13/07/2022 09:54:34 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 09:54:34 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 ( '24' , '20' , '2022-07-13' , '' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '88.52' , NOW() , NOW() ) 13/07/2022 09:54:34 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 = '59153' 13/07/2022 09:54:34 am >> DELETE FROM ps_document_detail WHERE id_document = '59153' 13/07/2022 09:54:34 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 ( '59153' , '11756' , 'VINO BIANCO SECCO - 14%' , '12' , '-12' , '1' , '6' , '4.9180327868852' , '22' , '0' , '72.00' ) 13/07/2022 09:54:34 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 ( '59153' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 13/07/2022 09:54:47 am >> DELETE FROM ps_document WHERE id_document = '59153' 13/07/2022 09:54:47 am >> DELETE FROM ps_document_detail WHERE id_document = '59153' 13/07/2022 11:00:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 11:00:18 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' , '2251' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 13/07/2022 11:00:18 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 = '59154' 13/07/2022 11:00:18 am >> DELETE FROM ps_document_detail WHERE id_document = '59154' 13/07/2022 11:00:18 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 ( '59154' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 13/07/2022 11:00:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 13/07/2022 11:00:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 13/07/2022 11:08:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 11:08:44 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' , '2252' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.40' , '12.57' , NOW() , NOW() ) 13/07/2022 11:08:44 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 = '59155' 13/07/2022 11:08:44 am >> DELETE FROM ps_document_detail WHERE id_document = '59155' 13/07/2022 11:08:45 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 ( '59155' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 13/07/2022 11:08:45 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 ( '59155' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 13/07/2022 11:08:45 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 ( '59155' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/07/2022 11:08:45 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 ( '59155' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 13/07/2022 11:08:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/07/2022 11:08:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/07/2022 11:17:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 11:17:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2253' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.70' , '25.98' , NOW() , NOW() ) 13/07/2022 11:17:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59156' 13/07/2022 11:17:48 am >> DELETE FROM ps_document_detail WHERE id_document = '59156' 13/07/2022 11:17:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59156' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '31.70' , '25.983606557377' , '22' , '0' , '31.70' ) 13/07/2022 11:17:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 13/07/2022 11:17:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 13/07/2022 11:27:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2254' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 11:27:00 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' , '2254' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 13/07/2022 11:27:00 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 = '59157' 13/07/2022 11:27:00 am >> DELETE FROM ps_document_detail WHERE id_document = '59157' 13/07/2022 11:27:00 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 ( '59157' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 13/07/2022 11:27:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '' 13/07/2022 11:27:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' ) 13/07/2022 11:33:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2255' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 11:33:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2255' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 13/07/2022 11:33:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59158' 13/07/2022 11:33:32 am >> DELETE FROM ps_document_detail WHERE id_document = '59158' 13/07/2022 11:33:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59158' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 13/07/2022 11:33:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 13/07/2022 11:33:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 13/07/2022 11:57:44 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 13/07/2022 11:57:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', 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 = '86.74', price_tax_excluded = '74.25', date_upd = NOW() WHERE id_document = '51968' 13/07/2022 11:57:44 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 = '51968' 13/07/2022 11:57:45 am >> DELETE FROM ps_document_detail WHERE id_document = '51968' 13/07/2022 11:57:45 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 ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/07/2022 11:57:45 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 ( '51968' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/07/2022 11:57:45 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 ( '51968' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/07/2022 11:57:45 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 ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/07/2022 11:57:45 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 ( '51968' , '0' , 'SOMMA PER ARRIVARE AL RESIDUO' , '1' , '-1' , '0' , '0.9400' , '0.94' , '0' , '0' , '0.94' ) 13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/07/2022 11:57:45 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 ( '51968' , '0' , 'ACCONTO scontrinato € 218 SCALATI, RESIDUO AL 27/06/2022 ' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/07/2022 11:57:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 13/07/2022 11:57:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 13/07/2022 12:02:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 13/07/2022 12:02:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', 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 = '28.00', price_tax_excluded = '28.00', date_upd = NOW() WHERE id_document = '51968' 13/07/2022 12:02:40 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 = '51968' 13/07/2022 12:02:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968' 13/07/2022 12:02:40 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 ( '51968' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.56' , '0.56' , '0' , '0' , '28.00' ) 13/07/2022 12:02:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 13/07/2022 12:02:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 13/07/2022 12:04:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 13/07/2022 12:04:10 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.04', price_tax_excluded = '65.04', date_upd = NOW() WHERE id_document = '51968' 13/07/2022 12:04:10 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 = '51968' 13/07/2022 12:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968' 13/07/2022 12:04:10 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 ( '51968' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.5600' , '0.56' , '0' , '0' , '28.00' ) 13/07/2022 12:04:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 13/07/2022 12:04:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 13/07/2022 12:04:10 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 ( '51968' , '19685' , 'AMEN - OTT 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 13/07/2022 12:04:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 13/07/2022 12:04:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 13/07/2022 12:04:10 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 ( '51968' , '19684' , 'AMEN - SETT. 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 13/07/2022 12:04:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 13/07/2022 12:04:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 13/07/2022 12:05:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2256' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 12:05: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' , '2256' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.23' , NOW() , NOW() ) 13/07/2022 12:05: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 = '59159' 13/07/2022 12:05:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '59159' 13/07/2022 12:05: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 ( '59159' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 13/07/2022 12:05:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/07/2022 12:05:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/07/2022 12:05: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 ( '59159' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/07/2022 12:05:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 13/07/2022 12:05:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 13/07/2022 12:07:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1311' AND id_document != '56492' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-29') 13/07/2022 12:07:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1311', document_date = '2022-04-29', 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 = '201.19', price_tax_excluded = '174.27', date_upd = NOW() WHERE id_document = '56492' 13/07/2022 12:07: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 = '56492' 13/07/2022 12:07:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '56492' 13/07/2022 12:07: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 ( '56492' , '9436' , 'SAN GABRIELE DELLADDOLORATA - V.SALVOLDI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9436' AND id_supplier = '' 13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9436' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9613' AND id_supplier = '' 13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9613' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 13/07/2022 12:07:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 13/07/2022 12:07:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3625' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3625' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '15' , '-15' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '42.00' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19316' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19316' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '2663' , 'CONFEZIONE CON LIBRETTO E CROCE - 2324/K04' , '4' , '-4' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '8.80' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2663' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2663' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '4' , '-4' , '4' , '1.9000' , '1.9' , '0' , '5' , '7.24' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11644' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11644' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '4.80' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7928' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7928' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '5' , '24.00' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7915' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7915' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '7.50' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '1312' , 'BRACCIALE DECINA' , '5' , '-5' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '6.50' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '42.00' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' , '-1' , '4' , '4.7500' , '4.75' , '0' , '0' , '4.75' ) 13/07/2022 12:07:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9647' AND id_supplier = '' 13/07/2022 12:07:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9647' , '' , '1' ) 13/07/2022 12:07: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 ( '56492' , '9129' , 'ROSARIO LEGNO - T/2' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 13/07/2022 12:07:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9129' AND id_supplier = '' 13/07/2022 12:07:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9129' , '' , '1' ) 13/07/2022 12:11:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1344' AND id_document != '56530' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 13/07/2022 12:11:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1344', document_date = '2022-05-02', 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 = '54.50', price_tax_excluded = '45.88', date_upd = NOW() WHERE id_document = '56530' 13/07/2022 12:11: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 = '56530' 13/07/2022 12:11:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '56530' 13/07/2022 12:11: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 ( '56530' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/07/2022 12:11: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 ( '56530' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.7000' , '1.6346153846154' , '4' , '0' , '8.50' ) 13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/07/2022 12:11: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 ( '56530' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/07/2022 12:11: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 ( '56530' , '9129' , 'ROSARIO LEGNO - T/2' , '5' , '-5' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '7.50' ) 13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9129' AND id_supplier = '' 13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9129' , '' , '1' ) 13/07/2022 12:11: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 ( '56530' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 13/07/2022 12:11:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/07/2022 12:11:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/07/2022 12:11:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1361' AND id_document != '56548' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 13/07/2022 12:11:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1361', document_date = '2022-05-02', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '56548' 13/07/2022 12:11: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 = '56548' 13/07/2022 12:11:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '56548' 13/07/2022 12:11: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 ( '56548' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '16' , '-16' , '1' , '1' , '0.81967213114754' , '22' , '0' , '16.00' ) 13/07/2022 12:11:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/07/2022 12:11:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/07/2022 12:12:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1363' AND id_document != '56550' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-02') 13/07/2022 12:12:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1363', document_date = '2022-05-02', 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 = '158.74', price_tax_excluded = '137.77', date_upd = NOW() WHERE id_document = '56550' 13/07/2022 12:12: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 = '56550' 13/07/2022 12:12:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '56550' 13/07/2022 12:12: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 ( '56550' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '13506' , 'SANTO ROSARIO' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '10' , '27.00' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13506' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13506' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '18377' , 'CHI RESTA SALDO? - E. BIANCHI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18377' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18377' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '19328' , 'AMEN - GIU. 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19328' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19328' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '19516' , 'AMEN - AGO 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '19275' , 'AMEN - MAG. 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19275' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19275' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1' , '0.81967213114754' , '22' , '0' , '36.00' ) 13/07/2022 12:12:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 13/07/2022 12:12:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 13/07/2022 12:12: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 ( '56550' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '42.00' ) 13/07/2022 12:12:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 13/07/2022 12:12:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 13/07/2022 12:13:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2067' AND id_document != '58931' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-28') 13/07/2022 12:13:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2067', document_date = '2022-06-28', 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 = '16.50', price_tax_excluded = '15.87', date_upd = NOW() WHERE id_document = '58931' 13/07/2022 12:13:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58931' 13/07/2022 12:13:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '58931' 13/07/2022 12:13:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58931' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 13/07/2022 12:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/07/2022 12:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/07/2022 12:13:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58931' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '1.75' , '1.6826923076923' , '4' , '0' , '3.50' ) 13/07/2022 12:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/07/2022 12:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/07/2022 12:13:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58931' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 13/07/2022 12:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/07/2022 12:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/07/2022 12:16:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2159' AND id_document != '59036' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-04') 13/07/2022 12:16:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2159', document_date = '2022-07-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA DUOMO, 1 84096 MONTECORVINO ROVELLA', 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 = '314.00', price_tax_excluded = '276.82', date_upd = NOW() WHERE id_document = '59036' 13/07/2022 12:16:07 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 = '59036' 13/07/2022 12:16:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '59036' 13/07/2022 12:16:08 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 ( '59036' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' , '6.0000' , '6' , '0' , '5' , '22.80' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '7311' , 'OSTIA SOTTILE 74MM' , '14' , '-14' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '26.60' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '7673' , 'PARTICOLE MM38' , '7' , '-7' , '3' , '3.0000' , '2.8846153846154' , '4' , '0' , '21.00' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '15666' , 'MIRACOLOSA CM 60' , '1' , '-1' , '1' , '180.0000' , '147.54098360656' , '22' , '0' , '180.00' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15666' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15666' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13.6000' , '13.6' , '0' , '0' , '13.60' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/07/2022 12:16:08 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 ( '59036' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 13/07/2022 12:16:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/07/2022 12:16:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/07/2022 12:22:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2257' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 12:22:17 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' , '2257' , '2022-07-13' , '' , '' , '' , '' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '188.60' , '154.59' , NOW() , NOW() ) 13/07/2022 12:22:17 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 = '59160' 13/07/2022 12:22:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '59160' 13/07/2022 12:22:17 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 ( '59160' , '6405' , 'MENSA DIAM 40X250 - M4025' , '25' , '-25' , '1' , '3.4000' , '2.7869' , '22' , '0' , '85.00' ) 13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6405' AND id_supplier = '' 13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6405' , '' , '1' ) 13/07/2022 12:22:17 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 ( '59160' , '1621' , 'CANDELE CONICHE 10 PZ' , '2' , '-2' , '1' , '6.8000' , '5.5738' , '22' , '0' , '13.60' ) 13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1621' AND id_supplier = '' 13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1621' , '' , '1' ) 13/07/2022 12:22:17 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 ( '59160' , '17161' , 'CARBONCINI NERI - CARNE' , '5' , '-5' , '1' , '12.0000' , '9.8361' , '22' , '0' , '60.00' ) 13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 13/07/2022 12:22:17 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 ( '59160' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.5902' , '22' , '0' , '30.00' ) 13/07/2022 12:22:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 13/07/2022 12:22:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 13/07/2022 12:22:25 pm >> DELETE FROM ps_document WHERE id_document = '59083' 13/07/2022 12:22:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '59083' 13/07/2022 12:52:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2258' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 12:52: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' , '2258' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 13/07/2022 12:52: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 = '59161' 13/07/2022 12:52:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '59161' 13/07/2022 12:52: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 ( '59161' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '35' , '35' , '0' , '0' , '35.00' ) 13/07/2022 12:52:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 13/07/2022 12:52:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 13/07/2022 04:22:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2259' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 04:22:03 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' , '2259' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 13/07/2022 04:22:03 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 = '59162' 13/07/2022 04:22:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '59162' 13/07/2022 04:22:03 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 ( '59162' , '1328' , 'BRACCIALE IN ECO PELLE CON PREGHIERE - 3163' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 13/07/2022 04:22:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1328' AND id_supplier = '' 13/07/2022 04:22:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1328' , '' , '1' ) 13/07/2022 05:51:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983400' AND id_product != '12849' AND ean13 != '' 13/07/2022 05:51:42 pm >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '9788895983400', date_upd = NOW() WHERE id_product = '12849' 13/07/2022 05:51:42 pm >> UPDATE ps_product_lang SET name = 'LIBRO DELLE SS. MESSE', description = '

Registri parrocchiali

 

Per la firma del celebrante, 2400 registrazioni.


' WHERE id_product = '12849' 13/07/2022 05:51:42 pm >> UPDATE ps_product SET wholesale_price = '1.40', on_sale = '0', price = '16.3900' WHERE id_product = '12849' 13/07/2022 05:51:42 pm >> UPDATE ps_product_shop SET wholesale_price = '1.40', price = '16.3900', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '433', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '1', on_most = '00', date_upd = NOW() WHERE id_product = '12849' 13/07/2022 05:51:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '12849' 13/07/2022 05:51:42 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '12849' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 13/07/2022 06:06:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2260' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 06:06: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' , '2260' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.80' , '172.71' , NOW() , NOW() ) 13/07/2022 06:06: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 = '59163' 13/07/2022 06:06:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '59163' 13/07/2022 06:06: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 ( '59163' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '143.00' , '117.2131147541' , '22' , '0' , '143.00' ) 13/07/2022 06:06:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = '' 13/07/2022 06:06:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' ) 13/07/2022 06:06: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 ( '59163' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '6' , '-6' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '7.20' ) 13/07/2022 06:06:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 13/07/2022 06:06:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 13/07/2022 06:06: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 ( '59163' , '2528' , 'COMPIETA' , '40' , '-40' , '4' , '1.30' , '1.3' , '0' , '5' , '49.60' ) 13/07/2022 06:06:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2528' AND id_supplier = '' 13/07/2022 06:06:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2528' , '' , '1' ) 13/07/2022 06:22:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2261' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 06:22:46 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' , '2261' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 13/07/2022 06:22:46 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 = '59164' 13/07/2022 06:22:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '59164' 13/07/2022 06:22:46 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 ( '59164' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '50' , '-50' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '25.00' ) 13/07/2022 06:22:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = '' 13/07/2022 06:22:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' ) 13/07/2022 06:22:46 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 ( '59164' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 13/07/2022 06:22:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/07/2022 06:22:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/07/2022 06:28:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2262' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 06:28: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' , '2262' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 13/07/2022 06:28: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 = '59165' 13/07/2022 06:28:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '59165' 13/07/2022 06:28: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 ( '59165' , '6359' , 'MEDAGLIA SCAPOLARE ARGENTO - MM12 ' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 13/07/2022 06:28:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6359' AND id_supplier = '' 13/07/2022 06:28:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6359' , '' , '1' ) 13/07/2022 06:28: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 ( '59165' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 13/07/2022 06:28:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/07/2022 06:28:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/07/2022 06:29:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2263' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-13') 13/07/2022 06:29:26 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' , '2263' , '2022-07-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 13/07/2022 06:29: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 = '59166' 13/07/2022 06:29:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '59166' 13/07/2022 06:29: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 ( '59166' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/07/2022 06:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18896' AND id_supplier = '' 13/07/2022 06:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18896' , '' , '1' ) 13/07/2022 06:32:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1803' AND id_document != '58627' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 13/07/2022 06:32:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1803', document_date = '2022-06-06', 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.70', price_tax_excluded = '14.10', date_upd = NOW() WHERE id_document = '58627' 13/07/2022 06:32: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 = '58627' 13/07/2022 06:32:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '58627' 13/07/2022 06:32: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 ( '58627' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '' 13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' ) 13/07/2022 06:32: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 ( '58627' , '18353' , 'PORTA ROSARIO IN VELLUTO PICCOLO - 313-NT 4' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18353' AND id_supplier = '' 13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18353' , '' , '1' ) 13/07/2022 06:32: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 ( '58627' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.50' ) 13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = '' 13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' ) 13/07/2022 06:32: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 ( '58627' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 13/07/2022 06:32:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 13/07/2022 06:32:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' )