Server shutdown in progress<br /><br /><br />
        SELECT<br />
          value, value AS name, COUNT(id) AS total<br />
        FROM<br />
          eshop_attributes<br />
          WHERE<br />
          (id_language=1 OR id_language IS NULL) AND name='color' AND value>0 AND id_article IN (SELECT id FROM eshop_articles WHERE published=1) GROUP BY value<br />
        <br />
          ORDER BY value<br />
        <br />
          <br />
          <br />
        ;<br />