[Bug Report] Marker search error resulting from incorrect SQL query.

[CosimoVestri]

Describe the bug When using the search field on the Markers page, any input will result in an error due to a missing SQL JOIN to the scenes table.

To Reproduce Steps to reproduce the behavior:

1. Go to Markers
2. Click on the search field
3. Enter anything
4. See error:

   error executing count query with SQL: SELECT COUNT(*) as count FROM (SELECT DISTINCT scene_markers.id FROM scene_markers LEFT JOIN tags ON scene_markers.primary_tag_id = tags.id WHERE (scene_markers.title LIKE ? OR scenes.title LIKE ? OR tags.name LIKE ?)) as temp, args: [%text% %text% %text%], error: error executing `SELECT COUNT(*) as count FROM (SELECT DISTINCT scene_markers.id FROM scene_markers LEFT JOIN tags ON scene_markers.primary_tag_id = tags.id WHERE (scene_markers.title LIKE ? OR scenes.title LIKE ? OR tags.name LIKE ?)) as temp` [[%text% %text% %text%]]: no such column: scenes.title

   Expected behavior The correct SQL query would be:

   SELECT COUNT(*) AS count
   FROM 
   (SELECT DISTINCT scene_markers.id
   FROM scene_markers
   LEFT JOIN tags
     ON scene_markers.primary_tag_id = tags.id
   LEFT JOIN scenes
     ON scene_markers.scene_id = scenes.id
   WHERE (scene_markers.title LIKE '%text%'
         OR scenes.title LIKE '%text%'
         OR tags.name LIKE '%text%')) AS temp

   However the JOIN to the scenes table is missing which means this is the query being executed:

SELECT COUNT(*) AS count
FROM 
  (SELECT DISTINCT scene_markers.id
  FROM scene_markers
  LEFT JOIN tags
      ON scene_markers.primary_tag_id = tags.id
  WHERE (scene_markers.title LIKE '%text%'
          OR scenes.title LIKE '%text%'
          OR tags.name LIKE '%text%')) AS temp

So the scenes.title column would be missing.

Stash Version: (from Settings -> About): v0.26.1-24-ga8fca47a

Additional context @DogmaDragon confirmed the error.