Is it possible to have a single query where I am doing
WHERE blah = bleh AND this = that AND age = 21
Where I can limit the "Blah" and the "This" results to like 3 or less each? I know I can tack a
LIMIT X to the end of the query but the limits total results. For my query I want 3 of this, and 3 of that and three of another.. but no more than 3 per, if each has less or none, oh well. Also is it possible with this idea to still have a max result limit?
Or is this something I would have to do across multiple queries, or something I would have to trim the results server side somehow?