Organisations

  • user warning: Table 'drupal_schoolofeverything_com.node_data_field_geonames_location' doesn't exist query: SELECT count(DISTINCT(node.nid)) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN node profilenode ON node.uid = profilenode.uid and profilenode.type = 'profile' INNER JOIN node_data_field_geonames_location node_data_field_geonames_location ON profilenode.nid = node_data_field_geonames_location.nid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.type IN ('organisation')) AND (term_node.tid IN ('5011','10060','49802','10330','5119','3934','1101','8852','3449','6320','1561')) AND (node_data_field_geonames_location.field_geonames_location_lng IS NOT NULL) AND (node_data_field_geonames_location.field_geonames_location_lat > 52.2291994406 AND node_data_field_geonames_location.field_geonames_location_lat < 53.6780005594 AND node_data_field_geonames_location.field_geonames_location_lng > -2.35292747467 AND node_data_field_geonames_location.field_geonames_location_lng < 0.0519874746705) ) in /mnt/data/sites/schoolofeverything.com/www/docs/includes/database.mysql.inc on line 187.
  • user warning: Table 'drupal_schoolofeverything_com.node_data_field_geonames_location' doesn't exist query: SELECT DISTINCT(node.nid), term_node.tid AS nco_tid, (POW(0.924214670784 - RADIANS(node_data_field_geonames_location.field_geonames_location_lat), 2) + POW(-0.0200794894454 - RADIANS(node_data_field_geonames_location.field_geonames_location_lng), 2)) AS distanceSquared FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN node profilenode ON node.uid = profilenode.uid and profilenode.type = 'profile' INNER JOIN node_data_field_geonames_location node_data_field_geonames_location ON profilenode.nid = node_data_field_geonames_location.nid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.type IN ('organisation')) AND (term_node.tid IN ('5011','10060','49802','10330','5119','3934','1101','8852','3449','6320','1561')) AND (node_data_field_geonames_location.field_geonames_location_lng IS NOT NULL) AND (node_data_field_geonames_location.field_geonames_location_lat > 52.2291994406 AND node_data_field_geonames_location.field_geonames_location_lat < 53.6780005594 AND node_data_field_geonames_location.field_geonames_location_lng > -2.35292747467 AND node_data_field_geonames_location.field_geonames_location_lng < 0.0519874746705) ) GROUP BY node.nid, distanceSquared ORDER BY (nco_tid = 5011) DESC, distanceSquared ASC LIMIT 0, 10 in /mnt/data/sites/schoolofeverything.com/www/docs/includes/database.mysql.inc on line 187.

Oh no. There aren't any organisations tagged as Drumkit near Nottingham.

Fingers crossed there will be some for you here soon.

Here are a few other useful things you could do