Saludos,,,,
Localiza :
// Comentarios
$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_comments, c.cat_name".get_user_table_field(", u.", "user_name")."
FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id
$cat_match_sql
ORDER BY i.image_comments DESC, i.image_name ASC
LIMIT 10";
cambia a :
// Comentarios
$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_comments, c.cat_name".get_user_table_field(", u.", "user_name")."
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id
$cat_match_sql
ORDER BY i.image_comments DESC, i.image_name ASC
LIMIT 10";
excitex