user warning: Unknown column 'Cybernetics' in 'where clause'
query:
select
t1.institution_name,
p.prog_title,
p.prog_description,
p.prog_duration,
p.prog_entry_reqs,
p.prog_entry_reqs_gpa,
p.prog_app_process,
t.time_unit_name,
q.qualification_acronym,
q.qualification_name,
l.level_name,
m.study_mode_name
from
programmes p
left join time_units t on p.prog_timeunit=t.timeunit_id
left join qualifications q on p.prog_qualification=q.qualification_id
left join study_levels l on p.prog_study_level=l.level_id
left join study_modes m on p.prog_study_mode=m.mode_id
left join (
select
if(d.name='' or d.name='Default Department', c.full_name, d.name) as institution_name,
dp.programme_id
from
central_details c,
departments_faculties d,
department_has_programmes dp
where
d.department_id=dp.department_id and
d.master_id=c.master_id and
dp.programme_id=Cybernetics
group by
programme_id
) t1 on p.programme_id=t1.programme_id
where
p.programme_id=Cybernetics in /var/www/htdocs/drupal-tu/sites/all/modules/topuni_advancedform/topuni_advancedform.pages.inc on line 123.