SELECT tg_tag, COUNT(*) as frequency FROM `tag_item` ti INNER JOIN `tag` t ON ti.tagid = t.tagid WHERE CONCAT(ti.plugin, ti.itemid) IN (SELECT CONCAT(plugin, itemid) FROM `tag_item` ti INNER JOIN `tag` t ON ti.tagid = t.tagid WHERE t.tg_tag IN ("elsewhere\","\"") GROUP BY CONCAT( plugin, itemid ) HAVING COUNT(DISTINCT ti.tagid) = 2 ) AND t.tg_tag NOT IN ("elsewhere\","\"") GROUP BY tg_tag; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\"") GROUP BY CONCAT( plugin, itemid ) ' at line 9array(6) { [0]=> array(6) { ["file"]=> string(51) "/mnt/xvol/www/jojo4/plugins/jojo_tags/jojo_tags.php" ["line"]=> int(433) ["function"]=> string(11) "selectQuery" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &string(709) "SELECT tg_tag, COUNT(*) as frequency FROM {tag_item} ti INNER JOIN {tag} t ON ti.tagid = t.tagid WHERE CONCAT(ti.plugin, ti.itemid) IN (SELECT CONCAT(plugin, itemid) FROM {tag_item} ti INNER JOIN {tag} t ON ti.tagid = t.tagid WHERE t.tg_tag IN ("elsewhere\","\"") GROUP BY CONCAT( plugin, itemid ) HAVING COUNT(DISTINCT ti.tagid) = 2 ) AND t.tg_tag NOT IN ("elsewhere\","\"") GROUP BY tg_tag;" } } [1]=> array(6) { ["file"]=> string(51) "/mnt/xvol/www/jojo4/plugins/jojo_tags/jojo_tags.php" ["line"]=> int(518) ["function"]=> string(11) "getTagCloud" ["class"]=> string(21) "Jojo_Plugin_Jojo_Tags" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &string(13) ""elsewhere\""" } } [2]=> array(4) { ["function"]=> string(14) "tagcloudfilter" ["class"]=> string(21) "Jojo_Plugin_Jojo_Tags" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &string(97870) " elsewhere" | Elsewhere by Graham Reid

elsewhere"

elsewhere" Content tagged as elsewhere".

KATHMANDU BLUES; ON TOP OF THE WORLD, a doco by COSTA BOTES (Lone Pine DVD)

KATHMANDU BLUES; ON TOP OF THE WORLD, a doco by COSTA BOTES (Lone Pine DVD)

Among the amusing moments in this fly-on-the-wall, 90 minute doco about -- yes -- a blues festival in Kathmandu, are artists saying that when invited they thought it was a joke by a friend or some kind of credit card fraud scheme. Singer-guitarist Paul Burris from the UK -- wearing Keep on Truckin' t-shirt -- says "we thought it was a...

Tags related to elsewhere"

[[tagcloud:"elsewhere\""]]
" } } [3]=> array(4) { ["file"]=> string(54) "/mnt/xvol/www/jojo4/plugins/jojo_core/classes/Jojo.php" ["line"]=> int(1741) ["function"]=> string(20) "call_user_func_array" ["args"]=> array(2) { [0]=> &array(2) { [0]=> string(21) "Jojo_Plugin_jojo_tags" [1]=> string(14) "tagcloudfilter" } [1]=> &array(1) { [0]=> string(97870) " elsewhere" | Elsewhere by Graham Reid

elsewhere"

elsewhere" Content tagged as elsewhere".

KATHMANDU BLUES; ON TOP OF THE WORLD, a doco by COSTA BOTES (Lone Pine DVD)

KATHMANDU BLUES; ON TOP OF THE WORLD, a doco by COSTA BOTES (Lone Pine DVD)

Among the amusing moments in this fly-on-the-wall, 90 minute doco about -- yes -- a blues festival in Kathmandu, are artists saying that when invited they thought it was a joke by a friend or some kind of credit card fraud scheme. Singer-guitarist Paul Burris from the UK -- wearing Keep on Truckin' t-shirt -- says "we thought it was a...

Tags related to elsewhere"

[[tagcloud:"elsewhere\""]]
" } } } [4]=> array(6) { ["file"]=> string(37) "/mnt/xvol/www/jojo4/includes/jojo.php" ["line"]=> int(619) ["function"]=> string(11) "applyFilter" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(2) { [0]=> &string(6) "output" [1]=> &string(83803) " elsewhere" | Elsewhere by Graham Reid

elsewhere"

elsewhere" Content tagged as elsewhere".

KATHMANDU BLUES; ON TOP OF THE WORLD, a doco by COSTA BOTES (Lone Pine DVD)

KATHMANDU BLUES; ON TOP OF THE WORLD, a doco by COSTA BOTES (Lone Pine DVD)

Among the amusing moments in this fly-on-the-wall, 90 minute doco about -- yes -- a blues festival in Kathmandu, are artists saying that when invited they thought it was a joke by a friend or some kind of credit card fraud scheme. Singer-guitarist Paul Burris from the UK -- wearing Keep on Truckin' t-shirt -- says "we thought it was a...

Tags related to elsewhere"

[[tagcloud:"elsewhere\""]]
" } } [5]=> array(4) { ["file"]=> string(37) "/mnt/xvol/www/elsewhere/www/index.php" ["line"]=> int(36) ["args"]=> array(1) { [0]=> string(37) "/mnt/xvol/www/jojo4/includes/jojo.php" } ["function"]=> string(12) "require_once" } }