MySQL error Unknown column 'designeroom.hu' in 'where clause'
Query:
SELECT SQL_CALC_FOUND_ROWS products.id, products_properties.name as name, products_properties.description as description, products_properties.stock as stock, (SELECT name FROM products_properties WHERE products_id = products.id AND languages_id = 1) AS name FROM `products` inner JOIN products_properties ON products_properties.products_id = products.id WHERE products.id IN (SELECT products_id FROM products_categories WHERE categories_id = designeroom.hu) AND products.sites_id = '27' AND products.status = 'active' AND products.parent_version = '0' ORDER BY name asc LIMIT 0, 10 #0 /data/domains/designeroom.hu/web/webroot/core/module/moduledao.php(109): core\DB->getAll('SELECT SQL_CALC...') #1 /data/domains/designeroom.hu/web/webroot/project/webshop/controller/category.php(718): core\module\ModuleDAO->get(Object(core\util\filter\FilterSet), Array, 1, 10, 'products.id, pr...', NULL, Array, NULL) #2 /data/domains/designeroom.hu/web/webroot/project/webshop/controller/category.php(347): project\webshop\controller\Category::showNew('designeroom.hu', 'js') #3 /data/domains/designeroom.hu/web/webroot/core/hbfw.php(195): project\webshop\controller\Category->show('designeroom.hu', 'js', 'daliheader.js') #4 /data/domains/designeroom.hu/web/webroot/project/webshop/www/index.php(20): require_once('/data/domains/d...') #5 {main}