Hi All, I have a problem in the advanced search query, there is no error but the query is taking a lot of time to run. i have given the query also, SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq WHERE sq.id = st.queue_id AND sq.g roup_id IN (1, 7) AND LOWER(st.customer_id) IN (LOWER('10093822'), LOWER('10093822') ) ORDER BY st.create_time _unix DESC LIMIT 50; Any help will be welcome, Regards, Veena --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time.