num queries: 1
select p.abbr, p.name, p.valid_as_of_date,
                  i.url, it.type_id, it.width, it.height, pl.url as link_url, pl2.url as ymedia_id,
                  p.intl_exclude_list,p.photo_provider,
                  p.morenews_include_leagues, p.morenews_exclude_leagues
                  from providers as p
                  left join partner_images as pi on pi.provider = p.abbr
                  left join images as i on pi.image = i.image_id
                  left join image_types as it on it.type_id = i.type
                  left join partner_links as pl on pl.provider = pi.provider and pl.type = 1
                  left join partner_links as pl2 on pl2.provider = p.abbr and pl2.type = 2
num queries: 2
select CONFERENCE_ID, NAME from CONFERENCES
num queries: 3
select DIVISION_ID, NAME from DIVISIONS
num queries: 4
select s.storyid, s.title, s.provider, s.author, s.priority,
                      s.unixtime, s.summary, s.article_template, s.url,
                      s.source,s.subcat1,s.subcat2,s.comments_enabled,
                      a.subtitle, a.issuedate, a.byline, a.text,
                      p.copyright, p.name as provider_long, e.type,
                      tn.title as topnews_title,
                      p.valid_as_of_date,
                      t.spaceid_suffix,
                      UNIX_TIMESTAMP(s.ts) as s_last_update,
                      UNIX_TIMESTAMP(a.ts) as a_last_update,
                      UNIX_TIMESTAMP(tn.ts) as tn_last_update from sportsnews as s
                  left join articles as a on s.storyid = a.storyid and
                                             s.subcat1 = a.subcat1
                  left join providers p on s.provider = p.abbr
                  left join expert_authors e on s.subcat1 = e.league and s.author = e.author
                  left join topnews tn on s.storyid = tn.storyid and s.subcat1 = tn.subcat1
                  left join article_templates t on s.article_template = t.template_id
                   where s.storyid = 'aw-wojnarowski_jeremy_lin_knicks_rockets_nba_021412' and s.subcat1 = 'nba' limit 1
num queries: 5
select s.storyid, s.title, s.provider, s.author, s.priority,
                      s.unixtime, s.summary, s.article_template, s.url,
                      s.source,s.subcat1,s.subcat2,s.comments_enabled,
                      a.subtitle, a.issuedate, a.byline, a.text,
                      p.copyright, p.name as provider_long, e.type,
                      tn.title as topnews_title,
                      p.valid_as_of_date,
                      t.spaceid_suffix,
                      UNIX_TIMESTAMP(s.ts) as s_last_update,
                      UNIX_TIMESTAMP(a.ts) as a_last_update,
                      UNIX_TIMESTAMP(tn.ts) as tn_last_update from sportsnews as s
                  left join articles as a on s.storyid = a.storyid and
                                             s.subcat1 = a.subcat1
                  left join providers p on s.provider = p.abbr
                  left join expert_authors e on s.subcat1 = e.league and s.author = e.author
                  left join topnews tn on s.storyid = tn.storyid and s.subcat1 = tn.subcat1
                  left join article_templates t on s.article_template = t.template_id
                   where s.storyid = 'aw-wojnarowski_jeremy_lin_knicks_rockets_nba_021412' and s.subcat1 = 'nba' limit 1
num queries: 6
select e.name, e.bio, e.description, e.expertsarchive_url, e.author_uuid,
                  ef.group_email, ef.spaceid, ef.title, ef.message,
                  e.spaceid_subpath,
                  GROUP_CONCAT(DISTINCT ea.league SEPARATOR ', ') as leagues
                  from experts as e
                  left join expert_authors as ea on ea.author = e.name
                  left join expert_feedback as ef on ef.name = e.name
                  group by e.name
num queries: 7
select e.name, i.url, i.type, it.width, it.height
                  from experts as e
                  left join expert_images as ei on ei.name = e.name
                  left join images as i on ei.image = i.image_id
                  left join image_types as it on it.type_id = i.type
                  where (i.type = 1 or i.type is null or i.type = 27)
num queries: 8
select e.name, jen.urn
                  from experts as e
                  join joint_expert_news as jen on jen.expert = e.name
num queries: 9
select p.abbr, p.name, p.valid_as_of_date,
                  i.url, it.type_id, it.width, it.height, pl.url as link_url, pl2.url as ymedia_id,
                  p.intl_exclude_list,p.photo_provider,
                  p.morenews_include_leagues, p.morenews_exclude_leagues
                  from providers as p
                  left join partner_images as pi on pi.provider = p.abbr
                  left join images as i on pi.image = i.image_id
                  left join image_types as it on it.type_id = i.type
                  left join partner_links as pl on pl.provider = pi.provider and pl.type = 1
                  left join partner_links as pl2 on pl2.provider = p.abbr and pl2.type = 2
num queries: 10
SELECT l.SHORT_NAME,
                      li.IPTC,
                      li.LEAGUE_RANK,
                      li.IPTC_RANK FROM LEAGUE_IPTC li JOIN LEAGUE l on l.LEAGUE_ID=li.LEAGUE  ORDER BY li.LEAGUE, IPTC_RANK
num queries: 11
select p.abbr, p.name, p.valid_as_of_date,
                  i.url, it.type_id, it.width, it.height, pl.url as link_url, pl2.url as ymedia_id,
                  p.intl_exclude_list,p.photo_provider,
                  p.morenews_include_leagues, p.morenews_exclude_leagues
                  from providers as p
                  left join partner_images as pi on pi.provider = p.abbr
                  left join images as i on pi.image = i.image_id
                  left join image_types as it on it.type_id = i.type
                  left join partner_links as pl on pl.provider = pi.provider and pl.type = 1
                  left join partner_links as pl2 on pl2.provider = p.abbr and pl2.type = 2
