FamousWhy
USA
Famous People Famous Regions Famous Articles Famous Software FamousWhy Web Services Famous Forum Submit Content
|
Birthdays Calendar
May 2021
SunMonTueWedThuFriSat
 1
2345678
9101112131415
16171819202122
23242526272829
3031 
Jump to month
January February
March April
May June
July August
September October
November December
Jump to year
Most Popular Birthdays
1 Jan 352 celebrities
4 Apr 312 celebrities
14 Feb 310 celebrities
3 Mar 290 celebrities
12 Feb 289 celebrities
17 Jan 289 celebrities
19 Sep 283 celebrities
1 Mar 279 celebrities
7 Mar 278 celebrities
16 Oct 278 celebrities
all days
Most Popular Birthdays
SqlExpression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'famousw_famousdata.celebrity.c_views' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Sqlselect count(*) as RowsNr, count(c_name) as nr_celebs FROM celebrity WHERE c_birth_day != '0' AND c_birth_month BETWEEN '1' AND '12' GROUP BY c_birth_month, c_birth_day ORDER BY c_views DESC