There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `gender_amlanding_idx66059a166d715`.`value`='270' AND `gender_amlanding_idx6' at line 7, query was: SELECT DISTINCT `e`.`attribute_set_id` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '39'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 LEFT JOIN `catalog_product_index_eav` AS `producator_amlanding_idx66059a166d5af` ON producator_amlanding_idx66059a166d5af.entity_id = e.entity_id AND producator_amlanding_idx66059a166d5af.attribute_id = '81' AND producator_amlanding_idx66059a166d5af.store_id = 1 AND `producator_amlanding_idx66059a166d5af`.`value`='538'
 LEFT JOIN `catalog_product_index_eav` AS `sport_amlanding_idx66059a166d66e` ON sport_amlanding_idx66059a166d66e.entity_id = e.entity_id AND sport_amlanding_idx66059a166d66e.attribute_id = '234' AND sport_amlanding_idx66059a166d66e.store_id = 1 AND `sport_amlanding_idx66059a166d66e`.`value`='164'
 LEFT JOIN `catalog_product_index_eav` AS `gender_amlanding_idx66059a166d715` ON gender_amlanding_idx66059a166d715.entity_id = e.entity_id AND gender_amlanding_idx66059a166d715.attribute_id = '149' AND gender_amlanding_idx66059a166d715.store_id = 1 AND `gender_amlanding_idx66059a166d715`.`value`='270'
 LEFT JOIN `catalog_product_index_eav` AS `gender_amlanding_idx66059a166d7b0` ON gender_amlanding_idx66059a166d7b0.entity_id = e.entity_id AND gender_amlanding_idx66059a166d7b0.attribute_id = '149' AND gender_amlanding_idx66059a166d7b0.store_id = 1 AND `gender_amlanding_idx66059a166d7b0`.`value`='268' WHERE (e.status = 1) AND ((`producator_amlanding_idx66059a166d5af`.`value`='538' AND `sport_amlanding_idx66059a166d66e`.`value`='164' AND  AND `gender_amlanding_idx66059a166d715`.`value`='270' AND `gender_amlanding_idx66059a166d7b0`.`value`='268'))
Trace:

Error log record number: 457008723316