Signup for free
for more features
and less ads

About Users Help

Users & Guests Online
On Page: 1
This Forum: 9 & 125
Directory: 13
Entire Site: 9 & 125

11-13-19 07:39 PM

Navigation

Information

All Forums

Total Threads
106,031

Total Posts
1,373,461

Posts per Thread
13 average

Thread Views
147,319,544

Views per Thread
1,389 average

Total Likes
94,251

Total Dislikes
8,459

Like/Dislike Ratio
11.14

All Forums - All Forums

Welcome to our family friendly forum community where users can discuss video games, entertainment or life in general.

Sub Forums

mame

Stories/Simulation/Art

All Forums Threads

Status

Creator / Forum

NEW POSTS

Sexy Parodius - Why Does This Exist, And Why Is It Fun? [reply]

Keywords: mame,

yoshirulez!
Game Reviews

1,135

SuperViperT302
07-09-16 08:41 PM

NEW POSTS

Pac Land [reply]

hidden help

Keywords: PacMan , Pac Land, mame,

looba
Game Guides

404

Pacman+Mariofan
02-13-16 12:36 PM

NEW POSTS

Son Son: Fun Fun! [reply]

Keywords: mame,

Ultrajeff
Game Reviews

304

Ultrajeff
05-08-16 06:57 AM

NEW POSTS

Road Runner [reply]

Keywords: mame,

Ultrajeff
Game Reviews

217

Ultrajeff
05-09-16 05:36 AM

NEW POSTS

Review - Arcade Game: Puckman Pockimon (Pacman and Pikachu?) [reply]

Keywords: mame,

AwesomeTrinket
Game Reviews

451

AwesomeTrinket
05-17-16 03:41 PM

NEW POSTS

Review: Arcade Game - Go! Go! Mile Smile (Mazes are fun!) [reply]

Keywords: mame,

AwesomeTrinket
Game Reviews

520

Vanelan
05-25-16 12:40 AM

NEW POSTS

one of the best arcade beat em up [reply]

Keywords: mame,

hongeee
Game Reviews

390

Oldschool777
06-04-16 08:55 PM

NEW POSTS

Review: Arcade Game - Daisu Kiss (Just your typical dating-visual novel-minigame arcade!) [reply]

Keywords: mame,

AwesomeTrinket
Game Reviews

643

Hidden Phantom
06-06-16 04:38 PM

NEW POSTS

a real gambling machine [reply]

Keywords: mame,

hongeee
Game Reviews

372

Oldschool777
06-06-16 08:59 PM

NEW POSTS

Review: Arcade Game - PuLiRuLa (This. Is. WEIRD.) [reply]

Keywords: mame,

AwesomeTrinket
Game Reviews

524

Vanelan
06-08-16 11:09 PM

NEW POSTS

Penguin-Kun Wars: a diamond in the rough [reply]

Keywords: mame,

Ultrajeff
Game Reviews

228

Ultrajeff
06-15-16 06:20 AM

NEW POSTS

Sky Boys: a sky kid review [reply]

Keywords: mame,

Ultrajeff
Game Reviews

275

Sword Legion
06-15-16 05:14 PM

NEW POSTS

Legendary Fighting Game of all time [reply]

Keywords: mame,

evilcon09
Game Reviews

495

Eniitan
07-09-16 07:02 AM

NEW POSTS
CLOSED

Acrobatic Dog Fight

Keywords: Arcade, mame,

unclechicken
Game Discussion

289

HeavyMetalGamer
07-26-16 06:49 PM

NEW POSTS
CLOSED

R-Type

Keywords: Arcade, mame, shmup,

ShyTallKnight
Game Discussion

222

ShyTallKnight
07-29-16 07:43 PM

NEW POSTS
CLOSED

Vizzed.com

Keywords: Playstation, Playstation 4, mame,

kamilek1996ch1
Trash Can

364

yoshirulez!
12-04-16 04:25 AM

NEW POSTS

Mega Man: The Power Battle Review - Heavy Metal Gamer Show [reply]

Keywords: mame, Retro Gaming, Mega Man: The Power Battle,

