classDatabase: rowCount: command: SELECT p.id, p.code, p.name_en AS title, p.description_en AS description, p.availablein , '/en/' + name_url AS path, c.parent AS catparent, c.series AS catseries , p.oldprice, p.price , p.discount , p.stock , p.photo, c.category_en AS catname, c.id AS catid , 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 WHERE p.visible=1 AND c.visible=1 AND (itemtype<>'1' OR starts>=GETDATE()) AND ( p.category IN (1) OR p.categoryb IN (1) ) AND (p.stock>0 OR p.ignorestock=1) AND (p.price>0 OR p.availablein=90)
Invalid column name 'location_en'.