WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'thareja_wp01.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC


Blog.Search



Blog.Categories



Blog.Archives

    WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'thareja_wp01.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
    SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC



Interesting.Pages



Priyavrat.Thareja

Blog » 2011 » January

Stategising for success is today’s imperative to existence. This is demonstrated by taking quite an an lucid exemplar of rifle shooting.
Shooting is a competitive process determined by competence.
If you shoot it well, DRFT ( doing right first time), the job is well done.
If not, then ‘Lage Raho Munna Bhai’ , That is the popular bollywood movie’s title.

The refernce to this downloadable paper is:
Thareja, Priyavrat and Thareja, Mannu, Strategise, Energise (the) Entreprise: See You Succeed (September 1, 2010). Quality World, Vol. 8, No. 9, 2010. Available at SSRN:

For more papers go to:
more papers on Quality

- Posted on January 9th, 2011 in Pages | 1,267 Views | Comments (0)

Six Sigma Green Belt Program & Black Belt Program (in succession)
Organized by: PEC Univ of Collaboration Jointly with NPC (National Productivity Council) leading to a joint certification
Co-coordinators: Prof P Thareja (Cert Lean Six Sigma Black Belt) and Er S S Bhuller (Cert Six Sigma Black Belt)

Course to be held on holidays- Saturday-Sundays, say 8th January 2010, 9.30 am

Read More

- Posted on January 7th, 2011 in Pages, Quality, Education, Engineering, Management, Six Sigma | 3,094 Views | Comments (0)