SELECT w1.service_date,w1.service_time,w1.service_note,w1.body_weight
,w1.height,w1.age_m,concat(p.pname,p.fname,' ',p.lname) AS person_name ,n.name AS nutrition_level_name
FROM person_wbc_service w1
LEFT OUTER JOIN person_wbc w2 ON w2.person_wbc_id = w1.person_wbc_id
LEFT OUTER JOIN person p ON p.person_id = w2.person_id
LEFT OUTER JOIN nutrition_level n ON n.nutrition_level = w1.nutrition_level
WHERE w1.service_date BETWEEN '2009-01-01' AND '2009-06-21'
ORDER BY w1.service_date,w1.service_time