SELECT b.*,u.user_picture,u.user_level,u.pid as uid from mb_photos_english b LEFT OUTER JOIN mb_users u ON b.user_pid=u.pid WHERE b.image_path != '' AND b.is_secret = '0' ORDER BY b.gid desc,b.reply asc limit 0, 9