MYSQL ERROR : Unknown column 'bpost.isFeatured' in 'field list'
Query : SELECT
SQL_CALC_FOUND_ROWS
bpost.blogID,
bpost.blogKey,
bpost.publishedDate,
bpost.isCommentAllowed,
bpost.isFeatured,
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,
(SELECT GROUP_CONCAT(DISTINCT bCatDet.blogCategoryName 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 categorynames
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) GROUP BY bpost.blogID ORDER BY bpost.blogID DESC LIMIT 0,8
MYSQL ERROR : Unknown column 'bpost.isFeatured' in 'field list'
Query : SELECT
SQL_CALC_FOUND_ROWS
bpost.blogID,
bpost.blogKey,
bpost.publishedDate,
bpost.isCommentAllowed,
bpost.isFeatured,
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,
(SELECT GROUP_CONCAT(DISTINCT bCatDet.blogCategoryName 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 categorynames
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) GROUP BY bpost.blogID ORDER BY bpost.blogID DESC LIMIT 1,8
Loading...
Gold
Diamond
Platinum
Watches
TT Brands
Advance Booking
Gold Schemes__252300642.png)
Try On
.jpg){kind=logo}