classDatabase: rowCount: command: SELECT TOP 1 p.id AS pid, p.name_en, p.code, p.name_url, p.category , p.price AS price, p.oldprice , p.discount , p.stock, p.photo, p.photos, p.text_en AS txt, p.availablefrom, p.availablein, specs_en , c.category_en AS catname, c.category_url AS catPath, b.brand_en AS brandName , av.value_en AS availability , CASE WHEN MONTH(p.starts)=MONTH(p.ends) THEN CAST(DAY(p.starts) AS nvarchar(2)) + ' - ' + CONVERT(nvarchar, p.ends, 103) ELSE CAST(DAY(p.starts) AS nvarchar(2)) + '/' + CAST(MONTH(p.starts) AS nvarchar(2)) + ' - ' + CONVERT(nvarchar, p.ends, 103) END + ' ΩΡΑ ' + p.hours AS strWhen , p.starts, p.ends, p.hours, p.webinar, p.location_en AS location , CASE WHEN itemtype='1' THEN 1 ELSE 0 END AS isSeminar FROM products p INNER JOIN categories c ON p.category=c.id LEFT JOIN brands b ON p.brand=b.id LEFT JOIN qavailability av ON p.availablein=av.id WHERE p.visible=1 AND (p.price>0 OR p.availablein=90) AND p.id=78 AND (itemtype<>'1' OR p.starts >= GETDATE())
Invalid column name 'location_en'.