mysql query modification

SELECT table1.url FROM table1, table2 WHERE table1.linkid=table2.id AND
table1.type='xyz' AND table2.status IN( 'Yellow') AND
table2.request='"&test&"' ORDER BY table2.time DESC"

I am getting data from 2 tables by using a join
that works but the problem is the the column in table 1 "url" has links
in it as enteries
which are actually urls to different pages.
Now this url can be of 3 types- All urls are of type 1 ,2 or 3
1) http://host1/Report/report1.htm.gz
2)http://host2/Enviroinments/2007/Reports/report7856/index.h tml
3)http://host1/Report/report1.html.gz

My old query returns results with all the urls
I want to modify it to return only the htm.gz or html.gz urls
Any idea how this can be done

Thanks in advance