query problem

query problem

midav
Junior Member
Posts: 40
Threads: 17
Joined: May 2019
Reputation: 0

07-02-2019, 08:22 AM

(07-02-2019, 08:01 AM)php_rocs Wrote: @midav,

Do you have a version of the query that works directly in MySQL?

Have you tried the query directly in MySQL?

You are going to have to break down each join to see where the issue is. Did you check the field in the table as the error suggested?

on my MySql 5.7 if it is disabled ONLY_FULL_GROUP_BY

Messages In This Thread

query problem - by midav - 07-02-2019, 03:05 AM

RE: query problem - by hc-innov - 07-02-2019, 05:37 AM

RE: query problem - by midav - 07-02-2019, 07:12 AM

RE: query problem - by php_rocs - 07-02-2019, 08:01 AM

RE: query problem - by midav - 07-02-2019, 08:22 AM

RE: query problem - by php_rocs - 07-02-2019, 10:04 AM

RE: query problem - by midav - 07-04-2019, 05:48 AM

RE: query problem - by midav - 07-04-2019, 05:52 AM

RE: query problem - by hc-innov - 07-04-2019, 08:59 AM

RE: query problem - by neuron - 07-04-2019, 08:20 AM