簡易フリーエリアプラグイン（タイプ：カテゴリ）

mySQL error with query DELETE FROM nucleus_plugin_analyze_templog WHERE alip LIKE '%.googlebot.com%' or alip LIKE '%.search.msn.com%' or alip LIKE '%msnbot.msn.com%' or alip LIKE '%.phx.gbl%' or alip LIKE '%inktomisearch.com%' or alip LIKE '%.fastsearch.net%' or alip LIKE '%ns.hatena.ne.jp%' or alip LIKE '%.alexa.com%' or alip LIKE '%.attens.net%' or alip LIKE '%.ask.com%' or alip LIKE '%.ask.jp%' or alip = '': Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE p_group as SELECT alid, COUNT(allog) as count FROM nucleus_plugin_analyze_templog GROUP BY alip, alid ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alid, COUNT(count) as count FROM p_group GROUP BY alid ORDER BY count DESC: Table 'weblog.p_group' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE q_group as SELECT alword, COUNT(alip) as count FROM nucleus_plugin_analyze_templog WHERE LEFT(alreferer, 3) = 'en?' GROUP BY alip, alword ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alword, COUNT(count) as count FROM q_group GROUP BY alword ORDER BY null: Table 'weblog.q_group' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE e_group as SELECT alreferer, COUNT(alip) as count FROM nucleus_plugin_analyze_templog WHERE LEFT(alreferer, 3) = 'en?' GROUP BY alip, alreferer ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alreferer, COUNT(count) as count FROM e_group GROUP BY alreferer ORDER BY null: Table 'weblog.e_group' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE r_group as SELECT alreferer, COUNT(alip) as count FROM nucleus_plugin_analyze_templog WHERE LEFT(alreferer, 4) = 'http' GROUP BY alip, alreferer ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alreferer, COUNT(count) as count FROM r_group GROUP BY alreferer ORDER BY null: Table 'weblog.r_group' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE h_group as SELECT CASE SUBSTRING_INDEX(alip, '.', -1) WHEN 'com' THEN SUBSTRING_INDEX(alip, '.', -2) WHEN 'net' THEN SUBSTRING_INDEX(alip, '.', -2) ELSE SUBSTRING_INDEX(alip, '.', -3) END as alip1, COUNT(allog) as count FROM nucleus_plugin_analyze_templog GROUP BY alip ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alip1, COUNT(count) as count, SUM(count) as count1 FROM h_group GROUP BY alip1 ORDER BY null: Table 'weblog.h_group' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE pq_group as SELECT alid, alword, COUNT(alip) as count FROM nucleus_plugin_analyze_templog WHERE LEFT(alreferer, 3) = 'en?' GROUP BY alip, alid, alword ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alid, alword, COUNT(alid) as count FROM pq_group GROUP BY alid, alword ORDER BY null: Table 'weblog.pq_group' doesn't exist

mySQL error with query CREATE TEMPORARY TABLE pagep as SELECT alid, alip, alreferer, COUNT(allog) as count FROM nucleus_plugin_analyze_templog WHERE NOT(LEFT(alreferer, 3) = 'en?' or alreferer LIKE 'http%' or alreferer = '') GROUP BY alid, alreferer, alip ORDER BY null: Table 'weblog.nucleus_plugin_analyze_templog' doesn't exist

mySQL error with query SELECT alid, SUM(count) as count, COUNT(alip) as count1, alreferer FROM pagep GROUP BY alid, alreferer ORDER BY null: Table 'weblog.pagep' doesn't exist