SELECT d.id,d.duration FROM duration d inner join price_template_details ptd on ptd.duration_id=d.id  WHERE ptd.template_id=41 AND ptd.price>0 AND NOT FIND_IN_SET('',d.disabledCities)=0