HeavyMetalGamer
Game Reviews

386

HeavyMetalGamer
12-24-16 02:34 PM

NEW POSTS
CLOSED

A sequel would be nice

Keywords: mame, Retro Gaming, Mega Man: The Power Battle,

HeavyMetalGamer
Game Discussion

344

Oldschool777
01-03-17 04:07 PM

NEW POSTS
CLOSED

is there a way we can use cheats in mame?

Keywords: mame,

UnholyArceus
Help / Questions / Suggestions

145

UnholyArceus
03-31-17 10:33 AM

NEW POSTS

Warning About Savestates [reply]

They don't quite work properly.

Keywords: Arcade, mame, issues, Debug, Glitch,

TheRealHedgehogS
Game Discussion

192

TheRealHedgehogS
09-27-19 07:41 PM

Page Comments

Sponsor

Footer

Only Bad Queries | Only Good Queries | Bad and Good Queries || Only Mediam Queries | Only Slow Queries | Fast and Slow Queries

Good Query! (1) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 21 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/boards/forum.php" /*()*/

Good Query! (2) Render Time: 0.003 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id, url, url_format, directory_id, page_order, update_date, update_users, last_users, views_today, parent_id, directory_id, theme_id FROM page INNER JOIN page_statistics ON page_statistics.page_id = id WHERE id=7 /*()*/

Good Query! (3) Render Time: 0.001 Very Fast

Rows Found: - Result Details: 1

/* get_browser Start /* /*()*/

Good Query! (4) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

/* get_browser End /* /*()*/

Good Query! (5) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/

Good Query! (6) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/

Good Query! (7) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT count(*) FROM ipbans WHERE INSTR('35.175.180.108',ip)=1 /*()*/

Good Query! (8) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 2 [type] => 0 )

SELECT ip FROM logs_11_13_19 ORDER BY id DESC LIMIT 2 /*()*/

Good Query! (9) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id FROM vizzed_logs.log_ip WHERE ip=INET_ATON('35.175.180.108') /*()*/

Good Query! (10) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_13 WHERE ip_id=1559507 AND date > 1573695542 - 3 /*()*/

Good Query! (11) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_13 WHERE ip_id=1559507 AND date > 1573695542 - 60 /*()*/

Good Query! (12) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id FROM log_2019_11_13 LIMIT 1 /*()*/

Good Query! (13) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM log_ip WHERE ip=INET_ATON('35.175.180.108') /*()*/

Good Query! (14) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM log_browser WHERE browser_details='CCBot/2.0 (https://commoncrawl.org/faq/)' /*()*/

Good Query! (15) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM log_device WHERE device='unknown' /*()*/

Good Query! (16) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM log_os WHERE os='unknown' /*()*/

Good Query! (17) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

INSERT INTO log_2019_11_13( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1559507', '287729', '23586', '2', '2', '70019273', '', 1573695542 ) /*()*/

Good Query! (18) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

INSERT INTO log_2019_11_13_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 289542, '//www.vizzed.com/boards/forum.php?sub=mame&order=title%E2%8A%82=Bible', 'All Threads', '', '', '{\"sub\":\"mame\",\"order\":\"title\\u2282=Bible\"}' ) /*()*/

Good Query! (19) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 11 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT * FROM boardconfig /*()*/

Good Query! (20) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT name,posts,sex,powerlevel,id FROM users,postradar WHERE postradar.user=0 AND users.id=postradar.comp ORDER BY posts DESC /*()*/

Good Query! (21) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 26 [type] => 0 )

SELECT * FROM users_group INNER JOIN users_group_user ON users_group_user.group_id = users_group.id WHERE type=8 /*()*/

Good Query! (22) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 4 [lengths] => [num_rows] => 34 [type] => 0 )

SELECT * FROM users_customization /*()*/

Good Query! (23) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 11 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT * FROM tourdevizzedmonthly WHERE year=2019 AND month=10 /*()*/

Good Query! (24) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT SUM(numthreads) FROM forums /*()*/

Good Query! (25) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(pid) FROM posts_text /*()*/

Good Query! (27) Render Time: 0.001 Very Fast

