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` = 1211 OR `category_idcategory_hu` = 1411 OR `category_idcategory_hu` = 1440 OR `category_idcategory_hu` = 1555 OR `category_idcategory_hu` = 1561 OR `category_idcategory_hu` = 2070 OR `category_idcategory_hu` = 1351 OR `category_idcategory_hu` = 1352 OR `category_idcategory_hu` = 1355 OR `category_idcategory_hu` = 1358 OR `category_idcategory_hu` = 1359 OR `category_idcategory_hu` = 1360 OR `category_idcategory_hu` = 1361 OR `category_idcategory_hu` = 1384 OR `category_idcategory_hu` = 1403 OR `category_idcategory_hu` = 1405 OR `category_idcategory_hu` = 1577 OR `category_idcategory_hu` = 1585 OR `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` = 1353 OR `category_idcategory_hu` = 1354 OR `category_idcategory_hu` = 1676 OR `category_idcategory_hu` = 1356 OR `category_idcategory_hu` = 1357 OR `category_idcategory_hu` = 2052 OR `category_idcategory_hu` = 2053 OR `category_idcategory_hu` = 2054 OR `category_idcategory_hu` = 2074 OR `category_idcategory_hu` = 2075 OR `category_idcategory_hu` = 2076 OR `category_idcategory_hu` = 2055 OR `category_idcategory_hu` = 2056 OR `category_idcategory_hu` = 2057 OR `category_idcategory_hu` = 2058 OR `category_idcategory_hu` = 2059 OR `category_idcategory_hu` = 2060 OR `category_idcategory_hu` = 1385 OR `category_idcategory_hu` = 1386 OR `category_idcategory_hu` = 1387 OR `category_idcategory_hu` = 1388 OR `category_idcategory_hu` = 1389 OR `category_idcategory_hu` = 1390 OR `category_idcategory_hu` = 1391 OR `category_idcategory_hu` = 1392 OR `category_idcategory_hu` = 1393 OR `category_idcategory_hu` = 1394 OR `category_idcategory_hu` = 1395 OR `category_idcategory_hu` = 1396 OR `category_idcategory_hu` = 1397 OR `category_idcategory_hu` = 1398 OR `category_idcategory_hu` = 1399 OR `category_idcategory_hu` = 1400 OR `category_idcategory_hu` = 1401 OR `category_idcategory_hu` = 1402 OR `category_idcategory_hu` = 2141 OR `category_idcategory_hu` = 1404 OR `category_idcategory_hu` = 1575 OR `category_idcategory_hu` = 1576 OR `category_idcategory_hu` = 1584 OR `category_idcategory_hu` = 1406 OR `category_idcategory_hu` = 1407 OR `category_idcategory_hu` = 1408 OR `category_idcategory_hu` = 1409 OR `category_idcategory_hu` = 1410 OR `category_idcategory_hu` = 1592 OR `category_idcategory_hu` = 1586 OR `category_idcategory_hu` = 1587 OR `category_idcategory_hu` = 1588 OR `category_idcategory_hu` = 1589 OR `category_idcategory_hu` = 1590 OR `category_idcategory_hu` = 1591 OR `category_idcategory_hu` = 1600 OR `category_idcategory_hu` = 1601 OR `category_idcategory_hu` = 1412 OR `category_idcategory_hu` = 1416 OR `category_idcategory_hu` = 1417 OR `category_idcategory_hu` = 1420 OR `category_idcategory_hu` = 1422 OR `category_idcategory_hu` = 1423 OR `category_idcategory_hu` = 1551 OR `category_idcategory_hu` = 1554 OR `category_idcategory_hu` = 1612 OR `category_idcategory_hu` = 1613 OR `category_idcategory_hu` = 2145 OR `category_idcategory_hu` = 1413 OR `category_idcategory_hu` = 1414 OR `category_idcategory_hu` = 1415 OR `category_idcategory_hu` = 1578 OR `category_idcategory_hu` = 1418 OR `category_idcategory_hu` = 1419 OR `category_idcategory_hu` = 1421 OR `category_idcategory_hu` = 1424 OR `category_idcategory_hu` = 1433 OR `category_idcategory_hu` = 1434 OR `category_idcategory_hu` = 1435 OR `category_idcategory_hu` = 1436 OR `category_idcategory_hu` = 1593 OR `category_idcategory_hu` = 1594 OR `category_idcategory_hu` = 1595 OR `category_idcategory_hu` = 1425 OR `category_idcategory_hu` = 1426 OR `category_idcategory_hu` = 1427 OR `category_idcategory_hu` = 1429 OR `category_idcategory_hu` = 1430 OR `category_idcategory_hu` = 1431 OR `category_idcategory_hu` = 1432 OR `category_idcategory_hu` = 1446 OR `category_idcategory_hu` = 1553 OR `category_idcategory_hu` = 1579 OR `category_idcategory_hu` = 1437 OR `category_idcategory_hu` = 1438 OR `category_idcategory_hu` = 1439 OR `category_idcategory_hu` = 1552 OR `category_idcategory_hu` = 2146 OR `category_idcategory_hu` = 2147 OR `category_idcategory_hu` = 2148 OR `category_idcategory_hu` = 2149 OR `category_idcategory_hu` = 1441 OR `category_idcategory_hu` = 1451 OR `category_idcategory_hu` = 1458 OR `category_idcategory_hu` = 1463 OR `category_idcategory_hu` = 1476 OR `category_idcategory_hu` = 1483 OR `category_idcategory_hu` = 1487 OR `category_idcategory_hu` = 1488 OR `category_idcategory_hu` = 1489 OR `category_idcategory_hu` = 1495 OR `category_idcategory_hu` = 1540 OR `category_idcategory_hu` = 1567 OR `category_idcategory_hu` = 1580 OR `category_idcategory_hu` = 2073 OR `category_idcategory_hu` = 2152 OR `category_idcategory_hu` = 1428 OR `category_idcategory_hu` = 1442 OR `category_idcategory_hu` = 1443 OR `category_idcategory_hu` = 1444 OR `category_idcategory_hu` = 1445 OR `category_idcategory_hu` = 1447 OR `category_idcategory_hu` = 1448 OR `category_idcategory_hu` = 1449 OR `category_idcategory_hu` = 1450 OR `category_idcategory_hu` = 1452 OR `category_idcategory_hu` = 1457 OR `category_idcategory_hu` = 1533 OR `category_idcategory_hu` = 1453 OR `category_idcategory_hu` = 1454 OR `category_idcategory_hu` = 1455 OR `category_idcategory_hu` = 1456 OR `category_idcategory_hu` = 2150 OR `category_idcategory_hu` = 2151 OR `category_idcategory_hu` = 1534 OR `category_idcategory_hu` = 1535 OR `category_idcategory_hu` = 1536 OR `category_idcategory_hu` = 1537 OR `category_idcategory_hu` = 1538 OR `category_idcategory_hu` = 1539 OR `category_idcategory_hu` = 1459 OR `category_idcategory_hu` = 1460 OR `category_idcategory_hu` = 1461 OR `category_idcategory_hu` = 1462 OR `category_idcategory_hu` = 1464 OR `category_idcategory_hu` = 1465 OR `category_idcategory_hu` = 1466 OR `category_idcategory_hu` = 1467 OR `category_idcategory_hu` = 1468 OR `category_idcategory_hu` = 1469 OR `category_idcategory_hu` = 1470 OR `category_idcategory_hu` = 1471 OR `category_idcategory_hu` = 1472 OR `category_idcategory_hu` = 1473 OR `category_idcategory_hu` = 1474 OR `category_idcategory_hu` = 1475 OR `category_idcategory_hu` = 1477 OR `category_idcategory_hu` = 1619 OR `category_idcategory_hu` = 1624 OR `category_idcategory_hu` = 1625 OR `category_idcategory_hu` = 1478 OR `category_idcategory_hu` = 1479 OR `category_idcategory_hu` = 1481 OR `category_idcategory_hu` = 1620 OR `category_idcategory_hu` = 1621 OR `category_idcategory_hu` = 1622 OR `category_idcategory_hu` = 1623 OR `category_idcategory_hu` = 1482 OR `category_idcategory_hu` = 1626 OR `category_idcategory_hu` = 1627 OR `category_idcategory_hu` = 1628 OR `category_idcategory_hu` = 1629 OR `category_idcategory_hu` = 1630 OR `category_idcategory_hu` = 1484 OR `category_idcategory_hu` = 1485 OR `category_idcategory_hu` = 1490 OR `category_idcategory_hu` = 1491 OR `category_idcategory_hu` = 1492 OR `category_idcategory_hu` = 1493 OR `category_idcategory_hu` = 1494 OR `category_idcategory_hu` = 1496 OR `category_idcategory_hu` = 1541 OR `category_idcategory_hu` = 1542 OR `category_idcategory_hu` = 1543 OR `category_idcategory_hu` = 1544 OR `category_idcategory_hu` = 1545 OR `category_idcategory_hu` = 1546 OR `category_idcategory_hu` = 1547 OR `category_idcategory_hu` = 1568 OR `category_idcategory_hu` = 1602 OR `category_idcategory_hu` = 1616 OR `category_idcategory_hu` = 1486 OR `category_idcategory_hu` = 1569 OR `category_idcategory_hu` = 1570 OR `category_idcategory_hu` = 1571 OR `category_idcategory_hu` = 1572 OR `category_idcategory_hu` = 1573 OR `category_idcategory_hu` = 1574 OR `category_idcategory_hu` = 1603 OR `category_idcategory_hu` = 1604 OR `category_idcategory_hu` = 1678 OR `category_idcategory_hu` = 1679 OR `category_idcategory_hu` = 1605 OR `category_idcategory_hu` = 1606 OR `category_idcategory_hu` = 1607 OR `category_idcategory_hu` = 1608 OR `category_idcategory_hu` = 1609 OR `category_idcategory_hu` = 1610 OR `category_idcategory_hu` = 1611 OR `category_idcategory_hu` = 1581 OR `category_idcategory_hu` = 1582 OR `category_idcategory_hu` = 1583 OR `category_idcategory_hu` = 2153 OR `category_idcategory_hu` = 2154 OR `category_idcategory_hu` = 2155 OR `category_idcategory_hu` = 2156 OR `category_idcategory_hu` = 2157 OR `category_idcategory_hu` = 2158 OR `category_idcategory_hu` = 2199 OR `category_idcategory_hu` = 2201 OR `category_idcategory_hu` = 2202 OR `category_idcategory_hu` = 2203 OR `category_idcategory_hu` = 2204 OR `category_idcategory_hu` = 1556 OR `category_idcategory_hu` = 1557 OR `category_idcategory_hu` = 1558 OR `category_idcategory_hu` = 1559 OR `category_idcategory_hu` = 1560 OR `category_idcategory_hu` = 1562 OR `category_idcategory_hu` = 1596 OR `category_idcategory_hu` = 1563 OR `category_idcategory_hu` = 1564 OR `category_idcategory_hu` = 1565 OR `category_idcategory_hu` = 1566 OR `category_idcategory_hu` = 1598 OR `category_idcategory_hu` = 1599 OR `category_idcategory_hu` = 1597 OR `category_idcategory_hu` = 1202 ) AND ( producers.url = "duchefa" ) 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