home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MJGraf" data-source="post: 1028063" data-attributes="member: 17886"><p><u><strong>Read Test 1</strong></u></p><p></p><p>What I'm doing technically is the following:</p><p>[CODE]</p><p>var necessaryMias = new List<Guid> { MediaAspect.ASPECT_ID };</p><p>var optionalMias = new List<Guid>(ServiceRegistration.Get<IMediaItemAspectTypeRegistration>().LocallyKnownMediaItemAspectTypes.Keys);</p><p>MediaItemQuery miq = ServiceRegistration.Get<IMediaLibrary>().BuildSimpleTextSearchQuery(searchString, necessaryMias, optionalMias, null, false, true);</p><p>var result = ServiceRegistration.Get<IMediaLibrary>().Search(miq, false);</p><p>[/CODE]</p><p>searchString is in this case "simon".</p><p></p><p>A bit less technically explained: I'm searching for all media items, which have "*simon*" in any text field of any media item aspect and I want to have these media items returned with any media item aspect they have (i.e. in particular including the Thumbnail Aspect with the covers). This query returns exactly 235 media items in my test collection.</p><p></p><p>What happens with this search on the database level. The SQLDebug.Log shows that this search executes in total 12 SQL queries. For documentation purposes, I include the 12 SQL queries below. They are relatively complex, include a lot of left outer joins and where "like" clauses. But every SQL query has one "from" table and I am going to refer to the different SQL queries based on the name of this "from" table. So here are the SQL queries:</p><p></p><p><u>SQL1 (Genres)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_GENRES T0</p><p> INNER JOIN V_GENRES T9 ON T0.ID = T9.ID</p><p> INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID</p><p> LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID</p><p> LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID</p><p>WHERE</p><p> (</p><p> T10.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T10.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T10.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T11.PATH LIKE @V8 ESCAPE @E9</p><p> OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T12.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T13.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T14.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T14.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T14.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T14.CITY LIKE @V52 ESCAPE @E53</p><p> OR T14.STATE LIKE @V54 ESCAPE @E55</p><p> OR T14.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T15.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T15.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T16.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T16.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T16.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T16.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T17.CHANNEL LIKE @V76 ESCAPE @E77</p><p>)</p><p>-------------------------------------------------------</p><p>"V0" [String]: '%simon%'</p><p>"E1" [String]: '\'</p><p>"V2" [String]: '%simon%'</p><p>"E3" [String]: '\'</p><p>"V4" [String]: '%simon%'</p><p>"E5" [String]: '\'</p><p>"V6" [String]: '%simon%'</p><p>"E7" [String]: '\'</p><p>"V8" [String]: '%simon%'</p><p>"E9" [String]: '\'</p><p>"V10" [String]: '%simon%'</p><p>"E11" [String]: '\'</p><p>"V12" [String]: '%simon%'</p><p>"E13" [String]: '\'</p><p>"V14" [String]: '%simon%'</p><p>"E15" [String]: '\'</p><p>"V16" [String]: '%simon%'</p><p>"E17" [String]: '\'</p><p>"V18" [String]: '%simon%'</p><p>"E19" [String]: '\'</p><p>"V20" [String]: '%simon%'</p><p>"E21" [String]: '\'</p><p>"V22" [String]: '%simon%'</p><p>"E23" [String]: '\'</p><p>"V24" [String]: '%simon%'</p><p>"E25" [String]: '\'</p><p>"V26" [String]: '%simon%'</p><p>"E27" [String]: '\'</p><p>"V28" [String]: '%simon%'</p><p>"E29" [String]: '\'</p><p>"V30" [String]: '%simon%'</p><p>"E31" [String]: '\'</p><p>"V32" [String]: '%simon%'</p><p>"E33" [String]: '\'</p><p>"V34" [String]: '%simon%'</p><p>"E35" [String]: '\'</p><p>"V36" [String]: '%simon%'</p><p>"E37" [String]: '\'</p><p>"V38" [String]: '%simon%'</p><p>"E39" [String]: '\'</p><p>"V40" [String]: '%simon%'</p><p>"E41" [String]: '\'</p><p>"V42" [String]: '%simon%'</p><p>"E43" [String]: '\'</p><p>"V44" [String]: '%simon%'</p><p>"E45" [String]: '\'</p><p>"V46" [String]: '%simon%'</p><p>"E47" [String]: '\'</p><p>"V48" [String]: '%simon%'</p><p>"E49" [String]: '\'</p><p>"V50" [String]: '%simon%'</p><p>"E51" [String]: '\'</p><p>"V52" [String]: '%simon%'</p><p>"E53" [String]: '\'</p><p>"V54" [String]: '%simon%'</p><p>"E55" [String]: '\'</p><p>"V56" [String]: '%simon%'</p><p>"E57" [String]: '\'</p><p>"V58" [String]: '%simon%'</p><p>"E59" [String]: '\'</p><p>"V60" [String]: '%simon%'</p><p>"E61" [String]: '\'</p><p>"V62" [String]: '%simon%'</p><p>"E63" [String]: '\'</p><p>"V64" [String]: '%simon%'</p><p>"E65" [String]: '\'</p><p>"V66" [String]: '%simon%'</p><p>"E67" [String]: '\'</p><p>"V68" [String]: '%simon%'</p><p>"E69" [String]: '\'</p><p>"V70" [String]: '%simon%'</p><p>"E71" [String]: '\'</p><p>"V72" [String]: '%simon%'</p><p>"E73" [String]: '\'</p><p>"V74" [String]: '%simon%'</p><p>"E75" [String]: '\'</p><p>"V76" [String]: '%simon%'</p><p>"E77" [String]: '\'</p><p>[/SPOILER]</p><p><u>SQL2 (AudioLanguages)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_AUDIOLANGUAGES T0</p><p> INNER JOIN V_AUDIOLANGUAGES T9 ON T0.ID = T9.ID</p><p> INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID</p><p> LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID</p><p> LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID</p><p>WHERE</p><p> (</p><p> T10.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T10.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T10.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T11.PATH LIKE @V8 ESCAPE @E9</p><p> OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T12.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T13.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T14.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T14.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T14.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T14.CITY LIKE @V52 ESCAPE @E53</p><p> OR T14.STATE LIKE @V54 ESCAPE @E55</p><p> OR T14.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T15.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T15.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T16.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T16.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T16.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T16.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T17.CHANNEL LIKE @V76 ESCAPE @E77</p><p>)</p><p>-------------------------------------------------------</p><p>"V0" [String]: '%simon%'</p><p>"E1" [String]: '\'</p><p>"V2" [String]: '%simon%'</p><p>"E3" [String]: '\'</p><p>"V4" [String]: '%simon%'</p><p>"E5" [String]: '\'</p><p>"V6" [String]: '%simon%'</p><p>"E7" [String]: '\'</p><p>"V8" [String]: '%simon%'</p><p>"E9" [String]: '\'</p><p>"V10" [String]: '%simon%'</p><p>"E11" [String]: '\'</p><p>"V12" [String]: '%simon%'</p><p>"E13" [String]: '\'</p><p>"V14" [String]: '%simon%'</p><p>"E15" [String]: '\'</p><p>"V16" [String]: '%simon%'</p><p>"E17" [String]: '\'</p><p>"V18" [String]: '%simon%'</p><p>"E19" [String]: '\'</p><p>"V20" [String]: '%simon%'</p><p>"E21" [String]: '\'</p><p>"V22" [String]: '%simon%'</p><p>"E23" [String]: '\'</p><p>"V24" [String]: '%simon%'</p><p>"E25" [String]: '\'</p><p>"V26" [String]: '%simon%'</p><p>"E27" [String]: '\'</p><p>"V28" [String]: '%simon%'</p><p>"E29" [String]: '\'</p><p>"V30" [String]: '%simon%'</p><p>"E31" [String]: '\'</p><p>"V32" [String]: '%simon%'</p><p>"E33" [String]: '\'</p><p>"V34" [String]: '%simon%'</p><p>"E35" [String]: '\'</p><p>"V36" [String]: '%simon%'</p><p>"E37" [String]: '\'</p><p>"V38" [String]: '%simon%'</p><p>"E39" [String]: '\'</p><p>"V40" [String]: '%simon%'</p><p>"E41" [String]: '\'</p><p>"V42" [String]: '%simon%'</p><p>"E43" [String]: '\'</p><p>"V44" [String]: '%simon%'</p><p>"E45" [String]: '\'</p><p>"V46" [String]: '%simon%'</p><p>"E47" [String]: '\'</p><p>"V48" [String]: '%simon%'</p><p>"E49" [String]: '\'</p><p>"V50" [String]: '%simon%'</p><p>"E51" [String]: '\'</p><p>"V52" [String]: '%simon%'</p><p>"E53" [String]: '\'</p><p>"V54" [String]: '%simon%'</p><p>"E55" [String]: '\'</p><p>"V56" [String]: '%simon%'</p><p>"E57" [String]: '\'</p><p>"V58" [String]: '%simon%'</p><p>"E59" [String]: '\'</p><p>"V60" [String]: '%simon%'</p><p>"E61" [String]: '\'</p><p>"V62" [String]: '%simon%'</p><p>"E63" [String]: '\'</p><p>"V64" [String]: '%simon%'</p><p>"E65" [String]: '\'</p><p>"V66" [String]: '%simon%'</p><p>"E67" [String]: '\'</p><p>"V68" [String]: '%simon%'</p><p>"E69" [String]: '\'</p><p>"V70" [String]: '%simon%'</p><p>"E71" [String]: '\'</p><p>"V72" [String]: '%simon%'</p><p>"E73" [String]: '\'</p><p>"V74" [String]: '%simon%'</p><p>"E75" [String]: '\'</p><p>"V76" [String]: '%simon%'</p><p>"E77" [String]: '\'</p><p>[/SPOILER]</p><p><u>SQL3 (Actors)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_ACTORS T0</p><p> INNER JOIN V_ACTORS T9 ON T0.ID = T9.ID</p><p> INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID</p><p> LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID</p><p> LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID</p><p>WHERE</p><p> (</p><p> T10.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T10.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T10.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T11.PATH LIKE @V8 ESCAPE @E9</p><p> OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T12.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T13.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T14.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T14.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T14.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T14.CITY LIKE @V52 ESCAPE @E53</p><p> OR T14.STATE LIKE @V54 ESCAPE @E55</p><p> OR T14.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T15.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T15.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T16.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T16.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T16.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T16.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T17.CHANNEL LIKE @V76 ESCAPE @E77</p><p>)</p><p>-------------------------------------------------------</p><p>"V0" [String]: '%simon%'</p><p>"E1" [String]: '\'</p><p>"V2" [String]: '%simon%'</p><p>"E3" [String]: '\'</p><p>"V4" [String]: '%simon%'</p><p>"E5" [String]: '\'</p><p>"V6" [String]: '%simon%'</p><p>"E7" [String]: '\'</p><p>"V8" [String]: '%simon%'</p><p>"E9" [String]: '\'</p><p>"V10" [String]: '%simon%'</p><p>"E11" [String]: '\'</p><p>"V12" [String]: '%simon%'</p><p>"E13" [String]: '\'</p><p>"V14" [String]: '%simon%'</p><p>"E15" [String]: '\'</p><p>"V16" [String]: '%simon%'</p><p>"E17" [String]: '\'</p><p>"V18" [String]: '%simon%'</p><p>"E19" [String]: '\'</p><p>"V20" [String]: '%simon%'</p><p>"E21" [String]: '\'</p><p>"V22" [String]: '%simon%'</p><p>"E23" [String]: '\'</p><p>"V24" [String]: '%simon%'</p><p>"E25" [String]: '\'</p><p>"V26" [String]: '%simon%'</p><p>"E27" [String]: '\'</p><p>"V28" [String]: '%simon%'</p><p>"E29" [String]: '\'</p><p>"V30" [String]: '%simon%'</p><p>"E31" [String]: '\'</p><p>"V32" [String]: '%simon%'</p><p>"E33" [String]: '\'</p><p>"V34" [String]: '%simon%'</p><p>"E35" [String]: '\'</p><p>"V36" [String]: '%simon%'</p><p>"E37" [String]: '\'</p><p>"V38" [String]: '%simon%'</p><p>"E39" [String]: '\'</p><p>"V40" [String]: '%simon%'</p><p>"E41" [String]: '\'</p><p>"V42" [String]: '%simon%'</p><p>"E43" [String]: '\'</p><p>"V44" [String]: '%simon%'</p><p>"E45" [String]: '\'</p><p>"V46" [String]: '%simon%'</p><p>"E47" [String]: '\'</p><p>"V48" [String]: '%simon%'</p><p>"E49" [String]: '\'</p><p>"V50" [String]: '%simon%'</p><p>"E51" [String]: '\'</p><p>"V52" [String]: '%simon%'</p><p>"E53" [String]: '\'</p><p>"V54" [String]: '%simon%'</p><p>"E55" [String]: '\'</p><p>"V56" [String]: '%simon%'</p><p>"E57" [String]: '\'</p><p>"V58" [String]: '%simon%'</p><p>"E59" [String]: '\'</p><p>"V60" [String]: '%simon%'</p><p>"E61" [String]: '\'</p><p>"V62" [String]: '%simon%'</p><p>"E63" [String]: '\'</p><p>"V64" [String]: '%simon%'</p><p>"E65" [String]: '\'</p><p>"V66" [String]: '%simon%'</p><p>"E67" [String]: '\'</p><p>"V68" [String]: '%simon%'</p><p>"E69" [String]: '\'</p><p>"V70" [String]: '%simon%'</p><p>"E71" [String]: '\'</p><p>"V72" [String]: '%simon%'</p><p>"E73" [String]: '\'</p><p>"V74" [String]: '%simon%'</p><p>"E75" [String]: '\'</p><p>"V76" [String]: '%simon%'</p><p>"E77" [String]: '\'</p><p>[/SPOILER]</p><p><u>SQL4 (Directors)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_DIRECTORS T0</p><p> INNER JOIN V_DIRECTORS T9 ON T0.ID = T9.ID</p><p> INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID</p><p> LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID</p><p> LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID</p><p>WHERE</p><p> (</p><p> T10.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T10.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T10.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T11.PATH LIKE @V8 ESCAPE @E9</p><p> OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T12.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T13.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T14.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T14.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T14.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T14.CITY LIKE @V52 ESCAPE @E53</p><p> OR T14.STATE LIKE @V54 ESCAPE @E55</p><p> OR T14.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T15.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T15.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T16.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T16.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T16.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T16.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T17.CHANNEL LIKE @V76 ESCAPE @E77</p><p>)</p><p>-------------------------------------------------------</p><p>"V0" [String]: '%simon%'</p><p>"E1" [String]: '\'</p><p>"V2" [String]: '%simon%'</p><p>"E3" [String]: '\'</p><p>"V4" [String]: '%simon%'</p><p>"E5" [String]: '\'</p><p>"V6" [String]: '%simon%'</p><p>"E7" [String]: '\'</p><p>"V8" [String]: '%simon%'</p><p>"E9" [String]: '\'</p><p>"V10" [String]: '%simon%'</p><p>"E11" [String]: '\'</p><p>"V12" [String]: '%simon%'</p><p>"E13" [String]: '\'</p><p>"V14" [String]: '%simon%'</p><p>"E15" [String]: '\'</p><p>"V16" [String]: '%simon%'</p><p>"E17" [String]: '\'</p><p>"V18" [String]: '%simon%'</p><p>"E19" [String]: '\'</p><p>"V20" [String]: '%simon%'</p><p>"E21" [String]: '\'</p><p>"V22" [String]: '%simon%'</p><p>"E23" [String]: '\'</p><p>"V24" [String]: '%simon%'</p><p>"E25" [String]: '\'</p><p>"V26" [String]: '%simon%'</p><p>"E27" [String]: '\'</p><p>"V28" [String]: '%simon%'</p><p>"E29" [String]: '\'</p><p>"V30" [String]: '%simon%'</p><p>"E31" [String]: '\'</p><p>"V32" [String]: '%simon%'</p><p>"E33" [String]: '\'</p><p>"V34" [String]: '%simon%'</p><p>"E35" [String]: '\'</p><p>"V36" [String]: '%simon%'</p><p>"E37" [String]: '\'</p><p>"V38" [String]: '%simon%'</p><p>"E39" [String]: '\'</p><p>"V40" [String]: '%simon%'</p><p>"E41" [String]: '\'</p><p>"V42" [String]: '%simon%'</p><p>"E43" [String]: '\'</p><p>"V44" [String]: '%simon%'</p><p>"E45" [String]: '\'</p><p>"V46" [String]: '%simon%'</p><p>"E47" [String]: '\'</p><p>"V48" [String]: '%simon%'</p><p>"E49" [String]: '\'</p><p>"V50" [String]: '%simon%'</p><p>"E51" [String]: '\'</p><p>"V52" [String]: '%simon%'</p><p>"E53" [String]: '\'</p><p>"V54" [String]: '%simon%'</p><p>"E55" [String]: '\'</p><p>"V56" [String]: '%simon%'</p><p>"E57" [String]: '\'</p><p>"V58" [String]: '%simon%'</p><p>"E59" [String]: '\'</p><p>"V60" [String]: '%simon%'</p><p>"E61" [String]: '\'</p><p>"V62" [String]: '%simon%'</p><p>"E63" [String]: '\'</p><p>"V64" [String]: '%simon%'</p><p>"E65" [String]: '\'</p><p>"V66" [String]: '%simon%'</p><p>"E67" [String]: '\'</p><p>"V68" [String]: '%simon%'</p><p>"E69" [String]: '\'</p><p>"V70" [String]: '%simon%'</p><p>"E71" [String]: '\'</p><p>"V72" [String]: '%simon%'</p><p>"E73" [String]: '\'</p><p>"V74" [String]: '%simon%'</p><p>"E75" [String]: '\'</p><p>"V76" [String]: '%simon%'</p><p>"E77" [String]: '\'</p><p>[/SPOILER]</p><p><u>SQL5 (Writers)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_WRITERS T0</p><p> INNER JOIN V_WRITERS T9 ON T0.ID = T9.ID</p><p> INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID</p><p> LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID</p><p> LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID</p><p>WHERE</p><p> (</p><p> T10.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T10.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T10.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T11.PATH LIKE @V8 ESCAPE @E9</p><p> OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T12.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T13.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T14.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T14.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T14.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T14.CITY LIKE @V52 ESCAPE @E53</p><p> OR T14.STATE LIKE @V54 ESCAPE @E55</p><p> OR T14.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T15.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T15.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T16.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T16.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T16.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T16.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T17.CHANNEL LIKE @V76 ESCAPE @E77</p><p>)</p><p>-------------------------------------------------------</p><p>"V0" [String]: '%simon%'</p><p>"E1" [String]: '\'</p><p>"V2" [String]: '%simon%'</p><p>"E3" [String]: '\'</p><p>"V4" [String]: '%simon%'</p><p>"E5" [String]: '\'</p><p>"V6" [String]: '%simon%'</p><p>"E7" [String]: '\'</p><p>"V8" [String]: '%simon%'</p><p>"E9" [String]: '\'</p><p>"V10" [String]: '%simon%'</p><p>"E11" [String]: '\'</p><p>"V12" [String]: '%simon%'</p><p>"E13" [String]: '\'</p><p>"V14" [String]: '%simon%'</p><p>"E15" [String]: '\'</p><p>"V16" [String]: '%simon%'</p><p>"E17" [String]: '\'</p><p>"V18" [String]: '%simon%'</p><p>"E19" [String]: '\'</p><p>"V20" [String]: '%simon%'</p><p>"E21" [String]: '\'</p><p>"V22" [String]: '%simon%'</p><p>"E23" [String]: '\'</p><p>"V24" [String]: '%simon%'</p><p>"E25" [String]: '\'</p><p>"V26" [String]: '%simon%'</p><p>"E27" [String]: '\'</p><p>"V28" [String]: '%simon%'</p><p>"E29" [String]: '\'</p><p>"V30" [String]: '%simon%'</p><p>"E31" [String]: '\'</p><p>"V32" [String]: '%simon%'</p><p>"E33" [String]: '\'</p><p>"V34" [String]: '%simon%'</p><p>"E35" [String]: '\'</p><p>"V36" [String]: '%simon%'</p><p>"E37" [String]: '\'</p><p>"V38" [String]: '%simon%'</p><p>"E39" [String]: '\'</p><p>"V40" [String]: '%simon%'</p><p>"E41" [String]: '\'</p><p>"V42" [String]: '%simon%'</p><p>"E43" [String]: '\'</p><p>"V44" [String]: '%simon%'</p><p>"E45" [String]: '\'</p><p>"V46" [String]: '%simon%'</p><p>"E47" [String]: '\'</p><p>"V48" [String]: '%simon%'</p><p>"E49" [String]: '\'</p><p>"V50" [String]: '%simon%'</p><p>"E51" [String]: '\'</p><p>"V52" [String]: '%simon%'</p><p>"E53" [String]: '\'</p><p>"V54" [String]: '%simon%'</p><p>"E55" [String]: '\'</p><p>"V56" [String]: '%simon%'</p><p>"E57" [String]: '\'</p><p>"V58" [String]: '%simon%'</p><p>"E59" [String]: '\'</p><p>"V60" [String]: '%simon%'</p><p>"E61" [String]: '\'</p><p>"V62" [String]: '%simon%'</p><p>"E63" [String]: '\'</p><p>"V64" [String]: '%simon%'</p><p>"E65" [String]: '\'</p><p>"V66" [String]: '%simon%'</p><p>"E67" [String]: '\'</p><p>"V68" [String]: '%simon%'</p><p>"E69" [String]: '\'</p><p>"V70" [String]: '%simon%'</p><p>"E71" [String]: '\'</p><p>"V72" [String]: '%simon%'</p><p>"E73" [String]: '\'</p><p>"V74" [String]: '%simon%'</p><p>"E75" [String]: '\'</p><p>"V76" [String]: '%simon%'</p><p>"E77" [String]: '\'</p><p>[/SPOILER]</p><p><u>SQL6 (Artists)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_ARTISTS T0</p><p> INNER JOIN V_ARTISTS T9 ON T0.ID = T9.ID</p><p> INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID</p><p> LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID</p><p> LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID</p><p>WHERE</p><p> (</p><p> T10.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T10.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T10.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T11.PATH LIKE @V8 ESCAPE @E9</p><p> OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T12.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T13.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T14.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T14.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T14.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T14.CITY LIKE @V52 ESCAPE @E53</p><p> OR T14.STATE LIKE @V54 ESCAPE @E55</p><p> OR T14.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T15.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T15.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T16.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T16.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T16.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T16.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T17.CHANNEL LIKE @V76 ESCAPE @E77</p><p>)</p><p>-------------------------------------------------------</p><p>"V0" [String]: '%simon%'</p><p>"E1" [String]: '\'</p><p>"V2" [String]: '%simon%'</p><p>"E3" [String]: '\'</p><p>"V4" [String]: '%simon%'</p><p>"E5" [String]: '\'</p><p>"V6" [String]: '%simon%'</p><p>"E7" [String]: '\'</p><p>"V8" [String]: '%simon%'</p><p>"E9" [String]: '\'</p><p>"V10" [String]: '%simon%'</p><p>"E11" [String]: '\'</p><p>"V12" [String]: '%simon%'</p><p>"E13" [String]: '\'</p><p>"V14" [String]: '%simon%'</p><p>"E15" [String]: '\'</p><p>"V16" [String]: '%simon%'</p><p>"E17" [String]: '\'</p><p>"V18" [String]: '%simon%'</p><p>"E19" [String]: '\'</p><p>"V20" [String]: '%simon%'</p><p>"E21" [String]: '\'</p><p>"V22" [String]: '%simon%'</p><p>"E23" [String]: '\'</p><p>"V24" [String]: '%simon%'</p><p>"E25" [String]: '\'</p><p>"V26" [String]: '%simon%'</p><p>"E27" [String]: '\'</p><p>"V28" [String]: '%simon%'</p><p>"E29" [String]: '\'</p><p>"V30" [String]: '%simon%'</p><p>"E31" [String]: '\'</p><p>"V32" [String]: '%simon%'</p><p>"E33" [String]: '\'</p><p>"V34" [String]: '%simon%'</p><p>"E35" [String]: '\'</p><p>"V36" [String]: '%simon%'</p><p>"E37" [String]: '\'</p><p>"V38" [String]: '%simon%'</p><p>"E39" [String]: '\'</p><p>"V40" [String]: '%simon%'</p><p>"E41" [String]: '\'</p><p>"V42" [String]: '%simon%'</p><p>"E43" [String]: '\'</p><p>"V44" [String]: '%simon%'</p><p>"E45" [String]: '\'</p><p>"V46" [String]: '%simon%'</p><p>"E47" [String]: '\'</p><p>"V48" [String]: '%simon%'</p><p>"E49" [String]: '\'</p><p>"V50" [String]: '%simon%'</p><p>"E51" [String]: '\'</p><p>"V52" [String]: '%simon%'</p><p>"E53" [String]: '\'</p><p>"V54" [String]: '%simon%'</p><p>"E55" [String]: '\'</p><p>"V56" [String]: '%simon%'</p><p>"E57" [String]: '\'</p><p>"V58" [String]: '%simon%'</p><p>"E59" [String]: '\'</p><p>"V60" [String]: '%simon%'</p><p>"E61" [String]: '\'</p><p>"V62" [String]: '%simon%'</p><p>"E63" [String]: '\'</p><p>"V64" [String]: '%simon%'</p><p>"E65" [String]: '\'</p><p>"V66" [String]: '%simon%'</p><p>"E67" [String]: '\'</p><p>"V68" [String]: '%simon%'</p><p>"E69" [String]: '\'</p><p>"V70" [String]: '%simon%'</p><p>"E71" [String]: '\'</p><p>"V72" [String]: '%simon%'</p><p>"E73" [String]: '\'</p><p>"V74" [String]: '%simon%'</p><p>"E75" [String]: '\'</p><p>"V76" [String]: '%simon%'</p><p>"E77" [String]: '\'</p><p>[/SPOILER]</p></blockquote><p></p>
[QUOTE="MJGraf, post: 1028063, member: 17886"] [U][B]Read Test 1[/B][/U] What I'm doing technically is the following: [CODE] var necessaryMias = new List<Guid> { MediaAspect.ASPECT_ID }; var optionalMias = new List<Guid>(ServiceRegistration.Get<IMediaItemAspectTypeRegistration>().LocallyKnownMediaItemAspectTypes.Keys); MediaItemQuery miq = ServiceRegistration.Get<IMediaLibrary>().BuildSimpleTextSearchQuery(searchString, necessaryMias, optionalMias, null, false, true); var result = ServiceRegistration.Get<IMediaLibrary>().Search(miq, false); [/CODE] searchString is in this case "simon". A bit less technically explained: I'm searching for all media items, which have "*simon*" in any text field of any media item aspect and I want to have these media items returned with any media item aspect they have (i.e. in particular including the Thumbnail Aspect with the covers). This query returns exactly 235 media items in my test collection. What happens with this search on the database level. The SQLDebug.Log shows that this search executes in total 12 SQL queries. For documentation purposes, I include the 12 SQL queries below. They are relatively complex, include a lot of left outer joins and where "like" clauses. But every SQL query has one "from" table and I am going to refer to the different SQL queries based on the name of this "from" table. So here are the SQL queries: [U]SQL1 (Genres)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_GENRES T0 INNER JOIN V_GENRES T9 ON T0.ID = T9.ID INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID WHERE ( T10.TITLE LIKE @V0 ESCAPE @E1 OR T10.MIMETYPE LIKE @V2 ESCAPE @E3 OR T10.COMMENT LIKE @V4 ESCAPE @E5 OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T11.PATH LIKE @V8 ESCAPE @E9 OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T12.STORYPLOT LIKE @V22 ESCAPE @E23 OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T13.ALBUM LIKE @V26 ESCAPE @E27 OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T14.FLASHMODE LIKE @V44 ESCAPE @E45 OR T14.FNUMBER LIKE @V46 ESCAPE @E47 OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T14.METERINGMODE LIKE @V50 ESCAPE @E51 OR T14.CITY LIKE @V52 ESCAPE @E53 OR T14.STATE LIKE @V54 ESCAPE @E55 OR T14.COUNTRY LIKE @V56 ESCAPE @E57 OR T15.SERIESNAME LIKE @V58 ESCAPE @E59 OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T15.EPISODENAME LIKE @V62 ESCAPE @E63 OR T16.MOVIENAME LIKE @V64 ESCAPE @E65 OR T16.ORIGNAME LIKE @V66 ESCAPE @E67 OR T16.IMDBID LIKE @V68 ESCAPE @E69 OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T16.TAGLINE LIKE @V74 ESCAPE @E75 OR T17.CHANNEL LIKE @V76 ESCAPE @E77 ) ------------------------------------------------------- "V0" [String]: '%simon%' "E1" [String]: '\' "V2" [String]: '%simon%' "E3" [String]: '\' "V4" [String]: '%simon%' "E5" [String]: '\' "V6" [String]: '%simon%' "E7" [String]: '\' "V8" [String]: '%simon%' "E9" [String]: '\' "V10" [String]: '%simon%' "E11" [String]: '\' "V12" [String]: '%simon%' "E13" [String]: '\' "V14" [String]: '%simon%' "E15" [String]: '\' "V16" [String]: '%simon%' "E17" [String]: '\' "V18" [String]: '%simon%' "E19" [String]: '\' "V20" [String]: '%simon%' "E21" [String]: '\' "V22" [String]: '%simon%' "E23" [String]: '\' "V24" [String]: '%simon%' "E25" [String]: '\' "V26" [String]: '%simon%' "E27" [String]: '\' "V28" [String]: '%simon%' "E29" [String]: '\' "V30" [String]: '%simon%' "E31" [String]: '\' "V32" [String]: '%simon%' "E33" [String]: '\' "V34" [String]: '%simon%' "E35" [String]: '\' "V36" [String]: '%simon%' "E37" [String]: '\' "V38" [String]: '%simon%' "E39" [String]: '\' "V40" [String]: '%simon%' "E41" [String]: '\' "V42" [String]: '%simon%' "E43" [String]: '\' "V44" [String]: '%simon%' "E45" [String]: '\' "V46" [String]: '%simon%' "E47" [String]: '\' "V48" [String]: '%simon%' "E49" [String]: '\' "V50" [String]: '%simon%' "E51" [String]: '\' "V52" [String]: '%simon%' "E53" [String]: '\' "V54" [String]: '%simon%' "E55" [String]: '\' "V56" [String]: '%simon%' "E57" [String]: '\' "V58" [String]: '%simon%' "E59" [String]: '\' "V60" [String]: '%simon%' "E61" [String]: '\' "V62" [String]: '%simon%' "E63" [String]: '\' "V64" [String]: '%simon%' "E65" [String]: '\' "V66" [String]: '%simon%' "E67" [String]: '\' "V68" [String]: '%simon%' "E69" [String]: '\' "V70" [String]: '%simon%' "E71" [String]: '\' "V72" [String]: '%simon%' "E73" [String]: '\' "V74" [String]: '%simon%' "E75" [String]: '\' "V76" [String]: '%simon%' "E77" [String]: '\' [/SPOILER] [U]SQL2 (AudioLanguages)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_AUDIOLANGUAGES T0 INNER JOIN V_AUDIOLANGUAGES T9 ON T0.ID = T9.ID INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID WHERE ( T10.TITLE LIKE @V0 ESCAPE @E1 OR T10.MIMETYPE LIKE @V2 ESCAPE @E3 OR T10.COMMENT LIKE @V4 ESCAPE @E5 OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T11.PATH LIKE @V8 ESCAPE @E9 OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T12.STORYPLOT LIKE @V22 ESCAPE @E23 OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T13.ALBUM LIKE @V26 ESCAPE @E27 OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T14.FLASHMODE LIKE @V44 ESCAPE @E45 OR T14.FNUMBER LIKE @V46 ESCAPE @E47 OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T14.METERINGMODE LIKE @V50 ESCAPE @E51 OR T14.CITY LIKE @V52 ESCAPE @E53 OR T14.STATE LIKE @V54 ESCAPE @E55 OR T14.COUNTRY LIKE @V56 ESCAPE @E57 OR T15.SERIESNAME LIKE @V58 ESCAPE @E59 OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T15.EPISODENAME LIKE @V62 ESCAPE @E63 OR T16.MOVIENAME LIKE @V64 ESCAPE @E65 OR T16.ORIGNAME LIKE @V66 ESCAPE @E67 OR T16.IMDBID LIKE @V68 ESCAPE @E69 OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T16.TAGLINE LIKE @V74 ESCAPE @E75 OR T17.CHANNEL LIKE @V76 ESCAPE @E77 ) ------------------------------------------------------- "V0" [String]: '%simon%' "E1" [String]: '\' "V2" [String]: '%simon%' "E3" [String]: '\' "V4" [String]: '%simon%' "E5" [String]: '\' "V6" [String]: '%simon%' "E7" [String]: '\' "V8" [String]: '%simon%' "E9" [String]: '\' "V10" [String]: '%simon%' "E11" [String]: '\' "V12" [String]: '%simon%' "E13" [String]: '\' "V14" [String]: '%simon%' "E15" [String]: '\' "V16" [String]: '%simon%' "E17" [String]: '\' "V18" [String]: '%simon%' "E19" [String]: '\' "V20" [String]: '%simon%' "E21" [String]: '\' "V22" [String]: '%simon%' "E23" [String]: '\' "V24" [String]: '%simon%' "E25" [String]: '\' "V26" [String]: '%simon%' "E27" [String]: '\' "V28" [String]: '%simon%' "E29" [String]: '\' "V30" [String]: '%simon%' "E31" [String]: '\' "V32" [String]: '%simon%' "E33" [String]: '\' "V34" [String]: '%simon%' "E35" [String]: '\' "V36" [String]: '%simon%' "E37" [String]: '\' "V38" [String]: '%simon%' "E39" [String]: '\' "V40" [String]: '%simon%' "E41" [String]: '\' "V42" [String]: '%simon%' "E43" [String]: '\' "V44" [String]: '%simon%' "E45" [String]: '\' "V46" [String]: '%simon%' "E47" [String]: '\' "V48" [String]: '%simon%' "E49" [String]: '\' "V50" [String]: '%simon%' "E51" [String]: '\' "V52" [String]: '%simon%' "E53" [String]: '\' "V54" [String]: '%simon%' "E55" [String]: '\' "V56" [String]: '%simon%' "E57" [String]: '\' "V58" [String]: '%simon%' "E59" [String]: '\' "V60" [String]: '%simon%' "E61" [String]: '\' "V62" [String]: '%simon%' "E63" [String]: '\' "V64" [String]: '%simon%' "E65" [String]: '\' "V66" [String]: '%simon%' "E67" [String]: '\' "V68" [String]: '%simon%' "E69" [String]: '\' "V70" [String]: '%simon%' "E71" [String]: '\' "V72" [String]: '%simon%' "E73" [String]: '\' "V74" [String]: '%simon%' "E75" [String]: '\' "V76" [String]: '%simon%' "E77" [String]: '\' [/SPOILER] [U]SQL3 (Actors)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_ACTORS T0 INNER JOIN V_ACTORS T9 ON T0.ID = T9.ID INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID WHERE ( T10.TITLE LIKE @V0 ESCAPE @E1 OR T10.MIMETYPE LIKE @V2 ESCAPE @E3 OR T10.COMMENT LIKE @V4 ESCAPE @E5 OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T11.PATH LIKE @V8 ESCAPE @E9 OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T12.STORYPLOT LIKE @V22 ESCAPE @E23 OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T13.ALBUM LIKE @V26 ESCAPE @E27 OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T14.FLASHMODE LIKE @V44 ESCAPE @E45 OR T14.FNUMBER LIKE @V46 ESCAPE @E47 OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T14.METERINGMODE LIKE @V50 ESCAPE @E51 OR T14.CITY LIKE @V52 ESCAPE @E53 OR T14.STATE LIKE @V54 ESCAPE @E55 OR T14.COUNTRY LIKE @V56 ESCAPE @E57 OR T15.SERIESNAME LIKE @V58 ESCAPE @E59 OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T15.EPISODENAME LIKE @V62 ESCAPE @E63 OR T16.MOVIENAME LIKE @V64 ESCAPE @E65 OR T16.ORIGNAME LIKE @V66 ESCAPE @E67 OR T16.IMDBID LIKE @V68 ESCAPE @E69 OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T16.TAGLINE LIKE @V74 ESCAPE @E75 OR T17.CHANNEL LIKE @V76 ESCAPE @E77 ) ------------------------------------------------------- "V0" [String]: '%simon%' "E1" [String]: '\' "V2" [String]: '%simon%' "E3" [String]: '\' "V4" [String]: '%simon%' "E5" [String]: '\' "V6" [String]: '%simon%' "E7" [String]: '\' "V8" [String]: '%simon%' "E9" [String]: '\' "V10" [String]: '%simon%' "E11" [String]: '\' "V12" [String]: '%simon%' "E13" [String]: '\' "V14" [String]: '%simon%' "E15" [String]: '\' "V16" [String]: '%simon%' "E17" [String]: '\' "V18" [String]: '%simon%' "E19" [String]: '\' "V20" [String]: '%simon%' "E21" [String]: '\' "V22" [String]: '%simon%' "E23" [String]: '\' "V24" [String]: '%simon%' "E25" [String]: '\' "V26" [String]: '%simon%' "E27" [String]: '\' "V28" [String]: '%simon%' "E29" [String]: '\' "V30" [String]: '%simon%' "E31" [String]: '\' "V32" [String]: '%simon%' "E33" [String]: '\' "V34" [String]: '%simon%' "E35" [String]: '\' "V36" [String]: '%simon%' "E37" [String]: '\' "V38" [String]: '%simon%' "E39" [String]: '\' "V40" [String]: '%simon%' "E41" [String]: '\' "V42" [String]: '%simon%' "E43" [String]: '\' "V44" [String]: '%simon%' "E45" [String]: '\' "V46" [String]: '%simon%' "E47" [String]: '\' "V48" [String]: '%simon%' "E49" [String]: '\' "V50" [String]: '%simon%' "E51" [String]: '\' "V52" [String]: '%simon%' "E53" [String]: '\' "V54" [String]: '%simon%' "E55" [String]: '\' "V56" [String]: '%simon%' "E57" [String]: '\' "V58" [String]: '%simon%' "E59" [String]: '\' "V60" [String]: '%simon%' "E61" [String]: '\' "V62" [String]: '%simon%' "E63" [String]: '\' "V64" [String]: '%simon%' "E65" [String]: '\' "V66" [String]: '%simon%' "E67" [String]: '\' "V68" [String]: '%simon%' "E69" [String]: '\' "V70" [String]: '%simon%' "E71" [String]: '\' "V72" [String]: '%simon%' "E73" [String]: '\' "V74" [String]: '%simon%' "E75" [String]: '\' "V76" [String]: '%simon%' "E77" [String]: '\' [/SPOILER] [U]SQL4 (Directors)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_DIRECTORS T0 INNER JOIN V_DIRECTORS T9 ON T0.ID = T9.ID INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID WHERE ( T10.TITLE LIKE @V0 ESCAPE @E1 OR T10.MIMETYPE LIKE @V2 ESCAPE @E3 OR T10.COMMENT LIKE @V4 ESCAPE @E5 OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T11.PATH LIKE @V8 ESCAPE @E9 OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T12.STORYPLOT LIKE @V22 ESCAPE @E23 OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T13.ALBUM LIKE @V26 ESCAPE @E27 OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T14.FLASHMODE LIKE @V44 ESCAPE @E45 OR T14.FNUMBER LIKE @V46 ESCAPE @E47 OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T14.METERINGMODE LIKE @V50 ESCAPE @E51 OR T14.CITY LIKE @V52 ESCAPE @E53 OR T14.STATE LIKE @V54 ESCAPE @E55 OR T14.COUNTRY LIKE @V56 ESCAPE @E57 OR T15.SERIESNAME LIKE @V58 ESCAPE @E59 OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T15.EPISODENAME LIKE @V62 ESCAPE @E63 OR T16.MOVIENAME LIKE @V64 ESCAPE @E65 OR T16.ORIGNAME LIKE @V66 ESCAPE @E67 OR T16.IMDBID LIKE @V68 ESCAPE @E69 OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T16.TAGLINE LIKE @V74 ESCAPE @E75 OR T17.CHANNEL LIKE @V76 ESCAPE @E77 ) ------------------------------------------------------- "V0" [String]: '%simon%' "E1" [String]: '\' "V2" [String]: '%simon%' "E3" [String]: '\' "V4" [String]: '%simon%' "E5" [String]: '\' "V6" [String]: '%simon%' "E7" [String]: '\' "V8" [String]: '%simon%' "E9" [String]: '\' "V10" [String]: '%simon%' "E11" [String]: '\' "V12" [String]: '%simon%' "E13" [String]: '\' "V14" [String]: '%simon%' "E15" [String]: '\' "V16" [String]: '%simon%' "E17" [String]: '\' "V18" [String]: '%simon%' "E19" [String]: '\' "V20" [String]: '%simon%' "E21" [String]: '\' "V22" [String]: '%simon%' "E23" [String]: '\' "V24" [String]: '%simon%' "E25" [String]: '\' "V26" [String]: '%simon%' "E27" [String]: '\' "V28" [String]: '%simon%' "E29" [String]: '\' "V30" [String]: '%simon%' "E31" [String]: '\' "V32" [String]: '%simon%' "E33" [String]: '\' "V34" [String]: '%simon%' "E35" [String]: '\' "V36" [String]: '%simon%' "E37" [String]: '\' "V38" [String]: '%simon%' "E39" [String]: '\' "V40" [String]: '%simon%' "E41" [String]: '\' "V42" [String]: '%simon%' "E43" [String]: '\' "V44" [String]: '%simon%' "E45" [String]: '\' "V46" [String]: '%simon%' "E47" [String]: '\' "V48" [String]: '%simon%' "E49" [String]: '\' "V50" [String]: '%simon%' "E51" [String]: '\' "V52" [String]: '%simon%' "E53" [String]: '\' "V54" [String]: '%simon%' "E55" [String]: '\' "V56" [String]: '%simon%' "E57" [String]: '\' "V58" [String]: '%simon%' "E59" [String]: '\' "V60" [String]: '%simon%' "E61" [String]: '\' "V62" [String]: '%simon%' "E63" [String]: '\' "V64" [String]: '%simon%' "E65" [String]: '\' "V66" [String]: '%simon%' "E67" [String]: '\' "V68" [String]: '%simon%' "E69" [String]: '\' "V70" [String]: '%simon%' "E71" [String]: '\' "V72" [String]: '%simon%' "E73" [String]: '\' "V74" [String]: '%simon%' "E75" [String]: '\' "V76" [String]: '%simon%' "E77" [String]: '\' [/SPOILER] [U]SQL5 (Writers)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_WRITERS T0 INNER JOIN V_WRITERS T9 ON T0.ID = T9.ID INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID WHERE ( T10.TITLE LIKE @V0 ESCAPE @E1 OR T10.MIMETYPE LIKE @V2 ESCAPE @E3 OR T10.COMMENT LIKE @V4 ESCAPE @E5 OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T11.PATH LIKE @V8 ESCAPE @E9 OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T12.STORYPLOT LIKE @V22 ESCAPE @E23 OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T13.ALBUM LIKE @V26 ESCAPE @E27 OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T14.FLASHMODE LIKE @V44 ESCAPE @E45 OR T14.FNUMBER LIKE @V46 ESCAPE @E47 OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T14.METERINGMODE LIKE @V50 ESCAPE @E51 OR T14.CITY LIKE @V52 ESCAPE @E53 OR T14.STATE LIKE @V54 ESCAPE @E55 OR T14.COUNTRY LIKE @V56 ESCAPE @E57 OR T15.SERIESNAME LIKE @V58 ESCAPE @E59 OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T15.EPISODENAME LIKE @V62 ESCAPE @E63 OR T16.MOVIENAME LIKE @V64 ESCAPE @E65 OR T16.ORIGNAME LIKE @V66 ESCAPE @E67 OR T16.IMDBID LIKE @V68 ESCAPE @E69 OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T16.TAGLINE LIKE @V74 ESCAPE @E75 OR T17.CHANNEL LIKE @V76 ESCAPE @E77 ) ------------------------------------------------------- "V0" [String]: '%simon%' "E1" [String]: '\' "V2" [String]: '%simon%' "E3" [String]: '\' "V4" [String]: '%simon%' "E5" [String]: '\' "V6" [String]: '%simon%' "E7" [String]: '\' "V8" [String]: '%simon%' "E9" [String]: '\' "V10" [String]: '%simon%' "E11" [String]: '\' "V12" [String]: '%simon%' "E13" [String]: '\' "V14" [String]: '%simon%' "E15" [String]: '\' "V16" [String]: '%simon%' "E17" [String]: '\' "V18" [String]: '%simon%' "E19" [String]: '\' "V20" [String]: '%simon%' "E21" [String]: '\' "V22" [String]: '%simon%' "E23" [String]: '\' "V24" [String]: '%simon%' "E25" [String]: '\' "V26" [String]: '%simon%' "E27" [String]: '\' "V28" [String]: '%simon%' "E29" [String]: '\' "V30" [String]: '%simon%' "E31" [String]: '\' "V32" [String]: '%simon%' "E33" [String]: '\' "V34" [String]: '%simon%' "E35" [String]: '\' "V36" [String]: '%simon%' "E37" [String]: '\' "V38" [String]: '%simon%' "E39" [String]: '\' "V40" [String]: '%simon%' "E41" [String]: '\' "V42" [String]: '%simon%' "E43" [String]: '\' "V44" [String]: '%simon%' "E45" [String]: '\' "V46" [String]: '%simon%' "E47" [String]: '\' "V48" [String]: '%simon%' "E49" [String]: '\' "V50" [String]: '%simon%' "E51" [String]: '\' "V52" [String]: '%simon%' "E53" [String]: '\' "V54" [String]: '%simon%' "E55" [String]: '\' "V56" [String]: '%simon%' "E57" [String]: '\' "V58" [String]: '%simon%' "E59" [String]: '\' "V60" [String]: '%simon%' "E61" [String]: '\' "V62" [String]: '%simon%' "E63" [String]: '\' "V64" [String]: '%simon%' "E65" [String]: '\' "V66" [String]: '%simon%' "E67" [String]: '\' "V68" [String]: '%simon%' "E69" [String]: '\' "V70" [String]: '%simon%' "E71" [String]: '\' "V72" [String]: '%simon%' "E73" [String]: '\' "V74" [String]: '%simon%' "E75" [String]: '\' "V76" [String]: '%simon%' "E77" [String]: '\' [/SPOILER] [U]SQL6 (Artists)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_ARTISTS T0 INNER JOIN V_ARTISTS T9 ON T0.ID = T9.ID INNER JOIN M_MEDIAITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T18 ON T18.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T1 ON T18.ID = T1.ID LEFT OUTER JOIN NM_ACTORS T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T2 ON T19.ID = T2.ID LEFT OUTER JOIN NM_DIRECTORS T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T3 ON T20.ID = T3.ID LEFT OUTER JOIN NM_WRITERS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T4 ON T21.ID = T4.ID LEFT OUTER JOIN NM_ARTISTS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T5 ON T22.ID = T5.ID LEFT OUTER JOIN NM_GENRES_0 T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T6 ON T23.ID = T6.ID LEFT OUTER JOIN NM_ALBUMARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T7 ON T24.ID = T7.ID LEFT OUTER JOIN NM_COMPOSERS T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T8 ON T25.ID = T8.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T11 ON T0.MEDIA_ITEM_ID = T11.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T12 ON T0.MEDIA_ITEM_ID = T12.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T13 ON T0.MEDIA_ITEM_ID = T13.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T14 ON T0.MEDIA_ITEM_ID = T14.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T15 ON T0.MEDIA_ITEM_ID = T15.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T16 ON T0.MEDIA_ITEM_ID = T16.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T17 ON T0.MEDIA_ITEM_ID = T17.MEDIA_ITEM_ID WHERE ( T10.TITLE LIKE @V0 ESCAPE @E1 OR T10.MIMETYPE LIKE @V2 ESCAPE @E3 OR T10.COMMENT LIKE @V4 ESCAPE @E5 OR T11.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T11.PATH LIKE @V8 ESCAPE @E9 OR T1.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T12.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T12.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T2.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T3.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T4.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T12.STORYPLOT LIKE @V22 ESCAPE @E23 OR T5.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T13.ALBUM LIKE @V26 ESCAPE @E27 OR T6.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T7.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T8.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T13.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T14.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T14.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T14.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T14.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T14.FLASHMODE LIKE @V44 ESCAPE @E45 OR T14.FNUMBER LIKE @V46 ESCAPE @E47 OR T14.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T14.METERINGMODE LIKE @V50 ESCAPE @E51 OR T14.CITY LIKE @V52 ESCAPE @E53 OR T14.STATE LIKE @V54 ESCAPE @E55 OR T14.COUNTRY LIKE @V56 ESCAPE @E57 OR T15.SERIESNAME LIKE @V58 ESCAPE @E59 OR T15.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T15.EPISODENAME LIKE @V62 ESCAPE @E63 OR T16.MOVIENAME LIKE @V64 ESCAPE @E65 OR T16.ORIGNAME LIKE @V66 ESCAPE @E67 OR T16.IMDBID LIKE @V68 ESCAPE @E69 OR T16.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T16.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T16.TAGLINE LIKE @V74 ESCAPE @E75 OR T17.CHANNEL LIKE @V76 ESCAPE @E77 ) ------------------------------------------------------- "V0" [String]: '%simon%' "E1" [String]: '\' "V2" [String]: '%simon%' "E3" [String]: '\' "V4" [String]: '%simon%' "E5" [String]: '\' "V6" [String]: '%simon%' "E7" [String]: '\' "V8" [String]: '%simon%' "E9" [String]: '\' "V10" [String]: '%simon%' "E11" [String]: '\' "V12" [String]: '%simon%' "E13" [String]: '\' "V14" [String]: '%simon%' "E15" [String]: '\' "V16" [String]: '%simon%' "E17" [String]: '\' "V18" [String]: '%simon%' "E19" [String]: '\' "V20" [String]: '%simon%' "E21" [String]: '\' "V22" [String]: '%simon%' "E23" [String]: '\' "V24" [String]: '%simon%' "E25" [String]: '\' "V26" [String]: '%simon%' "E27" [String]: '\' "V28" [String]: '%simon%' "E29" [String]: '\' "V30" [String]: '%simon%' "E31" [String]: '\' "V32" [String]: '%simon%' "E33" [String]: '\' "V34" [String]: '%simon%' "E35" [String]: '\' "V36" [String]: '%simon%' "E37" [String]: '\' "V38" [String]: '%simon%' "E39" [String]: '\' "V40" [String]: '%simon%' "E41" [String]: '\' "V42" [String]: '%simon%' "E43" [String]: '\' "V44" [String]: '%simon%' "E45" [String]: '\' "V46" [String]: '%simon%' "E47" [String]: '\' "V48" [String]: '%simon%' "E49" [String]: '\' "V50" [String]: '%simon%' "E51" [String]: '\' "V52" [String]: '%simon%' "E53" [String]: '\' "V54" [String]: '%simon%' "E55" [String]: '\' "V56" [String]: '%simon%' "E57" [String]: '\' "V58" [String]: '%simon%' "E59" [String]: '\' "V60" [String]: '%simon%' "E61" [String]: '\' "V62" [String]: '%simon%' "E63" [String]: '\' "V64" [String]: '%simon%' "E65" [String]: '\' "V66" [String]: '%simon%' "E67" [String]: '\' "V68" [String]: '%simon%' "E69" [String]: '\' "V70" [String]: '%simon%' "E71" [String]: '\' "V72" [String]: '%simon%' "E73" [String]: '\' "V74" [String]: '%simon%' "E75" [String]: '\' "V76" [String]: '%simon%' "E77" [String]: '\' [/SPOILER] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
Top
Bottom