Rows Found: - Result Details: 1

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_13','289542',' SELECT SUM(views) as view_total, SUM(likes) as likes_total, SUM(dislikes) as dislikes_total FROM threads WHERE forum<>0 /*()*/ ','79') /*()*/

Good Query! (27) Render Time: 0.079 Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT SUM(views) as view_total, SUM(likes) as likes_total, SUM(dislikes) as dislikes_total FROM threads WHERE forum<>0 /*()*/

Good Query! (28) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

UPDATE page_statistics SET views_today=views_today+1, views=views+1 WHERE page_id=287729 /*()*/

Good Query! (29) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 22 [lengths] => [num_rows] => 72 [type] => 0 )

SELECT * FROM `page_variable_list` WHERE (page_id=0 OR page_id=287729 OR page_id=287729 OR page_id=7) ORDER BY page_id <> '' DESC, category = 'Page Meta' DESC, category = 'Page Look' DESC, category = 'Page Detailed' DESC, category = 'Content Disabling' ASC, category ASC, variableOrder ASC, name ASC /*()*/

Good Query! (30) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 42 [type] => 0 )

SELECT * FROM `page_variables_theme_variables` WHERE page_variables_theme_id=1 /*()*/

Good Query! (31) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 5 [type] => 0 )

SELECT * FROM `page_variables` WHERE page_id=7 /*()*/

Good Query! (32) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 3 [type] => 0 )

SELECT * FROM `page_variables` WHERE page_id=287729 /*()*/

Good Query! (33) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 3 [type] => 0 )

SELECT * FROM `page_variables` WHERE page_id=287729 /*()*/

Good Query! (34) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(id) as total FROM page_content WHERE cantremovefrompage=287729 /*()*/

Good Query! (35) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id FROM guests WHERE ip = '35.175.180.108' ORDER BY date DESC LIMIT 1 /*()*/

Good Query! (36) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

UPDATE guests SET date=1573695542, last_page_id=287729,last_parent_id=287729,last_directory_id=7 WHERE ip = '35.175.180.108' /*()*/

Good Query! (37) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT allkeywords,id FROM page_indexes WHERE url='/boards/forum.php?sub=mame&order=title%E2%8A%82=Bible' /*()*/

Good Query! (38) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 3 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM searchkeywords WHERE url='/boards/forum.php?sub=mame&order=title%E2%8A%82=Bible' AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/

Good Query! (39) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 2 [type] => 0 )

SELECT views FROM misc /*()*/

Good Query! (40) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: 1

UPDATE misc SET views=2534703376 /*()*/

Good Query! (41) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 120 [type] => 0 )

SELECT page.* FROM `page` INNER JOIN page_statistics ON page_statistics.page_id = page.id WHERE page_order = 3 ORDER BY views_today DESC /*()*/

Good Query! (42) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 10 [type] => 0 )

SELECT page.* FROM `page` INNER JOIN page_statistics ON page_statistics.page_id = page.id WHERE page_order <= 3 ORDER BY page.id=2 DESC, page.id=3 DESC, page.id=7 DESC, page.id=8 DESC, page.id=141056 DESC, page.id=290325 DESC, page.id=817112 DESC, page.id=139840 DESC, page.id=980494 DESC, page.id=270457 DESC, page_order DESC, views DESC LIMIT 10 /*()*/

Good Query! (43) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 5 [type] => 0 )

SELECT title FROM announcements ORDER BY date DESC LIMIT 5 /*()*/

Good Query! (44) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1573695542-900 AND last_page_id=287729 /*()*/

Good Query! (45) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT id FROM guests WHERE date >= 1573695542-900 AND last_page_id=287729 /*()*/

Good Query! (46) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM users LEFT JOIN users_last ON users_last.user_id = users.id WHERE lastactivity >= 1573695542-900 AND (last_parent_id=287729 OR last_page_id=287729 OR lastforum=0) /*()*/

Good Query! (47) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM guests WHERE date >= 1573695542-900 AND (last_parent_id=287729 OR last_page_id=287729 OR lastforum=0) /*()*/

