Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- itemId | fieldId | value
- ==========================
- 41 | 236 | Paris
- 41 | 213 | Paris
- 14 | 236 |
- 14 | 213 | Paris
- 25 | 236 | Paris
- 25 | 213 |
- SELECT COUNT(*) AS sp_actions
- FROM
- `tiki_tracker_item_fields` AS actions
- WHERE
- COALESCE(
- actions.fieldId = 236,
- actions.fieldId = 213
- )
- AND actions.value = 'Paris'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement