|
SELECT E.ID as IDEVE, E.*, TE.* FROM eventos E LEFT OUTER JOIN tipos_eventos TE ON E.TIPO_EVENTO = TE.ID WHERE E.DEPORTE = 1 and E.FECHA >= '2013-05-19' and E.INSCRIP = 1 and E.INT_EXT = 0 and (E.pais2 in (11,22,26,29,39,45,48,50,56,58,80,87,151,160,162,163,167,216)) ORDER BY E.EVENTO_ASDEPORTE DESC, E.FECHA LIMIT 0, 5
|
|
