30/06/2023 08:26:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1958' AND id_document != '85714' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 30/06/2023 08:26:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1958', document_date = '2023-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 = '104.80', price_tax_excluded = '98.99', date_upd = NOW() WHERE id_document = '85714' 30/06/2023 08:26: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 = '85714' 30/06/2023 08:26:17 am >> DELETE FROM ps_document_detail WHERE id_document = '85714' 30/06/2023 08:26: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 ( '85714' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 30/06/2023 08:26: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 ( '85714' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 30/06/2023 08:26: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 ( '85714' , '21203' , 'MIO GRANDE LIBRO DA COLORARE - SUPER' , '1' , '-1' , '4' , '7.2' , '7.2' , '0' , '' , '7.20' ) 30/06/2023 08:26: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 ( '85714' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 30/06/2023 08:26: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 ( '85714' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 30/06/2023 08:26: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 ( '85714' , '7395' , 'PADRE PIO - UN PENSIERO PER OGNI GIORNO - 8142' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/06/2023 08:26: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 ( '85714' , '19871' , 'LUCE DELLA VITA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 30/06/2023 08:26: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 ( '85714' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 30/06/2023 08:26: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 ( '85714' , '10071' , 'SONO ANZIANO SIGNORE, AIUTAMI A PREGARE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 30/06/2023 08:26: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 ( '85714' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 30/06/2023 08:26: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 ( '85714' , '978' , 'BEATA VERGINE MARIA CHE SCIOGLIE I NODI - ALBERO GENEALOGICO' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 30/06/2023 08:26: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 ( '85714' , '19487' , 'ROSARIO - R. LUPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 30/06/2023 08:26: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 ( '85714' , '7134' , 'NOZIONI E PRECI' , '1' , '-1' , '4' , '1.3000' , '1.3' , '0' , '0' , '1.30' ) 30/06/2023 08:26: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 ( '85714' , '13084' , 'PRIMI VENERDI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 30/06/2023 08:26: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 ( '85714' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 30/06/2023 08:26: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 ( '85714' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 30/06/2023 08:26:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1966' AND id_document != '85725' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 30/06/2023 08:26:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1966', document_date = '2023-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 = '16.40', price_tax_excluded = '14.81', date_upd = NOW() WHERE id_document = '85725' 30/06/2023 08:26: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 = '85725' 30/06/2023 08:26:35 am >> DELETE FROM ps_document_detail WHERE id_document = '85725' 30/06/2023 08:26: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 ( '85725' , '21204' , 'MIO GRANDE LIBRO DA COLORARE - FAVOLOSO' , '1' , '-1' , '4' , '7.6' , '7.6' , '0' , '0' , '7.60' ) 30/06/2023 08:26: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 ( '85725' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 30/06/2023 08:26: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 ( '85725' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 30/06/2023 08:40:47 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 30/06/2023 08:40:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2343.30', price_tax_excluded = '1928.28', date_upd = NOW() WHERE id_document = '86558' 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86558' 30/06/2023 08:40:47 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024 ***' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23 ****' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21198' , 'AMEN - SET 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21199' , 'AMEN - OTT 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023***' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '16456' , 'CINGOLO - CING03***' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39 ***' , '2' , '-2' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '84.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 30/06/2023 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21290' , 'ROSARIO ADDOLORATA' , '400' , '-400' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '1960.00' ) 30/06/2023 09:16:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-30') 30/06/2023 09:16:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2246' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 30/06/2023 09:16:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86572' 30/06/2023 09:16:55 am >> DELETE FROM ps_document_detail WHERE id_document = '86572' 30/06/2023 09:16:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86572' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 30/06/2023 10:00:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2247' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-30') 30/06/2023 10: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' , '2247' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '142.28' , NOW() , NOW() ) 30/06/2023 10: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 = '86573' 30/06/2023 10:00:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86573' 30/06/2023 10:00:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86573' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 30/06/2023 10:00:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86573' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 30/06/2023 10:00:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86573' , '2177' , 'CLERGY BASIC - MM - B&P' , '3' , '-3' , '1' , '32.75' , '26.844262295082' , '22' , '0' , '98.25' ) 30/06/2023 10:13:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2248' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-30') 30/06/2023 10:13:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2248' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.20' , '10.20' , NOW() , NOW() ) 30/06/2023 10:13:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86574' 30/06/2023 10:13:29 am >> DELETE FROM ps_document_detail WHERE id_document = '86574' 30/06/2023 10:13:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86574' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2023 10:13:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86574' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2023 10:13:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86574' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 30/06/2023 10:26:18 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 30/06/2023 10:26:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2439.30', price_tax_excluded = '2006.96', date_upd = NOW() WHERE id_document = '86558' 30/06/2023 10:26: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 = '86558' 30/06/2023 10:26:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 30/06/2023 10:26: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 ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 30/06/2023 10:26: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 ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024 ***' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 30/06/2023 10:26: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 ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23 ****' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 30/06/2023 10:26: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 ( '86558' , '21198' , 'AMEN - SET 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 10:26: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 ( '86558' , '21199' , 'AMEN - OTT 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 10:26: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 ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023***' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 30/06/2023 10:26: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 ( '86558' , '16456' , 'CINGOLO - CING03***' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 30/06/2023 10:26: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 ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 30/06/2023 10:26: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 ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 30/06/2023 10:26: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 ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 10:26: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 ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39 ***' , '2' , '-2' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '84.00' ) 30/06/2023 10:26: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 ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 10:26: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 ( '86558' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 30/06/2023 10:26: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 ( '86558' , '21290' , 'ROSARIO ADDOLORATA' , '400' , '-400' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '1960.00' ) 30/06/2023 10:26: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 ( '86558' , '20437' , 'LUMINO BIANCO 10BTS000' , '192' , '-192' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '96.00' ) 30/06/2023 10:27:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1083' AND id_document != '82591' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 30/06/2023 10:27:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1083', document_date = '2023-04-01', 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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '82591' 30/06/2023 10:27:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82591' 30/06/2023 10:27:41 am >> DELETE FROM ps_document_detail WHERE id_document = '82591' 30/06/2023 10:27:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82591' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/06/2023 10:27:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82591' , '6019' , 'LUMINO ROSSO - 10B' , '192' , '-192' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '76.80' ) 30/06/2023 10:27:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82591' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 30/06/2023 10:28:16 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 30/06/2023 10:28:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2439.30', price_tax_excluded = '2006.96', date_upd = NOW() WHERE id_document = '86558' 30/06/2023 10:28:16 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 = '86558' 30/06/2023 10:28:16 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 30/06/2023 10:28:16 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 ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 30/06/2023 10:28:16 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 ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024 ***' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 30/06/2023 10:28:16 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 ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23 ****' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 30/06/2023 10:28:16 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 ( '86558' , '21198' , 'AMEN - SET 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 10:28:16 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 ( '86558' , '21199' , 'AMEN - OTT 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 10:28:16 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 ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023***' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 30/06/2023 10:28:16 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 ( '86558' , '16456' , 'CINGOLO - CING03***' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 30/06/2023 10:28:16 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 ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 30/06/2023 10:28:16 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 ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 30/06/2023 10:28:16 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 ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 10:28:16 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 ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39 ***' , '2' , '-2' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '84.00' ) 30/06/2023 10:28:16 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 ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 10:28:16 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 ( '86558' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 30/06/2023 10:28:16 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 ( '86558' , '21290' , 'ROSARIO ADDOLORATA' , '400' , '-400' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '1960.00' ) 30/06/2023 10:28:16 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 ( '86558' , '20437' , 'LUMINO BIANCO 10BTS000 ***' , '192' , '-192' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '96.00' ) 30/06/2023 10:53:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2249' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-30') 30/06/2023 10:53:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2249' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 30/06/2023 10:53:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86575' 30/06/2023 10:53:55 am >> DELETE FROM ps_document_detail WHERE id_document = '86575' 30/06/2023 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86575' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 30/06/2023 10:54:06 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('2023-06-30') 30/06/2023 10:54:06 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' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/06/2023 10:54: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 = '86576' 30/06/2023 10:54:06 am >> DELETE FROM ps_document_detail WHERE id_document = '86576' 30/06/2023 10:54: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 ( '86576' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2023 11:00:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856685541' AND id_product != '20248' AND ean13 != '' 30/06/2023 11:00:14 am >> UPDATE ps_product SET id_supplier = '47', reference = '6/6', ean13 = '9788856685541', date_upd = NOW() WHERE id_product = '20248' 30/06/2023 11:00:14 am >> UPDATE ps_product_lang SET name = 'FORZA DELLO SPIRITO - C. AMIRANTE', description = '' WHERE id_product = '20248' 30/06/2023 11:00:14 am >> UPDATE ps_product SET wholesale_price = '9.03', on_sale = '0', price = '12.9000' WHERE id_product = '20248' 30/06/2023 11:00:14 am >> UPDATE ps_product_shop SET wholesale_price = '9.03', price = '12.9000', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20248' 30/06/2023 11:00:14 am >> DELETE FROM ps_specific_price WHERE id_product = '20248' 30/06/2023 11:02:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2065' AND id_document != '85852' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-14') 30/06/2023 11:02:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2065', document_date = '2023-06-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '119.08', date_upd = NOW() WHERE id_document = '85852' 30/06/2023 11:02:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85852' 30/06/2023 11:02:27 am >> DELETE FROM ps_document_detail WHERE id_document = '85852' 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '21098' , 'BRACCIALE DECINA PIETRA - BC1885' , '10' , '-10' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '25.00' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '20696' , 'NOSTRE NOZZE ' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '20839' , 'RELIQUIARIO DORATO CM 19,5' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '19106' , 'FRAGRANZA NARDO' , '2' , '-2' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '32.00' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2023 11:02:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85852' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.17' , '7.17' , '0' , '0' , '7.17' ) 30/06/2023 11:16:15 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('2023-06-30') 30/06/2023 11:16:15 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' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.68' , '29.68' , NOW() , NOW() ) 30/06/2023 11:16:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86577' 30/06/2023 11:16:15 am >> DELETE FROM ps_document_detail WHERE id_document = '86577' 30/06/2023 11:16:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86577' , '20999' , 'AMEN - LUG 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 30/06/2023 11:16:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86577' , '21067' , 'AMEN - AGO 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 30/06/2023 11:16:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86577' , '21198' , 'AMEN - SET 2023' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 30/06/2023 11:16:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86577' , '21199' , 'AMEN - OTT 2023' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 30/06/2023 11:17:34 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('2023-06-30') 30/06/2023 11:17: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 ( '11' , '2252' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.71' , '80.71' , NOW() , NOW() ) 30/06/2023 11:17: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 = '86578' 30/06/2023 11:17:34 am >> DELETE FROM ps_document_detail WHERE id_document = '86578' 30/06/2023 11:17: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 ( '86578' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2023 11:17: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 ( '86578' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2023 11:17: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 ( '86578' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2023 11:17: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 ( '86578' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2023 11:17: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 ( '86578' , '1090' , 'BIBBIA' , '7' , '-7' , '4' , '9.90' , '9.9' , '0' , '5' , '65.87' ) 30/06/2023 11:18:32 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('2023-06-30') 30/06/2023 11:18: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' , '2253' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.61' , '52.96' , NOW() , NOW() ) 30/06/2023 11:18: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 = '86579' 30/06/2023 11:18:32 am >> DELETE FROM ps_document_detail WHERE id_document = '86579' 30/06/2023 11:18: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 ( '86579' , '14079' , 'ALBERO DELLA VITA ROSSO 42X22' , '1' , '-1' , '1' , '64.61' , '52.959016393443' , '22' , '0' , '64.61' ) 30/06/2023 11:37:01 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 30/06/2023 11:37:01 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '2484.30', price_tax_excluded = '2051.96', date_upd = NOW() WHERE id_document = '86558' 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86558' 30/06/2023 11:37:01 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024 ***' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23 ****' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21198' , 'AMEN - SET 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21199' , 'AMEN - OTT 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023***' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '16456' , 'CINGOLO - CING03***' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39 ***' , '2' , '-2' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '84.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21290' , 'ROSARIO ADDOLORATA' , '400' , '-400' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '1960.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '20437' , 'LUMINO BIANCO 10BTS000 ***' , '192' , '-192' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '96.00' ) 30/06/2023 11:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '20954' , 'TEMPO DELL’APOCALISSE ' , '3' , '-3' , '4' , '15.00' , '15' , '0' , '0' , '45.00' ) 30/06/2023 11:44:43 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('2023-06-30') 30/06/2023 11:44:43 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' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 30/06/2023 11:44: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 = '86580' 30/06/2023 11:44:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86580' 30/06/2023 11:44: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 ( '86580' , '21037' , 'SULLA TUA PAROLA LUG/AGO 23' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '5' , '33.25' ) 30/06/2023 12:11:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2255' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-30') 30/06/2023 12:11: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' , '2255' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 30/06/2023 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 = '86581' 30/06/2023 12:11:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '86581' 30/06/2023 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 ( '86581' , '6590' , 'MEZZO VETRO ROSSO RUBINO - VKINGS2' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 30/06/2023 12:11: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 ( '86581' , '6011' , 'LUMINELLO VETRO - 474' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/06/2023 12:11: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 ( '86581' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 30/06/2023 12:15:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '310/TP' AND id_product != '12742' AND ean13 != '' 30/06/2023 12:15:17 pm >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '310/TP', date_upd = NOW() WHERE id_product = '12742' 30/06/2023 12:15:17 pm >> UPDATE ps_product_lang SET name = 'COPRILEGGIO - 310/TP', description = '' WHERE id_product = '12742' 30/06/2023 12:15:17 pm >> UPDATE ps_product SET wholesale_price = '31.00', on_sale = '0', price = '61.47540983606557' WHERE id_product = '12742' 30/06/2023 12:15:17 pm >> UPDATE ps_product_shop SET wholesale_price = '31.00', price = '61.47540983606557', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12742' 30/06/2023 12:15:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '12742' 30/06/2023 12:17:24 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '135' 30/06/2023 12:17:48 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '133' 30/06/2023 12:18:49 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '133' 30/06/2023 12:18:49 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '133' 30/06/2023 12:44:50 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('2023-06-30') 30/06/2023 12:44:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2256' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.00' , '54.92' , NOW() , NOW() ) 30/06/2023 12:44: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 = '86582' 30/06/2023 12:44:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '86582' 30/06/2023 12:44: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 ( '86582' , '7554' , 'PARAFIAMMA PLEXIGLASS CM 5' , '2' , '-2' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '38.00' ) 30/06/2023 12:44: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 ( '86582' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 30/06/2023 12:46:26 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('2023-06-30') 30/06/2023 12:46: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' , '2257' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 30/06/2023 12:46: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 = '86583' 30/06/2023 12:46:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '86583' 30/06/2023 12:46: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 ( '86583' , '11743' , 'MINISTERO STRAORDINARIO DELLA COMUNIONE' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/06/2023 12:54:10 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/06/2023 12:54:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21292' , '1' , '' , 'nuovo-prodotto' ) 30/06/2023 12:54:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21292' , '1' , '1' , '2' , NOW() , NOW() ) 30/06/2023 12:54:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21292' , '0' , '1' , '0' , '0' ) 30/06/2023 12:54:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885589988' AND id_product != '21292' AND ean13 != '' 30/06/2023 12:54:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788885589988', date_upd = NOW() WHERE id_product = '21292' 30/06/2023 12:54:48 pm >> UPDATE ps_product_lang SET name = 'PANE QUOTIDIANO SETT/OTT 2023', description = '' WHERE id_product = '21292' 30/06/2023 12:54:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21292' 30/06/2023 12:54:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '343', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21292' 30/06/2023 12:54:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21292' 30/06/2023 12:54:49 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21292' 30/06/2023 12:54:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21293' , '1' , '' , 'nuovo-prodotto' ) 30/06/2023 12:54:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21293' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21292' 30/06/2023 12:54:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21293' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21292' 30/06/2023 12:55:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242760' AND id_product != '21293' AND ean13 != '' 30/06/2023 12:55:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892242760', date_upd = NOW() WHERE id_product = '21293' 30/06/2023 12:55:27 pm >> UPDATE ps_product_lang SET name = 'GRIDO DELLA PACE - A. RICCARDI', description = '' WHERE id_product = '21293' 30/06/2023 12:55:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21293' 30/06/2023 12:55:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21293' 30/06/2023 12:55:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '21293' 30/06/2023 12:55:28 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21293' 30/06/2023 12:55:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21294' , '1' , '' , 'nuovo-prodotto' ) 30/06/2023 12:55:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21294' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21293' 30/06/2023 12:55:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21294' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21293' 30/06/2023 12:56:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '635536' , '2023-06-29' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.24' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.33' , '77.33' , NOW() , NOW() ) 30/06/2023 12:56:05 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 = '86584' 30/06/2023 12:56:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '86584' 30/06/2023 12:56:05 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 ( '86584' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '6' , '6' , '4' , '18.00' , '18' , '0' , '33' , '72.3600' ) 30/06/2023 12:56:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21293' AND id_supplier = '7' 30/06/2023 12:56:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21293' , '7' , '1' ) 30/06/2023 12:56:05 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 ( '86584' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '100' , '0.0000' ) 30/06/2023 12:56:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21293' AND id_supplier = '7' 30/06/2023 12:56:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21293' , '7' , '1' ) 30/06/2023 12:56:05 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 ( '86584' , '21292' , 'PANE QUOTIDIANO SETT/OTT 2023' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 30/06/2023 12:56:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21292' AND id_supplier = '7' 30/06/2023 12:56:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21292' , '7' , '1' ) 30/06/2023 02:55:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241800' AND id_product != '20958' AND ean13 != '' 30/06/2023 02:55:22 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/5', ean13 = '9788892241800', date_upd = NOW() WHERE id_product = '20958' 30/06/2023 02:55:22 pm >> UPDATE ps_product_lang SET name = 'PER MARIA A GESU\' ', description = '' WHERE id_product = '20958' 30/06/2023 02:55:23 pm >> UPDATE ps_product SET wholesale_price = '1.01', on_sale = '0', price = '1.5000' WHERE id_product = '20958' 30/06/2023 02:55:23 pm >> UPDATE ps_product_shop SET wholesale_price = '1.01', price = '1.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20958' 30/06/2023 02:55:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '20958' 30/06/2023 03:38:53 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('2023-06-30') 30/06/2023 03:38: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' , '2258' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 30/06/2023 03:38: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 = '86585' 30/06/2023 03:38:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '86585' 30/06/2023 03:38: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 ( '86585' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/06/2023 03:50:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 30/06/2023 03:50:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.60', price_tax_excluded = '38.60', date_upd = NOW() WHERE id_document = '81317' 30/06/2023 03:50: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 = '81317' 30/06/2023 03:50:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 30/06/2023 03:50: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 ( '81317' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 03:50: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 ( '81317' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 30/06/2023 03:50: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 ( '81317' , '21197' , 'PAROLA E PREGHIERA - SET 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/06/2023 03:50: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 ( '81317' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 03:50: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 ( '81317' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 30/06/2023 03:50: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 ( '81317' , '21192' , 'SULLA TUA PAROLA - SET OTT 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 30/06/2023 03:50: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 ( '81317' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 30/06/2023 06:28:11 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('2023-06-30') 30/06/2023 06:28:11 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' , '2023-06-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.30' , '24.63' , NOW() , NOW() ) 30/06/2023 06:28:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86586' 30/06/2023 06:28:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '86586' 30/06/2023 06:28:11 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 ( '86586' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 30/06/2023 06:28:11 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 ( '86586' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 30/06/2023 07:10:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2023010001291' , '2023-06-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.00' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '58.95' , '58.95' , NOW() , NOW() ) 30/06/2023 07:10:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86587' 30/06/2023 07:10:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '86587' 30/06/2023 07:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86587' , '21181' , 'CAMMINO DI FORMAZIONE - R. COLIZZI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '3.25' ) 30/06/2023 07:10:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21181' AND id_supplier = '107' 30/06/2023 07:10:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21181' , '107' , '1' ) 30/06/2023 07:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86587' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 30/06/2023 07:10:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 30/06/2023 07:10:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 30/06/2023 07:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86587' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 30/06/2023 07:10:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19366' AND id_supplier = '107' 30/06/2023 07:10:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19366' , '107' , '1' ) 30/06/2023 07:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86587' , '16107' , 'VERGINE MADRE, FIGLIA DEL TUO FIGLIO - L. EPICOCO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '35' , '7.80' ) 30/06/2023 07:10:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16107' AND id_supplier = '107' 30/06/2023 07:10:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16107' , '107' , '1' ) 30/06/2023 07:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86587' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '30' , '22.40' ) 30/06/2023 07:10:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 30/06/2023 07:10:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 30/06/2023 07:10:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86587' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '10' , '0' , '4' , '1.0000' , '1' , '0' , '35' , '6.50' ) 30/06/2023 07:10:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '107' 30/06/2023 07:10:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '107' , '1' ) 30/06/2023 07:38:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423601' AND id_product != '5457' AND ean13 != '' 30/06/2023 07:38:09 pm >> UPDATE ps_product SET id_supplier = '53', reference = '4/2', ean13 = '9788886423601', date_upd = NOW() WHERE id_product = '5457' 30/06/2023 07:38:09 pm >> UPDATE ps_product_lang SET name = 'IO SONO CON VOI 1 PARTE', description = '
Il sussidio:
• approfondisce, attraverso domande e frasi da completare, gli argomenti proposti dal catechismo della CEI;
• offre al catechista un aiuto per verificare il lavoro svolto e propone attività per ogni incontro.
Il disegno aiuta a visualizzare l’argomento.
Il sussidio è arricchito da:
•tavole fuori testo che spiegano gli argomenti più importanti;
•cartine dei luoghi in cui si svolgono gli avvenimenti;
•un piccolo dizionario che spiega il significato dei termini meno noti.
Caratteristica principale di questo sussidio è la semplicità e la chiarezza.
' WHERE id_product = '5457' 30/06/2023 07:38:09 pm >> UPDATE ps_product SET wholesale_price = '0.53', on_sale = '0', price = '2.8' WHERE id_product = '5457' 30/06/2023 07:38:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.53', price = '2.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5457' 30/06/2023 07:38:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '5457' 30/06/2023 07:38:09 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' , '5457' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 30/06/2023 07:38:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423618' AND id_product != '5458' AND ean13 != '' 30/06/2023 07:38:15 pm >> UPDATE ps_product SET id_supplier = '53', reference = '4/2', ean13 = '9788886423618', date_upd = NOW() WHERE id_product = '5458' 30/06/2023 07:38:15 pm >> UPDATE ps_product_lang SET name = 'IO SONO CON VOI 2 PARTE', description = 'Il sussidio:
• approfondisce, attraverso domande e frasi da completare, gli argomenti proposti dal catechismo della CEI;
• offre al catechista un aiuto per verificare il lavoro svolto e propone attività per ogni incontro.
Il disegno aiuta a visualizzare l’argomento.
Il sussidio è arricchito da:
•tavole fuori testo che spiegano gli argomenti più importanti;
•cartine dei luoghi in cui si svolgono gli avvenimenti;
•un piccolo dizionario che spiega il significato dei termini meno noti.
Caratteristica principale di questo sussidio è la semplicità e la chiarezza.
' WHERE id_product = '5458' 30/06/2023 07:38:15 pm >> UPDATE ps_product SET wholesale_price = '0.53', on_sale = '0', price = '2.8' WHERE id_product = '5458' 30/06/2023 07:38:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.53', price = '2.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5458' 30/06/2023 07:38:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '5458' 30/06/2023 07:38:16 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' , '5458' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 30/06/2023 07:38:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423625' AND id_product != '11191' AND ean13 != '' 30/06/2023 07:38:29 pm >> UPDATE ps_product SET id_supplier = '115', reference = '4/2', ean13 = '9788886423625', date_upd = NOW() WHERE id_product = '11191' 30/06/2023 07:38:29 pm >> UPDATE ps_product_lang SET name = 'VENITE CON ME 1 PARTE', description = 'Il sussidio:
• approfondisce, attraverso domande e frasi da completare, gli argomenti proposti dal catechismo della CEI;
• offre al catechista un aiuto per verificare il lavoro svolto e propone attività per ogni incontro.
Il disegno aiuta a visualizzare l’argomento.
Il sussidio è arricchito da:
•tavole fuori testo che spiegano gli argomenti più importanti;
•cartine dei luoghi in cui si svolgono gli avvenimenti;
•un piccolo dizionario che spiega il significato dei termini meno noti.
Caratteristica principale di questo sussidio è la semplicità e la chiarezza.
' WHERE id_product = '11191' 30/06/2023 07:38:29 pm >> UPDATE ps_product SET wholesale_price = '0.53', on_sale = '0', price = '2.8' WHERE id_product = '11191' 30/06/2023 07:38:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.53', price = '2.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11191' 30/06/2023 07:38:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '11191' 30/06/2023 07:38:29 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' , '11191' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 30/06/2023 07:38:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423632' AND id_product != '11192' AND ean13 != '' 30/06/2023 07:38:40 pm >> UPDATE ps_product SET id_supplier = '115', reference = '4/2', ean13 = '9788886423632', date_upd = NOW() WHERE id_product = '11192' 30/06/2023 07:38:40 pm >> UPDATE ps_product_lang SET name = 'VENITE CON ME 2 PARTE', description = 'Il sussidio:
• approfondisce, attraverso domande e frasi da completare, gli argomenti proposti dal catechismo della CEI;
• offre al catechista un aiuto per verificare il lavoro svolto e propone attività per ogni incontro.
Il disegno aiuta a visualizzare l’argomento.
Il sussidio è arricchito da:
•tavole fuori testo che spiegano gli argomenti più importanti;
•cartine dei luoghi in cui si svolgono gli avvenimenti;
•un piccolo dizionario che spiega il significato dei termini meno noti.
Caratteristica principale di questo sussidio è la semplicità e la chiarezza.
' WHERE id_product = '11192' 30/06/2023 07:38:40 pm >> UPDATE ps_product SET wholesale_price = '0.53', on_sale = '0', price = '2.8' WHERE id_product = '11192' 30/06/2023 07:38:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.53', price = '2.8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11192' 30/06/2023 07:38:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '11192' 30/06/2023 07:38:40 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' , '11192' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )