select SQL_CALC_FOUND_ROWS product.* from product where activen='1' order by IF( FIND_IN_SET('summer', `tags`),2, IF( FIND_IN_SET('midseason', `tags`),1,0 ) ) DESC, product_grupi.reda asc, id desc limit 0,89
Unknown column 'product_grupi.reda' in 'order clause'