select p.models_id, p.products_cost, p.products_id, pd.slug, p.products_image, p.products_ubicacion, p.products_auto_desc, p.coebay_color, p.battery_model, p.battery_capacity, p.coebay_screen, p.coebay_resolucion, p.coebay_status, p.coebay_calidad, group_concat(ml.models_name separator ", ") as modl_comp, m.manufacturers_name, fm.familias_name, fm.familias_description, p.products_model, p.products_free_shipping, p.products_tax_class_id, p.products_price, pd.products_name, p.products_quantity
from products p
inner join products_description pd on (p.products_id = pd.products_id)
left join familias_description fm on (fm.familias_id = p.familias_id and fm.language_id = "3")
left join models ml on (p.models_id = ml.models_id)
left join manufacturers m on (p.manufacturers_id = m.manufacturers_id)
where p.products_status = 1 and p.products_quantity > 0 and pd.language_id = 3 and p.products_model != ""
group by p.products_id
order by p.products_date_added desc
limit 3
Misterphone solicita su permiso para obtener datos estadísticos de su navegación en esta web, en cumplimiento del Real Decreto-ley 13/2012. Si continua navegando, consideramos que acepta su uso.
Ver Politica de cookies.
Al crear una cuenta en ' . STORE_NAME . ' podrás realizar tus compras rápidamente en nuestra tienda virtual, revisar el estado de tus pedidos y consultar tus operaciones anteriores.