SELECT mvreprom_id, mvreprom_etiqueta, mvreprom_imagen, mvreprom_detalle,mvreprom_titulo_es as mvreprom_titulo, mvreprom_resumen_es as mvreprom_resumen, mvreprom_slugname_es as mvreprom_slugname, mvreprov_slugname_es as mvreprov_slugname FROM `mvrepromociones` LEFT JOIN `mvreprovincias` on mvreprom_provincia_id = mvreprov_id WHERE mvreprom_activo=1 AND mvreprom_provincia_id=3 AND (mvreprom_agrupacion_id=0 OR mvreprom_agrupacion_id IS NULL OR mvreprom_agrupacion_id='') AND mvreprom_gestalia=1 AND mvreprom_historico = 0 ORDER BY mvreprom_orden ASC, mvreprom_id DESC LIMIT 12
La Rioja promociones viviendas - Gestalia Consulting
Nuevo lanzamiento
Nuevo lanzamiento