Jump to content
TNG Community
Sign in to follow this  
Michael Schmidt

Can someone explain these puzzling search-result to me?

Recommended Posts

Michael Schmidt

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×