|
|
|
|
| 2020-07-16T03:02:03+02:00 | info | 2048 Kb | Database connected |
| 2020-07-16T03:02:03+02:00 | sql | 4096 Kb | SELECT id, clave, link_es AS link, titulo_es AS titulo,
slug_es AS slug, header_menu, footer_menu, parent_id, orden
FROM casasymar_articulos
ORDER BY orden
|
| 2020-07-16T03:02:03+02:00 | sql | 4096 Kb | SELECT id, clave, link_es AS link, titulo_es AS titulo,
slug_es AS slug, header_menu, footer_menu, parent_id, orden
FROM casasymar_articulos
ORDER BY orden
|
| 2020-07-16T03:02:03+02:00 | sql | 4096 Kb |
select v.*, v.titulo_es AS titulo,v.descripcion_es AS descripcion,
l.nombre as ciudad, cla.nombre_es as clase, t.nombre_es as tipo, j.nombre_es as jardin, ori.nombre_es as orientacion, cos.nombre_es AS costa, ori.nombre_es AS orientacion,
titulo_es,titulo_en,titulo_fr,titulo_de,titulo_se,
pis.nombre_es as piscina, vis.nombre_es as vistas, par.nombre_es as parking, z.nombre as zona
from casasymar_viviendas as v
left join casasymar_localidades as l on l.id = v.localidad_id
left join casasymar_zonas as z on z.id = v.zona_id
left join casasymar_costas as cos on cos.id = v.costa_id
left join casasymar_clases as cla on cla.id = v.clase_id
left join casasymar_tipos as t on t.id = v.tipo_id
left join casasymar_piscinas as pis on pis.id = v.piscina_id
left join casasymar_jardines as j on j.id = v.jardin_id
left join casasymar_orientaciones as ori on ori.id = v.orientacion_id
left join casasymar_vistas as vis on vis.id = v.vista_id
left join casasymar_parkings as par on par.id = v.parking_id
where v.visible is true
and v.id = 989 |
| 2020-07-16T03:02:03+02:00 | sql | 4096 Kb | select SQL_CALC_FOUND_ROWS v.id as vid,v.piscina_id, v.titulo_es as titulo,v.referencia, v.vendido, v.reservado, v.localidad_id, l.nombre as ciudad, v.tipo_id, t.nombre_es as tipo, v.sup_vivienda, v.banos, v.dormitorios, v.precio_de_venta, v.precio_anterior, v.precio_desde, c.nombre_es AS costa, s.nombre_es AS clase,v.descripcion_es as descr
from casasymar_viviendas as v
left join casasymar_localidades as l on l.id = v.localidad_id
left join casasymar_tipos as t on t.id = v.tipo_id
left join casasymar_costas as c on c.id = v.costa_id
left join casasymar_clases as s on s.id = v.clase_id
where v.visible is TRUE
and v.id != 989
and v.tipo_id = 1
and v.clase_id = 2
and v.precio_de_venta >= 164900
and v.precio_de_venta <= 214900
ORDER BY RAND()
limit 2 |
105.00 m2
2 Baños
