13 March 2009 - !false IT emo (original) (raw)

$sql = "SELECT a.*, GROUP_CONCAT(DISTINCT CONCAT(epl.lang_id,'|',epl.name)) as lang_names, etl.name as type_name,
GROUP_CONCAT(DISTINCT CONCAT(efl.edu_type_id,'|',efl.name)) as form_names, GROUP_CONCAT(DISTINCT CONCAT(esl.edu_type_id,'|',esl.name)) as spec_names,
(SELECT rl.name FROM regions_langs AS rl WHERE rl.region_id=a.city_id AND rl.version_id=".DEFAULT_LANG.") as city_name,
(SELECT rl.name FROM regions_langs AS rl WHERE rl.region_id=a.region_id AND rl.version_id=".DEFAULT_LANG.") as region_name,
(SELECT rl.name FROM regions_langs AS rl WHERE rl.region_id=a.country_id AND rl.version_id=".DEFAULT_LANG.") as country_name
FROM education_places AS a
LEFT JOIN education_places_langs AS epl ON a.edu_id=epl.edu_id
LEFT JOIN education_types_langs AS etl ON a.type_id=etl.type_id AND etl.lang_id=".DEFAULT_LANG."
LEFT JOIN education_forms_relations AS efr ON a.edu_id=efr.edu_id
LEFT JOIN education_forms_types_langs AS efl ON efl.edu_type_id=efr.edu_form_id AND efl.lang_id=".DEFAULT_LANG."
LEFT JOIN education_specialities_relations AS esr ON a.edu_id=esr.edu_id
LEFT JOIN education_specialities_types_langs AS esl ON esr.edu_type_id=esl.edu_type_id AND esl.lang_id=".DEFAULT_LANG."
WHERE a.edu_id=" .(int)$edu_id. "
GROUP BY a.edu_id

один мой очень эмоциональный друг написал этот запрос в знак непримерения с конформистами на своей работе, и как символ всей боли и всех страданий, всех несправедливостей в мире кодеров.... хотя вам наверное все равно... жестокий мир...