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