Subscribe by EmailArchives
- mySQL error with query SELECT itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM nucleus_item WHERE iblog=1 and itime <="2024-04-24 18:44:11" and idraft=0 and icat=3 GROUP BY Year, Month ORDER BY itime DESC: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mohammad_cms.nucleus_item.itime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
January 23, 2008: World's largest swimming pool - 1,000 yards long
Measuring almost 3,500 ft in length,
The San Alfonso del Mar seawater pool in Algarrobo,
Chile has been named the world's largest outdoor swimming pool
by the Guiness Book of World Records.
Resources: http://www.dailymail.co.uk/pages/live/articles/ news/news.html?in_article_id=509718&in_page_id=1770