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 ('+Guest +Room +Directorie' 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 = 3147) AND c_right <= (SELECT c_right FROM category WHERE c_id = 3147) order by relev desc, p_model LIMIT 0, 24
In Room Directory, 8-1/2" x 11", 1/2" three ring binder, case bound, padded, pockets on both sides of interior, (specify color), Made in USA (minimum order 25 each)
Guest Directory, leather-like vinyl exterior, 3 ring in spine, holds multiple 8-1/2" x 11" page protectors, heat sealed edge, one interior clear half pocket, includes logo (up to 45 sq. inches, includes all plate, stamp, and set-up charges) (priced per each, minimum order 25 each)
Guest Directory, leather-like vinyl exterior, 3 ring in spine, heat sealed edge, two interior clear half pocket, includes logo (up to 45 sq. inches, includes all plate, stamp, and set-up charges) (priced per each, minimum order 25 each)
Español