SELECTCOUNT(*) FROM (SELECTp.id,p.title,p.cover,p.text,p.url,p.published,p.date,c.idAScategory_id,c.nameAScategory_name,a.urlASauthor_url,a.nameASauthor_name,a.avatarASauthor_avatar, (SELECTCOUNT(m.id) FROMblog_post_commentsmWHEREm.post_id=p.id) AScomments_countFROMblog_postspINNER JOINblog_categoriescONp.category_id=c.idINNER JOINblog_authorsaONp.author_id=a.idWHERE (a.id=?) AND (p.published=?) ORDER BYdatedesc) tmp
SELECTCOUNT(*)
FROM
(
SELECTp.id,p.title,p.cover,p.text,p.url,p.published,p.date,c.idAScategory_id,c.nameAScategory_name,a.urlASauthor_url,a.nameASauthor_name,a.avatarASauthor_avatar,
(
SELECTCOUNT(m.id)
FROMblog_post_commentsmWHEREm.post_id=p.id
) AScomments_countFROMblog_postspINNER JOINblog_categoriescONp.category_id=c.idINNER JOINblog_authorsaONp.author_id=a.idWHERE
(a.id=?)
AND (p.published=?)
ORDER BYdatedesc
) tmp
SELECTCOUNT(*) FROM (SELECTp.id,p.title,p.cover,p.text,p.url,p.published,p.date,c.idAScategory_id,c.nameAScategory_name,a.urlASauthor_url,a.nameASauthor_name,a.avatarASauthor_avatar, (SELECTCOUNT(m.id) FROMblog_post_commentsmWHEREm.post_id=p.id) AScomments_countFROMblog_postspINNER JOINblog_categoriescONp.category_id=c.idINNER JOINblog_authorsaONp.author_id=a.idWHERE (a.id=3) AND (p.published=1) ORDER BYdatedesc) tmp;