SELECT DISTINCT
rs.id_rs,
rs.miasto,
cena_od,
cat.menus_name,
rs.transakcja,
rs.dzielnica,
rs.pokoje,
rs.ulica,
powierzchnia_od, bez_prowizji, pokoje
FROM pfx_real_estate rs,pfx_real_estate_lang rsl, pfx_rs_category_lang cat
WHERE
rs.active = "1" AND rs.id_rs = rsl.id_rs AND cat.idm = rs.typ AND transakcja IN (1,2) AND typ = "1" AND is_international="0"
ORDER BY id_rs desc