0 -

SELECT * FROM synonymes as s INNER JOIN types as t ON s.synonymes_id=t.types_id_synonymes INNER JOIN products AS p ON p.products_description_short=t.types_value INNER JOIN products_to_categories AS ptc ON ptc.products_id = p.products_id and s.synonymes_id_categories=ptc.categories_id INNER JOIN categories AS cat ON cat.categories_id = ptc.categories_id INNER JOIN catalogs AS c ON p.products_saison = c.catalogs_saison AND p.products_doc = c.catalogs_doc AND "2015-07-06" BETWEEN c.catalogs_date_begin AND c.catalogs_date_end INNER JOIN univers AS u ON univers_id = INNER JOIN univers_products AS up ON u.univers_id = up.univers_id AND up.products_id = p.products_model WHERE synonymes_id_categories=85 GROUP BY types_id_synonymes ORDER BY s.ordre ASC