Oh boy, you are screwing the query royally. Use the joins as mentioned by gamyers.