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 <="2023-06-07 13:20:11" and idraft=0 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
May 15, 2007: Blessed
Blessed are the Poor in Spirit
They shall see God
Blessed are the Mediators
Solution without Rod
Blessed are the Artists
For they see the Truth
Blessed are the Authors
Bourbon not Vermouth
Blessed are those
Who search for Justice
Protecting the Poor
Knowing what must is
Blessed are the Parents
Whose children we adore
Untamed in Spirit
Never a bore
Blessed are the Lovers
Whose eyes are blind
Seeing each other
With vision kind
Blessed are the Grandparents
Christmas time friends
Candy and marbles
Morality bends
Blessed are the Healers
Of Body and Spirit
Holistic Medicine
Never an Irit.
By
Anthony J. Fejfar