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 * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
GROUP BY bp.key_banner_place
ORDER BY b.key_banner
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '5'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '5'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '19' WHERE key_banner_place = '5'
UPDATE `poker_banners` SET `display` = '2617808' WHERE key_banner = '19'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '8'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '8'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '94' WHERE key_banner_place = '8'
UPDATE `poker_banners` SET `display` = '1790084' WHERE key_banner = '94'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '4'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '4'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '98' WHERE key_banner_place = '4'
UPDATE `poker_banners` SET `display` = '1488263' WHERE key_banner = '98'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '9'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '9'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '112' WHERE key_banner_place = '9'
UPDATE `poker_banners` SET `display` = '1075489' WHERE key_banner = '112'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '3'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '3'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '120' WHERE key_banner_place = '3'
UPDATE `poker_banners` SET `display` = '477596' WHERE key_banner = '120'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '10'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '10'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '123' WHERE key_banner_place = '10'
UPDATE `poker_banners` SET `display` = '160417' WHERE key_banner = '123'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '2'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '2'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '124' WHERE key_banner_place = '2'
UPDATE `poker_banners` SET `display` = '160395' WHERE key_banner = '124'
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE b.key_banner > bp.key_last_banner
AND bp.key_banner_place = '1'
ORDER BY b.key_banner ASC LIMIT 1
SELECT * FROM poker_banners b
JOIN poker_banner_places bp ON bp.key_banner_place = b.key_place
WHERE bp.key_banner_place = '1'
ORDER BY b.key_banner ASC LIMIT 1
UPDATE `poker_banner_places` SET `key_last_banner` = '125' WHERE key_banner_place = '1'
UPDATE `poker_banners` SET `display` = '15922' WHERE key_banner = '125'
SELECT name, name_url FROM `poker_news_site_categories`
WHERE name_url = 'pokertermek'
SELECT name, name_url FROM `poker_news_site_categories`
WHERE name_url = 'jokerclick'
SELECT name, name_url FROM `poker_news_site_categories`
WHERE name_url = 'jokerclick'
SELECT key_category, name, name_url FROM `poker_news_site_categories`
WHERE name_url = 'jokerclick'
SELECT title, news_url FROM `poker_news_hir`
WHERE news_url = 'jokerclick'
SELECT title, news_url FROM `poker_news_pokerhutipp`
WHERE news_url = 'jokerclick'
SELECT name, surl FROM `poker_termek`
WHERE surl = 'jokerclick'
SELECT t1.key_termek,t1.forum_url, t1.name, t1.rakerace, t1.surl
FROM poker_termek t1
WHERE t1.rakerace > '' AND rakerace_show = 1
ORDER BY t1.weight ASC
LIMIT 4
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 = 113
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 = 113
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 = 112
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'
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 = 59 LIMIT 1
SELECT * FROM `poker_vote_answers` a WHERE a.key_que = 59 ORDER BY a.key_answer
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 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 = 113
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 = 113
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 = 112
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 3
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 = 'pokertermek'
AND c.sp = 'jokerclick'
AND c.is_deleted = '0'
ORDER BY created_at DESC
SELECT * FROM poker_termek
WHERE surl = 'jokerclick' AND `show` = '1'
SELECT * FROM poker_termek_ertekeles
WHERE key_termek =
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2