SELECT t1. *,
       cc.name AS category_name
FROM (SELECT c. *,
             a.name AS `owner`
      FROM clip c
           LEFT JOIN `admin` a ON c.admin_id = a.id) t1
     LEFT JOIN clip_category cc ON t1.category_id = cc.id;

Formated by http://www.sql-workbench.net/