SELECT DISTINCT s.school_id, s.language as primary_language, s.currency, language.xfi_language_value as language, language.language_value as language_id_en, s.school,s.school_country, s.school_city_general, c.course_name, s.csn, s.xfi_school_country as xschool_country, s.xfi_school_city_general as xschool_city_general, s.coordinate_1, s.coordinate_2, s.xfi_school_description as xschool_description, false as xmore_information, c.includes_accommodation, s.kasp_programme, s.exposure, s.exposure_most_popular, s.exposure_top_price, s.exposure_top_value, s.exposure_best_rated, s.exposure_most_popular_country, s.exposure_most_popular_city, s.exposure_top_leisure_country, s.exposure_top_leisure_city, s.exposure_best_price_country, s.exposure_best_price_city, s.exposure_best_rated_country, s.exposure_most_revs_city, s.commission_tuition, s.commission_accommodation, s.commission_other, s.commission_inscription_fee, (SELECT COUNT(*) FROM registration as r WHERE r.school_id = s.school_id AND r.appl_date >= '20160528') as num_registrations, (select COUNT(e.ev_overall*10) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_overall>0) limit 1) ev_number, (select ROUND(AVG(e.ev_overall*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_overall>0) limit 1) ev_overall, (select ROUND(AVG(e.ev_teaching*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_teaching>0) limit 1) ev_teaching, (select ROUND(AVG(e.ev_activity*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_activity>0) limit 1) ev_activity, c.course_cat, country.coordinate_1 countryX, country.coordinate_2 countryY, country.zoom countryZ, s.hometuition as hometuition, s.discount as discount, cy.max_students, cy.start_date_every, cy.starting_dates as xstarting_dates, c.min_level, cy.xfi_course_comments as xcourse_comments, s.minimum_age_children, s.junior_level_no_year, s.junior_level_no_summer, s.student_no_year_junior, s.student_no_summer_junior, s.leisure_free_juniors, s.leisure_paid_juniors, cy.exam_fee, cy.exam_dates, c.incl_accommo_type, c.incl_accommo_room_status, c.incl_accommo_meal, s.tuition_hour, s.student_no_summer, s.student_no_year, s.school_district, cy.time_afternoon_start, cy.time_afternoon_finish, c.exam_is_centre, s.tuition_hour as lesson_duration, image_name, IF (s.school_id IN (SELECT school_id FROM temp_top_schools),true,false) as top_school ,cur.currency_rate,cur.symbol as currency_rate_value, cur.currency_id as currency_id,cur_target.currency_rate as currency_target_rate, cur_target.symbol as currency_target_value,(SELECT yd.inscription_fee FROM year_data as yd WHERE yd.school_id=s.school_id and yd.year='2017' limit 1) as inscription_fee FROM school s LEFT JOIN country on (s.school_country = country.country) LEFT JOIN course1 c ON s.school_id=c.school_id and (c.course_cat='21' OR c.course_cat2='21') JOIN course_category cc ON (cc.course_category_id = c.course_cat OR (cc.course_category_id = c.course_cat2)) AND (cc.course_priority IS NOT NULL) LEFT JOIN course_categories_super ccs ON (ccs.super_id = cc.super_id) LEFT JOIN course_language c_lang ON ( c.course_id = c_lang.course_id )LEFT JOIN language ON (s.language = language.language) LEFT JOIN course_year cy on (c.course_id=cy.course_id AND cy.year='2017' AND cy.hours>='3') LEFT JOIN images img ON (img.school_id=s.school_id AND img.shown_in_search=1) left join currency cur on (s.currency = cur.currency_id) left join currency cur_target on (cur_target.currency_id = 1) WHERE s.school_city_general='vancouver' AND (IFNULL(s.discount,0)<3) AND forced_limited != 1 and cy.deleted != '1' and (cy.price_1week > 0 or cy.price_2weeks > 0 or cy.price_3weeks > 0 or cy.price_4weeks > 0 or cy.price_5weeks > 0 or cy.price_6weeks > 0 or cy.price_7weeks > 0 or cy.price_8weeks > 0 or cy.price_9weeks > 0 or cy.price_10weeks > 0 or cy.price_11weeks > 0 or cy.price_12weeks > 0 or (cy.price_custom_weeks > 0 and cy.addweek_valid > 0)) GROUP BY school_id ORDER BY school_country,school_city_general,school,ccs.super_priority, cc.course_prioritySELECT DISTINCT s.school_id, s.language as primary_language, s.currency, language.xfi_language_value as language, language.language_value as language_id_en, s.school,s.school_country, s.school_city_general, c.course_name, s.csn, s.xfi_school_country as xschool_country, s.xfi_school_city_general as xschool_city_general, s.coordinate_1, s.coordinate_2, s.xfi_school_description as xschool_description, false as xmore_information, c.includes_accommodation, s.kasp_programme, s.exposure, s.exposure_most_popular, s.exposure_top_price, s.exposure_top_value, s.exposure_best_rated, s.exposure_most_popular_country, s.exposure_most_popular_city, s.exposure_top_leisure_country, s.exposure_top_leisure_city, s.exposure_best_price_country, s.exposure_best_price_city, s.exposure_best_rated_country, s.exposure_most_revs_city, s.commission_tuition, s.commission_accommodation, s.commission_other, s.commission_inscription_fee, (SELECT COUNT(*) FROM registration as r WHERE r.school_id = s.school_id AND r.appl_date >= '20160528') as num_registrations, (select COUNT(e.ev_overall*10) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_overall>0) limit 1) ev_number, (select ROUND(AVG(e.ev_overall*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_overall>0) limit 1) ev_overall, (select ROUND(AVG(e.ev_teaching*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_teaching>0) limit 1) ev_teaching, (select ROUND(AVG(e.ev_activity*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_activity>0) limit 1) ev_activity, c.course_cat, country.coordinate_1 countryX, country.coordinate_2 countryY, country.zoom countryZ, s.hometuition as hometuition, s.discount as discount, cy.max_students, cy.start_date_every, cy.starting_dates as xstarting_dates, c.min_level, cy.xfi_course_comments as xcourse_comments, s.minimum_age_children, s.junior_level_no_year, s.junior_level_no_summer, s.student_no_year_junior, s.student_no_summer_junior, s.leisure_free_juniors, s.leisure_paid_juniors, cy.exam_fee, cy.exam_dates, c.incl_accommo_type, c.incl_accommo_room_status, c.incl_accommo_meal, s.tuition_hour, s.student_no_summer, s.student_no_year, s.school_district, cy.time_afternoon_start, cy.time_afternoon_finish, c.exam_is_centre, s.tuition_hour as lesson_duration, image_name, IF (s.school_id IN (SELECT school_id FROM temp_top_schools),true,false) as top_school ,cur.currency_rate,cur.symbol as currency_rate_value, cur.currency_id as currency_id,cur_target.currency_rate as currency_target_rate, cur_target.symbol as currency_target_value,(SELECT yd.inscription_fee FROM year_data as yd WHERE yd.school_id=s.school_id and yd.year='2017' limit 1) as inscription_fee FROM school s LEFT JOIN country on (s.school_country = country.country) LEFT JOIN course1 c ON s.school_id=c.school_id and (c.course_cat='21' OR c.course_cat2='21') JOIN course_category cc ON (cc.course_category_id = c.course_cat OR (cc.course_category_id = c.course_cat2)) AND (cc.course_priority IS NOT NULL) LEFT JOIN course_categories_super ccs ON (ccs.super_id = cc.super_id) LEFT JOIN course_language c_lang ON ( c.course_id = c_lang.course_id )LEFT JOIN language ON (s.language = language.language) LEFT JOIN course_year cy on (c.course_id=cy.course_id AND cy.year='2017' AND cy.hours>='3') LEFT JOIN images img ON (img.school_id=s.school_id AND img.shown_in_search=1) left join currency cur on (s.currency = cur.currency_id) left join currency cur_target on (cur_target.currency_id = 1) WHERE s.school_city_general='vancouver' AND (IFNULL(s.discount,0)<3) AND forced_limited != 1 and cy.deleted != '1' and (cy.price_1week > 0 or cy.price_2weeks > 0 or cy.price_3weeks > 0 or cy.price_4weeks > 0 or cy.price_5weeks > 0 or cy.price_6weeks > 0 or cy.price_7weeks > 0 or cy.price_8weeks > 0 or cy.price_9weeks > 0 or cy.price_10weeks > 0 or cy.price_11weeks > 0 or cy.price_12weeks > 0 or (cy.price_custom_weeks > 0 and cy.addweek_valid > 0)) GROUP BY school_id ORDER BY school_country,school_city_general,school,ccs.super_priority, cc.course_prioritySELECT DISTINCT s.school_id, s.language as primary_language, s.currency, language.xfi_language_value as language, language.language_value as language_id_en, s.school,s.school_country, s.school_city_general, c.course_name, s.csn, s.xfi_school_country as xschool_country, s.xfi_school_city_general as xschool_city_general, s.coordinate_1, s.coordinate_2, s.xfi_school_description as xschool_description, false as xmore_information, c.includes_accommodation, s.kasp_programme, s.exposure, s.exposure_most_popular, s.exposure_top_price, s.exposure_top_value, s.exposure_best_rated, s.exposure_most_popular_country, s.exposure_most_popular_city, s.exposure_top_leisure_country, s.exposure_top_leisure_city, s.exposure_best_price_country, s.exposure_best_price_city, s.exposure_best_rated_country, s.exposure_most_revs_city, s.commission_tuition, s.commission_accommodation, s.commission_other, s.commission_inscription_fee, (SELECT COUNT(*) FROM registration as r WHERE r.school_id = s.school_id AND r.appl_date >= '20160528') as num_registrations, (select COUNT(e.ev_overall*10) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_overall>0) limit 1) ev_number, (select ROUND(AVG(e.ev_overall*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_overall>0) limit 1) ev_overall, (select ROUND(AVG(e.ev_teaching*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_teaching>0) limit 1) ev_teaching, (select ROUND(AVG(e.ev_activity*10)) from evaluation as e WHERE (e.school_id=s.school_id and e.ev_activity>0) limit 1) ev_activity, c.course_cat, country.coordinate_1 countryX, country.coordinate_2 countryY, country.zoom countryZ, s.hometuition as hometuition, s.discount as discount, cy.max_students, cy.start_date_every, cy.starting_dates as xstarting_dates, c.min_level, cy.xfi_course_comments as xcourse_comments, s.minimum_age_children, s.junior_level_no_year, s.junior_level_no_summer, s.student_no_year_junior, s.student_no_summer_junior, s.leisure_free_juniors, s.leisure_paid_juniors, cy.exam_fee, cy.exam_dates, c.incl_accommo_type, c.incl_accommo_room_status, c.incl_accommo_meal, s.tuition_hour, s.student_no_summer, s.student_no_year, s.school_district, cy.time_afternoon_start, cy.time_afternoon_finish, c.exam_is_centre, s.tuition_hour as lesson_duration, image_name, IF (s.school_id IN (SELECT school_id FROM temp_top_schools),true,false) as top_school ,cur.currency_rate,cur.symbol as currency_rate_value, cur.currency_id as currency_id,cur_target.currency_rate as currency_target_rate, cur_target.symbol as currency_target_value,(SELECT yd.inscription_fee FROM year_data as yd WHERE yd.school_id=s.school_id and yd.year='2017' limit 1) as inscription_fee FROM school s LEFT JOIN country on (s.school_country = country.country) LEFT JOIN course1 c ON s.school_id=c.school_id and (c.course_cat='21' OR c.course_cat2='21') JOIN course_category cc ON (cc.course_category_id = c.course_cat OR (cc.course_category_id = c.course_cat2)) AND (cc.course_priority IS NOT NULL) LEFT JOIN course_categories_super ccs ON (ccs.super_id = cc.super_id) LEFT JOIN course_language c_lang ON ( c.course_id = c_lang.course_id )LEFT JOIN language ON (s.language = language.language) LEFT JOIN course_year cy on (c.course_id=cy.course_id AND cy.year='2017' AND cy.hours>='3') LEFT JOIN images img ON (img.school_id=s.school_id AND img.shown_in_search=1) left join currency cur on (s.currency = cur.currency_id) left join currency cur_target on (cur_target.currency_id = 1) WHERE s.school_city_general='vancouver' AND (IFNULL(s.discount,0)<3) AND forced_limited != 1 and cy.deleted != '1' and (cy.price_1week > 0 or cy.price_2weeks > 0 or cy.price_3weeks > 0 or cy.price_4weeks > 0 or cy.price_5weeks > 0 or cy.price_6weeks > 0 or cy.price_7weeks > 0 or cy.price_8weeks > 0 or cy.price_9weeks > 0 or cy.price_10weeks > 0 or cy.price_11weeks > 0 or cy.price_12weeks > 0 or (cy.price_custom_weeks > 0 and cy.addweek_valid > 0)) GROUP BY school_id ORDER BY school_country,school_city_general,school,ccs.super_priority, cc.course_priority
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/lib/schools.class.php:1366) in /var/www/html/etc/config.php on line 98

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/html/lib/evaluations.class.php on line 355

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /var/www/html/lib/evaluations.class.php on line 364
Cambridge First Certificate preppauskurssi kohteessa
X

Medioissa:
Android icon
+
Apple icon
+
VT app shown on tablet
+
VT app shown on mobile

Opi Englanti ilmaisella sovelluksellamme

+10.000.000 Latausta