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-04-25 06:49:17' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-04-25 06:49:17' ) AND c.id IN (162) ORDER BY i.publish_up DESC, cast(i.metakey as SIGNED) DESC
  • Cto de Euskadi 2015 Compack Sporting en Zambrana

  • 12 Mayo 2015

  • PosTiradorR1Total
    1 Igor Larrea Otamendi 93 93
    2 Daniel Txapartegi Iturria 90 90
    3 Iraitz Oiarbide Sarasola 89 89
    4 Mikel Elorrieta Sangroniz 89 89
    5 Felipe Queralt Chans 87 87
  • Campeonato Provincial de F.U en Santiago

  • 10 Mayo 2015

  • PosTiradorR1Total
    1 John Henderson Rivas 100 100
    2 Fabián Domínguez Gesto 97 97
    3 Yago Lanzos Gesto 94 94
    4 Andrés Vázquez Da Silva 93 93
    5 Luis Paz Iglesia 92 92
  • Tirada del Corpus F.O. Las Gabias en Granada

  • 10 Mayo 2015

  • PosTiradorR1Total
    1 Juan José Serrano Ramos 99 99
    2 Pedro Ramírez Serrano 98 98
    3 Antonio Jesús Bailón Rodríguez 96 96
    4 Fatima Gálvez Martín 95 95
    5 Francisco José Martínez Domingo 93 93
  • I Tirada Armusa - Armería Paco Díaz

  • 19 Julio 2015

  • PosTiradorR1Total
    1 José Luis Rodríguez   50
    2 Javier Benito   49
    3 Cruz García   49
    4 David Calurano   48
    5 Luciano Cardoso   48
    6 José Antonio Salguero   48
  • Copa Presidente Foso Olímpico Andalucía

  • 12 Julio 2015

  • Pos Tirador Total
    1 Cristóbal García Flores 95+14+14
    2 Manuel David Soltero López 95+15+13
    3 José Luís Carrión Borja 95+13+13+2
    4 Antonio Jesús Bailón Rodríguez 96+13+13+1
    5 José E. Bedoya de la Cruz 95+12
  • Copa ADTP Foso Universal en Carmona (Sevilla)

  • 19 Julio 2015

  • PosTiradorR1Total
    1 Miguel Cortes Escobar   99
    2 Lorenzo Eusebio Rodríguez   96
    3 Manuel Hernández Sánchez   96
    4 Juan Hierro Fernández   95
    5 Federico Díaz Díaz   95
    6 Manuel Polvillo Bayer   95

PORTADA

 

Grandes Tiradas en

  • 1
  • 2
  • 3