Since I don't think anyone answered my question I did find a combination
of queries that seemed to do the trick. In case anyone else might need to
know this is what I did.. please correct me if you see anything I did
wrong..
CREATE TEMPORARY TABLE tmp1 SELECT vc0.imageid FROM vote_count AS vc0 LE
I have a table:
CREATE TABLE vote_count (
id int(10) DEFAULT '0' NOT NULL auto_increment,
imageid int(6) DEFAULT '0' NOT NULL,
catid int(4) DEFAULT '0' NOT NULL,
count int(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX (imageid, catid)
);
and am