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` = 1362 OR `category_idcategory_hu` = 1372 OR `category_idcategory_hu` = 1373 OR `category_idcategory_hu` = 1363 OR `category_idcategory_hu` = 1364 OR `category_idcategory_hu` = 1365 OR `category_idcategory_hu` = 1366 OR `category_idcategory_hu` = 1367 OR `category_idcategory_hu` = 1368 OR `category_idcategory_hu` = 1369 OR `category_idcategory_hu` = 1370 OR `category_idcategory_hu` = 1371 OR `category_idcategory_hu` = 1374 OR `category_idcategory_hu` = 1375 OR `category_idcategory_hu` = 1376 OR `category_idcategory_hu` = 1377 OR `category_idcategory_hu` = 1378 OR `category_idcategory_hu` = 1379 OR `category_idcategory_hu` = 1380 OR `category_idcategory_hu` = 1381 OR `category_idcategory_hu` = 1382 OR `category_idcategory_hu` = 1383 OR `category_idcategory_hu` = 1351 ) 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