"EXPLAIN SELECT pp.art_num, pp.showprice as price, pc.custom_price, pc.custom_name, pc.custom_delivery, pd.instock, Stdnsv.Description FROM product_tags pt, products_prices pp, products_dists pd, filter_categories fc, product_linking pl  LEFT JOIN cds_Stdnsv Stdnsv ON (Stdnsv.ProdID = pp.art_num) LEFT JOIN products_custom pc ON (pc.art_num = pp.art_num) WHERE pp.art_num = pl.art_num AND pp.art_num = pd.art_num AND fc.filter_type_id = 1 AND fc.filter_id = pl.filter_id AND (Stdnsv.Description != 'None' OR Stdnsv.Description != '') AND (Stdnsv.Description LIKE '%Media%Center%' OR pl.art_num LIKE '%Media%Center%') GROUP BY pp.art_num ORDER BY pp.showprice DESC LIMIT 100"

+--------+--------+--------------------------+-----------+---------+--------------+-------+---------------------------------+
| table  | type   | possible_keys            | key       | key_len | ref          | rows  | Extra                           |
+--------+--------+--------------------------+-----------+---------+--------------+-------+---------------------------------+
| pp     | ALL    | PRIMARY,art_num          | NULL      |    NULL | NULL         |  8022 | Using temporary; Using filesort |
| pl     | ref    | art_num                  | art_num   |     100 | pp.art_num   |    10 |                                 |
| pd     | ref    | art_num                  | art_num   |     100 | pp.art_num   |    14 |                                 |
| fc     | ref    | filter_id,filter_type_id | filter_id |       4 | pl.filter_id |    12 | Using where                     |
| pt     | index  | NULL                     | PRIMARY   |       4 | NULL         | 65567 | Using index                     |
| Stdnsv | eq_ref | PRIMARY                  | PRIMARY   |      40 | pp.art_num   |     1 | Using where                     |
| pc     | eq_ref | PRIMARY,art_num          | PRIMARY   |     100 | pp.art_num   |     1 |                                 |
+--------+--------+--------------------------+-----------+---------+--------------+-------+---------------------------------+