X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d34bc8cb52749eb039edbe5b86ed47b5c7fa143d..270902bc8e1f6bedae948ab73500b9fed85510cc:/script/statistics?ds=inline diff --git a/script/statistics b/script/statistics index 47c18312d..3f0c433f2 100755 --- a/script/statistics +++ b/script/statistics @@ -20,8 +20,7 @@ begin node_count = Node.count(:conditions => "visible = true") segment_count = Segment.count(:conditions => "visible = true") way_count = Way.count(:conditions => "visible = true") - tagged_way_count = Way.count(:conditions => "current_ways.visible = true AND current_way_tags.k <> 'created_by'", - :joins => "INNER JOIN current_way_tags ON current_way_tags.id = current_ways.id") + tagged_way_count = Way.count(:conditions => "visible = true AND EXISTS (SELECT * FROM current_way_tags WHERE id = current_ways.id AND k <> 'created_by')") puts "
Number of users | #{user_count} | |
#{count} #{display_name} | " + if column.nil? + puts "" + else + display_name = User.find(column[0]).display_name.gsub('@', ' at ').gsub('.', ' dot ') + count = column[1] + puts " | #{count} #{display_name} | " + end end puts "