num queries: 12
select e.name, e.bio, e.description, e.expertsarchive_url, e.author_uuid,
                  ef.group_email, ef.spaceid, ef.title, ef.message,
                  e.spaceid_subpath,
                  GROUP_CONCAT(DISTINCT ea.league SEPARATOR ', ') as leagues
                  from experts as e
                  left join expert_authors as ea on ea.author = e.name
                  left join expert_feedback as ef on ef.name = e.name
                  group by e.name
num queries: 13
select e.name, i.url, i.type, it.width, it.height
                  from experts as e
                  left join expert_images as ei on ei.name = e.name
                  left join images as i on ei.image = i.image_id
                  left join image_types as it on it.type_id = i.type
                  where (i.type = 1 or i.type is null or i.type = 27)
num queries: 14
select e.name, jen.urn
                  from experts as e
                  join joint_expert_news as jen on jen.expert = e.name
num queries: 15
select storyid, provider, category, url from distlinks where storyid in ('.lego_topnews_uuid', '.lego_default_uuid_v1', '.lego_default_uuid_v2' )
num queries: 16
SELECT  s.storyid, s.subcat1, s.provider, p.valid_as_of_date,
                        UNIX_TIMESTAMP(s.ts) as s_last_update
                    FROM sportsnews s
INNER JOIN providers p on s.provider = p.abbr
                    WHERE (s.unixtime > 1328142600 and s.priority > 0 and s.subcat2 in ('lgns', 'story_recruiting', 'team_report', 'ept_sports_georgia_bulldogs', 'ept_sports_indiana_hoosiers', 'ept_sports_kentucky_wildcats', 'ept_sports_michigan_wolverines', 'ept_sports_missouri_power_mizzou', 'ept_sports_nascar_marbles', 'ept_sports_ncstate_wolfpack', 'ept_sports_oklahoma_sooners', 'ept_sports_olemiss_rebels', 'ept_sports_pittsburgh_panthers', 'ept_sports_rivals_footballrecruiting', 'ept_sports_texas_longhorns', 'ept_sports_texastech_raiders', 'ept_sports_usc_trojans', 'ept_sports_vanderbilt_commodores', 'ept_sports_alabama_crimsontide', 'ept_sports_california_goldenbears', 'ept_sports_florida_gators', 'ept_sports_floridastate_seminoles', 'ept_sports_iowastate_cyclones', 'ept_sports_louisianatech_bulldogs', 'ept_sports_northcarolina_tarheels', 'ept_sports_oklahomastate_cowboys', 'ept_sports_southcarolina_gamecocks', 'ept_sports_unlv_rebels', 'ept_sports_virginiatech_hokies', 'ept_sports_mississippistate_bulldogs', 'ept_sports_oregonstate_beavers'))
                    ORDER BY s.unixtime DESC
                    LIMIT 1 OFFSET 0
Array
(
    [0] => Array
        (
            [class] => connective
            [inclusive] => Array
                (
                    [0] => Array
                        (
                            [class] => connective
                            [inclusive] => Array
                                (
                                    [0] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => fcb559c7-584e-480d-be44-b8c6b60ade33
                                        )

                                    [1] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 54edcaf7-cdbb-43d7-a41b-bffdcc37fb56
                                        )

                                    [2] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 0839657e-6c78-4e67-9d21-5409b8eb8a2b
                                        )

                                    [3] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => a70566db-8a27-4473-bb6f-73380e4c965b
                                        )

                                    [4] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => de666450-3434-45fa-ac3d-ea6088f81691
                                        )

                                    [5] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => f4707a9e-944a-47ad-a831-3062394020c0
                                        )

                                    [6] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 6b24cdb1-fb0e-4eae-8f3f-41b3d8741f6b
                                        )

                                    [7] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 497660ab-6a82-4a53-b16c-6a93638f82dc
                                        )

                                    [8] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 19a5a5b1-6477-4f16-8a89-22fee8d3fccd
                                        )

                                    [9] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 99add987-dcd1-48ae-b801-e4aa58e4ebd0
                                        )

                                    [10] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 21d636bb-8aa8-4731-9147-93a932d2b27a
                                        )

                                    [11] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => ba4206fb-9043-48b4-9f77-d0eafd5887ed
                                        )

                                    [12] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 6237e2fb-9732-4a69-bb38-16cdcd4667ca
                                        )

                                    [13] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 4b2bf1a7-a780-428e-98ec-21f52c1073ce
                                        )

                                    [14] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 7789969d-5b14-4a6e-8e2c-ca6b83cb8cf7
                                        )

                                    [15] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => f7d799a7-9855-4f3b-8c5d-90c407ab22ee
                                        )

                                    [16] => Array
                                        (
                                            [class] => condition
                                            [field] => provider_id
                                            [operator] => is
                                            [subclass] => string
                                            [value] => 885f4802-0bf4-46d2-b22e-3c63e4aa0239
                                        )

                                )

                            [subclass] => or
                        )

                    [1] => Array
                        (
                            [class] => condition
                            [field] => published
                            [operator] => gt
                            [subclass] => datetime
                            [value] => 2012-02-01T19:30:00-05:00
                        )

                    [2] => Array
                        (
                            [class] => condition
                            [field] => tags
                            [operator] => is
                            [subclass] => string
                            [value] => ysports:slug=aw-wojnarowski_jeremy_lin_knicks_rockets_nba_021412
                        )

                )

            [subclass] => and
        )

)