zend-blog-3-backend
20 строк · 360.0 Байт
1CREATE VIEW `v_commentators` AS2SELECT3c.id,4c.name,5c.mail,6c.website,7c.force_image,8c.fake_email,9c.email_check10FROM commentators AS c11UNION ALL12SELECT1310000000 + u.id AS id,14u.username AS name,15u.mail,16NULL AS website,171 AS force_image,180 AS fake_email,19NULL AS email_check20FROM users AS u21