SELECT 
 * 

FROM 
 `user`
 
WHERE 
  NOT( ( `username` IS NULL ) OR ( `username` = '' ) ) 
 AND 
  IF( :role<>'', IF( :role='all', true, `role` = :role ), true )
	
ORDER BY
 `created` DESC
 
LIMIT 
 :limit 
 
OFFSET 
 :offset	