gistfile1.sql

SELECT * FROM shops WHERE 
( 
  SELECT management_division_value 
  FROM shop_management_divisions 
  WHERE management_division_id = 7 AND shop_management_divisions.shop_id = shops.id
) = 1 AND
( 
  SELECT management_division_value 
  FROM shop_management_divisions 
  WHERE management_division_id = 8 AND shop_management_divisions.shop_id = shops.id
) = 4

a = ShopManagementDivision.where(:management_division_id => 7,:management_division_value => 1)
b = ShopManagementDivision.where(:management_division_id => 8,:management_division_value => 4)
shops = Shop.where(:id => a.map{|v| v.shop_id}).where(:id => b.map{|v| v.shop_id})