Receive judges feedback from the NPC New Mexico State Open/Natty and prepare for your next show!
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
a.forumid='258' AND
b.visible=1 AND a.title='NPC New Mexico state open/natty Judges Feedback'
ORDER BY
b.dateline DESC
LIMIT 20
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
INSERT INTO
thread
(title, forumid, open, postusername, postuserid, lastposter, lastposterid,dateline,postercount,visible)
VALUES
('NPC New Mexico state open/natty Judges Feedback','258',1,'Muscle Insider','47810','Muscle Insider','47810','1732158636',1,1)
WordPress database error: [Table 'musclech_mcvb.post' doesn't exist]
INSERT INTO
post
(threadid, username, userid, title, dateline,pagetext,allowsmilie,showsignature,ipaddress,visible,htmlstate)
VALUES
('0','Muscle Insider','47810','NPC New Mexico state open/natty Judges Feedback','1732158636','Receive judges feedback from the NPC New Mexico State Open/Natty and prepare for your next show!\n\nReceive judges feedback from the NPC New Mexico State Open/Natty and prepare for your next show!\n\n\n[url=\"https://www.muscleinsiders.com/npc-new-mexico-state-open-natty-judges-feedback/\"]Click here to view the article.[/url]',1,1,'127.0.0.1',1,'on_nl2br')
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
UPDATE
user
SET
posts=posts+1
WHERE
userid IN (
SELECT
x.postuserid
FROM
thread x
WHERE
x.threadid='0'
)
WordPress database error: [Table 'musclech_mcvb.forum' doesn't exist]
UPDATE
forum
SET
threadcount=threadcount+1
WHERE
forumid IN (
SELECT
x.forumid
FROM
thread x
WHERE
x.threadid='0'
)
WordPress database error: [Table 'musclech_mcvb.thread' doesn't exist]
UPDATE
thread
SET
firstpostid='0', lastpostid='0', lastpost='1732158636'
WHERE
threadid='0'
WordPress database error: [Table 'musclech_mcvb.forum' doesn't exist]
UPDATE
forum
SET
lastpostid='0', lastpost='1732158636', lastthread='NPC New Mexico state open/natty Judges Feedback', lastthreadid='0', lastposter='Muscle Insider', lastposterid='47810'
WHERE
forumid='258'
WordPress database error: [Table 'musclech_mcvb.activitystreamtype' doesn't exist]
SELECT
a.typeid
FROM
activitystreamtype a
WHERE
a.type='post'
LIMIT 1
WordPress database error: [Table 'musclech_mcvb.activitystream' doesn't exist]
INSERT INTO
activitystream
(userid, dateline, data, contentid, typeid, action, score)
VALUES
('47810','1732184188','','0','','create','0.000')
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
a.forumid='258' AND
b.visible=1 AND a.title='NPC New Mexico state open/natty Judges Feedback'
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.forumid='258' AND
a.forumid='258'
AND
a.title='NPC New Mexico state open/natty Judges Feedback'
Receive judges feedback from the NPC New Mexico State Open/Natty and prepare for your next show!