Good Query! (48) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1573695542-900 AND (last_directory_id=7 OR last_page_id=7) /*()*/

Good Query! (49) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 13 [type] => 0 )

SELECT id FROM guests WHERE date >= 1573695542-900 AND (last_directory_id=7 OR last_page_id=7) /*()*/

Good Query! (50) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1573695542-900 /*()*/

Good Query! (51) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM guests WHERE date >= 1573695542-900 /*()*/

Good Query! (52) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT page_admin.power, users_group.name as group_name, group_id, user_id as userid , users.birthday as userbirthday, users.name as username, users.regdate as userregdate, users.posts as userposts, users.sex as usersex, users.powerlevel as userpowerlevel, users.postsToday as userpostsToday, users.picture as userpic FROM `page_admin` LEFT JOIN users ON users.id=page_admin.user_id LEFT JOIN users_group ON users_group.id=page_admin.group_id WHERE page_id=287729 OR page_id=7 OR page_id=287729 ORDER BY power DESC /*()*/

Good Query! (53) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 12 [type] => 0 )

SELECT * FROM page WHERE page_order <= 2 ORDER BY page_order ASC, page_title ASC /*()*/

Good Query! (54) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 5 [type] => 0 )

SELECT * FROM page WHERE (directory_id=287729 OR (directory_id=7 AND directory_id!=2) ) AND page_order=3 AND (page_title <> '' OR page_title_short <> '') ORDER BY page_title ASC /*()*/

Good Query! (55) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 5 [lengths] => [num_rows] => 6 [type] => 0 )

SELECT id, url, page_order, page_title, page_title_short FROM page WHERE (parent_id=287729 OR directory_id=287729 OR id=287729 OR id=7 OR parent_id=287729 OR (directory_id=7 AND directory_id <> 2) ) AND page_order <= 3 ORDER BY id = 7 DESC, page_order ASC, page_title ASC /*()*/

Good Query! (56) Render Time: 0.000 Extremely Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 50 [lengths] => [num_rows] => 0 [type] => 0 )

SELECT *, page_content_url.id as page_content_url_id FROM page_content_url LEFT JOIN page_content ON page_content.id = page_content_url.page_content_id WHERE page_id = 287729 ORDER BY page_content_order ASC /*()*/

Good Query! (57) Render Time: 0.001 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 )

SELECT COUNT(*) as total FROM threads LEFT JOIN threads_keywords ON threads_keywords.thread_id = threads.id LEFT JOIN keywords ON keywords.id = threads_keywords.keyword_id LEFT JOIN forums ON forums.id=threads.forum WHERE forum<>0 AND (forums.minpower <= 0 )AND keywords.keyword = 'mame' /*()*/

Good Query! (58) Render Time: 0.002 Very Fast

Rows Found: - Result Details: mysqli_result Object ( [current_field] => 0 [field_count] => 42 [lengths] => [num_rows] => 20 [type] => 0 )

SELECT threads.* FROM ( SELECT threads.*, page.img_thumbnail AS img_thumbnail, minpower, forums.title as forumtitle, forums.id as forumid, users2.id as user2, users2.birthday as birthday2, users2.name as name2, users2.regdate as regdate2, users2.posts as posts2, users2.sex as sex2, users2.powerlevel as powerlevel2, users2.postsToday as postsToday2 , users.birthday as userbirthday, users.name as username, users.regdate as userregdate, users.posts as userposts, users.sex as usersex, users.powerlevel as userpowerlevel, users.postsToday as userpostsToday, users.picture as userpic FROM threads INNER JOIN users ON users.id = threads.user INNER JOIN users users2 ON users2.id = threads.lastposter LEFT JOIN threads_keywords ON threads_keywords.thread_id = threads.id LEFT JOIN keywords ON keywords.id = threads_keywords.keyword_id LEFT JOIN forums ON forums.id=threads.forum LEFT JOIN page ON page.special_id = threads.id AND page.parent_id=795701 WHERE forum<>0 AND (forums.minpower <= 0 )AND keywords.keyword = 'mame' LIMIT 0,50 ) threads /*()*/

Good Query! (59) Render Time: 0.001 Very Fast