SELECT
p_model, p_title as p_titlang, p_title, p_descrip as p_descrip, p_sell, p_sellBy, p_listPrc, p_mapPrc,
prc_bustSite, prc_bustCart,
sp_price, v_id, v_name
, (MATCH (p_title) AGAINST ('+Gift +Certificates +and +Envelope' IN BOOLEAN MODE) ) * p_relevance as relev
FROM products
JOIN pricing ON p_prc_id = prc_id
JOIN vendor ON prc_v_id = v_id
JOIN prod_cat ON pc_p_id = p_id JOIN category ON pc_c_id = c_id
LEFT JOIN ship_prod ON sp_p_id = p_id
LEFT JOIN media ON p_id = m_p_id AND m_type = 'Image'
WHERE
p_sell <> 0 and p_relevance >= 0
and c_left >= (SELECT c_left FROM category WHERE c_id = 3005) AND c_right <= (SELECT c_right FROM category WHERE c_id = 3005) order by relev desc, p_model LIMIT 0, 24
Gift Certificate, printed on mottled gold, simulated parchment paper, space available for personalization (packed 1000 per case) (contact factory for price)
Gift Certificate, printed on mottled gold, simulated parchment paper, space available for personalization (packed 500 per case) (contact factory for price)
Gift Certificate with Receipt Stub, repeated knife and fork design printed on white textured paper (100 per pack, minimum order 5 packs) (contact factory for price)