* @hibernate.query
 *      name="hql.AttributeGroup.byProductName"
 *      query="SELECT
 * 				    ag.attributeGroupID,
 * 				    ag.groupName,
 * 				    ag.guiCommandName,
 *                  ag.instanceName,
 * 				    pag.requiredFlag,
 * 				    ag.allowGroupsFlag,
 * 				    pag.allowBooleanFlag,
 * 				    pag.allowComboCombineFlag,
 *                  pag.allowNestedComboFlag,
 *                  pag.allowDataRecurr,
 *                  ag.allowTrashCanFlag,
 *                  ag.allowPlusFlag,
 * 					pag.inWizardFlag,
 * 					pag.message,
 * 					ag.showFlag,
 *                  pag.processCheck
 *              FROM
 *              	ProductAttributeGroup pag,
 *              	AttributeGroup ag,
 *              	Product p
 *              WHERE
 *              	pag.productID = p.productID AND
 *              	pag.attributeGroupID = ag.attributeGroupID AND
 *                  p.productName = ? AND
 *                  pag.attributeGroupID in ( :agIDS )
 *              ORDER BY pag.sequenceNumber"