DEBUG before query run:
select i.id as id, i.add_date as add_date, i.formats_id as formats_id, i.title as title, i.notes as notes, i.subtitle as subtitle, a.name as artist, p.name as producer, l.name as label, f.name as format, t.name as type, g.name as genre, i.riddim as riddim, i.import_id as import_id, i.avail_yn as avail_yn, i.price as price, i.release_date as release_date, i.inAmazonS3, i.item_type_id from items i join artist a force index(primary) on (a.id=i.artist_id) join formats f force index(primary) on (f.id=i.formats_id) join genre g on (g.id=i.genre_id) join producer p on (p.id=i.producer_id) join item_type t on (t.id=i.item_type_id) join label l on (l.id=i.label_id) where i.item_type_id='1' and i.avail_yn='Y' and i.riddim like '%Stink%' order by a.name limit 0,12
