534
edits
Changes
Jump to navigation
Jump to search
Line 4:
Line 4: − +
Report: Number of people originating from first level birthplace (view source)
Revision as of 03:56, 8 August 2010
, 03:56, 8 August 2010no edit summary
--------
--------
SELECT LTRIM(REVERSE(SUBSTRING_INDEX(REVERSE(birthplace),",",3))) as city_or_village, COUNT(*) AS Number, RPAD('',COUNT(*)/100,'=') AS Graph FROM tng_people WHERE birthplace <> "" group BY city_or_village order by Number desc
SELECT LTRIM(REVERSE(SUBSTRING_INDEX(REVERSE(birthplace),",",3))) as city_or_village, COUNT(*) AS Number, RPAD(' ',COUNT(*)/100,'=') AS Graph FROM tng_people WHERE birthplace <> "" group BY city_or_village order by Number desc
--------
--------
[[Category:Henny Savenije - Reports]]
[[Category:Henny Savenije - Reports]]
