Thanks for the advice last time folks, I think that one's working. Here's a tougher query, any ideas on how to speed this one up: SELECT DISTINCT badge.last_name AS last_name, badge.first_name AS first_name, badge.bid AS bid, badge.employee AS employee, badge_type.description AS type, badgests.cond_desc AS status, badge.pin AS pin, department.description AS department, facility.description AS facility, badge.expired_date AS expired_date, badge.expired_time AS expired_time, reader.description AS reader, area.description AS area, category.description AS category FROM badge, reader, area, category, badge_type, department, facility, badgests LEFT JOIN smccm_user_vs_permitted_department ON badge.dept = smccm_user_vs_permitted_department.permitted_department WHERE smccm_user_vs_permitted_department.smccm_user = 1 AND smccm_user_vs_permitted_department.permitted_department = department.id AND badge.type = badge_type.id AND badge.dept = department.id AND badge.facility = facility.id AND badge.status = badgests.id AND reader.area = area.id AND (badge.category1 = area.category1 OR badge.category1 = area.category2 OR badge.category1 = area.category3 OR badge.category1 = area.category4 OR badge.category1 = area.category5 OR badge.category1 = area.category6 OR badge.category1 = area.category7 OR badge.category1 = area.category8 OR badge.category1 = area.category9 OR badge.category1 = area.category10 OR badge.category2 = area.category1 OR badge.category2 = area.category2 OR badge.category2 = area.category3 OR badge.category2 = area.category4 OR badge.category2 = area.category5 OR badge.category2 = area.category6 OR badge.category2 = area.category7 OR badge.category2 = area.category8 OR badge.category2 = area.category9 OR badge.category2 = area.category10 OR badge.category3 = area.category1 OR badge.category3 = area.category2 OR badge.category3 = area.category3 OR badge.category3 = area.category4 OR badge.category3 = area.category5 OR badge.category3 = area.category6 OR badge.category3 = area.category7 OR badge.category3 = area.category8 OR badge.category3 = area.category9 OR badge.category3 = area.category10 OR badge.category4 = area.category1 OR badge.category4 = area.category2 OR badge.category4 = area.category3 OR badge.category4 = area.category4 OR badge.category4 = area.category5 OR badge.category4 = area.category6 OR badge.category4 = area.category7 OR badge.category4 = area.category8 OR badge.category4 = area.category9 OR badge.category4 = area.category10 OR badge.category5 = area.category1 OR badge.category5 = area.category2 OR badge.category5 = area.category3 OR badge.category5 = area.category4 OR badge.category5 = area.category5 OR badge.category5 = area.category6 OR badge.category5 = area.category7 OR badge.category5 = area.category8 OR badge.category5 = area.category9 OR badge.category5 = area.category10 OR badge.category6 = area.category1 OR badge.category6 = area.category2 OR badge.category6 = area.category3 OR badge.category6 = area.category4 OR badge.category6 = area.category5 OR badge.category6 = area.category6 OR badge.category6 = area.category7 OR badge.category6 = area.category8 OR badge.category6 = area.category9 OR badge.category6 = area.category10 OR badge.category7 = area.category1 OR badge.category7 = area.category2 OR badge.category7 = area.category3 OR badge.category7 = area.category4 OR badge.category7 = area.category5 OR badge.category7 = area.category6 OR badge.category7 = area.category7 OR badge.category7 = area.category8 OR badge.category7 = area.category9 OR badge.category7 = area.category10 OR badge.category8 = area.category1 OR badge.category8 = area.category2 OR badge.category8 = area.category3 OR badge.category8 = area.category4 OR badge.category8 = area.category5 OR badge.category8 = area.category6 OR badge.category8 = area.category7 OR badge.category8 = area.category8 OR badge.category8 = area.category9 OR badge.category8 = area.category10 OR badge.category9 = area.category1 OR badge.category9 = area.category2 OR badge.category9 = area.category3 OR badge.category9 = area.category4 OR badge.category9 = area.category5 OR badge.category9 = area.category6 OR badge.category9 = area.category7 OR badge.category9 = area.category8 OR badge.category9 = area.category9 OR badge.category9 = area.category10 OR badge.category10 = area.category1 OR badge.category10 = area.category2 OR badge.category10 = area.category3 OR badge.category10 = area.category4 OR badge.category10 = area.category5 OR badge.category10 = area.category6 OR badge.category10 = area.category7 OR badge.category10 = area.category8 OR badge.category10 = area.category9 OR badge.category10 = area.category10 OR badge.category11 = area.category1 OR badge.category11 = area.category2 OR badge.category11 = area.category3 OR badge.category11 = area.category4 OR badge.category11 = area.category5 OR badge.category11 = area.category6 OR badge.category11 = area.category7 OR badge.category11 = area.category8 OR badge.category11 = area.category9 OR badge.category11 = area.category10 OR badge.category12 = area.category1 OR badge.category12 = area.category2 OR badge.category12 = area.category3 OR badge.category12 = area.category4 OR badge.category12 = area.category5 OR badge.category12 = area.category6 OR badge.category12 = area.category7 OR badge.category12 = area.category8 OR badge.category12 = area.category9 OR badge.category12 = area.category10 OR badge.category13 = area.category1 OR badge.category13 = area.category2 OR badge.category13 = area.category3 OR badge.category13 = area.category4 OR badge.category13 = area.category5 OR badge.category13 = area.category6 OR badge.category13 = area.category7 OR badge.category13 = area.category8 OR badge.category13 = area.category9 OR badge.category13 = area.category10 OR badge.category14 = area.category1 OR badge.category14 = area.category2 OR badge.category14 = area.category3 OR badge.category14 = area.category4 OR badge.category14 = area.category5 OR badge.category14 = area.category6 OR badge.category14 = area.category7 OR badge.category14 = area.category8 OR badge.category14 = area.category9 OR badge.category14 = area.category10 OR badge.category15 = area.category1 OR badge.category15 = area.category2 OR badge.category15 = area.category3 OR badge.category15 = area.category4 OR badge.category15 = area.category5 OR badge.category15 = area.category6 OR badge.category15 = area.category7 OR badge.category15 = area.category8 OR badge.category15 = area.category9 OR badge.category15 = area.category10 OR badge.category16 = area.category1 OR badge.category16 = area.category2 OR badge.category16 = area.category3 OR badge.category16 = area.category4 OR badge.category16 = area.category5 OR badge.category16 = area.category6 OR badge.category16 = area.category7 OR badge.category16 = area.category8 OR badge.category16 = area.category9 OR badge.category16 = area.category10 OR badge.category17 = area.category1 OR badge.category17 = area.category2 OR badge.category17 = area.category3 OR badge.category17 = area.category4 OR badge.category17 = area.category5 OR badge.category17 = area.category6 OR badge.category17 = area.category7 OR badge.category17 = area.category8 OR badge.category17 = area.category9 OR badge.category17 = area.category10 OR badge.category18 = area.category1 OR badge.category18 = area.category2 OR badge.category18 = area.category3 OR badge.category18 = area.category4 OR badge.category18 = area.category5 OR badge.category18 = area.category6 OR badge.category18 = area.category7 OR badge.category18 = area.category8 OR badge.category18 = area.category9 OR badge.category18 = area.category10 OR badge.category19 = area.category1 OR badge.category19 = area.category2 OR badge.category19 = area.category3 OR badge.category19 = area.category4 OR badge.category19 = area.category5 OR badge.category19 = area.category6 OR badge.category19 = area.category7 OR badge.category19 = area.category8 OR badge.category19 = area.category9 OR badge.category19 = area.category10 OR badge.category20 = area.category1 OR badge.category20 = area.category2 OR badge.category20 = area.category3 OR badge.category20 = area.category4 OR badge.category20 = area.category5 OR badge.category20 = area.category6 OR badge.category20 = area.category7 OR badge.category20 = area.category8 OR badge.category20 = area.category9 OR badge.category20 = area.category10 OR badge.category21 = area.category1 OR badge.category21 = area.category2 OR badge.category21 = area.category3 OR badge.category21 = area.category4 OR badge.category21 = area.category5 OR badge.category21 = area.category6 OR badge.category21 = area.category7 OR badge.category21 = area.category8 OR badge.category21 = area.category9 OR badge.category21 = area.category10 OR badge.category22 = area.category1 OR badge.category22 = area.category2 OR badge.category22 = area.category3 OR badge.category22 = area.category4 OR badge.category22 = area.category5 OR badge.category22 = area.category6 OR badge.category22 = area.category7 OR badge.category22 = area.category8 OR badge.category22 = area.category9 OR badge.category22 = area.category10 OR badge.category23 = area.category1 OR badge.category23 = area.category2 OR badge.category23 = area.category3 OR badge.category23 = area.category4 OR badge.category23 = area.category5 OR badge.category23 = area.category6 OR badge.category23 = area.category7 OR badge.category23 = area.category8 OR badge.category23 = area.category9 OR badge.category23 = area.category10 OR badge.category24 = area.category1 OR badge.category24 = area.category2 OR badge.category24 = area.category3 OR badge.category24 = area.category4 OR badge.category24 = area.category5 OR badge.category24 = area.category6 OR badge.category24 = area.category7 OR badge.category24 = area.category8 OR badge.category24 = area.category9 OR badge.category24 = area.category10 OR badge.category25 = area.category1 OR badge.category25 = area.category2 OR badge.category25 = area.category3 OR badge.category25 = area.category4 OR badge.category25 = area.category5 OR badge.category25 = area.category6 OR badge.category25 = area.category7 OR badge.category25 = area.category8 OR badge.category25 = area.category9 OR badge.category25 = area.category10 OR badge.category26 = area.category1 OR badge.category26 = area.category2 OR badge.category26 = area.category3 OR badge.category26 = area.category4 OR badge.category26 = area.category5 OR badge.category26 = area.category6 OR badge.category26 = area.category7 OR badge.category26 = area.category8 OR badge.category26 = area.category9 OR badge.category26 = area.category10 OR badge.category27 = area.category1 OR badge.category27 = area.category2 OR badge.category27 = area.category3 OR badge.category27 = area.category4 OR badge.category27 = area.category5 OR badge.category27 = area.category6 OR badge.category27 = area.category7 OR badge.category27 = area.category8 OR badge.category27 = area.category9 OR badge.category27 = area.category10 OR badge.category28 = area.category1 OR badge.category28 = area.category2 OR badge.category28 = area.category3 OR badge.category28 = area.category4 OR badge.category28 = area.category5 OR badge.category28 = area.category6 OR badge.category28 = area.category7 OR badge.category28 = area.category8 OR badge.category28 = area.category9 OR badge.category28 = area.category10 OR badge.category29 = area.category1 OR badge.category29 = area.category2 OR badge.category29 = area.category3 OR badge.category29 = area.category4 OR badge.category29 = area.category5 OR badge.category29 = area.category6 OR badge.category29 = area.category7 OR badge.category29 = area.category8 OR badge.category29 = area.category9 OR badge.category29 = area.category10 OR badge.category30 = area.category1 OR badge.category30 = area.category2 OR badge.category30 = area.category3 OR badge.category30 = area.category4 OR badge.category30 = area.category5 OR badge.category30 = area.category6 OR badge.category30 = area.category7 OR badge.category30 = area.category8 OR badge.category30 = area.category9 OR badge.category30 = area.category10 OR badge.category31 = area.category1 OR badge.category31 = area.category2 OR badge.category31 = area.category3 OR badge.category31 = area.category4 OR badge.category31 = area.category5 OR badge.category31 = area.category6 OR badge.category31 = area.category7 OR badge.category31 = area.category8 OR badge.category31 = area.category9 OR badge.category31 = area.category10 OR badge.category32 = area.category1 OR badge.category32 = area.category2 OR badge.category32 = area.category3 OR badge.category32 = area.category4 OR badge.category32 = area.category5 OR badge.category32 = area.category6 OR badge.category32 = area.category7 OR badge.category32 = area.category8 OR badge.category32 = area.category9 OR badge.category32 = area.category10 OR badge.category1 = -1 OR badge.category2 = -1 OR badge.category3 = -1 OR badge.category4 = -1 OR badge.category5 = -1 OR badge.category6 = -1 OR badge.category7 = -1 OR badge.category8 = -1 OR badge.category9 = -1 OR badge.category10 = -1 OR badge.category11 = -1 OR badge.category12 = -1 OR badge.category13 = -1 OR badge.category14 = -1 OR badge.category15 = -1 OR badge.category16 = -1 OR badge.category17 = -1 OR badge.category18 = -1 OR badge.category19 = -1 OR badge.category20 = -1 OR badge.category21 = -1 OR badge.category22 = -1 OR badge.category23 = -1 OR badge.category24 = -1 OR badge.category25 = -1 OR badge.category26 = -1 OR badge.category27 = -1 OR badge.category28 = -1 OR badge.category29 = -1 OR badge.category30 = -1 OR badge.category31 = -1 OR badge.category32 = -1) Thanks, Mike B. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
