select profile.id, profile.status, unix_timestamp(new_date) as unix_new, profile.name as profile_name, profile.img_path, profile.short_name, profile.summary_eng, profile.username, profile.address, profile.zip, zip_city.city, profile.lat, profile.lng, keyword.name_eng, profile_type.type_id, profile.xpon_card from profile left join (profile_type) on (profile.id=profile_type.profile_id ) left join (type) on (profile_type.type_id=type.id) left join (profile_keyword) on (profile.id=profile_keyword.profile_id) left join (keyword) on (profile_keyword.keyword_id=keyword.id) left join (zip_city) on (profile.zip=zip_city.zip) left outer join (profile_other) on (profile_other.profile_id=profile.id) left outer join (other) on (profile_other.other_id=other.id) left join (profile_district) on (profile_district.profile_id=profile.id) left join (district) on (profile_district.district_id=district.id) where trim(description_eng)!="" and profile.status ="full" and (lower(keyword.name_eng) = lower("steaks")) and ((profile.zip>=1000 and profile.zip<=2999) or (profile.zip>=3700 and profile.zip<=3799)) group by profile.id

Steaks