gist: 24938


  
    
      SQL #
    
    
      
      
        embed
        
      
      
      
      raw
    
  
  
  
    
      
        
          
            
            1
2
3
4
5

          
          
            
              SELECT `articles`.*, `priorities`.position 
FROM `articles` 
LEFT OUTER JOIN `priorities` ON priorities.article_id = articles.id 
WHERE (`articles`.`status` = 1) 
ORDER BY priorities.position ASC, created_at DESC LIMIT 0, 20
Public Clone URL:	git://gist.github.com/24938.git Give this clone URL to anyone. `git clone git://gist.github.com/24938.git gist-24938`
Embed All Files:	show embed