Error Number: 1054

Unknown column 'hu_price' in 'field list'

SELECT product.`name_hu`, product.`url_hu`, `idproduct`, product.`desc_hu`, product.`img`, product.`catalog_no`, `producers_idproducers`, producers.url as pUrl, producers.name as pName FROM `product` JOIN producers ON idproducers = producers_idproducers JOIN ( SELECT min(hu_price), product_idproduct FROM species JOIN `prices` AS `pric` ON `species`.`idspecies` = `pric`.`species_idspecies` WHERE hu_price <> '0' GROUP BY `product_idproduct` ) AS `spec` ON `product`.`idproduct` = `spec`.`product_idproduct` WHERE `product`.`visible_hu` = 1 AND producers.visible_hu = 1 AND `product`.`producers_idproducers` != "NULL" AND ( `category_idcategory_hu` = 1571 ) GROUP BY `product`.`idproduct` ORDER BY `product`.`sell_hu` ASC, `spec`.`min(hu_price)` ASC LIMIT 0 , 16

Filename: /data/www/client1/web1/web/models/categories_frontend.php

Line Number: 680