i have about 3000 hosts per day and my hosting provider tired with me
they says that this query extremly load mysql server each time that page has been requested. May be a way to simplify this query or completely disable ? source file functions.php.... thanks!
SELECT DISTINCT i.image_id, i.cat_id, i.user_id,
i.image_name, i.image_description, i.image_keywords,
i.image_date, i.image_active, i.image_media_file,
i.image_thumb_file, i.image_download_url,
i.image_allow_comments, i.image_comments,
i.image_downloads, i.image_votes, i.image_rating,
i.image_hits, c.cat_name, u.user_name FROM 4images_images
i, 4images_categories c LEFT JOIN 4images_users u ON
(u.user_id = i.user_id) WHERE i.image_active = 1 AND
i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY
RAND();