select * from cars_listings, cars_agents, cars_priority, cars_vehicle where cars_listings.AgentID = cars_agents.AgentID and cars_agents.PriorityLevel = cars_priority.PriorityLevel and (cars_agents.AccountStatus = 'active' OR cars_agents.AccountStatus = 'dormant') and cars_listings.VehicleMake = cars_vehicle.VehicleID and cars_listings.CategoryID = '2.' order by cars_agents.PriorityLevel desc, cars_listings.DateAdded desc limit 0, 20