Thread

I am trying to use a SQL query to return all entries and to also only return entries that have a status of open.

I can’t seem to get my head around it. Am absolute beginner with EE and SQL.

This is what I have:

SELECT field_id_3 FROM exp_channel_data WHERE EXISTS ( SELECT status FROM exp_statuses WHERE status = 'open' );

Any help appreciated

SELECT d.field_id_3
FROM exp_channel_data d
INNER JOIN exp_channel_entries t ON t.entry_id = d.entry_id
WHERE t.status = ‘open’

should do the trick

Hey niallthompson,

I am glad to see that boswebdev was able to provide some SQL. Not my strongest skill, so always love to see the community jump in with direction in this area.

Nice work guys.

Can you test this and see if it works for you? Let us know!

Cheers,

It returned an error actually so used EE tags instead. Kept it simple:

{exp:channel:entries channel="lettings" status="open" backspace="1"}"{town}",{/exp:channel:entries}

Hi niallthompson,

Sweet! Glad to hear it. Channel Entry Tags I do understand perfectly. 😊

Have a great weekend!

Cheers,