CREATE TEMPORARY TABLE tmp0 (INDEX(edi_tstmp), INDEX(code), INDEX(count), INDEX(qan_code), INDEX(qar_code), INDEX(user_code), INDEX(qar_code), INDEX(cert), INDEX(date) ) SELECT s.*, u.name AS user_name, u.about AS user_about, LOWER(CONV(CONCAT(1, u.file_code), 10, 35)) AS user_face, u.tel_cert AS user_tel, u.iden_cert AS user_iden, u.qar_code AS qar_code, u.qar_name AS qar_name, u.cyph_type, u.reco_type AS reco_type, u.cert AS cert, u.ti AS ti, u.pay_code AS pay_code, IFNULL(f.kana, '0') AS favo, GROUP_CONCAT(CASE WHEN q.row IS NULL THEN '' ELSE b.memo END SEPARATOR '') AS prilabel FROM tmp1 AS s LEFT OUTER JOIN quser AS u ON u.code = s.user_code AND u.real_code = '0' AND u.pay_code = '1' AND u.qan_code = '000005' LEFT OUTER JOIN favo AS f ON f.subj_code = s.code AND f.user_code = '' LEFT OUTER JOIN sub2 AS b ON b.code = s.code LEFT OUTER JOIN qar_subj AS q ON 1 AND q.row = b.row AND q.type = b.type AND q.qan_code = '000005' AND q.code = u.qar_code AND q.pri_code = '1' WHERE 1 AND u.join_code = '0' AND u.code IS NOT NULL GROUP BY s.code ORDER BY s.count DESC, u.cert DESC LIMIT 12;
Deadlock found when trying to get lock; try restarting transactionSELECT * FROM tmp0 WHERE 1 GROUP BY code ORDER BY CASE WHEN cyph_type = '1' THEN 0 ELSE count END DESC, ti, cert DESC;
Table '8match.tmp0' doesn't exist
PR案件お待ちしてます！｜&Buzz｜口コミマーケティング/評判のインフルエンサーマッチングAndBuzz