Michael Schmidt Posted August 7, 2019 Report Share Posted August 7, 2019 Hi, if I build and execute a query on the db itself, I get 7 results. People where the custom event field 15 does not exist. SELECT DISTINCT(tng_events.persfamID) FROM tng_events WHERE tng_events.persfamID NOT IN (SELECT tng_events.persfamID FROM tng_events LEFT JOIN tng_eventtypes ON tng_eventtypes.eventtypeID = tng_events.eventtypeID WHERE tng_eventtypes.eventtypeID <> "" AND tng_eventtypes.eventtypeID <> 15) However, if I select "advanced search" and search for "does not exist", I get 5 totaly different results - valid ones. The SQL-Query on the database gives correct answers - but not all of the results! The "advanced search" on the homepage itself gives correct answers - but not all of the results! Is there a way to display this SQL-Query, so I can spot & understand the difference? Or can somebody explain to me a "thought-error" I probably did? Thanks & Bye Michael Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.