SELECT key_user FROM poker_users WHERE lastvisit = '0000-00-00 00:00:00' AND kelt < DATE_SUB(NOW(), INTERVAL 24 HOUR)
SELECT * FROM poker_tweet_cache WHERE tweet_name = 'PokerHU' ORDER BY updated DESC LIMIT 3
SELECT name, name_url FROM `poker_news_site_categories` WHERE name_url = 'pokerklubok'
SELECT name, name_url FROM `poker_news_site_categories` WHERE name_url = 'magyar-poker-klubok'
SELECT name, name_url FROM `poker_news_site_categories` WHERE name_url = 'universum-poker-center'
SELECT name, name_url FROM `poker_news_site_categories` WHERE name_url = 'universum-poker-center'
SELECT key_category, name, name_url FROM `poker_news_site_categories` WHERE name_url = 'universum-poker-center'
SELECT title, news_url FROM `poker_news_hir` WHERE news_url = 'universum-poker-center'
SELECT title, news_url FROM `poker_news_pokerhutipp` WHERE news_url = 'universum-poker-center'
SELECT name, surl FROM `poker_termek` WHERE surl = 'universum-poker-center'
SELECT title, news_url FROM `poker_news_szoftver` WHERE news_url = 'universum-poker-center'
SELECT title, news_url FROM `poker_news_klub` WHERE news_url = 'universum-poker-center'
SELECT t1.key_termek,t1.forum_url, t1.name, t1.rakerace, t1.surl, tr1.rakerace_url, tr1.rakerace_label FROM `poker_termek` t1 LEFT JOIN `poker_termek_rakerace` `tr1` USING (`key_termek`) WHERE CHAR_LENGTH(t1.rakerace) > 0 AND rakerace_show = 1 ORDER BY t1.rakerace_weight ASC;
SELECT value FROM poker_configs WHERE name = 'rakerace_show'
SELECT distinct c1.name, c1.name_url FROM poker_news_site_categories c1 JOIN poker_news_strategia t2 ON t2.key_category = c1.key_category WHERE c1.key_category_parent = 54 AND ( c1.key_category = 58 OR c1.key_category = 59 ) ORDER BY c1.name ASC
SELECT distinct c1.name, c1.name_url FROM poker_news_site_categories c1 JOIN poker_news_szoftver t2 ON t2.key_category = c1.key_category WHERE c1.key_category_parent = 74 ORDER BY c1.weight ASC LIMIT 4
SELECT distinct c1.name, c1.name_url FROM poker_news_site_categories c1 JOIN poker_news_pokerhutipp t2 ON t2.key_category = c1.key_category WHERE c1.key_category_parent = 111 ORDER BY c1.weight ASC
SELECT c1.name, c1.name_url FROM poker_news_site_categories c1 WHERE c1.key_category_parent = 122 ORDER BY c1.weight ASC
SELECT t.name, t.surl FROM poker_termek t ORDER BY t.weight ASC LIMIT 6
SELECT key_category, name, name_url FROM poker_news_site_categories WHERE key_category_parent = 80 ORDER BY weight ASC
SELECT fc.*, ui.nick FROM poker_forum_comments fc JOIN poker_users u ON u.key_user = fc.key_user JOIN poker_user_infos ui ON ui.key_user = u.key_user ORDER BY kelt desc LIMIT 3
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 52
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 57
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 57
SELECT distinct c1.key_category, c1.name, c1.name_url FROM poker_news_site_categories c1 JOIN poker_news_hir t2 ON t2.key_category = c1.key_category WHERE c1.key_category_parent = 50 AND c1.hardcoded = '0' AND c1.disabled = 'False' ORDER BY c1.name ASC;
SELECT key_termek, name, weight, bonuszkod, actual_promotion, surl from poker_termek t1 WHERE t1.weight <= 3 AND `show` = '1' ORDER BY RAND() LIMIT 0,3
SELECT key_termek, name, weight, bonuszkod, actual_promotion, surl from poker_termek t1 WHERE t1.weight <= 20 AND t1.weight >= 4 AND `show` = '1' ORDER BY t1.weight
SELECT * FROM `poker_vote_questions` q WHERE q.active < NOW() ORDER BY q.active DESC LIMIT 1
SELECT * FROM poker_voted_users WHERE key_user = '' AND key_que = 95 LIMIT 1
SELECT * FROM `poker_vote_answers` a WHERE a.key_que = 95 ORDER BY a.key_answer
SELECT NS.*, NC.name_url as name_url1, NST.name_url as name_url2 FROM (`poker_news_strategia` NS) LEFT JOIN (`poker_news_site_categories` NC) USING (key_category) LEFT JOIN (`poker_news_site_categories` NST) ON (NST.key_category = NS.key_strategy)WHERE `strategy_box` = 1 ORDER BY kelt DESC LIMIT 0,3 ;SELECT phpbb_topics.topic_id AS tid, phpbb_forums.forum_id AS fid, topic_title, forum_name, topic_last_post_time AS time, post_text as text, username AS poster_nick FROM phpbb_topics LEFT JOIN phpbb_forums USING (forum_id) LEFT JOIN phpbb_posts ON (phpbb_topics.topic_last_post_id = phpbb_posts.post_id) LEFT JOIN phpbb_users ON (phpbb_topics.topic_last_poster_id = phpbb_users.user_id) ORDER BY topic_last_post_time DESC LIMIT 0, 5;
SELECT fc.*, ui.nick ,CASE WHEN DATE_FORMAT(fc.kelt,'%Y-%m-%d') = CURDATE() THEN CONCAT('ma ', DATE_FORMAT(fc.kelt,'%H:%i')) WHEN DATE_FORMAT(fc.kelt,'%Y-%m-%d') = DATE_SUB(CURDATE(), interval 1 DAY) THEN CONCAT('tegnap ', DATE_FORMAT(fc.kelt,'%H:%i')) ELSE DATE_FORMAT(fc.kelt,'%Y.%m.%d %H:%i') END AS last_kelt, t.title AS topic_name FROM poker_forum_comments fc JOIN poker_users u ON u.key_user = fc.key_user JOIN poker_user_infos ui ON ui.key_user = u.key_user JOIN poker_forum_topics t ON t.key_topic = fc.key_topic WHERE fc.is_deleted = '0' ORDER BY kelt desc LIMIT 5
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 52
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 28
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 28
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 56
SELECT ft.key_topic, ft.title as title_topic, ft.title_url as title_url_topic, fc.key_category, fc.title as title_category, fc.title_url as title_url_category, fg.key_group, fg.title as title_group, fg.title_url as title_url_group FROM poker_forum_topics ft JOIN poker_forum_categories fc ON fc.key_category = ft.key_category JOIN poker_forum_groups fg ON fg.key_group = fc.key_group WHERE ft.key_topic = 56
SELECT b.*, ui.nick ,CASE WHEN DATE_FORMAT(b.created_at,'%Y-%m-%d') = CURDATE() THEN CONCAT('ma ', DATE_FORMAT(b.created_at,'%H:%i')) WHEN DATE_FORMAT(b.created_at,'%Y-%m-%d') = DATE_SUB(CURDATE(), interval 1 DAY) THEN CONCAT('tegnap ', DATE_FORMAT(b.created_at,'%H:%i')) ELSE DATE_FORMAT(b.created_at,'%Y.%m.%d %H:%i') END AS last_kelt FROM poker_blogs b JOIN poker_users u ON u.key_user = b.key_user JOIN poker_user_infos ui ON ui.key_user = u.key_user JOIN poker_users2blogcat u2b ON u2b.key_user = u.key_user WHERE b.is_deleted = '0' ORDER BY created_at DESC LIMIT 4
SELECT c.*, ui.nick FROM poker_comments c JOIN poker_user_infos ui ON ui.key_user = c.key_user WHERE 1 AND c.page = 'pokerklubok' AND c.sp = 'magyar-poker-klubok/universum-poker-center' AND c.is_deleted = '0' ORDER BY created_at DESC
SELECT key_category FROM poker_news_site_categories WHERE name_url = '73'
SELECT * FROM poker_news_site_categories WHERE key_category = '73'
SELECT * FROM `poker_news_site_categories` WHERE name_url = 'magyar-poker-klubok'
SELECT *,i.nick,IF(i.vnev,CONCAT(i.vnev,' ',i.knev),i.nick) AS szerzo, DATE_FORMAT(IF(bekuldte,bekuldte,s.kelt),'%Y.%m.%d %H:%i') AS kelt, c.name AS name,c.key_category FROM poker_news_klub s JOIN `poker_news_site_categories` c ON s.key_category = c.key_category JOIN poker_user_infos i ON s.key_user=i.key_user WHERE 1 AND s.`show` = '1' AND s.news_url = 'universum-poker-center' GROUP BY s.key_news
UPDATE `poker_news_klub` SET `display` = '1' WHERE news_url = 'universum-poker-center'
SELECT g.*,DATE_FORMAT(g.kelt, '%Y.%m.%d %H:%I' ) AS gkelt,gc.url AS cat_url, gc.title AS cat_title,parent_gc.url AS parent_url,parent_gc.title AS parent_title FROM poker_gallery g JOIN poker_gallery_categories gc ON g.key_category = gc.key_category LEFT JOIN poker_gallery_categories parent_gc ON parent_gc.key_category = gc.key_parent WHERE gc.key_category = AND gc.display = '1' ORDER BY g.sequenceYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gc.display = '1' ORDER BY g.sequence' at line 6