SELECTu.idASuser_id,u.nicknameASuser_nickname,u.avatarASuser_avatar,u.photos_dir_numASuser_photos_dir_num,TRIM(CONCAT(u.name_first,' ',u.name_last)) ASuser_name,c.text,c.reply_to,p.titleASpost_title,p.urlASpost_urlFROMblog_post_commentscINNER JOINuser_usersuONc.author_id=u.idINNER JOINblog_postspONc.post_id=p.idWHERE (c.approved=1) AND (u.name_first<>'') ORDER BYc.iddescLIMIT9
SELECTu.idASuser_id,u.nicknameASuser_nickname,u.avatarASuser_avatar,u.photos_dir_numASuser_photos_dir_num,TRIM(
CONCAT(u.name_first,' ',u.name_last)
) ASuser_name,c.text,c.reply_to,p.titleASpost_title,p.urlASpost_urlFROMblog_post_commentscINNER JOINuser_usersuONc.author_id=u.idINNER JOINblog_postspONc.post_id=p.idWHERE
(c.approved=1)
AND (u.name_first<>'')
ORDER BYc.iddescLIMIT9
SELECTu.idASuser_id,u.nicknameASuser_nickname,u.avatarASuser_avatar,u.photos_dir_numASuser_photos_dir_num,TRIM(CONCAT(u.name_first,' ',u.name_last)) ASuser_name,c.text,c.reply_to,p.titleASpost_title,p.urlASpost_urlFROMblog_post_commentscINNER JOINuser_usersuONc.author_id=u.idINNER JOINblog_postspONc.post_id=p.idWHERE (c.approved=1) AND (u.name_first<>'') ORDER BYc.iddescLIMIT9;