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 = 2024 )
GROUP BY p_id order by p_model LIMIT 0, 24
Español