zend-blog-3-backend
24 строки · 799.0 Байт
1CREATE VIEW `v_comments` AS
2SELECT
3c.id,
4c.parent_id,
5c.post_id,
6IF (c.user_id IS NULL, c.commentator_id, 10000000 + c.user_id) AS uid,
7IF (c.user_id IS NULL, t.name, u.username) AS username,
8IF (c.user_id IS NULL, t.mail, u.mail) AS mail,
9t.website,
10c.text,
11c.ip_addr,
12gci.city,
13gci.region,
14gco.country_name,
15IF (c.user_id IS NULL, t.email_hash, u.email_hash) AS email_hash,
16c.disqus_id,
17c.deleted,
18c.time_created
19FROM comments AS c
20LEFT JOIN geo_location AS gl ON c.geo_location_id = gl.id
21LEFT JOIN geo_location_city AS gci ON gl.city_id = gci.id
22LEFT JOIN geo_location_country AS gco ON gci.country_id = gco.id
23LEFT JOIN commentators AS t ON c.commentator_id = t.id
24LEFT JOIN users AS u ON c.user_id = u.id
25