SELECT 
 * 

FROM 
 `comp`
 
WHERE 
  NOT( ( `name` IS NULL ) OR ( `name` = '' ) )
 
ORDER BY
 `updated` DESC
 
LIMIT 
 :limit 
 
OFFSET 
 :offset 