Notice: Error: Out of resources when opening file '/tmp/#sql_3da8_0.MYI' (Errcode: 24)
Error No: 23
SELECT DISTINCT l.*, ld.* ,lm.image_data,(SELECT AVG(rating) AS total FROM ebr_review r1 WHERE r1.link_id = l.link_id AND r1.status = '1' GROUP BY r1.link_id) AS rating,(SELECT SUM(votes) AS total FROM ebr_review r1 WHERE r1.link_id = l.link_id AND r1.status = '1' GROUP BY r1.link_id) AS votes,(SELECT COUNT(*) AS total FROM ebr_review r2 WHERE r2.link_id = l.link_id AND r2.status = '1' GROUP BY r2.link_id) AS reviews, l.sort_order FROM ebr_link l LEFT JOIN ebr_link_description ld ON (l.link_id = ld.link_id) LEFT JOIN ebr_link_image lm ON (l.link_id = lm.link_id) WHERE l.link_id = '2332' AND ld.language_id = '1' AND l.status = '1' in /home/sift2sit/public_html/system/database/mysql.php on line 49