SELECT name, short_name FROM oc_poi
 WHERE short_name IN ('EL7468','SA7470','SA7473','EL7480','EL7488','CO7523','EL7530','CO7545','EL7579','EL7602','EL15124','EL15125','EL15126','EL15127','SA7620','SA7627','EL7628','EL7648','SA7669','SA7670','EL8515','CO8950','CO8952','CO8953','SA15756','SA15757','SA15758','SA15759','SA15760','CO8954','CO8955','CO8957','CO8958','CO8959','CO8960','CO8961','CO8962','EL5429','EL8500','EL8502','EL8504','EL15144','EL15152','EL15085','OPL002','OPL001','7','SA9404','EL5617','SA9401','EL4562','EL9005','EL9012','EL6619','EL6655','CO7415','EL7422','EL7423','SA7444','SA7445','EL7462','SA4542','EL4093','EL14130','EL14157','EL8519','EL8520','EL8521','EL8523','EL8524','EL8525','EL8526','EL8527','EL8528','EL8529','EL8530','SA14493','EL14166','EL14132','EL14100','EL6443','EL8541','SA7409','EL6368','CO6574','EL5668','EL14066','SA15761','SA15762','SA15763','SA15764','PELLET','SA15765','SA15766','SA15767','SA15768','EL8531','EL8532','EL8534','EL8535','EL8536','EL8537','EL8538','EL8539','EL8540','SA8750','SA8751','SA8752','SA15769','SA15770','SA15771','SA15772','SA8753','SA8754','SA8755','SA8756','SA8757','SA8758','SA8759','SA8760','SA8761','SA8762','SA8763','SA4489','SA4564','SA15773','SA8764','SA8765','SA8766','SA8767','SA8768','SA8769','EL7310','EL6575','5','EL5635','7310','SA15774','SA15775','SA15776','SA15777','CO9800','SA9412','EL9018','CO9801','EL9007','SA9402','EL7412','EL6577','SA6530','CO6534','SA15778','SA15779','SA15780','SA15781','SA15782','EL8506','EL8507','EL8508','EL8509','EL8510','EL8511','EL8512','EL8513','EL8514','EL8516','EL8517','EL8518','CO14882','EL15014','EL15090','EL9052','EL9076','EL9078','SA9442','SA9429','EL4766','EL9059','EL5424','SA9443','EL9065','EL9032','SA9426','EL9079','SA9444','EL9082','EL9020','EL9092','CO9804','SA14525','SA14558','SA15033','SA15783','EL15057','1','SA13464','EL14150','EL15067','SA14598','2','4','6','SA15413','EL5349','EL8955','EL9046','EL9047','EL5628','SA4420','SA14568','EL14095','SA4454','EL9050','SA9415','CO6505','CO9802','EL8961','EL8950','EL7571','EL9006','EL9060','SA9803','TESTAAL','EL6302','EL9064','EL8962','EL9051','EL2954','EL9034','EL4776','SA7652','SA7395','CO14864','CO14881','SA4447','EL14178','EL14081','SA9455','EL5313','EL9111','SA9438','EL6405','EL9075','EL9053','EL9048','EL5535','SA9458','EL9110','SA0400','CO0801','SA9469;ECOLE DE WIHERIES - DOUR;"Trou à calloux" 7370          WHIERIES;;08/01/10;29/04/11;LBO,,,,,','EL0015','EL0010','EL9135','SA0403','SA14544','SA14524','EL15040','SA0406','EL0024','CO0802','EL9182','EL0034','SA0409','EL0036','SA0410','EL0039','SA8961','SA8962','EL9026','SA9459','SA9470','EL9109','EL9141','SA9467','EL9083','EL9140','SA9457','EL9043','EL9021','EL9156','SA9416','EL9119','EL9162','SA9407','CO9809','EL9204','CO9810','SA9417','CO9811','SA9484','EL9228','SA9418','EL3182','SA4407','SA4444','SA4531','EL9187','EL1780','EL4751','EL9055','SA9527','SA9491','SA9530','CO9813','SA14578','EL14099','SA14575','SA14501','CO9805','CO9806','CO9807','CO9808','SA9447','SA9454','EL7496','EL7594','SA5512','EL9106','EL14094','SA14511','EL14170','EL14143','EL15050','EL9227','EL9225','CO0808','EL0122','EL0077','SA0462','SA0444','CO0814','SA0487','CO0818','SA0427','SA0440','SA0425','EL0140','EL0148','SA0431','EL0065','EL0151','EL0075','EL9160','CO0819','EL0040','EL0042','SA9473','EL0043','EL9195','EL9030','EL0054','EL9240','EL9202','EL0022','CO0803','SA9520','SA0423','EL0073','SA9445','EL0019','SA0416','EL9245','SA0404','EL8958','EL9151','SA0456','SA0460','SA0461','CO0806','SA0424','EL0057','CO0805','SA0468','CO0804','CO9814','CO0807','EL0105','EL0107','EL0068','EL0108','EL0110','SA9800','EL0087','EL0101','EL9001','SA9504','EL0116','EL9264','SA0401','EL0118','EL0066','SA0524','EL0200','SA0457','EL0195','EL0193','SA0480','EL0178','CO0823','EL0214','EL9800','CO1817','CO1818','CO1819','CO1820','CO1821','EL0213','SA1476','EL0208','EL0174','SA0507','EL0185','EL0112','SA9505','SA1417','EL9209','SA1479','SA0484','TESTMDO','SA0525','SA0546','EL1019','EL1016','SA1402','EL1104','SA1435','SA0549','CO1825','CO1826','CO1827','EL1105','EL1151','EL1122','EL1001','EL1002','EL1003','EL1004','EL1005','SA1401','SA1403','CO1801','CO1802','EL0067','EL0138','SA9465','EL0196','EL0046','EL1010','SA1442','EL1039','EL0162','SA1418','EL1041','SA1453','CO1808','EL1055','SA0491','EL1060','CO1815','CO1816','CO0820','SA0510','EL0159','SA0513','EL0099','CO0821','EL0146','EL0061','EL0139','CO0822','EL1207','CO1804','EL1047','EL2021','EL2022','EL2024','EL2010','CO2804','CO2805','EL1147','EL1224','EL1206','EL1223','EL2028','EL2027','SA2428','CO2806','EL2038','EL2039','CO1810','CO1811','CO1812','CO1813','CO1814','EL1090','EL1097','SA1504','EL1046','EL1054','CO1828','EL1059','SA1461','CO1829','EL1108','EL1045','EL9153','SA9486','EL1048','EL1102','SA1477','SA0411','SA0407','EL0001','EL0177','EL0181','CO0815','EL0188','EL0189','EL0187','EL1106','EL1082','EL1067','CO1830','SA1513','CO1831','EL1174','SA1518','SA1522','SA1576','SA1569','CO1835','EL1179','EL1181','SA1498','EL2011','EL2014','EL2023','CO3822','CO3829','CO3811','CO3820','EL3197','CO3845','CO1805','SA2458','EL2079','SA2447','SA2471','EL2103','EL2102','SA2421','SA1533','EL2088','SA3443','CO3821','SA3523','CO3836','EL3024','SA3492','SA2441','EL2068','SA2454','EL1182','SA2464','EL2124','EL2087','EL2816','EL2134','EL3011','SA3502','EL3507','EL4053','CO2809','EL2012','SA2411','SA2412','EL2016','SA2417','SA2418','SA2422','EL2043','EL2044','SA4470','SA4438','SA4476','SA4479','EL2041','EL2035','EL2049','CLARK EL','SA2450','SA2429','SA1507','SA1502','CO2817','CO2818','HARNAIS','CO2816','EL1096','SA2459','SA2423','CO2822','3','EL2109','EL2114','EL3123','CO3830','SA3526','CO3837','CO3838','EL3179','EL3219','EL2052','EL2075','EL2097','EL2107','EL2112','EL2121','CO2825','CO2826','CO2827','CO2828','EL2020','EL2047','EL2048','EL2050','EL2051','EL2053','CO2815','EL2073','EL2083','CO2824','CO4817','CO4818','CO2811','CO2812','CO2813','EL2070','EL2071','CO2814','EL2077','SA2470','EL2122','SA2415','SA2555','EL2166','EL2130','CO2837','CO2838','CO2839','CO2840','CO2841','SOT','EL2143','EL2156','SA2453','SA2512','EL2167','EL2113','EL2158','SA2158','SA2473','EL2165','SA2816','CO2834','EL2175','SA2175','EL2180','SA2180','SA2499','EL2182','CO2836','SA2549','CO2831','EL2101','EL2179','CO2842','CO2830','EL2065','EL2151','EL2153','SA2153','SA2510','CO2833','EL2200','SA2506','SA2516','SA2154','EL2154','CO9850','EL9850','SA9850','EL2190','EL2219','SA2486','SA2440','SA2495','SA2496','EL2138','EL2139','EL2142','EL2146','EL2132','EL2149','EL4012','CO14869','EL13057','CO14880','EL14171','SA2561','EL2145','EL2237','SA3415','CO2850','EL2217','SA2504','EL3079','EL3084','EL2196','CO3839','EL4122','EL15023','TEST150424','CO14863','EL2238','CO3804','SA3429','EL3075','EL3064','EL3065','CO3808','CO3810','CO3815','SA3453','EL15012','EL2233','EL2216','EL3052','SA2541','CO3814','EL2161','EL3094','EL15088','EL15011','EL15105','EL2225','EL3043','EL3044','EL3048','CO3806','CO3801','EL3067','EL2162','CO3816','CO3817','CO4836','EL14195','SA14569','SA4449','SA14455','EL2228','EL2152','CO3805','EL3081','CO3818','SA2478','SA4492','SA4487','CO4835','CO3848','SA3417','EL3063','EL4118','EL4086','SA4494','CO4853','EL3010','EL3073','SA14635','SA14557','SA15401','SA15750','SA15751','SA2493','CO2843','SA2534','CO2845','CO2846','SA3418','EL3045','SA2487','CO3807','SA15753','SA15752','SA15754','SA15755','SA2456','EL2140','EL3110','EL3161','SA3535','EL3176','SA3507','EL4050','CO4819','CO4820','CO4821','CO4822','CO4823','CO4824','SA4816','EL4067','SA4472','SA4473','EL3040','EL3033','EL3025','SA2452','CO3834','EL3119','EL3181','SA3455','EL3190','EL3085','CO4827','CO4828','EL4068','CO4831','EL4070','SA4474','EL4069','SA4475','EL15106','SA15467','EL15095','EL15154','EL15122','EL15145','EL16045','EL16048','EL16049','EL4105','SA4516','SA14510','EL15009','SA4506','SA14590','CO14874','EL15158','SA16419','SA15463','SA15785','SA4408','EL4091','SA14508','CO14866','SA14534','EL15072','EL15037','SA14404','CO14868','SA15433','SA15507','EL15113','SA4496','SA4459','EL4096','SA14565','SA14582','SA14581','SA14580','CO14875','SA14535','CO14893','SA14548','SA3576','SA4411','EL4026','EL4033','SA4471','8','EL16081','SA2557','CO3828','SA4440','CO4804','CO4806','CO4808','CO4810','CO4814','CO4815','SA15423','SA15458','EL16060','SA3481','EL15043','SA14513','EL15059','SA4481','SA4461','EL4128','EL4135','SA15606','SA14611','SA14551','CO14871','SA3509','EL3149','SA3510','EL3147','CO3833','EL3056','SA3437','SA3573','SA15007','EL15141','FG14590','EL3121','EL3032','SA3511','EL4035','SA4430','EL4036','EL4013','SA4431','EL4031','EL4037','SA4499','SA4452','EL15060','EL15006','SA15035','CO4048','EL15162','EL16040','EL15147','SA3468','SA2568','EL4045','SA4432','SA4434','EL4038','EL4039','EL4041','SA4435','SA4437','SA15784','EL15083','EL15135','CO4849','EL4075','SA14575-P2','SA15508','SA4436','SA4418','SA4416','SA4417','CO4816','EL4022','EL4029','EL4025','SA3570','CO4805','CO4833','CO3819','CO3835','CO3841','SA3471','EL3104','SA3499','SA2540','SA3531','SA3532','SA3536','EL3187','CO3843','SA3558','CO3825','EL3212','SA3565','SA3482','SA3524','EL3216','EL3218','EL4040','CO3850','EL4044','EL3133','SA2514','EL4043','SA4458','EL4046','EL4048','SA4048','SA4429','SA4451','EL4042','EL3164','EL4051')
 AND oc_poi_status_id = 0
 GROUP BY name, short_name
 HAVING COUNT(short_name) > 1;
 --no matches

 SELECT name, short_name FROM oc_poi
 WHERE short_name IN ('EL4052','CO4801','EL4073','CO17930','EL17134','EL17214','EL18040','EL18024','SA18444','EL18058','EL18047','EL18050','SA18449','EL18034','SA18415','SA18438','EL18038','EL18072','EL18097','EL18100','CO18942','EL18011','EL18073','EL18089','EL18061','EL17094','SA18457','EL18039','SA18437','CO18949','EL18138','CO18950','CO18951','EL18091','CO19922','SA19414','CO18945','EL18146','SA18554','EL19016','EL17169','SA17489','EL17182','EL19018','SA19406','EL18099','SA18476','EL18085','EL18141','EL18118','EL19050','SA19440','EL18080','EL19049','CO19927','EL19060','EL19166','CO19902','EL18020','CO18936','EL18075','CO19923','EL18139','EL18076','SA18505','EL19040','SA19460','CO19905','CO19906','SA18506','EL18062','SA18452','CO18948','SA18508','EL18092','EL19160','EL19167','EL19168','SA19435','SA16474','EL17057','EL17081','EL17082','EL17147','SA17563','EL17058','EL17059','EL17062','EL17064','EL19070','CO19907','EL19022','CO19140','CO16905','EL16069','EL16072','EL17159','EL19056','EL17060','EL17091','EL18027','SA17400','BUDGET','CO16910','EL16128','SA17446','SA17421','SA17487','SA14524-2','SA16554','EL17055','EL16137','EL17166','EL17183','EL16131','EL17025','EL17042','EL17043','EL17044','EL17045','EL17046','EL17029','EL17033','0007CO','0007SA','0007EL','SA14524DEC','SA14525DEC','SA16510','CO17931','EL16152','EL17087','EL17179','EL17218','EL16120','SA16503','EL17086','CO17951','EL17154','EL17155','EL15143','EL16098','EL15156','SA16750','EL16141','EL16162','EL16153','EL17040','EL16090','SA15545','EL16057','EL16157','EL16177','EL16178','EL16179','EL17035','SA15476','SA15786','EL16080','SA15787','BUDGETEL','BUDGETSA','BUDGETCO','EL16095','SA16518','EL15111','EL16006','EL16082','SA16500','EL16125','EL16111','EL16116','EL16150','EL16151','EL16156','EL16169','EL17028','EL17031','EL17030','EL16108','SA16515','EL16181','EL16076','EL17039','EL17026','EL17027','EL16119','EL16133','EL16174','EL16175','EL16176','EL16180','SA17447','EL17150','SA17120','EL17032','EL17034','EL17038','EL17056','EL17065','EL17067','EL17066','EL17079','EL16163','EL16170','EL16171','EL16172','EL16173','EL17036','EL17047','EL16085','EL16046','CO16936','EL16143','CO18941','EL17048','EL17049','SA17432','EL17117','EL17185','EL17130','SA17486','SA17544','EL17152','EL17080','EL17099','SA17551','EL17017','EL17111','CO17918','SA17482','EL17128','EL17024','SA17428','EL17050','EL17051','EL17054','EL17083','EL17084','EL17085','SA17433','SA17550','EL17071','EL17072','SA17444','SA17448','EL17104','EL17098','SA17507','CO17938','EL18166','EL18023','EL18025','EL17160','EL17122','EL17162','EL17181','CO17922','CO17910','SA19443','SA16551','EL16145','EL17089','SA15545BIS','EL17068','EL17124','EL17121','EL17203','EL17105','EL17041','SA17480','EL17119','EL17120','EL17106','EL17138','EL16164','EL17100','EL17217','EL17176','CO18912','EL18051','CO17940','CO18923','EL18014','EL18015','EL17910','CO18904','EL16217','EL17143','EL18052','SA17517','EL17190','CO17447','EL17202','EL18060','CO18913','EL18032','EL19017','CO19910','CO19936','EL20060','SA20407','SA20408','SA20403','CO19930','CO19921','SA20700','SA20701','SA20702','SA20703','SA20704','SA20705','SA20706','SA20707','EL19077','CO20900','CO19901','EL19088','SA19452','SA19466','CO19935','EL19109','EL20040','CO20905','SA20708','SA20709','SA20710','SA20711','SA20712','SA20713','SA20714','SA20715','EL20070','SA19468','EL19096','EL19103','EL19075','EL19067','EL20069','SA19444','SA19458','SA20716','SA20717','SA20718','SA20719','SA20720','A20721','SA20722','SA20723','SA19465','SA20724','SA20725','SA20726','SA20727','SA20728','SA20729','SA20730','EL20018','EL20055','EL19101','SA20731','EL20062','EL19062','SA20406','EL20044','EL20064','SA19457','EL20074','EL19097')
 AND oc_poi_status_id = 0
 GROUP BY name, short_name
 HAVING COUNT(short_name) > 1;
 --2 matches