Please enter the teacher's email address who will complete your LETTER OF RECOMMENDATION.
options:
path_info_key: PATH_INFO
path_info_array: SERVER
http_port: null
https_port: null
default_format: null
logging: '1'
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
no_script_name: false
parameterHolder:
action: recommendationTeacher
module: highschoolsandadvisors
attributeHolder:
sf_route: 'sfRoute Object()'
status:
code: 200
text: OK
options:
http_protocol: HTTP/1.0
logging: '1'
charset: utf-8
send_http_headers: false
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts:
/sfFormExtraPlugin/tiny_mce/tiny_mce.js: { }
/js/text-format.js: { }
/js/jquery.maskedinput.js: { }
stylesheets:
main.css: { }
flickrbomb.css: { }
metas:
title: 'High School Study Abroad | Spanish Immersion Programs | Sol Abroad'
description: 'SOL ABROAD provides affordable high school Study Abroad & Spanish Immersion programs. Academic programs in Spain, Costa Rica, Argentina & Mexico.'
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: null
default_culture: en
use_flash: true
logging: '1'
timeout: 1800
attributeHolder: { }
culture: en
authenticated: false
credentials: { }
lastRequest: 1464300428
app_azul_photo_gallery_settings:
Sample: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Director: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Destination: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Academic_Overview: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Excursion: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Cultural_Activity: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Volunteer_Program: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
City: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Homestay: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Alumni: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Homepage: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Alumni_Profile: { temp_upload_path: uploads/temp, upload_path: uploads/assests }
Testimonial_DP: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Announcement: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Schools_of_Record: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Custom_Program: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Country_Transcript: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Header_Photo: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Univ_Transcript: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
Destination_RP: { temp_upload_path: uploads/temp, upload_path: uploads/assets }
app_azul_photo_gallery_sizes:
thumbnail: { width: 100, height: 100 }
profile: { width: 200, height: 200 }
app_azul_video_gallery_settings:
- Sample
- Sample
- Cultural_Activity
- Volunteer_Program
- Academic_Overview
- Excursion
- Alumni
- Homepage
- Destination
app_server_env_conf: /home/uwptaik/new.solabroad.com/config/server_env.ini
app_server_env_vars_local:
db_name_app: uwptaik_sol_high_school
db_host: localhost
db_user: uwptaik_gaplabs
db_password: 2KsjdLKsl3skIehHrKd1245
mail_host: mail.soleducation.com
mail_username: [email protected]
mail_pass: ;KrB@rO7zy2h
frontend_url: 'https://www.solabroad.com'
app_server_env_vars_prod:
db_name_app: uwptaik_sol_high_school
db_host: localhost
db_user: uwptaik_gaplabs
db_password: 2KsjdLKsl3skIehHrKd1245
mail_host: mail.soleducation.com
mail_username: [email protected]
mail_pass: ;KrB@rO7zy2h
frontend_url: 'https://www.solabroad.com'
app_server_env_vars_staging:
db_name_app: uwptaik_sol_high_school
db_host: localhost
db_user: uwptaik_gaplabs
db_password: 2KsjdLKsl3skIehHrKd1245
mail_host: mail.soleducation.com
mail_username: [email protected]
mail_pass: ;KrB@rO7zy2h
frontend_url: 'https://www.solabroad.com'
app_tg_ssl_redirect_secure: null
app_tg_ssl_redirect_strict: true
mod_about_enabled: true
mod_about_view_class: sfPHP
mod_alumni_enabled: true
mod_alumni_view_class: sfPHP
mod_collegeprep_enabled: true
mod_collegeprep_view_class: sfPHP
mod_destinations_enabled: true
mod_destinations_view_class: sfPHP
mod_faq_enabled: true
mod_faq_view_class: sfPHP
mod_finance_enabled: true
mod_finance_view_class: sfPHP
mod_highschoolsandadvisors_enabled: true
mod_highschoolsandadvisors_view_class: sfPHP
mod_teachers_enabled: true
mod_teachers_view_class: sfPHP
mod_testimonials_enabled: true
mod_testimonials_view_class: sfPHP
mod_widget_enabled: true
mod_widget_view_class: sfPHP
sf_admin_module_web_dir: /sfPropelPlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend
sf_app_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend/dev
sf_app_config_dir: /home/uwptaik/new.solabroad.com/apps/frontend/config
sf_app_dir: /home/uwptaik/new.solabroad.com/apps/frontend
sf_app_i18n_dir: /home/uwptaik/new.solabroad.com/apps/frontend/i18n
sf_app_lib_dir: /home/uwptaik/new.solabroad.com/apps/frontend/lib
sf_app_module_dir: /home/uwptaik/new.solabroad.com/apps/frontend/modules
sf_app_template_dir: /home/uwptaik/new.solabroad.com/apps/frontend/templates
sf_apps_dir: /home/uwptaik/new.solabroad.com/apps
sf_cache: false
sf_cache_dir: /home/uwptaik/new.solabroad.com/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend/dev/config
sf_config_dir: /home/uwptaik/new.solabroad.com/config
sf_csrf_secret: 5251e083306b9a7984c8a66f59d84f7b3095efe9
sf_data_dir: /home/uwptaik/new.solabroad.com/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
- azulphotogallery
- azulvideogallery
- gapagination
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: error
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: false
sf_i18n_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend/dev/i18n
sf_lib_dir: /home/uwptaik/new.solabroad.com/lib
sf_log_dir: /home/uwptaik/new.solabroad.com/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: propel
sf_plugins_dir: /home/uwptaik/new.solabroad.com/plugins
sf_root_dir: /home/uwptaik/new.solabroad.com
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- Cache
sf_symfony_lib_dir: /home/uwptaik/new.solabroad.com/vendor/symfony-1.4.15/lib
sf_template_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend/dev/template
sf_test_cache_dir: /home/uwptaik/new.solabroad.com/cache/frontend/dev/test
sf_test_dir: /home/uwptaik/new.solabroad.com/test
sf_upload_dir: /home/uwptaik/new.solabroad.com/web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/uwptaik/new.solabroad.com/web
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true
symfony.view.slot_names: { }
cookie: { }
env:
CONTEXT_DOCUMENT_ROOT: /home/uwptaik/public_html
CONTEXT_PREFIX: ''
DOCUMENT_ROOT: /home/uwptaik/public_html
GATEWAY_INTERFACE: CGI/1.1
HTTP_CONNECTION: close
HTTP_FROM: [email protected]
HTTP_HOST: www.solabroad.com
HTTP_USER_AGENT: ia_archiver
PATH: '/bin:/usr/bin'
PATH_INFO: /teacher-email-recommendation
PATH_TRANSLATED: /home/uwptaik/public_html/frontend_dev.php
QUERY_STRING: ''
REDIRECT_STATUS: '200'
REMOTE_ADDR: 174.129.237.157
REMOTE_PORT: '45847'
REQUEST_METHOD: GET
REQUEST_SCHEME: http
REQUEST_URI: /frontend_dev.php/teacher-email-recommendation
SCRIPT_FILENAME: /home/uwptaik/public_html/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 208.76.84.124
SERVER_ADMIN: [email protected]
SERVER_NAME: www.solabroad.com
SERVER_PORT: '80'
SERVER_PROTOCOL: HTTP/1.0
SERVER_SIGNATURE: "<address>Apache/2.4.12 (Unix) OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 Server at www.solabroad.com Port 80</address>\n"
SERVER_SOFTWARE: 'Apache/2.4.12 (Unix) OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4'
UNIQUE_ID: V0dzjNBMVHAAAB2V9BAAAAAB
files: { }
get: { }
post: { }
server:
CONTEXT_DOCUMENT_ROOT: /home/uwptaik/public_html
CONTEXT_PREFIX: ''
DOCUMENT_ROOT: /home/uwptaik/public_html
GATEWAY_INTERFACE: CGI/1.1
HTTP_CONNECTION: close
HTTP_FROM: [email protected]
HTTP_HOST: www.solabroad.com
HTTP_USER_AGENT: ia_archiver
PATH: '/bin:/usr/bin'
PATH_INFO: /teacher-email-recommendation
PATH_TRANSLATED: /home/uwptaik/public_html/frontend_dev.php
PHP_SELF: /frontend_dev.php/teacher-email-recommendation
QUERY_STRING: ''
REDIRECT_STATUS: '200'
REMOTE_ADDR: 174.129.237.157
REMOTE_PORT: '45847'
REQUEST_METHOD: GET
REQUEST_SCHEME: http
REQUEST_TIME: 1464300428
REQUEST_URI: /frontend_dev.php/teacher-email-recommendation
SCRIPT_FILENAME: /home/uwptaik/public_html/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 208.76.84.124
SERVER_ADMIN: [email protected]
SERVER_NAME: www.solabroad.com
SERVER_PORT: '80'
SERVER_PROTOCOL: HTTP/1.0
SERVER_SIGNATURE: "<address>Apache/2.4.12 (Unix) OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 Server at www.solabroad.com Port 80</address>\n"
SERVER_SOFTWARE: 'Apache/2.4.12 (Unix) OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4'
UNIQUE_ID: V0dzjNBMVHAAAB2V9BAAAAAB
argc: 0
argv: { }
session: { }
php: 5.3.29 os: 'Linux dedicated146.tchmachines.com 2.6.18-371.12.1.el5PAE #1 SMP Wed Sep 3 17:06:41 EDT 2014 i686' extensions: 8: bcmath 9: bz2 10: calendar 48: cgi-fcgi 0: 'Core (5.3.29)' 11: ctype 12: curl 1: 'date (5.3.29)' 13: 'dom (20031129)' 2: ereg 39: 'exif (1.4 $Id$)' 52: 'fileinfo (0.1)' 15: 'filter (0.11.0)' 16: ftp 17: gd 18: gettext 14: 'hash (1.0)' 20: iconv 49: 'igbinary (1.2.1)' 33: imap 53: 'ionCube Loader' 22: 'json (1.2.1)' 3: libxml 23: mbstring 24: mcrypt 51: 'memcache (2.2.7)' 25: 'mysql (1.0)' 26: 'mysqli (0.1)' 4: openssl 5: pcre 28: 'PDO (1.0.4dev)' 29: 'pdo_mysql (1.0.2)' 30: 'pdo_sqlite (1.0.1)' 50: 'Phar (2.0.0)' 31: posix 32: 'Reflection ($Id: 4af6c4c676864b1c0bfa693845af0688645c37cf $)' 21: session 34: 'SimpleXML (0.1)' 35: snmp 36: soap 37: sockets 19: 'SPL (0.2)' 38: 'SQLite (2.0-dev)' 6: 'sqlite3 (0.7-dev)' 27: 'standard (5.3.29)' 40: 'tokenizer (0.1)' 41: wddx 42: xml 43: 'xmlreader (0.1)' 44: 'xmlrpc (0.51)' 45: 'xmlwriter (0.1)' 46: 'xsl (0.1)' 54: 'Zend Guard Loader' 47: 'zip (1.11.0)' 7: 'zlib (1.1)'
version: 1.4.15 path: /home/uwptaik/new.solabroad.com/vendor/symfony-1.4.15/lib
Parameters:
No parameters were passed to this template.
Parameters:
$links (array)Parameters:
$type (string)$content (GeneralContentSection)No parameters were passed to this template.
No parameters were passed to this template.
Parameters:
$route (string)$countryDestinations (array)$countryID (integer)Parameters:
$selectedTab (string)Parameters:
$route (string)$countryDestinations (array)$countryID (integer)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$route (string)$countryDestinations (array)$countryID (integer)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)Parameters:
$selectedTab (string)No parameters were passed to this template.
| # | type | message |
|---|---|---|
| 1 | sfPatternRouting | Match route "email_recommendation" (/teacher-email-recommendation) for /teacher-email-recommendation with parameters array ( 'module' => 'highschoolsandadvisors', 'action' => 'recommendationTeacher',) |
| 2 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 3 | sfFilterChain | Executing filter "tgSslRedirectFilter" |
| 4 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 5 | highschoolsandadvisorsActions | Call "highschoolsandadvisorsActions->executeRecommendationTeacher()" |
| 6 | sfPHPView | Render "sf_app_dir/modules/highschoolsandadvisors/templates/recommendationTeacherSuccess.php" |
| 7 | main | Set slot "selectedMainTab" |
| 8 | main | Set slot "mainContent" |
| 9 | sfPartialView | Render "sf_app_dir/modules/highschoolsandadvisors/templates/_notification.php" |
| 10 | main | Call "widget->executeBreadcrumbs()" |
| 11 | sfPartialView | Render "sf_app_dir/modules/widget/templates/_breadcrumbs.php" |
| 12 | main | Call "alumni->executeContent()" |
| 13 | sfPropelLogger | time: 0.000 sec | slow: NO | mem: 7.3 MB | mempeak: 7.3 MB | memdelta: 0.0 B | SET NAMES 'utf8' |
| 14 | sfPropelLogger | time: 0.000 sec | slow: NO | mem: 7.3 MB | mempeak: 7.3 MB | memdelta: 0.0 B | SELECT general_content_section.ID, general_content_section.CONTENT, general_content_section.SECTION_TYPE FROM `general_content_section` WHERE general_content_section.SECTION_TYPE='9' LIMIT 1 |
| 15 | sfPartialView | Render "sf_app_dir/modules/alumni/templates/_content.php" |
| 16 | sfPartialView | Render "sf_app_dir/templates/_frontendLayout.php" |
| 17 | main | Get slot "selectedMainTab" |
| 18 | sfPartialView | Render "sf_app_dir/templates/_socialBarHeader.php" |
| 19 | main | Call "destinations->executeDestinationsList()" |
| 20 | sfPropelLogger | time: 0.000 sec | slow: NO | mem: 8.0 MB | mempeak: 8.0 MB | memdelta: 0.0 B | SELECT country.ID, country.NAME FROM `country`, `destination` WHERE country.ID=destination.COUNTRY_ID |
| 21 | sfPartialView | Render "sf_app_dir/modules/destinations/templates/_destinationsList.php" |
| 22 | main | Call "collegeprep->executeSideNavigationList()" |
| 23 | sfPartialView | Render "sf_app_dir/modules/collegeprep/templates/_sideNavigationList.php" |
| 24 | main | Call "destinations->executeDestinationsList()" |
| 25 | sfPropelLogger | time: 0.000 sec | slow: NO | mem: 9.5 MB | mempeak: 9.5 MB | memdelta: 0.0 B | SELECT country.ID, country.NAME FROM `country`, `destination` WHERE country.ID=destination.COUNTRY_ID |
| 26 | sfPartialView | Render "sf_app_dir/modules/destinations/templates/_destinationsList.php" |
| 27 | main | Call "finance->executeSideNavigationList()" |
| 28 | sfPartialView | Render "sf_app_dir/modules/finance/templates/_sideNavigationList.php" |
| 29 | main | Call "testimonials->executeSideNavigationList()" |
| 30 | sfPartialView | Render "sf_app_dir/modules/testimonials/templates/_sideNavigationList.php" |
| 31 | main | Call "faq->executeSideNavigationList()" |
| 32 | sfPartialView | Render "sf_app_dir/modules/faq/templates/_sideNavigationList.php" |
| 33 | main | Call "teachers->executeSideNavigationList()" |
| 34 | sfPartialView | Render "sf_app_dir/modules/teachers/templates/_sideNavigationList.php" |
| 35 | main | Call "alumni->executeSideNavigationList()" |
| 36 | sfPartialView | Render "sf_app_dir/modules/alumni/templates/_sideNavigationList.php" |
| 37 | main | Call "about->executeSideNavigationList()" |
| 38 | sfPartialView | Render "sf_app_dir/modules/about/templates/_sideNavigationList.php" |
| 39 | main | Get slot "mainContent" |
| 40 | main | Call "collegeprep->executeSideNavigationList()" |
| 41 | sfPartialView | Render "sf_app_dir/modules/collegeprep/templates/_sideNavigationList.php" |
| 42 | main | Call "destinations->executeDestinationsList()" |
| 43 | sfPropelLogger | time: 0.000 sec | slow: NO | mem: 9.5 MB | mempeak: 9.8 MB | memdelta: 0.0 B | SELECT country.ID, country.NAME FROM `country`, `destination` WHERE country.ID=destination.COUNTRY_ID |
| 44 | sfPartialView | Render "sf_app_dir/modules/destinations/templates/_destinationsList.php" |
| 45 | main | Call "finance->executeSideNavigationList()" |
| 46 | sfPartialView | Render "sf_app_dir/modules/finance/templates/_sideNavigationList.php" |
| 47 | main | Call "testimonials->executeSideNavigationList()" |
| 48 | sfPartialView | Render "sf_app_dir/modules/testimonials/templates/_sideNavigationList.php" |
| 49 | main | Call "faq->executeSideNavigationList()" |
| 50 | sfPartialView | Render "sf_app_dir/modules/faq/templates/_sideNavigationList.php" |
| 51 | main | Call "teachers->executeSideNavigationList()" |
| 52 | sfPartialView | Render "sf_app_dir/modules/teachers/templates/_sideNavigationList.php" |
| 53 | main | Call "alumni->executeSideNavigationList()" |
| 54 | sfPartialView | Render "sf_app_dir/modules/alumni/templates/_sideNavigationList.php" |
| 55 | main | Call "about->executeSideNavigationList()" |
| 56 | sfPartialView | Render "sf_app_dir/modules/about/templates/_sideNavigationList.php" |
| 57 | main | Call "faq->executeSideNavigationList()" |
| 58 | sfPartialView | Render "sf_app_dir/modules/faq/templates/_sideNavigationList.php" |
| 59 | sfPartialView | Render "sf_app_dir/templates/_socialBar.php" |
| 60 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 61 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 62 | sfWebResponse | Send status "HTTP/1.0 200 OK" |
| 63 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 51 | 339.52 | 73 |
| Factories | 1 | 19.13 | 4 |
| Action "highschoolsandadvisors/recommendationTeacher" | 1 | 9.33 | 2 |
| View "Success" for "highschoolsandadvisors/recommendationTeacher" | 1 | 397.98 | 86 |
| Partial "highschoolsandadvisors/_notification" | 1 | 0.33 | 0 |
| Component "widget/breadcrumbs" | 1 | 0.01 | 0 |
| Partial "widget/_breadcrumbs" | 1 | 0.57 | 0 |
| Component "alumni/content" | 1 | 8.35 | 1 |
| Partial "alumni/_content" | 1 | 0.37 | 0 |
| Partial "global/_frontendLayout" | 1 | 41.17 | 8 |
| Partial "global/_socialBarHeader" | 1 | 0.31 | 0 |
| Component "destinations/destinationsList" | 3 | 13.73 | 2 |
| Partial "destinations/_destinationsList" | 3 | 2.18 | 0 |
| Component "collegeprep/sideNavigationList" | 2 | 0.02 | 0 |
| Partial "collegeprep/_sideNavigationList" | 2 | 0.84 | 0 |
| Component "finance/sideNavigationList" | 2 | 0.02 | 0 |
| Partial "finance/_sideNavigationList" | 2 | 0.78 | 0 |
| Component "testimonials/sideNavigationList" | 2 | 0.02 | 0 |
| Partial "testimonials/_sideNavigationList" | 2 | 1.03 | 0 |
| Component "faq/sideNavigationList" | 3 | 0.03 | 0 |
| Partial "faq/_sideNavigationList" | 3 | 1.48 | 0 |
| Component "teachers/sideNavigationList" | 2 | 0.02 | 0 |
| Partial "teachers/_sideNavigationList" | 2 | 1.07 | 0 |
| Component "alumni/sideNavigationList" | 2 | 0.02 | 0 |
| Partial "alumni/_sideNavigationList" | 2 | 1.11 | 0 |
| Component "about/sideNavigationList" | 2 | 0.02 | 0 |
| Partial "about/_sideNavigationList" | 2 | 1.27 | 0 |
| Partial "global/_socialBar" | 1 | 0.30 | 0 |
SET NAMES 'utf8'
SELECT general_content_section.ID, general_content_section.CONTENT, general_content_section.SECTION_TYPE FROM `general_content_section` WHERE general_content_section.SECTION_TYPE='9' LIMIT 1
SELECT country.ID, country.NAME FROM `country`, `destination` WHERE country.ID=destination.COUNTRY_ID
SELECT country.ID, country.NAME FROM `country`, `destination` WHERE country.ID=destination.COUNTRY_ID
SELECT country.ID, country.NAME FROM `country`, `destination` WHERE country.ID=destination.COUNTRY_ID