Skip to main content

Query 3

Image
By
SELECT count(*) as cnt FROM (
SELECT job_mail.*,
CASE WHEN nuser.mail IS NOT NULL THEN nuser.mail
WHEN cuser.mail IS NOT NULL THEN cuser.mail
WHEN admin.mail IS NOT NULL THEN admin.mail
ELSE consultant.mail END AS mail,

CASE WHEN nuser.nick_name IS NOT NULL THEN nuser.nick_name
WHEN cuser.nick_name IS NOT NULL THEN cuser.nick_name
WHEN admin.name IS NOT NULL THEN admin.name
ELSE consultant.nick_name END AS nick_name,
topic.subject,private_message.content,private_message.author_id,private_message_user.user_id

FROM job_mail
left join topic on job_mail.topic_id = topic.id
left join private_message on job_mail.item_id = private_message.id
left join private_message_user on private_message.id = private_message_user.pm_id
left join nuser on private_message_user.user_id = nuser.id
left join cuser on private_message_user.user_id = cuser.id
left join consultant on private_message_user.user_id = consultant.id
left join admin on private_message_user.user_id = admin.id

WHERE (private_message_user.is_draft = 0 and private_message_user.is_read = 0
and job_mail.template != 'ADD_USER' and job_mail.status = 'waiting' and job_mail.id = 'JM0000052')
) as result_table

Comments

Post a Comment

Popular posts from this blog

Rand mm 10

By
https://stackoverflow.com/questions/2447791/define-vs-const Oh const vs define, many time I got unexpected interview question. As this one, I do not know much or try to study this. My work flow, and I believe of many programmer is that search topic only when we have task or job to tackle. We ignore many 'basic', 'fundamental' documents, RTFM is boring. So I think it is a trade off between the two way of study language. And I think there are a bridge or balanced way to extract both advantage of two method. There are some huge issue with programmer like me that prevent we master some technique that take only little time if doing properly. For example, some Red Hat certificate program, lesson, course that I have learned during Collage gave our exceptional useful when it cover almost all topic while working with Linux. I remember it called something like RHEL (RedHat Enterprise Linux) Certificate... I think there are many tons of documents, guide n books about Linux bu
Post a Comment
Read more

Martin Fowler - Software Architecture - Making Architecture matter

By
  https://martinfowler.com/architecture/ One can appreciate the point of this presentation when one's sense of code smell is trained, functional and utilized. Those controlling the budget as well as developer leads should understand the design stamina hypothesis, so that the appropriate focus and priority is given to internal quality - otherwise pay a high price soon. Andrew Farrell 8 months ago I love that he was able to give an important lesson on the “How?” of software architecture at the very end: delegate decisions to those with the time to focus on them. Very nice and straight-forward talk about the value of software architecture For me, architecture is the distribution of complexity in a system. And also, how subsystems communicate with each other. A battle between craftmanship and the economics and economics always win... https://hackernoon.com/applying-clean-architecture-on-web-application-with-modular-pattern-7b11f1b89011 1. Independent of Frameworks 2. Testable 3. Indepe
Post a Comment
Read more