SELECT * FROM types  ;

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

SELECT a.*, l.location, l.country FROM areas AS a  LEFT JOIN locations AS l ON l.id = a.location  WHERE 1  AND a.`` = '' LIMIT 1;

SELECT c.*
                FROM reported_demo.comments c
                JOIN (
                    SELECT number, MAX(id) AS max_id
                    FROM reported_demo.comments
                    WHERE number LIKE '516%'
                    GROUP BY number
                ) max_ids
                ON c.number = max_ids.number AND c.id = max_ids.max_id
                ORDER BY c.id DESC LIMIT 50 OFFSET 50

SELECT COUNT(DISTINCT number) AS total FROM reported_demo.comments WHERE number LIKE '516%'