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='jewelry' AND jewelry_type='equipment' ORDER BY priority DESC LIMIT 0, 24