andante

or the four cheapest, then put the featured at the top?

dorsetdigital

What mix of items do you need though? 4 featured, 4 non-featured, 2 of each?

andante

you could look into a fancy case statement, like case deals.name == featured 1 else 0 as featuresort orderby featuresort style thing - but then you'd need to get down and dirty

CptPillow

ill try it but I need 4 items and not sure if I can get it to limit em consistantly

dorsetdigital

Make sure you have an index on the column in question

andante

id genuinely just have a getFeatured() and a getNonFeatured() and loop each individually