SELECT d_value AS value , f_units AS units FROM data JOIN feature ON (f_id = d_feature) WHERE d_package = AND d_level = AND d_feature = #qryInfo.units#'/> SELECT #Left(argName,1)#_label AS label FROM #argName# WHERE #Left(argName,1)#_id = SELECT DISTINCT f_units AS units FROM feature WHERE f_id IN () ORDER BY f_order ASC SELECT DISTINCT c_id AS category FROM category JOIN feature ON (f_category = c_id) JOIN data ON (d_feature = f_id) WHERE 1=1 AND f_priority IN () AND d_package IN () ORDER BY c_order ASC SELECT DISTINCT f_id AS feature FROM category JOIN feature ON (f_category = c_id) JOIN data ON (d_feature = f_id) WHERE 1=1 AND f_category IN () AND f_priority IN () AND d_package IN () ORDER BY c_order, f_order ASC SELECT DISTINCT l_id AS level_id, l_label AS level_label FROM level JOIN data ON (d_level = l_id) WHERE d_package IN () ORDER BY l_order ASC SELECT DISTINCT p_id AS package_id, p_label AS package_label FROM package ORDER BY p_order ASC