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`.`interestid` LIKE ?)) group by p.postid
ORDER BY p.postid DESC
Unknown column 'p.interestid' in 'where clause'