# Query_time: 5 Lock_time: 0 Rows_sent: 4477 Rows_examined: 37504
SELECT (users.id * 9 + 4) AS id, 0 AS id, '' AS authors, '' AS body, 'User' AS class, 4 AS class_id, '' AS comment, '' AS content, countries.name AS country_name, country_translations.name AS country_tname, '' AS dedicated_to, '' AS description, '' AS id_title, location.name AS location_name, location_translations.name AS location_tname, users.login AS login, '' AS name, '' AS stripped_content, '' AS thought_for, '' AS title, users.user_location_name AS user_location_name FROM users LEFT OUTER JOIN locations AS location ON location.id = users.location_id LEFT JOIN ( location_translations ) ON ( users.location_id = location_translations.location_id ) LEFT JOIN ( locations l2,countries ) ON ( users.location_id=l2.id and l2.country_id=countries.id ) LEFT JOIN (locations l3, country_translations) ON (users.location_id=l3.id and l3.country_id=country_translations.country_id ) WHERE users.id >= 5001 AND users.id <= 10000 AND (users.deleted_at is null AND users.activated_at is not null) GROUP BY users.id;
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]