SELECT * FROM website_inventory WHERE bin_price != '' AND image_top != 'images/space.gif' AND quantity > 0 AND cost > 0 and web_status != 'nonweb' AND web_class='gemstone' AND category='pearls' ORDER BY priority DESC LIMIT 0, 24