Code |
Context$parametros = array(
"seccion" => "axenda-cultural",
"c" => "cine",
"m" => "64,GE,22-12-2012",
"s" => "axenda-cultural"
)
$resumen = "<span class="busqueda-etiqueta">Sections:</span> Axenda cultural - <span class="busqueda-etiqueta">Categories:</span> Cinema"
$cantidad = 0
$codigo_idioma = "spa"
$entradas_clasificadas = array()
$tipoclasificacion = "categoria"
$newcondition = null
$sort = "Entrada.fecha_publicacion"
$direction = "DESC"
$joins = " LEFT JOIN entradas_metadatosdata_29 as Metadatodata ON Metadatodata.identrada = Entrada.id LEFT JOIN entradas_categorias as entradas_categorias ON entradas_categorias.identrada = Entrada.id "
$conditions = " Entrada.visible = 1 AND Seccion.visible = 1 AND Entrada.identrada IS null AND Seccion.id IN ( 29) AND entradas_categorias.idcategoria IN ( 103) "
$fields = null
$separador = ","
$secciones = array(
array(
"Seccion" => array()
)
)
$categorias = array(
array(
"Categoria" => array()
)
)
$etiquetas = null
$coordenadas = array()
$metadatos = array(
array(
"id" => "64",
"operation" => "GE",
"value" => "22-12-2012"
)
)
$fecha_publicado_desde = null
$fecha_publicado_hasta = null
$cadena_busqueda = null
$restrictivo = array()
$identificadores = array(
"cine"
)
$nombres = array(
"Cinema"
)
$seccion = array(
"Seccion" => array(
"id" => "29",
"idmenu" => "1",
"mptt_parent" => "10",
"mptt_left" => "52",
"mptt_right" => "59",
"idperfil" => "0",
"activo" => "1",
"defecto" => "0",
"multiples_entradas" => "1",
"definicion_entrada_nivel_1" => "Evento",
"definicion_entrada_nivel_2" => "Archivo",
"titulo" => "Axenda cultural",
"contenido" => "<p><em><span lang="GL">A oferta cultural e de lecer de Compostela resulta admirábel para unha cidade das súas dimensións. Por iso recoméndase gardar enerxías para experimentar Santiago despois do anoitecer. </span></em></p>",
"seo_url" => "axenda-cultural",
"seo_enlace_descripcion" => "",
"seo_titulo" => "",
"seo_meta_descripcion" => "",
"seo_palabrasclave" => "",
"fecha_publicacion" => "15/12/2009 16:09",
"fecha_finalizacion" => "",
"layout" => "default",
"view_seccion" => "activarcuenta",
"view_entrada" => "single-axenda",
"view_etiquetas" => "listado-estatico-axenda",
"view_categorias" => "listado-estatico-axenda",
"view_secciones" => "home",
"view_albumes" => "home",
"view_usuarios" => "home",
"view_shadowbox" => "activarcuenta",
"orden" => "0",
"activar_comentarios" => "1",
"activar_valoraciones" => "1",
"visible" => "1",
"contenidos" => "1",
"created" => "27/12/2009 03:04",
"modified" => "21/06/2011 16:19",
"imagen" => "",
"action_seccion" => "listado_axenda",
"action_entrada" => "single_axenda",
"action_etiqueta" => "listado_axenda",
"action_categoria" => "listado_axenda",
"action_secciones" => "defecto",
"action_albumes" => "defecto",
"action_usuarios" => "defecto",
"listado_limite" => "50",
"listado_orden_direccion" => "2",
"listado_orden_tipo" => "3",
"redireccion" => null,
"redireccion_entrada" => null,
"redireccion_seccion" => null,
"idmenuseccion" => null,
"relacion_seccion" => null,
"relacion_categoria" => null,
"relacion_entrada" => null,
"minisite" => "0",
"auxiliar" => "0",
"ayuda" => "",
"ayuda_seccion" => null,
"locale" => "glg"
)
)
$categoria = array(
"Categoria" => array(
"id" => "103",
"idseccion" => "29",
"mptt_parent" => null,
"mptt_left" => "97",
"mptt_right" => "98",
"titulo" => "Cinema",
"contenido" => "<p></p>",
"modified" => "30/09/2010 11:03",
"created" => "31/12/1899 00:00",
"orden" => "0",
"seo_url" => "cine",
"seo_enlace_descripcion" => "",
"seo_meta_descripcion" => "",
"seleccionable_combo" => "1",
"imagen" => null,
"locale" => "eng"
)
)
$temp = array(
"64,GE,22-12-2012"
)
$metadatosdef = array()
$mdf = "64,GE,22-12-2012"
$datos = array(
"64",
"GE",
"22-12-2012"
)
$id = "64"
$operacion = "GE"
$valor = "22-12-2012"
$order = " , Metadatodata.fecha_de_inicio ASC "
$idsecciones = array(
"29"
)
$idscategorias = array(
"103"
)
$aliases = array()
$m = array(
"id" => "64",
"operation" => "GE",
"value" => "22-12-2012"
)
$metadato = $this->metadatosindexados[ $m['id'] ];
WebController::_buscar() - APP/controllers/web_controller.php, line 29898
WebController::_axenda_cultural_listado() - APP/controllers/web_controller.php, line 5194
WebController::rss() - APP/controllers/web_controller.php, line 3567
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 196
[main] - APP/webroot/index.php, line 94
Code |
Context$sql = "
SELECT DISTINCT SQL_CALC_FOUND_ROWS
Entrada.id, Entrada.idseccion
FROM entradas as Entrada
LEFT JOIN secciones as Seccion ON Seccion.id = Entrada.idseccion
LEFT JOIN entradas_metadatosdata_29 as Metadatodata ON Metadatodata.identrada = Entrada.id LEFT JOIN entradas_categorias as entradas_categorias ON entradas_categorias.identrada = Entrada.id LEFT JOIN entradas_metadatosdata_ as Metadatodata ON Metadatodata.identrada = Entrada.id
WHERE
Entrada.visible = 1 AND Seccion.visible = 1 AND Entrada.identrada IS null AND Seccion.id IN ( 29) AND entradas_categorias.idcategoria IN ( 103) AND Metadatodata. >= 22-12-2012AND Entrada.fecha_publicacion <= "2013-05-21 14:11:33"
AND ( Entrada.fecha_finalizacion >= "2013-05-21 14:11:33"
OR Entrada.fecha_finalizacion IS NULL )
ORDER BY
Seccion.mptt_left ASC , Metadatodata.fecha_de_inicio ASC , Entrada.fecha_publicacion DESC
LIMIT 200;
"
$error = "1066: Not unique table/alias: 'Metadatodata'"
$out = null $out = null;
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 537
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 342
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 221
Model::query() - CORE/cake/libs/model/model.php, line 2325
WebController::_buscar() - APP/controllers/web_controller.php, line 30055
WebController::_axenda_cultural_listado() - APP/controllers/web_controller.php, line 5194
WebController::rss() - APP/controllers/web_controller.php, line 3567
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 196
[main] - APP/webroot/index.php, line 94