I hate responding to my self on a list, but I don't think I outlined the
problem clearly enough:
The article table data looks like this:
select * from articles;
+++
| id | active |
+++
| 1 | 1 |
+++
and the articles_attributes table looks like this:
This is my ugly solution:
SELECT
MAX(IF(articles_attribs.attrib_key='content', articles_attribs.
attrib_value, '')) AS content,
MAX(IF(articles_attribs.attrib_key='description', articles_attribs.
attrib_value, '')) AS description,
MAX(IF(articles_attribs.attrib_key='keyword', articles_attribs.