1054. Query Error 1054: Unknown column 'type' in 'where clause' Query: SELECT p.*, r.sort FROM shop_promo AS p JOIN shop_promo_routes AS r ON p.id=r.promo_id WHERE r.storefront IN ('robottpd.ru/','robottpd.ru') AND type='link' AND p.enabled > 0 ORDER BY r.sort, p.id