-----------------------------------------------
i am trying to get a set of random results from the database, then get another set using a different query later... however i do not want any results that were returned in the first query to display in the second
i have an ineffective way of doing this at the moment (below)... i am looking for a faster method
-----------------------------------------------
SELECT galleries.id FROM galleries, affiliate_sites, galleries_sites
WHERE galleries.affiliate_site_i
d = affiliate_sites.id AND galleries.status = 100 AND
galleries_sites.gallery_id = galleries.id AND ga
lleries_sites.thumb = 1 AND galleries_sites.site_id = '2' AND
galleries.id != '14721' AND galleries.id
!= '185965' AND galleries.id != '169449' AND galleries.id != '20821' AND
galleries.id != '80227' AND
galleries.id != '7815' AND galleries.id != '20016' AND galleries.id !=
'20775' AND galleries.id != '18
300' AND galleries.id != '5707' AND galleries.id != '30063' AND
galleries.id != '80789' AND galleries.
id != '60291' AND galleries.id != '84668' AND galleries.id != '86613' AND
galleries.id != '167557' AND
galleries.id != '36145' AND galleries.id != '66653' AND galleries.id !=
'107453' AND galleries.id !=
'70753' AND galleries.id != '78392' AND galleries.id != '77182' AND
galleries.id != '44846' AND galler
ies.id != '7044' AND galleries.id != '58965' AND galleries.id != '109172'
AND galleries.id != '142462'
AND galleries.id != '2135' AND galleries.id != '108995' AND galleries.id
!= '161289' AND galleries.id
!= '154829' AND galleries.id != '30050' AND galleries.id != '32134' AND
galleries.id != '131015' AND
galleries.id != '77178' AND galleries.id != '140455' AND galleries.id !=
'142970' AND galleries.id !=
'57692' AND galleries.id != '131444' AND galleries.id != '1842' AND
galleries.id != '49774' AND galler
ies.id != '105848' AND galleries.id != '27008' AND galleries.id !=
'40701' AND galleries.id != '140335
' AND galleries.id != '162665' AND galleries.id != '74236' AND
galleries.id != '120588' AND galleries.
id != '32404' AND galleries.id != '207137' AND galleries.id != '187229'
AND galleries.id != '113470' A
ND galleries.id != '148952' AND galleries.id != '66776' AND galleries.id
!= '78967' AND galleries.id !
= '124623' AND galleries.id != '28246' AND galleries.id != '35918' AND
galleries.id != '58603' AND gal
leries.id != '182776' AND galleries.id != '85066' AND galleries.id !=
'23964' AND galleries.id != '147
700' AND galleries.id != '27167' AND galleries.id != '174604' AND
galleries.id != '134066' AND galleri
es.id != '186102' AND galleries.id != '192020' AND galleries.id !=
'173715' AND galleries.id != '1890'
AND galleries.id != '190694' AND galleries.id != '38041' ORDER BY RAND()
LIMIT 50;