Bug 842196 – Tag search SQL query should be changed from a bunch of IN() statments

Bug 842196 - Tag search SQL query should be changed from a bunch of IN() statments

Summary:	Tag search SQL query should be changed from a bunch of IN() statments

Status:	NEW

Aliases:	None

Product:	PressGang CCMS
Classification:	Community
Component:	Web-UI (Show other bugs)
Sub Component:
Version:	1.x
Hardware:	Unspecified Unspecified

Priority	unspecified Severity unspecified
Target Milestone:	---
Target Release:	---
Assigned To:	pressgang-ccms-dev
QA Contact:
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2012-07-22 22:34 EDT by Matthew Casperson
Modified:	2014-08-04 18:28 EDT (History)
CC List:	2 users (show)

See Also:
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Groups: None (edit)

Description Matthew Casperson 2012-07-22 22:34:44 EDT

This is an example of a more effecient select statment when querying for the existence of multiple children.

http://stackoverflow.com/questions/163887/sql-query-simulating-an-and-over-several-rows-instead-of-sub-querying#163907

Note You need to log in before you can comment on or make changes to this bug.