php - select query with 2 tables -

-

i have page people can post comments , page people can click "follow" on other people profiles (same on facebook)

i have select query post comments have, order them follow way: first, print 2 newest comments (they must been posted week) of lastest people click follow. second, post rest of posted, order them create-date

(i'm using linux time)

can me sql query?

this current select query. pull comment create-date:

 select id, userid, text, createdate `comments` comment (comment.refid = 0) , (comment.pagename = 'yard') , 1=1 order comment.createdate desc limit 0, 20

"followers" table looks this:

userid  ownerid     createdate 1       2           1439019657 1       4           1438940399

"comments" table looks loke this:

 id     userid  pagename    refid   text    createdate 220      1       yard       0       text1    1438030967 227      1       yard       0       text2    1438031704 228      1       yard       0       text3    1438031704

i might've messed followers' relations. example data looks incoplete full context. shows userid=1 comments sure, either no 1 follows userid=1 or both 3 , 4 follow him. no idea refid doing in comments table. query shows concept anyway - you'll figure out details.

select un.* ((     select 1 priority, comment.id, comment.userid, comment.text, comment.createdate     `comments` comment     inner join `followers` follower on follower.userid = comment.userid     comment.refid = 0       , comment.pagename = 'yard'       , ...     order follower.createdate desc limit 2 ) union distinct (     select 2 priority, id, userid, text, createdate     `comments` comment     comment.refid = 0       , comment.pagename = 'yard' )) un order un.priority, un.createdate desc limit 20

Comments

Post a Comment

Popular posts from this blog

php - Admin SDK -- get information about the group -

-
please, help. https://www.googleapis.com/admin/directory/v1/groups/106274944935548788283 sending request obtain information group id 1062 ... here link method in google https://developers.google.com/admin-sdk/directory/v1/guides/manage-groups#get_group in response error - 401 unauthorized. oauth authenticate via user has received rights necessary request, included in console admin sdk. authorization successful, there token. not can not understand. if not hard - response. requested information: file_get_contents("https://www.googleapis.com/admin/directory/v1/groups/1062749‌​44935548788283?key=aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4"); id group - "106274944935548788283" key applications in case - "aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4" error: failed open stream: http request failed! http/1.0 401 unauthorized
Read more

dns - How To Use Custom Nameserver On Free Cloudflare? -

-
i have problem. i own small hosting company. trying add cloudflare site free cdn. problem when sign have change nameservers nameservers. have nameserver dns set through godaddy, how add them cloudflare? main site uses company's nameservers whenever add them site goes offline. when go cloudflare's dns records click on dropdown, click ns, , there's 2 boxes 'name' , 'nameserver'. mean input 'ns1' 'name' , 'ns1.domain.com' 'nameserver'? input server's ip addresses? is there way of accomplishing free version of cloudflare? that impossible. option have custom name servers available on business , enterprise. see https://www.cloudflare.com/plans . also, might mistaken. must change name servers in domain register settings, not on cloudflare.
Read more

Python Error - TypeError: input expected at most 1 arguments, got 3 -

-
can explain why can not use your_name in goal variable? my_name = "bryson" my_age = 29 your_name = input ("what name? ") your_age = input ("what age? ") print ("my name is", my_name,", , am", my_age, "years old.") print ("your name is", your_name,", , are", your_age,".") print("thank buying book,", your_name,"!") goal = input ("what favorite part of book,", your_name, "?") print("awesome!") the error is: goal = input ("what favorite part of book,", your_name, "?") typeerror: input expected @ 1 arguments, got 3 you got error because in fact gave 3 arguments input function when expecting 1 (namely, string prompt). in input ("what favorite part of book,", your_name, "?") ---------------------------------------- , ---------, --- the underlined parts comma-separated arguments: st...
Read more