classDatabase: rowCount: command: SELECT TOP 1 b.id AS businessid, path, companyname, logo, promo , phone, website , (SELECT COUNT(id) FROM announcements a WHERE a.business=10 AND a.starts <= GETDATE() AND (a.ends >= GETDATE() OR a.ends IS NULL) ) AS anns , CASE WHEN ISNULL(bt.id,0)>0 THEN 1 ELSE 0 END AS businesstop , CASE WHEN ISNULL(bp.id,0)>0 THEN 1 ELSE 0 END AS businessprominent , m.title_en AS location FROM business b INNER JOIN businesscategories c ON b.category=c.id LEFT JOIN businesstop() bt ON bt.id=b.id LEFT JOIN businessprominent() bp ON bp.id=b.id LEFT JOIN qmunicipalities m ON b.location=m.id WHERE b.id=10
Invalid column name 'title_en'.