A Database Error Occurred
Error Number: 1054
Unknown column 'P' in 'where clause'
SELECT c.CommercialId,c.propertyname, c.description,c.IsPastProject ,c.Size,c.Aerial,c.ThumbNail,c.SitePlan,c.Price,c.Map,c.Demography,ss.SubCategoryName FROM commercialland c inner join stc_subcategory ss on c.SubCategoryId = ss.SubCategoryId and IsPastproject=0 and ss.SubCategoryId=1 WHERE c.CommercialId =P and c.IsDeleted=0 and ss.IsDeleted=0