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 companies AS p WHERE 1 AND `` IS NULL LIMIT 1;
SELECT * FROM rate_centers AS p WHERE 1 AND `` IS NULL LIMIT 1;