Ver originalSELECT * FROM js_sc_products p JOIN jos_sc_categorias c ON p.categoria = c.id ORDER BY c.nombre;