I am trying to develop a custom module where I have options to select 4 different Joomla articles.

In my module XML file, I have the following:

    <field name="articleOne"
        type="sql"
        label="Select an article"
        query="SELECT id AS value, title AS articleOne FROM #__content"
    />

    <field name="articleTwo"
        type="sql"
        label="Select an article"
        query="SELECT id AS value, title AS articleOne FROM #__content"
    />

    <field name="articleThree"
        type="sql"
        label="Select an article"
        query="SELECT id AS value, title AS articleOne FROM #__content"
    />

    <field name="articleFour"
        type="sql"
        label="Select an article"
        query="SELECT id AS value, title AS articleOne FROM #__content"
    />

I can get this to output the ID in the frontend. But how can I output the title, introtext and image?

I would like it to display in the frontend as follows:

[![enter image description here][1]][1]


  [1]: https://i.sstatic.net/z2hUz.png