SELECT proinvestor_posts.uid,subject,replyid,proinvestor_posts.threadid,posttime,rateup,ratedown,allrateup,allratedown,proinvestor_posts.postid,theme,lastreplytime,lastreplyuid,lastreplyusername,posts,views,language,posttype,plus,username,posttext FROM proinvestor_posts JOIN proinvestor_profiles USING(uid) WHERE proinvestor_posts.threadid IN(SELECT * FROM ( SELECT postid FROM proinvestor_posts WHERE replyid=0 ORDER BY posttime DESC LIMIT 0,25) as t) ORDER BY postid DESC;
Debat
Materialer
Konglomerater
Forbrug
Finans
Sundhed
Industri
Service
Teknologi
Infrastruktur
Alle
FA
TA
Makro
Lounge
Ny investor
Obligationer
Valuta
Pension
Bolig
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT proinvestor_posts.uid,subject,replyid,proinvestor_posts.threadid,posttime,rateup,ratedown,allrateup,allratedown,proinvestor_posts.postid,theme,lastreplytime,lastreplyuid,lastreplyusername,posts,views,language,posttype,plus,username FROM proinvestor_posts JOIN proinvestor_profiles USING(uid) WHERE proinvestor_posts.postid IN(SELECT * FROM ( SELECT postid FROM proinvestor_posts WHERE replyid=0 AND (DATEDIFF(NOW(),posttime)<40) ORDER BY allrateup DESC LIMIT 0,5) as t) ORDER BY allrateup DESC
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT proinvestor_posts.uid,subject,replyid,proinvestor_posts.threadid,posttime,rateup,ratedown,allrateup,allratedown,proinvestor_posts.postid,theme,lastreplytime,lastreplyuid,lastreplyusername,posts,views,language,posttype,plus,username FROM proinvestor_posts JOIN proinvestor_profiles USING(uid) WHERE proinvestor_posts.postid IN(SELECT * FROM ( SELECT postid FROM proinvestor_posts WHERE replyid=0 AND (DATEDIFF(NOW(),posttime)<40) ORDER BY views DESC LIMIT 0,5) as t) ORDER BY views DESC
SELECT proinvestor_posts.uid,subject,replyid,proinvestor_posts.threadid,posttime,rateup,ratedown,allrateup,allratedown,proinvestor_posts.postid,theme,lastreplytime,lastreplyuid,lastreplyusername,posts,views,language,posttype,plus,username FROM proinvestor_posts JOIN proinvestor_profiles USING(uid) WHERE proinvestor_posts.postid IN(SELECT * FROM ( SELECT postid FROM proinvestor_posts WHERE replyid=0 AND (DATEDIFF(NOW(),posttime)<40) ORDER BY allrateup DESC LIMIT 0,5) as t) ORDER BY allrateup DESC
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT proinvestor_posts.uid,subject,replyid,proinvestor_posts.threadid,posttime,rateup,ratedown,allrateup,allratedown,proinvestor_posts.postid,theme,lastreplytime,lastreplyuid,lastreplyusername,posts,views,language,posttype,plus,username FROM proinvestor_posts JOIN proinvestor_profiles USING(uid) WHERE proinvestor_posts.postid IN(SELECT * FROM ( SELECT postid FROM proinvestor_posts WHERE replyid=0 AND (DATEDIFF(NOW(),posttime)<40) ORDER BY views DESC LIMIT 0,5) as t) ORDER BY views DESC