/*SELECT * FROM table1 INNER JOIN table2 ON table1.value1 comp[=, <, >, <=, >=] table2.value1 INNER JOIN table3 ON table1.value2 comp[=, <, >, <=, >=] table3.value1*/;
SELECT 
 `runranges`.`runMin`, 
 `runranges`.`runMax`, 
 `runranges`.`id` AS `runRangeId`, 
 `assignments`.`id` AS `asgmntId`,
 `variations`.`id` AS `varId`
FROM `runranges` 
   INNER JOIN `assignments` ON `assignments`.`runRangeId`= `runranges`.`id`
   INNER JOIN `variations` ON `assignments`.`variationId`= `variations`.`id`
WHERE `runranges`.`runMin` < '121' AND `runranges`.`runMax` >'121' AND `variations`.`name`="default"
