Última hora
: NOS INFORMAN QUE EL CAMPO DE TIRO LA CALA DE MIJAS ESTÁ MOMENTANEAMENTE CERRADO HASTA NUEVO AVISO. LA DIRECCIÓN DEL CAMPO LAMENTA LAS MOLESTIAS A LOS TIRADORES. SE INFORMARÁ DE SU REAPERTURA.
 
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM #__k2_items as i RIGHT JOIN #__k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-06-27 02:00:03' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-06-27 02:00:03' ) AND c.id IN (137,138,172) AND i.featured != 1 ORDER BY i.id DESC, cast(i.metakey as SIGNED) DESC

Grandes Tiradas en

  • 1
  • 2
  • 3
  • 4
  • 5