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(5) { [0]=> array(6) { ["file"]=> string(51) "/var/www/html/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) "/var/www/html/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]=> array(2) { [0]=> string(10) "elsewhere\" [1]=> string(1) """ } } } [2]=> array(6) { ["file"]=> string(54) "/var/www/html/jojo4/plugins/jojo_core/classes/Jojo.php" ["line"]=> int(1751) ["function"]=> string(14) "tagcloudfilter" ["class"]=> string(21) "Jojo_Plugin_Jojo_Tags" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> string(100577) " 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(6) { ["file"]=> string(37) "/var/www/html/jojo4/includes/jojo.php" ["line"]=> int(625) ["function"]=> string(11) "applyFilter" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(2) { [0]=> string(6) "output" [1]=> string(85184) " 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(4) { ["file"]=> string(37) "/mnt/xvol/www/elsewhere/www/index.php" ["line"]=> int(36) ["args"]=> array(1) { [0]=> string(37) "/var/www/html/jojo4/includes/jojo.php" } ["function"]=> string(12) "require_once" } }