SELECT SPIK.sku, SPI.id_site_products_item, SPIL.name, SPIL.name_rewrite, SPIK.id_site_products_color, SPIK.id_site_products_size FROM `site_products_items` SPI INNER JOIN `site_products_items_languages` SPIL ON SPI.id_site_products_item = SPIL.id_site_products_item LEFT JOIN `site_products_items_skus` SPIK ON SPI.id_site_products_item = SPIK.id_site_products_item INNER JOIN `site_products_items_related` SPIR ON SPIR.id_site_products_items_related = SPI.id_site_products_item WHERE SPI.status = 1 AND SPIL.status = 1 AND SPIL.id_language = 1 AND SPIK.status = 1 AND SPI.id_site_products_item != 97 AND SPIR.id_site_products_item = 97 GROUP BY SPI.id_site_products_item ORDER BY SPI.id_site_products_item ASC LIMIT 8