Server shutdown in progress
query=SELECT filters.*, count(distinct products.prod_id) as total from prodcat_weight inner join products on products.prod_id = prodcat_weight.prod_id inner join suppliers on suppliers.sid=products.supplier inner join products_filters on products_filters.product_id=products.id inner join filters on products_filters.filter_id=filters.id WHERE prodcat_weight.cat_id in (826,810,116,812,813,802) and prodcat_weight.hidden='0' group by filters.id order by ((products_filters.filter_id='478' or products_filters.filter_id='326') and (products_filters.filter_id='478' or products_filters.filter_id='326' or products_filters.filter_id='931' or products_filters.filter_id='698') ) DESC, filters.weight asc