如何结合这两个查询？

Question

SELECT htpid AS parentid 
    FROM likehot WHERE htpid 
    IN (SELECT id FROM bultin WHERE  DATE  >= '1317108749') 
    GROUP BY htpid ORDER BY COUNT( htpid ) 
    DESC

giving result

parentid
16060
16059
16058
16057

and other query

SELECT app_id,bultin.id,photo_album_id,entcmmnt_id,link_url,youtubeLink,
       link_image,id, mem_id, subj, body, bultin.date,parentid, 
       from_id, visible_to, image_link,post_via 
FROM bultin 
WHERE id IN ('16062','16059','16058','16057') 
ORDER BY FIELD('16062','16059','16058','16057') 
LIMIT 5

Actually I wanted the same sequence as that of in IN so I used FIELD operator

Please Suggest thanks

Answer 1

I couldn't Understand Your Question.. If You Can Please Explain it a better way.. I can gave you the Solution.. Wel I would like to say that u can not use more then one value in side the First Query "SELECT id FROM bultin WHERE DATE >= '1317108749')". And One more thing Y don't u use the values in the ist query like this

SELECT htpid AS parentid FROM likehot WHERE htpid IN (16062','16059','16058','16057')