SELECT t1.*, COUNT(DISTINCTROW(t2.`id`)) clicks, '0' id_editor_edit,COUNT(DISTINCTROW(t3.`id`)) comments, t4.`path` path FROM `dir_links` t1 LEFT JOIN `dir_link_clicks` t2 ON t1.`id` = t2.`id_link` LEFT JOIN `dir_link_comments` t3 ON t1.`id` = t3.`id_link` LEFT JOIN `dir_categories` t4 ON t1.`id_category` = t4.`id` WHERE t1.`status` = 'active' GROUP BY t1.`id` ORDER BY t1.`date` DESC LIMIT 0, 10<br />Table 'links.dir_flat_structure' doesn't exist