Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined offset: 0 in /var/www/concierge/diagram/2/index.php on line 57
Notice: Undefined index: in /var/www/concierge/diagram/2/index.php on line 66
SELECT
K.`キーワードID` AS K_ID,
K.`キーワード名` AS K_NAME,
SUM(`スコア`) AS SUM_SCORE
FROM
`研究室_X_キーワード` LA_X_K
LEFT JOIN `研究室マスタ` LA USING (`研究室ID`)
LEFT JOIN `学科_X_研究室` GK_X_LA USING (`研究室ID`)
LEFT JOIN `学科マスタ` GK USING (`学科ID`)
LEFT JOIN `学部マスタ` GB USING (`学部ID`)
LEFT JOIN `キーワードマスタ` K USING (`キーワードID`)
WHERE
GK.`学科ID` IN ()
AND K.`キーワードID` IN (104000032,105000030,139000033,106000036,139000027,113000041,300000013,300000010,300000011,300000014,300000012,123000045,111000044,300000015,117000043,136000048)
GROUP BY `キーワードID`
ORDER BY SUM_SCORE DESC
Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/concierge/diagram/2/index.php on line 78 相関図｜進学分野診断 学問コンシェルジュ｜大阪大学
