Versions Compared

Old Version 2

changes.mady.by.user Mark Henry

Saved on

compared with

New Version Current

changes.mady.by.user Mark Henry

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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';