select widget_website.id as ID, widget_website.widget_id as wID, coalesce(widget_website.title, widget.title) as title, coalesce(widget_website.description, widget.description) as description, coalesce(widget_website.image, widget.image) as image, coalesce(widget_website.img_title, widget.img_title) as img_title, coalesce(widget_website.img_alt, widget.img_alt) as img_alt, coalesce(widget.link_url, widget_website.link_url) as url, coalesce(widget.link_text, widget_website.link_text) as link_text, coalesce(widget.link_title, widget_website.link_title) as link_title, (select count(widget.id) from widget inner join widget_website on widget.id = widget_website.widget_id where widget_website.website_id = 37) as wCount from widget_website inner join widget on widget_website.widget_id = widget.id where widget_website.website_id = 37 Automotive Picture Gallery | Chip's Transmissions