SELECT p.*,jlsp.post_sub_types, lds.product_service, lp.post_type as posttype,d.logo_img,d.businessname,d.firstname,d.lastname,d.membership_type,p.postid,p.displaylevel,p.featured
FROM tbl_posts p
left join list_post_type lp on lp.id = p.post_type
Join tbl_directorylistings d on d.id= p.customerid 
left join join_posts_sub_types jp on jp.post_id=p.postid
left join list_post_type jlsp on jp.product_id=jlsp.id
left join list_dl_prod_service lds on jp.product_id=lds.id
where  p.displaylevel ='Public'
AND (p.eventdate >= CURDATE() OR p.eventdate IS NULL)
 AND ((`p`.`featuredAdmin` LIKE ?))  group by p.postid
ORDER BY p.postid DESC<BR><BR>Unknown column 'p.featuredAdmin' in 'where clause'