Unknown column 'pa.a8' in 'where clause'
SELECT p.id, p.new_arrivals, p.name, p.image, p.stock_status_id, p.url_name, p.manufacturer_id, p.price, c.parent_id as cid, cr.category_id as category_id, c.url_name as category_url_name, c.name as category_name, cp.url_name as parent_category_url_name, cp.name as parent_category_name FROM cie_product as p, cie_category as c, cie_category as cp, cie_category_product_connector as cr WHERE cr.product_id=p.id AND cr.category_id=c.id AND c.parent_id=cp.id AND p.manufacturer_id IN (2,35,39,12,40,41,42,9,23,72,71,73,70,69,67,68,6,34,22,45,46,26,43,51,55,57,44,58,59,64,61,60,62,63,21) AND p.stock_status_id = 1 AND pa.a8>0 GROUP BY p.id ORDER BY cr.sort_id ASC
Array
(
    [0] => Array
        (
            [line] => 305
            [file] => /srv/github/esf/web/system/database/DB_driver.php
        )

    [1] => Array
        (
            [line] => 456
            [file] => /srv/github/esf/web/application/libraries/shop_catalog/RefineCatalog.php
        )

    [2] => Array
        (
            [line] => 80
            [file] => /srv/github/esf/web/application/libraries/shop_catalog/SearchCatalog.php
        )

    [3] => Array
        (
            [line] => 320
            [file] => /srv/github/esf/web/application/libraries/shop_catalog/RefineCatalog.php
        )

    [4] => Array
        (
            [line] => 99
            [file] => /srv/github/esf/web/application/libraries/shop_catalog/FrontCatalog.php
        )

    [5] => Array
        (
            [line] => 166
            [file] => /srv/github/esf/web/application/libraries/shop_catalog.php
        )

    [6] => Array
        (
            [line] => 17
            [file] => /srv/github/esf/web/application/controllers/search.php
        )

    [7] => Array
        (
            [line] => 230
            [file] => /srv/github/esf/web/system/codeigniter/CodeIgniter.php
        )

    [8] => Array
        (
            [line] => 362
            [file] => /srv/github/esf/web/engine.php
        )

)