Test: mlb | SELECT attribute_id browse_id,attribute_description browse_name FROM attribute
WHERE attribute_group_id ='806' AND status = 0 AND search_status = 0
ORDER BY attribute_description
Test: nba |
SELECT
attribute_id browse_id,
attribute_description browse_name
FROM
attribute
WHERE
attribute_group_id ='810'
AND status = 0
AND search_status = 0
ORDER BY
attribute_description
Test: ncaa |
SELECT
attribute_id browse_id,
attribute_description browse_name
FROM
attribute
WHERE
attribute_group_id = '802'
AND status = '0'
Cherokee Uniforms - Medical scrubs, nursing uniforms and footwear
