Lithium subquery

gistfile1.aw

public function allParameters($product) {
		$conditions = array('subtype_id' => $product->subtype_id);
		$order = array('pos' => 'ASC');
		$with = array(
			'ParametersIndexes' => array(
				'conditions' => array(
					'product_id_key' => $product->id
				)
			)
		);

		return Parameters::all(compact('conditions', 'order', 'with'));
	}

$SQL= "SELECT *
FROM `sc_param` AS `Parameters`
LEFT JOIN `sc_param_index` AS `ParametersIndexes`
ON `Parameters`.`id` = `ParametersIndexes`.`param_id`
WHERE `subtype_id` = 5
ORDER BY `Parameters`.`pos` ASC"

$SQL= "SELECT *
FROM `sc_param` AS `Parameters`
LEFT JOIN `sc_param_index` AS `ParametersIndexes`
ON `Parameters`.`id` = `ParametersIndexes`.`param_id`
WHERE `subtype_id` = 5 AND sc_param_index = 2133 <----
ORDER BY `Parameters`.`pos` ASC"