MYSQL ERROR : Undeclared variable: 20rows
Query : SELECT SQL_CALC_FOUND_ROWS bpost.blogID, bpost.blogKey, bpost.publishedDate, bpost.isCommentAllowed, bpostDet.blogTitle, CONCAT(usr.adminUserFirstName,' ',usr.adminUserLastName) AS fullName, (SELECT COUNT(DISTINCT bCom.blogCommentID) FROM dp_blog_comments AS bCom WHERE (bpost.blogID = bCom.blogID AND bCom.commentStatus = 'Active') ) AS commentCount, (SELECT GROUP_CONCAT(DISTINCT bCatDet.blogCategoryID SEPARATOR ',') FROM dp_blog_to_category as bToCat LEFT JOIN dp_blog_categories as bCat ON ( bToCat.blogCategoryID=bCat.blogCategoryID AND bCat.blogCategoryStatus = 'Active') LEFT JOIN dp_blog_category_details as bCatDet ON (bCat.blogCategoryID=bCatDet.blogCategoryID AND bCatDet.languageID='1') WHERE (bpost.blogID=bToCat.blogID) GROUP BY bToCat.blogID) AS categoryIDs, (SELECT GROUP_CONCAT(DISTINCT tToPost.blogTagID SEPARATOR ',') FROM dp_blog_tag_to_post as tToPost LEFT JOIN dp_blog_tags as bTag ON tToPost.blogTagID=bTag.blogTagID AND bTag.blogTagStatus = 'Active' LEFT JOIN dp_blog_tag_details as bTagDet ON bTag.blogTagID=bTagDet.blogTagID AND bTagDet.languageID='1' WHERE (bpost.blogID=tToPost.blogID) ) AS tagNames, bpostDet.blogContent, bpostDet.blogImage FROM dp_blog_posts AS bpost INNER JOIN dp_blog_post_details AS bpostDet ON (bpost.blogID = bpostDet.blogID) AND bpostDet.languageID IN (0,1) LEFT JOIN dp_admin_users as usr ON (usr.adminUserID=bpost.createdBy) LEFT JOIN dp_blog_to_category as bToCat ON (bpost.blogID=bToCat.blogID) LEFT JOIN dp_blog_categories as bCat ON (bToCat.blogCategoryID=bCat.blogCategoryID AND bCat.blogCategoryStatus = 'Active') LEFT JOIN dp_blog_category_details as bCatDet ON (bCat.blogCategoryID=bCatDet.blogCategoryID AND bCatDet.languageID='1') LEFT JOIN dp_blog_tag_to_post as tToPost ON (bpost.blogID=tToPost.blogID) LEFT JOIN dp_blog_tags as bTag ON (tToPost.blogTagID=bTag.blogTagID AND bTag.blogTagStatus = 'Active') LEFT JOIN dp_blog_tag_details as bTagDet ON (bTag.blogTagID=bTagDet.blogTagID AND bTagDet.languageID='1' ) WHERE bpost.blogStatus = 'publish' AND (FIND_IN_SET('0',bpost.viewedBy ) OR bpost.viewedBy ='' OR bpost.viewedBy IS NULL) AND bToCat.blogCategoryID IN (3,4,2,5,6,7) GROUP BY bpost.blogID ORDER BY bpost.publishedDate DESC LIMIT 0,20rows

Self-help and basic troubleshooting inputs on QZ products
Loading...
CATEGORY : QZ product help pages
Self-help and basic troubleshooting inputs on QZ products
No Records Found