+
Viernes
Máx. 22°C
Min. 14°C
Sábado
Máx. 27°C
Min. 14°C
Domingo
Máx. 24°C
Min. 17°C
|
|
Error Can't create/write to file '/tmp/#sql_6e83_2.MYD' (Errcode: 17) in query
SELECT SQL_CALC_FOUND_ROWS DISTINCTROW
comercios.*,
comercios_traduccion.*,
tpreview.id_foto,
tpreview.filename,
tpreview.desc_foto,
zonas.nombre AS nombre_zona,
zonas.caracteristica AS caract_telef,
departamentos.nombre AS nombre_depto,
tipos_comercios.descripcion AS desc_tipo
FROM
comercios
INNER JOIN comercios_traduccion ON (comercios.id = comercios_traduccion.id_comercio)
LEFT JOIN (SELECT * FROM (
SELECT
id_galeria AS id_comercio,
id AS id_foto,
orden,
filename,
comercios_fotos_traduccion.texto1 AS desc_foto
FROM
comercios_fotos
INNER JOIN comercios_fotos_traduccion ON (comercios_fotos.id=comercios_fotos_traduccion.id_foto)
WHERE
habilitado=1 AND
(comercios_fotos_traduccion.id_idioma = 1)
ORDER BY principal DESC, orden, id DESC) t GROUP BY t.id_comercio) tpreview ON (tpreview.id_comercio=comercios.id)
INNER JOIN zonas ON (comercios.id_zona = zonas.id)
INNER JOIN departamentos ON (zonas.id_departamento = departamentos.id)
LEFT JOIN tipos_comercios ON (comercios.id_tipo = tipos_comercios.id)
WHERE
(comercios_traduccion.id_idioma = 1) AND
(comercios.habilitado = 1) AND
(comercios.id <> 0) AND (departamentos.id=117)
ORDER BY tipos_comercios.orden,RAND(1913557573) LIMIT 0,20. In file in line . Date: 2010-03-11 05:32:36
0 ítems encontrados.
Fatal error: Call to a member function fetch_array() on a non-object in /home/portalde/public_html/comercios/comercios.php on line 168
| |
|
|
|
