Example response

Response

Array
(
    [0] => Array
        (
            [distinct Attributes.id] => 1
            [name] => Colour
        )

    [1] => Array
        (
            [distinct Attributes.id] => 3
            [name] => Weight
        )

    [2] => Array
        (
            [distinct Attributes.id] => 4
            [name] => Size
        )

    [3] => Array
        (
            [distinct Attributes.id] => 5
            [name] => type
        )

    [4] => Array
        (
            [distinct Attributes.id] => 2
            [name] => Simple Colour
        )

    [5] => Array
        (
            [distinct Attributes.id] => 1
            [name] => Colour
        )

    [6] => Array
        (
            [distinct Attributes.id] => 3
            [name] => Weight
        )

    [7] => Array
        (
            [distinct Attributes.id] => 4
            [name] => Size
        )

    [8] => Array
        (
            [distinct Attributes.id] => 5
            [name] => type
        )

    [9] => Array
        (
            [distinct Attributes.id] => 2
            [name] => Simple Colour
        )

)

Here is the generated SQL code:

SELECT distinct Attributes.id, `Attributes`.`name` FROM `attributes` AS `Attributes` WHERE `Attributes`.`deleted` = 0 ORDER BY `Attributes`.`order_num` ASC LIMIT 10;