Our high quality products have grown to include many products used in restaurants, businesses and homes all over the world ranging from ceramic dinnerware to utensils and preparation equipment to disposable products. -
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
FROM products
JOIN pricing ON p_prc_id = prc_id
JOIN vendor ON prc_v_id = v_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 ( v_id = 2382 )
GROUP BY p_id order by p_model LIMIT 1776, 24
Español