SELECT a.*, c.name as country_name, l.name as location_name, l.short_name as location_short FROM area AS a  LEFT JOIN countries AS c ON c.id = a.country LEFT JOIN locations AS l ON l.id = a.location  WHERE 1  AND a.`` = '' AND a.`` = '' LIMIT 1;

SELECT p.*, r.name as rate_center_name, c.name as company_name FROM prefix AS p  LEFT JOIN companies AS c ON c.id = p.company LEFT JOIN rate_centers AS r ON r.id = p.rate_center  WHERE 1  AND p.`` = '' AND p.`` = '' AND p.`` = '' LIMIT 1;

SELECT * FROM ranges   WHERE 1  AND `` = '' AND `` = '' AND `` = '' LIMIT 1;