All Apartments for rent in Odessa Ukraine

SELECT a.id, a.name, price_day, bedrooms, location, floor, h_water, tv, phone_s, wash, balcon, days_navail, month_rent, conditioner, description, map1, map2, c.name AS category, month_sw FROM apartment a LEFT JOIN apt_category c ON id_apt_category=c.id WHERE a.id_apt_category=1 AND available=1 ORDER BY a.bedrooms, a.price_day Limit 75,-1