Versions Compared

Old Version 1

changes.mady.by.user Mark Unwin

Saved on

compared with

New Version 2

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`system LEFT JOIN `field`field ON `system`(system.`id`id = `field`field.`systemsystem_id`id) WHERE @filter AND `field`field.`fieldsfields_id`id = '8' AND `field`field.`value`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`system LEFT JOIN `field`field ON `system`(system.`id`id = `field`field.`systemsystem_id`id) WHERE @filter AND `field`field.`fieldsfields_id`id = '8';