Check the calendar

Low cost tournaments, freerolls and leagues

Access

Learn from the best

Follow the blogs of our teachers

Access
SELECT n.id,nl.titulo,nl.imagen, nl.descripcion, c.id AS categoria, sub.nombre FROM noticias n INNER JOIN noticias_lang nl ON nl.id_noticias = n.id AND nl.id_lang = 2 AND nl.titulo != '' INNER JOIN categorias_blog c ON n.id_categoria = c.id AND lower(c.nombre) = 'habpoker' INNER JOIN subcategorias_blog sub ON n.id_subcategoria = sub.id AND internacional = 1 WHERE n.fecha <= NOW() AND (n.fecha_fin >= CURDATE() OR n.fecha_fin = '0000-00-00') ORDER BY fecha DESC limit 0,9

News and promotions

Our use of cookies and other tracking technologies allows us to improve our Web site and your Web experience. By continuing to browse this site you are agreeing to our use of cookies. OK | More Information