The Loomers

select * from loomers_multi where module like 'gallery' and (category regexp '^[0-9]{0,2}[\-~]{0,2}PHOTOS-exclaim-$' or category like 'PHOTOS-exclaim-') and featured != 8 and featured < 9 order by display_order asc, featured desc, updated desc, id asc limit -36,36