Array
(
    [hiddenCAT] => 4
    [p] => 1
    [f] => 4,
)

SELECT DISTINCT REPLACE(product_desc.name, '"', '') as orderName, product_desc.name AS name, product.id AS id, product_desc.m_text AS text, product.sort AS sort, product_desc.seo FROM product,lang,product_desc ,cat,cat_product WHERE product.status != 0 AND product.id=product_desc.id_product AND product_desc.lang=lang.id AND lang.id=1 AND product.status=1 AND product.id=cat_product.id_product AND cat_product.id_cat=cat.id AND cat.id=4 AND ((SELECT ad.value FROM avalue a, avalue_desc ad WHERE a.id_attribute=4 AND a.id=ad.id_avalue AND a.id_product=product.id LIMIT 1) = 'TAK' ) ORDER BY product_desc.seo ASC LIMIT 8,8