SELECT node.type, count(node.nid) as count,  node.nid, node.title
FROM node node, content_field_tourist_attraction ta
WHERE ta.field_tourist_attraction_nid = node.nid AND node.type IN ('tourist_attraction')
GROUP BY node.nid ORDER BY count DESC;