title: select comments from table with conditions
body: <p>I have page where people can post comments and page where people can click "follow" on other people profiles (same as LIKE on Facebook)</p>
  
  <p>I would like to have SELECT query that will post all the comments I have, but will order them with the follow way:
  first, print the 2 newest comments (they must been posted this week) of the lastest people you click FOLLOW (order by createDate).
  second, post the rest of the posted, order them by create-date.</p>
  
  <p>(I'm using linux time)
  2 emphasis:</p>
  
  <p>1.avoid duplicate comments is necessary...</p>
  
  <p>2.not everyone is following other users....</p>
  
  <p>Can you help me with the SQL query?</p>
  
  <p>this is my current SELECT query. it pull all comment by create-date:</p>
  
  <pre><code> SELECT id, userID, text, createDate FROM `comments` AS comment WHERE (comment.refID = 0) AND (comment.pageName = 'yard') ORDER BY comment.createDate DESC LIMIT 0, 20
  </code></pre>
  
  <p>"followers" table looks like this:</p>
  
  <pre><code>userID  ownerID     createDate
  1       2           1439019657
  1       4           1438940399
  </code></pre>
  
  <p>(In this case user 1 is following users 2 and 4. "createDate" = the date when userID start follow ownerID)</p>
  
  <p>"comments" table looks loke this:</p>
  
  <pre><code> id     userID  pageName    refID   text    createDate
  220      1       yard       0       text1    1438030967
  227      1       yard       0       text2    1438031704
  228      1       yard       0       text3    1438031704
  </code></pre>
  
  <p>(userID is the one who publish the post/comment. pageName always "yard" and refID always 0)</p>