Cod postal | Localitatea | Strada | Judetul |
---|---|---|---|
540478 | Targu Mures | infratirii | Mures |
540479 | Targu Mures | infratirii | Mures |
540558 | Targu Mures | infratirii | Mures |
540559 | Targu Mures | infratirii | Mures |
540560 | Targu Mures | infratirii | Mures |
ro-fr-MS-SELECT postal_code,city,street,county_id,county,street,city FROM ro WHERE (LCASE(county_id)=LCASE('MS')) AND (LCASE(city) LIKE LCASE('%Targu_Mures%')) AND ((LCASE(street) LIKE LCASE('%infratirii%')) OR (street='')) AND 1 ORDER BY city LIMIT 0,16-10