Cod postal | Localitatea | Strada | Judetul |
---|---|---|---|
520090 | Sfantu Gheorghe | Lacramioarei | Covasna |
520090 | Sfantu Gheorghe | Puskas Tivadar | Covasna |
520092 | Sfantu Gheorghe | Epresteto | Covasna |
520092 | Sfantu Gheorghe | Pap Lehel | Covasna |
ro-fr-CV-SELECT postal_code,city,street,county_id,county,street,city FROM ro WHERE (LCASE(county_id)=LCASE('CV')) AND (LCASE(city) LIKE LCASE('%Sfantu_Gheorghe%')) AND 1 ORDER BY city LIMIT 255,16-x9