...
Code Block |
---|
SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, field.value AS `field.value` FROM system LEFT JOIN field ON (system.id = field.system_id) WHERE @filter AND field.fields_id = '8' AND field.value = 'my value'; |
If you don't care about the value and want all values reported, you could use the below.
Code Block |
---|
SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, field.value AS `field.value` FROM system LEFT JOIN field ON (system.id = field.system_id) WHERE @filter AND field.fields_id = '8'; |