Error description: Unknown column 'valorMenor' in 'order clause'
SELECT p.id, p.nombre, p.thumbs, p.marca_id FROM productos p, productos_detalles pd WHERE p.id = pd.producto_id and p.publicado=1 AND (p.nombre like '%nanotech%' OR pd.nombre like '%nanotech%' OR pd.sku like '%nanotech%') and pd.color_id = 14 and pd.talla_id = 5 group by(p.id) ORDER BY valorMenor desc