Arnold Classic UK 2024 prejudging- it looks close between Samson Dauda and Hadi Choopan
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
SELECT
a.*,
b.postid, b.threadid, b.parentid, b.username, b.userid, b.title, b.dateline, b.pagetext as pagetext, b.iconid, b.visible,
customavatar.filename as customavatar, user.avatarrevision, user.avatarid, postparsed.pagetext_html as cachetext,
usergroup.opentag, usergroup.closetag,
(
SELECT COUNT(x.postid) FROM post x WHERE x.visible = 1 AND x.threadid = a.threadid
) as scVBTotalPosts
FROM
thread a
LEFT OUTER JOIN
post b
ON
b.threadid = a.threadid
LEFT OUTER JOIN
customavatar customavatar
ON
customavatar.userid = b.userid
LEFT OUTER JOIN
user user
ON
user.userid = b.userid
LEFT OUTER JOIN
usergroup usergroup
ON
usergroup.usergroupid = user.usergroupid
LEFT OUTER JOIN
postparsed postparsed
ON
postparsed.languageid IN (
SELECT
MAX(x.languageid)
FROM
postparsed x
WHERE
x.styleid = postparsed.styleid
AND
x.postid = b.postid
)
AND
postparsed.styleid IN (
SELECT
MAX(x.styleid)
FROM
postparsed x
WHERE
x.postid = b.postid
)
AND
postparsed.postid = b.postid
WHERE
b.visible=1 AND a.threadid='136686'
ORDER BY
b.dateline DESC
LIMIT 20
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
SELECT
a.*,
b.postid, b.threadid, b.parentid, b.username, b.userid, b.title, b.dateline, b.pagetext as pagetext, b.iconid, b.visible,
customavatar.filename as customavatar, user.avatarrevision, user.avatarid, postparsed.pagetext_html as cachetext,
usergroup.opentag, usergroup.closetag,
(
SELECT COUNT(x.postid) FROM post x WHERE x.visible = 1 AND x.threadid = a.threadid
) as scVBTotalPosts
FROM
thread a
LEFT OUTER JOIN
post b
ON
b.threadid = a.threadid
LEFT OUTER JOIN
customavatar customavatar
ON
customavatar.userid = b.userid
LEFT OUTER JOIN
user user
ON
user.userid = b.userid
LEFT OUTER JOIN
usergroup usergroup
ON
usergroup.usergroupid = user.usergroupid
LEFT OUTER JOIN
postparsed postparsed
ON
postparsed.languageid IN (
SELECT
MAX(x.languageid)
FROM
postparsed x
WHERE
x.styleid = postparsed.styleid
AND
x.postid = b.postid
)
AND
postparsed.styleid IN (
SELECT
MAX(x.styleid)
FROM
postparsed x
WHERE
x.postid = b.postid
)
AND
postparsed.postid = b.postid
WHERE
b.visible=1 AND a.threadid='136686'
ORDER BY
b.dateline DESC
LIMIT 20
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
SELECT
(a.replycount+1) as commentCount
FROM
thread a
WHERE
a.threadid = 136686
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
SELECT
a.*,
b.postid, b.threadid, b.parentid, b.username, b.userid, b.title, b.dateline, b.pagetext as pagetext, b.iconid, b.visible,
customavatar.filename as customavatar, user.avatarrevision, user.avatarid, postparsed.pagetext_html as cachetext,
usergroup.opentag, usergroup.closetag,
(
SELECT COUNT(x.postid) FROM post x WHERE x.visible = 1 AND x.threadid = a.threadid
) as scVBTotalPosts
FROM
thread a
LEFT OUTER JOIN
post b
ON
b.threadid = a.threadid
LEFT OUTER JOIN
customavatar customavatar
ON
customavatar.userid = b.userid
LEFT OUTER JOIN
user user
ON
user.userid = b.userid
LEFT OUTER JOIN
usergroup usergroup
ON
usergroup.usergroupid = user.usergroupid
LEFT OUTER JOIN
postparsed postparsed
ON
postparsed.languageid IN (
SELECT
MAX(x.languageid)
FROM
postparsed x
WHERE
x.styleid = postparsed.styleid
AND
x.postid = b.postid
)
AND
postparsed.styleid IN (
SELECT
MAX(x.styleid)
FROM
postparsed x
WHERE
x.postid = b.postid
)
AND
postparsed.postid = b.postid
WHERE
b.visible=1 AND a.threadid='136686'
ORDER BY
b.dateline DESC
LIMIT 20