or download this
(SELECT me.id, me.bu_id, me.description, me.contact_name, me.contact_p
+hone, me.contact_email, me.creation_ts, (SELECT COUNT( * ) FROM custo
+mer you INNER JOIN box boxes ON boxes.customer_id = you.id INNER JOIN
+ device devices ON devices.box_id = boxes.id WHERE ( you.id = me.id )
+) FROM customer me)