zend-blog-3-backend

1
CREATE VIEW `v_comments` AS
2
  SELECT
3
    c.id,
4
    c.parent_id,
5
    c.post_id,
6
    IF (c.user_id IS NULL, c.commentator_id, 10000000 + c.user_id) AS uid,
7
    IF (c.user_id IS NULL, t.name, u.username) AS username,
8
    IF (c.user_id IS NULL, t.mail, u.mail) AS mail,
9
    t.website,
10
    c.text,
11
    c.ip_addr,
12
    gci.city,
13
    gci.region,
14
    gci.latitude,
15
    gci.longitude,
16
    gci.time_zone,
17
    gco.country_name,
18
    gco.country_code,
19
    IF (c.user_id IS NULL, t.force_image, 1) AS force_image,
20
    c.deleted,
21
    c.time_created
22
  FROM comments AS c
23
    LEFT JOIN geo_location AS gl ON c.geo_location_id = gl.id
24
    LEFT JOIN geo_location_city AS gci ON gl.city_id = gci.id
25
    LEFT JOIN geo_location_country AS gco ON gci.country_id = gco.id
26
    LEFT JOIN commentators AS t ON c.commentator_id = t.id
27
    LEFT JOIN users AS u ON c.user_id = u.id
28