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: 1028064" data-attributes="member: 17886"><p><u>SQL7 (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_0 T0</p><p> INNER JOIN V_GENRES_0 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>SQL8 (Albumartist)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_ALBUMARTISTS T0</p><p> INNER JOIN V_ALBUMARTISTS 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>SQL9 (Composers)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_COMPOSERS T0</p><p> INNER JOIN V_COMPOSERS 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>SQL10 (Episode)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_EPISODE T0</p><p> INNER JOIN V_EPISODE 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>SQL11 (DVDEpisode)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A0,</p><p> T9.ATTRIBUTE_VALUE A1</p><p>FROM NM_DVDEPISODE T0</p><p> INNER JOIN V_DVDEPISODE 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>SQL12 (Mediaitem)</u></p><p>[SPOILER]</p><p>SELECT</p><p> T0.MEDIA_ITEM_ID A72,</p><p> T0.MEDIA_ITEM_ID A73,</p><p> T1.MEDIA_ITEM_ID A74,</p><p> T2.MEDIA_ITEM_ID A75,</p><p> T19.MEDIA_ITEM_ID A76,</p><p> T3.MEDIA_ITEM_ID A77,</p><p> T4.MEDIA_ITEM_ID A78,</p><p> T5.MEDIA_ITEM_ID A79,</p><p> T6.MEDIA_ITEM_ID A80,</p><p> T7.MEDIA_ITEM_ID A81,</p><p> T8.MEDIA_ITEM_ID A82,</p><p> T9.MEDIA_ITEM_ID A83,</p><p> T10.MEDIA_ITEM_ID A84,</p><p> T0.TITLE A0,</p><p> T0.MIMETYPE A1,</p><p> T0.RECORDINGTIME A2,</p><p> T0.RATING A3,</p><p> T0.COMMENT A4,</p><p> T0.PLAYCOUNT A5,</p><p> T0.LASTPLAYED A6,</p><p> T1.SYSTEM_ID A7,</p><p> T1.PATH A8,</p><p> T1.PARENTDIRECTORY A9,</p><p> T2.LASTIMPORTDATE A10,</p><p> T2.DIRTY A11,</p><p> T2.DATEADDED A12,</p><p> T3.DURATION A13,</p><p> T3.AUDIOSTREAMCOUNT A14,</p><p> T3.AUDIOENCODING A15,</p><p> T3.AUDIOBITRATE A16,</p><p> T3.VIDEOENCODING A17,</p><p> T3.VIDEOBITRATE A18,</p><p> T3.WIDTH A19,</p><p> T3.HEIGHT A20,</p><p> T3.ASPECTRATIO A21,</p><p> T3.FPS A22,</p><p> T3.ISDVD A23,</p><p> T3.STORYPLOT A24,</p><p> T4.ALBUM A25,</p><p> T4.DURATION_0 A26,</p><p> T4.TRACK A27,</p><p> T4.NUMTRACKS A28,</p><p> T4.ENCODING A29,</p><p> T4.BITRATE A30,</p><p> T4.DISCID A31,</p><p> T4.NUMDISCS A32,</p><p> T5.WIDTH_0 A33,</p><p> T5.HEIGHT_0 A34,</p><p> T5.EQUIPMENTMAKE A35,</p><p> T5.EQUIPMENTMODEL A36,</p><p> T5.EXPOSUREBIAS A37,</p><p> T5.EXPOSURETIME A38,</p><p> T5.FLASHMODE A39,</p><p> T5.FNUMBER A40,</p><p> T5.ISOSPEEDRATING A41,</p><p> T5.ORIENTATION A42,</p><p> T5.METERINGMODE A43,</p><p> T5.LATITUDE A44,</p><p> T5.LONGITUDE A45,</p><p> T5.CITY A46,</p><p> T5.STATE A47,</p><p> T5.COUNTRY A48,</p><p> T6.SERIESNAME A49,</p><p> T6.SEASON A50,</p><p> T6.SERIESSEASONNAME A51,</p><p> T6.EPISODENAME A52,</p><p> T6.FIRSTAIRED A53,</p><p> T7.MOVIENAME A54,</p><p> T7.ORIGNAME A55,</p><p> T7.IMDBID A56,</p><p> T7.TMDBID A57,</p><p> T7.COLLECTIONNAME A58,</p><p> T7.COLLECTIONID A59,</p><p> T7.RUNTIME A60,</p><p> T7.CERTIFICATION A61,</p><p> T7.TAGLINE A62,</p><p> T7.POPULARITY A63,</p><p> T7.BUDGET A64,</p><p> T7.REVENUE A65,</p><p> T7.SCORE A66,</p><p> T8.THUMBNAIL A67,</p><p> T9.THUMBNAIL_0 A68,</p><p> T10.CHANNEL A69,</p><p> T10.STARTTIME A70,</p><p> T10.ENDTIME A71</p><p>FROM M_MEDIAITEM T0</p><p> LEFT OUTER JOIN M_PROVIDERRESOURCE T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMPORTEDITEM T2 ON T2.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_DIRECTORY T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_VIDEOITEM T3 ON T3.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_AUDIOITEM T4 ON T4.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_IMAGEITEM T5 ON T5.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_SERIESITEM T6 ON T6.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_MOVIEITEM T7 ON T7.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_THUMBNAILSMALL T8 ON T8.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_THUMBNAILLARGE T9 ON T9.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN M_RECORDINGITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN NM_GENRES T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES T11 ON T20.ID = T11.ID</p><p> LEFT OUTER JOIN NM_ACTORS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ACTORS T12 ON T21.ID = T12.ID</p><p> LEFT OUTER JOIN NM_DIRECTORS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_DIRECTORS T13 ON T22.ID = T13.ID</p><p> LEFT OUTER JOIN NM_WRITERS T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_WRITERS T14 ON T23.ID = T14.ID</p><p> LEFT OUTER JOIN NM_ARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ARTISTS T15 ON T24.ID = T15.ID</p><p> LEFT OUTER JOIN NM_GENRES_0 T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_GENRES_0 T16 ON T25.ID = T16.ID</p><p> LEFT OUTER JOIN NM_ALBUMARTISTS T26 ON T26.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_ALBUMARTISTS T17 ON T26.ID = T17.ID</p><p> LEFT OUTER JOIN NM_COMPOSERS T27 ON T27.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID</p><p> LEFT OUTER JOIN V_COMPOSERS T18 ON T27.ID = T18.ID </p><p>WHERE</p><p> (</p><p> T0.TITLE LIKE @V0 ESCAPE @E1</p><p> OR T0.MIMETYPE LIKE @V2 ESCAPE @E3</p><p> OR T0.COMMENT LIKE @V4 ESCAPE @E5</p><p> OR T1.SYSTEM_ID LIKE @V6 ESCAPE @E7</p><p> OR T1.PATH LIKE @V8 ESCAPE @E9</p><p> OR T11.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11</p><p> OR T3.AUDIOENCODING LIKE @V12 ESCAPE @E13</p><p> OR T3.VIDEOENCODING LIKE @V14 ESCAPE @E15</p><p> OR T12.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17</p><p> OR T13.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19</p><p> OR T14.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21</p><p> OR T3.STORYPLOT LIKE @V22 ESCAPE @E23</p><p> OR T15.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25</p><p> OR T4.ALBUM LIKE @V26 ESCAPE @E27</p><p> OR T16.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29</p><p> OR T17.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31</p><p> OR T18.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33</p><p> OR T4.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35</p><p> OR T5.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37</p><p> OR T5.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39</p><p> OR T5.EXPOSUREBIAS LIKE @V40 ESCAPE @E41</p><p> OR T5.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43</p><p> OR T5.FLASHMODE LIKE @V44 ESCAPE @E45</p><p> OR T5.FNUMBER LIKE @V46 ESCAPE @E47</p><p> OR T5.ISOSPEEDRATING LIKE @V48 ESCAPE @E49</p><p> OR T5.METERINGMODE LIKE @V50 ESCAPE @E51</p><p> OR T5.CITY LIKE @V52 ESCAPE @E53</p><p> OR T5.STATE LIKE @V54 ESCAPE @E55</p><p> OR T5.COUNTRY LIKE @V56 ESCAPE @E57</p><p> OR T6.SERIESNAME LIKE @V58 ESCAPE @E59</p><p> OR T6.SERIESSEASONNAME LIKE @V60 ESCAPE @E61</p><p> OR T6.EPISODENAME LIKE @V62 ESCAPE @E63</p><p> OR T7.MOVIENAME LIKE @V64 ESCAPE @E65</p><p> OR T7.ORIGNAME LIKE @V66 ESCAPE @E67</p><p> OR T7.IMDBID LIKE @V68 ESCAPE @E69</p><p> OR T7.COLLECTIONNAME LIKE @V70 ESCAPE @E71</p><p> OR T7.CERTIFICATION LIKE @V72 ESCAPE @E73</p><p> OR T7.TAGLINE LIKE @V74 ESCAPE @E75</p><p> OR T10.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: 1028064, member: 17886"] [U]SQL7 (Genres)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_GENRES_0 T0 INNER JOIN V_GENRES_0 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]SQL8 (Albumartist)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_ALBUMARTISTS T0 INNER JOIN V_ALBUMARTISTS 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]SQL9 (Composers)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_COMPOSERS T0 INNER JOIN V_COMPOSERS 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]SQL10 (Episode)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_EPISODE T0 INNER JOIN V_EPISODE 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]SQL11 (DVDEpisode)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A0, T9.ATTRIBUTE_VALUE A1 FROM NM_DVDEPISODE T0 INNER JOIN V_DVDEPISODE 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]SQL12 (Mediaitem)[/U] [SPOILER] SELECT T0.MEDIA_ITEM_ID A72, T0.MEDIA_ITEM_ID A73, T1.MEDIA_ITEM_ID A74, T2.MEDIA_ITEM_ID A75, T19.MEDIA_ITEM_ID A76, T3.MEDIA_ITEM_ID A77, T4.MEDIA_ITEM_ID A78, T5.MEDIA_ITEM_ID A79, T6.MEDIA_ITEM_ID A80, T7.MEDIA_ITEM_ID A81, T8.MEDIA_ITEM_ID A82, T9.MEDIA_ITEM_ID A83, T10.MEDIA_ITEM_ID A84, T0.TITLE A0, T0.MIMETYPE A1, T0.RECORDINGTIME A2, T0.RATING A3, T0.COMMENT A4, T0.PLAYCOUNT A5, T0.LASTPLAYED A6, T1.SYSTEM_ID A7, T1.PATH A8, T1.PARENTDIRECTORY A9, T2.LASTIMPORTDATE A10, T2.DIRTY A11, T2.DATEADDED A12, T3.DURATION A13, T3.AUDIOSTREAMCOUNT A14, T3.AUDIOENCODING A15, T3.AUDIOBITRATE A16, T3.VIDEOENCODING A17, T3.VIDEOBITRATE A18, T3.WIDTH A19, T3.HEIGHT A20, T3.ASPECTRATIO A21, T3.FPS A22, T3.ISDVD A23, T3.STORYPLOT A24, T4.ALBUM A25, T4.DURATION_0 A26, T4.TRACK A27, T4.NUMTRACKS A28, T4.ENCODING A29, T4.BITRATE A30, T4.DISCID A31, T4.NUMDISCS A32, T5.WIDTH_0 A33, T5.HEIGHT_0 A34, T5.EQUIPMENTMAKE A35, T5.EQUIPMENTMODEL A36, T5.EXPOSUREBIAS A37, T5.EXPOSURETIME A38, T5.FLASHMODE A39, T5.FNUMBER A40, T5.ISOSPEEDRATING A41, T5.ORIENTATION A42, T5.METERINGMODE A43, T5.LATITUDE A44, T5.LONGITUDE A45, T5.CITY A46, T5.STATE A47, T5.COUNTRY A48, T6.SERIESNAME A49, T6.SEASON A50, T6.SERIESSEASONNAME A51, T6.EPISODENAME A52, T6.FIRSTAIRED A53, T7.MOVIENAME A54, T7.ORIGNAME A55, T7.IMDBID A56, T7.TMDBID A57, T7.COLLECTIONNAME A58, T7.COLLECTIONID A59, T7.RUNTIME A60, T7.CERTIFICATION A61, T7.TAGLINE A62, T7.POPULARITY A63, T7.BUDGET A64, T7.REVENUE A65, T7.SCORE A66, T8.THUMBNAIL A67, T9.THUMBNAIL_0 A68, T10.CHANNEL A69, T10.STARTTIME A70, T10.ENDTIME A71 FROM M_MEDIAITEM T0 LEFT OUTER JOIN M_PROVIDERRESOURCE T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMPORTEDITEM T2 ON T2.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_DIRECTORY T19 ON T19.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_VIDEOITEM T3 ON T3.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_AUDIOITEM T4 ON T4.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMAGEITEM T5 ON T5.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_SERIESITEM T6 ON T6.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_MOVIEITEM T7 ON T7.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_THUMBNAILSMALL T8 ON T8.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_THUMBNAILLARGE T9 ON T9.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_RECORDINGITEM T10 ON T10.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN NM_GENRES T20 ON T20.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES T11 ON T20.ID = T11.ID LEFT OUTER JOIN NM_ACTORS T21 ON T21.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ACTORS T12 ON T21.ID = T12.ID LEFT OUTER JOIN NM_DIRECTORS T22 ON T22.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_DIRECTORS T13 ON T22.ID = T13.ID LEFT OUTER JOIN NM_WRITERS T23 ON T23.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_WRITERS T14 ON T23.ID = T14.ID LEFT OUTER JOIN NM_ARTISTS T24 ON T24.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T15 ON T24.ID = T15.ID LEFT OUTER JOIN NM_GENRES_0 T25 ON T25.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_GENRES_0 T16 ON T25.ID = T16.ID LEFT OUTER JOIN NM_ALBUMARTISTS T26 ON T26.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ALBUMARTISTS T17 ON T26.ID = T17.ID LEFT OUTER JOIN NM_COMPOSERS T27 ON T27.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_COMPOSERS T18 ON T27.ID = T18.ID WHERE ( T0.TITLE LIKE @V0 ESCAPE @E1 OR T0.MIMETYPE LIKE @V2 ESCAPE @E3 OR T0.COMMENT LIKE @V4 ESCAPE @E5 OR T1.SYSTEM_ID LIKE @V6 ESCAPE @E7 OR T1.PATH LIKE @V8 ESCAPE @E9 OR T11.ATTRIBUTE_VALUE LIKE @V10 ESCAPE @E11 OR T3.AUDIOENCODING LIKE @V12 ESCAPE @E13 OR T3.VIDEOENCODING LIKE @V14 ESCAPE @E15 OR T12.ATTRIBUTE_VALUE LIKE @V16 ESCAPE @E17 OR T13.ATTRIBUTE_VALUE LIKE @V18 ESCAPE @E19 OR T14.ATTRIBUTE_VALUE LIKE @V20 ESCAPE @E21 OR T3.STORYPLOT LIKE @V22 ESCAPE @E23 OR T15.ATTRIBUTE_VALUE LIKE @V24 ESCAPE @E25 OR T4.ALBUM LIKE @V26 ESCAPE @E27 OR T16.ATTRIBUTE_VALUE LIKE @V28 ESCAPE @E29 OR T17.ATTRIBUTE_VALUE LIKE @V30 ESCAPE @E31 OR T18.ATTRIBUTE_VALUE LIKE @V32 ESCAPE @E33 OR T4.ENCODING LIKE @[USER=15455]v34[/USER] ESCAPE @E35 OR T5.EQUIPMENTMAKE LIKE @V36 ESCAPE @E37 OR T5.EQUIPMENTMODEL LIKE @V38 ESCAPE @E39 OR T5.EXPOSUREBIAS LIKE @V40 ESCAPE @E41 OR T5.EXPOSURETIME LIKE @[USER=112108]V42[/USER] ESCAPE @E43 OR T5.FLASHMODE LIKE @V44 ESCAPE @E45 OR T5.FNUMBER LIKE @V46 ESCAPE @E47 OR T5.ISOSPEEDRATING LIKE @V48 ESCAPE @E49 OR T5.METERINGMODE LIKE @V50 ESCAPE @E51 OR T5.CITY LIKE @V52 ESCAPE @E53 OR T5.STATE LIKE @V54 ESCAPE @E55 OR T5.COUNTRY LIKE @V56 ESCAPE @E57 OR T6.SERIESNAME LIKE @V58 ESCAPE @E59 OR T6.SERIESSEASONNAME LIKE @V60 ESCAPE @E61 OR T6.EPISODENAME LIKE @V62 ESCAPE @E63 OR T7.MOVIENAME LIKE @V64 ESCAPE @E65 OR T7.ORIGNAME LIKE @V66 ESCAPE @E67 OR T7.IMDBID LIKE @V68 ESCAPE @E69 OR T7.COLLECTIONNAME LIKE @V70 ESCAPE @E71 OR T7.CERTIFICATION LIKE @V72 ESCAPE @E73 OR T7.TAGLINE LIKE @V74 ESCAPE @E75 OR T10.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
