<br />
SELECT
	GROUP_CONCAT(DISTINCT CONCAT(p.cod,'-',p.ordine,'-',IFNULL(po.ordine,'xx'),'-',p.promotional)) AS listaProduseSiOrdine,
	COUNT(DISTINCT p.cod) AS totalProduse
FROM mv_produse p

LEFT JOIN mv_produse_ordonare po ON (po.cod_produs=p.cod AND po.cod_categorie="578")
LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1)


			INNER JOIN (SELECT cod_produs FROM mv_specificatii_produse WHERE cod_specificatie=94 AND activ=1 AND sters!=1  AND valoare IN (11mmin15-Grand-Cherokee-WK2)) AS dMSUS94 ON sp.cod_produs=dMSUS94.cod_produs

WHERE p.vizibil=1 AND FIND_IN_SET("578",REPLACE(p.cod_categorie,'|',','))>0

 --> query<br /><pre>Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column '11mmin15' in 'WHERE'
)
Array
(
    [0] => 
SELECT
	GROUP_CONCAT(DISTINCT CONCAT(p.cod,'-',p.ordine,'-',IFNULL(po.ordine,'xx'),'-',p.promotional)) AS listaProduseSiOrdine,
	COUNT(DISTINCT p.cod) AS totalProduse
FROM mv_produse p

LEFT JOIN mv_produse_ordonare po ON (po.cod_produs=p.cod AND po.cod_categorie="578")
LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1)


			INNER JOIN (SELECT cod_produs FROM mv_specificatii_produse WHERE cod_specificatie=94 AND activ=1 AND sters!=1  AND valoare IN (11mmin15-Grand-Cherokee-WK2)) AS dMSUS94 ON sp.cod_produs=dMSUS94.cod_produs

WHERE p.vizibil=1 AND FIND_IN_SET("578",REPLACE(p.cod_categorie,'|',','))>0


)
</pre>