anonimowy blog

Kilka dni temu musiałem przygotować pewną bazę danych i pojawiło się gigant zapytanie

Mam watpliwości czy jest to wyjście najlepsze.

 
A oto i zapytanie:
 

CREATE VIEW v_daemon AS \
SELECT mail_accounts.id AS id , \
mail_accounts.user_name AS account , \
v_domain_real.domain AS domain , \
mail_accounts.passwd_crypt AS passwd_crypt , \
mail_accounts.passwd_plain AS passwd_plain , \
mail_accounts.uid AS uid , \
mail_accounts.gid AS gid , \
CONCAT(mail_accounts.user_name,'@',v_domain_real.domain) AS email , \
mail_accounts.homedir AS homedir , \
mail_accounts.fullname AS fullname , \
mail_accounts.maildir AS maildir , \
IF(quota_space.value !='0',CONCAT(quota_space.value,'MB'),quota_space.value) AS quota , \
mail_accounts.locked AS locked \
FROM mail_accounts JOIN ( v_domain_real , quota_space ) \
ON ( mail_accounts.domain_id = v_domain_real.id AND mail_accounts.quota_limit = quota_space.id ) \
WHERE mail_accounts.exp_date > NOW() \
AND mail_accounts.active = '1' \
AND mail_accounts.alias_value = '' ;