ROOT Ejecutando Query:
SELECT plan_phones.value, 
plans.id_file, files.name, 
plans.full_content, 
plan_properies.value as mensual, 
files.name AS ordenamiento, 
(SELECT a.value FROM plan_properies a WHERE a.id_plan = plans.id_plan AND a.name = 'prop_t_plan') AS tipo_plan 
   FROM plan_phones, phones, files, plans, plan_properies 
   WHERE phones.id_phone = 605 
 AND phones.id_file = plan_phones.id_phone 
 AND plan_phones.id_plan = plans.id_plan 
 AND plans.id_file = files.id_file 
 AND plan_properies.id_plan = plans.id_plan 
 AND plan_properies.name = 'prop_c_mensual' 
 ORDER BY tipo_plan, ordenamiento