Advertisement
Guest User

Error QA

a guest
Jul 9th, 2015
353
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 8.62 KB | None | 0 0
  1. Question2Answer MySQL query: (SELECT 'options' AS selectkey, title, content FROM qa_options) UNION ALL (SELECT 'time', 'db_time', UNIX_TIMESTAMP(NOW()))Question2Answer MySQL query: (SELECT '0' AS selectkey, qa_posts.postid, qa_posts.categoryid, qa_posts.TYPE, LEFT(qa_posts.TYPE, 1) AS basetype, INSTR(qa_posts.TYPE, '_HIDDEN')>0 AS hidden, qa_posts.acount, qa_posts.selchildid, qa_posts.closedbyid, qa_posts.upvotes, qa_posts.downvotes, qa_posts.netvotes, qa_posts.views, qa_posts.hotness, qa_posts.flagcount, qa_posts.title, qa_posts.tags, UNIX_TIMESTAMP(qa_posts.created) AS created, qa_posts.name, qa_categories.title AS categoryname, qa_categories.backpath AS categorybackpath, CONCAT_WS(',', qa_posts.catidpath1, qa_posts.catidpath2, qa_posts.catidpath3, qa_posts.categoryid) AS categoryids, qa_posts.userid, qa_posts.cookieid, INET_NTOA(qa_posts.createip) AS createip, qa_userpoints.points, qa_users.flags, qa_users.level, qa_users.email AS email, qa_users.handle AS handle, BINARY qa_users.avatarblobid AS avatarblobid, qa_users.avatarwidth, qa_users.avatarheight, NULL AS obasetype, NULL AS ohidden, NULL AS opostid, NULL AS ouserid, NULL AS ocookieid, NULL AS oname, NULL AS oip, NULL AS otime, NULL AS oflagcount, NULL AS oflags, NULL AS olevel, NULL AS oemail, NULL AS ohandle, NULL AS oavatarblobid, NULL AS oavatarwidth, NULL AS oavatarheight, NULL AS opoints, NULL AS parentid, NULL AS qcount, NULL AS POSITION, NULL AS childcount, NULL AS content, NULL AS backpath, NULL AS action, NULL AS period, NULL AS COUNT, NULL AS pageid, NULL AS permit, NULL AS nav, NULL AS heading, NULL AS widgetid, NULL AS place FROM qa_posts LEFT JOIN qa_categories ON qa_categories.categoryid=qa_posts.categoryid LEFT JOIN qa_users ON qa_posts.userid=qa_users.userid LEFT JOIN qa_userpoints ON qa_posts.userid=qa_userpoints.userid JOIN (SELECT postid FROM qa_posts WHERE TYPE='Q' ORDER BY qa_posts.created DESC LIMIT 0,20) y ON qa_posts.postid=y.postid) UNION ALL (SELECT '1', qa_posts.postid, qa_posts.categoryid, qa_posts.TYPE, LEFT(qa_posts.TYPE, 1), INSTR(qa_posts.TYPE, '_HIDDEN')>0, qa_posts.acount, qa_posts.selchildid, qa_posts.closedbyid, qa_posts.upvotes, qa_posts.downvotes, qa_posts.netvotes, qa_posts.views, qa_posts.hotness, qa_posts.flagcount, qa_posts.title, qa_posts.tags, UNIX_TIMESTAMP(qa_posts.created), qa_posts.name, qa_categories.title, qa_categories.backpath, CONCAT_WS(',', qa_posts.catidpath1, qa_posts.catidpath2, qa_posts.catidpath3, qa_posts.categoryid), qa_posts.userid, qa_posts.cookieid, INET_NTOA(qa_posts.createip), qa_userpoints.points, qa_users.flags, qa_users.level, qa_users.email, qa_users.handle, BINARY qa_users.avatarblobid, qa_users.avatarwidth, qa_users.avatarheight, LEFT(aposts.TYPE, 1), INSTR(aposts.TYPE, '_HIDDEN')>0, aposts.postid, aposts.userid, aposts.cookieid, aposts.name, INET_NTOA(aposts.createip), UNIX_TIMESTAMP(aposts.created), aposts.flagcount, ausers.flags, ausers.level, ausers.email, ausers.handle, BINARY ausers.avatarblobid, ausers.avatarwidth, ausers.avatarheight, auserpoints.points, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM qa_posts LEFT JOIN qa_categories ON qa_categories.categoryid=qa_posts.categoryid LEFT JOIN qa_users ON qa_posts.userid=qa_users.userid LEFT JOIN qa_userpoints ON qa_posts.userid=qa_userpoints.userid JOIN qa_posts AS aposts ON qa_posts.postid=aposts.parentid LEFT JOIN qa_users AS ausers ON aposts.userid=ausers.userid LEFT JOIN qa_userpoints AS auserpoints ON aposts.userid=auserpoints.userid JOIN (SELECT postid FROM qa_posts WHERE TYPE='A' ORDER BY qa_posts.created DESC LIMIT 0,50) y ON aposts.postid=y.postid WHERE qa_posts.TYPE='Q') UNION ALL (SELECT '2', NULL, qa_categories.categoryid, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, qa_categories.title, qa_categories.tags, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, qa_categories.parentid, qa_categories.qcount, qa_categories.POSITION, COUNT(child.categoryid), qa_categories.content, qa_categories.backpath, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM qa_categories JOIN (SELECT NULL AS parentkey UNION SELECT grandparent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid JOIN qa_categories AS grandparent ON parent.parentid=grandparent.categoryid WHERE qa_categories.backpath='' UNION SELECT parent.parentid FROM qa_categories JOIN qa_categories AS parent ON qa_categories.parentid=parent.categoryid WHERE qa_categories.backpath='' UNION SELECT parentid FROM qa_categories WHERE backpath='' UNION SELECT categoryid FROM qa_categories WHERE backpath='') y ON qa_categories.parentid<=>parentkey LEFT JOIN qa_categories AS child ON child.parentid=qa_categories.categoryid GROUP BY qa_categories.categoryid ORDER BY qa_categories.POSITION) UNION ALL (SELECT 'pending_iplimits', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, action, period, COUNT, NULL, NULL, NULL, NULL, NULL, NULL FROM qa_iplimits WHERE ip=COALESCE(INET_ATON('91.119.163.209'), 0)) UNION ALL (SELECT 'pending_navpages', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, title, tags, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, flags, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, POSITION, NULL, NULL, NULL, NULL, NULL, NULL, pageid, permit+0, nav, heading, NULL, NULL FROM qa_pages WHERE nav IN ('B','M','O','F') ORDER BY POSITION) UNION ALL (SELECT 'pending_widgets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, title, tags, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, POSITION, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, widgetid, place FROM qa_widgets ORDER BY POSITION)Question2Answer MySQL query: SELECT entityid, entitytype, level FROM qa_userlevels WHERE userid=NULLQuestion2Answer MySQL query: REPLACE qa_options (title, content) VALUES ('flatbox_author', 'Q2A Market') Question2Answer MySQL query: UNLOCK TABLESQuestion2Answer MySQL query: SELECT VERSION()Question2Answer MySQL query: SHOW TABLESQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_optionsQuestion2Answer MySQL query: SELECT content FROM qa_options WHERE title='db_version'Question2Answer MySQL query: SHOW COLUMNS FROM qa_usersQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userloginsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userlevelsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userprofileQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userfieldsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_messagesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userfavoritesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_usernoticesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_usereventsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_sharedeventsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_cookiesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_categoriesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_pagesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_widgetsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_postsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_blobsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_wordsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_titlewordsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_contentwordsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_tagwordsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_posttagsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_uservotesQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userpointsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_userlimitsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_iplimitsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_optionsQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_cacheQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_usermetasQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_postmetasQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_categorymetasQuestion2Answer MySQL query: SHOW COLUMNS FROM qa_tagmetasQuestion2Answer MySQL query: SELECT COUNT(*) FROM qa_usersQuestion2Answer MySQL query: SHOW TABLES
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement