SELECT projects.*, projects.id as projects_id, projects_descriptions.title as title_projects, projects_descriptions.permalink as permalink_projects, clients.title as title_clients FROM projects join projects_descriptions on projects_descriptions.id_projects = projects.id join categories_relationships on categories_relationships.id_table_belongs_to = projects.id LEFT JOIN clients ON projects.id_clients = clients.id where categories_relationships.id_categories = 7 and categories_relationships.table_belongs_to = 'projects' and projects_descriptions.id_languages =1 and projects.active=1 and projects_descriptions.active = 1 and projects.trash = 0 order by projects.sort_order ASC