Food with Articles by food name in DB

Result: SQL executed.

SELECT * FROM food WHERE food.name='Nasi Lemak' AND food.name='Nasi Lemak'   LIMIT 1

SELECT *, food.id AS _food__id, article.id AS _article__id,
                        food.id AS _food__id,
                        article.food_id AS _article__food_id
                        FROM food
                        
                        LEFT OUTER JOIN article
                        ON food.id = article.food_id
                        WHERE article.draft<>1 AND food.id='4' AND food.name='Nasi Lemak' AND food.description='A kind of rice made with coconut milk' AND food.location='Malaysia' AND food.food_type_id='4'
                        ORDER BY createtime DESC  

Food Object
(
    [id] => 4
    [name] => Nasi Lemak
    [description] => A kind of rice made with coconut milk
    [location] => Malaysia
    [food_type_id] => 4
    [_table] => food
    [_primarykey] => id
    [_fields] => Array
        (
            [0] => id
            [1] => name
            [2] => description
            [3] => location
            [4] => food_type_id
        )

    [Article] => Array
        (
            [0] => Article Object
                (
                    [id] => 3
                    [title] => More on Nasi Lemak
                    [content] => This is something additional to Nasi Lemak.....
                    [createtime] => 2009-07-20 21:57:35
                    [draft] => 0
                    [food_id] => 4
                    [_table] => article
                    [_primarykey] => id
                    [_fields] => Array
                        (
                            [0] => id
                            [1] => title
                            [2] => content
                            [3] => createtime
                            [4] => draft
                            [5] => food_id
                        )

                )

            [1] => Article Object
                (
                    [id] => 1
                    [title] => Nasi Lemak Review
                    [content] => This is a review for nasi lemak, a common for a Malaysian.
                    [createtime] => 2009-07-15 21:56:40
                    [draft] => 0
                    [food_id] => 4
                    [_table] => article
                    [_primarykey] => id
                    [_fields] => Array
                        (
                            [0] => id
                            [1] => title
                            [2] => content
                            [3] => createtime
                            [4] => draft
                            [5] => food_id
                        )

                )

        )

)