gistfile1.txt

SELECT If(MONTH(CachedProducts.date_release) = "00", 13, MONTH(CachedProducts.date_release)) month_release, If(Day(CachedProducts.date_release) = "00", 32, DAY(CachedProducts.date_release)) day_release, GROUP_CONCAT(Parameters.tag) AS tags, `ParametersIndices`.`id`, `CachedProducts`.`id`, `CachedProducts`.`id_big`, `CachedProducts`.`type_id`, `CachedProducts`.`subtype_id`, `CachedProducts`.`category_param_select_id`, `CachedProducts`.`title`, `CachedProducts`.`original_title`, `CachedProducts`.`slug`, `CachedProducts`.`year_of_production`, `CachedProducts`.`date_release`, `CachedProducts`.`rating`, `CachedProducts`.`rating_count`, `CachedProducts`.`rating_average`, `CachedProducts`.`collection_count`, `CachedProducts`.`recommend_count`, `CachedProducts`.`current_count`, `CachedProducts`.`done_count`, `CachedProducts`.`wish_list_count`, `CachedProducts`.`shopping_list_count`, `CachedProducts`.`review_count`, `CachedProducts`.`list_count`, `CachedProducts`.`json`, `CachedProducts`.`venue_count`, `CachedProducts`.`parent_1_id`, `CachedProducts`.`parent_2_id`, `CachedProducts`.`level_1`, `CachedProducts`.`level_2`, `CachedProducts`.`absolute_level` FROM `sc_param_index` AS `ParametersIndices` LEFT JOIN `sc_gen_product_fr_FR` AS `CachedProducts` ON `ParametersIndices`.`product_id_key` = `CachedProducts`.`id` LEFT JOIN `sc_param` AS `Parameters` ON `ParametersIndices`.`param_id` = `Parameters`.`id` LEFT JOIN `sc_param_index` AS `FrenchReleaseDate` ON `ParametersIndices`.`product_id_key` = `FrenchReleaseDate`.`product_id_key` AND `ParametersIndices`.`gen_subtype_id` = `FrenchReleaseDate`.`gen_subtype_id` WHERE `ParametersIndices`.`contact_id_value` = 26057 AND (`ParametersIndices`.`state` >= 0) AND `FrenchReleaseDate`.`param_id` = 7 AND (`FrenchReleaseDate`.`state` >= 0) AND CachedProducts.id IS NOT NULL AND (`ParametersIndices`.`gen_subtype_id` != 8) AND CachedProducts.subtype_id NOT IN (5, 32) GROUP BY `ParametersIndices`.`product_id_key` ORDER BY IF(GROUP_CONCAT(Parameters.tag) like "%distributors%",COALESCE(YEAR(FrenchReleaseDate.value_date),
								CachedProducts.year_of_production),coalesce(YEAR(CachedProducts.date_release),
								CachedProducts.year_of_production)) DESC, `month_release` DESC, `day_release` DESC LIMIT 15