TR queries

gistfile1.sql

SELECT r.id AS r__id, r.created_sf_guard_user_id AS r__created_sf_guard_user_id, r.author_id AS r__author_id, r.published_at AS r__published_at, r.teaser_web AS r__teaser_web, r.teaser_newsletter AS r__teaser_newsletter, r.verdict AS r__verdict, r.product_id AS r__product_id, r.award_recommended AS r__award_recommended, r.award_editors_choice AS r__award_editors_choice, r.with_photos_tab AS r__with_photos_tab, r.first_look AS r__first_look, r.review_type AS r__review_type, r.overall_score AS r__overall_score, r.comments_id AS r__comments_id, r.review_price AS r__review_price, r.reviewed_at AS r__reviewed_at, r.adtech_keywords AS r__adtech_keywords, r.last_synced AS r__last_synced, r.standout_url AS r__standout_url, r.created_at AS r__created_at, r.updated_at AS r__updated_at, r.is_published AS r__is_published, r.publish_start AS r__publish_start, r.publish_end AS r__publish_end, a.id AS a__id, a.name AS a__name, a.created_at AS a__created_at, a.updated_at AS a__updated_at, p.id AS p__id, p.page_title AS p__page_title, p.heading AS p__heading, p.position AS p__position, p.dropdown_title AS p__dropdown_title, p2.id AS p2__id, p2.page_title AS p2__page_title, p2.heading AS p2__heading, p2.position AS p2__position, p2.dropdown_title AS p2__dropdown_title, r3.review_id AS r3__review_id, r3.page_id AS r3__page_id, r3.show_score AS r3__show_score, p4.id AS p4__id, p4.name AS p4__name, p4.name_raw AS p4__name_raw, p4.name_short AS p4__name_short, p4.page_title AS p4__page_title, p4.auto_seo_meta_page_title AS p4__auto_seo_meta_page_title, p4.meta_keywords AS p4__meta_keywords, p4.meta_description AS p4__meta_description, p4.meta_news_keywords AS p4__meta_news_keywords, p4.auto_seo_meta_description AS p4__auto_seo_meta_description, p4.manufacturer_id AS p4__manufacturer_id, p4.created_sf_guard_user_id AS p4__created_sf_guard_user_id, p4.mpn_row AS p4__mpn_row, p4.mpn_us AS p4__mpn_us, p4.fallback_price AS p4__fallback_price, p4.fallback_price_offers AS p4__fallback_price_offers, p4.fallback_price_provider AS p4__fallback_price_provider, p4.fallback_price_tbc AS p4__fallback_price_tbc, p4.pricegrabber_mid_uk AS p4__pricegrabber_mid_uk, p4.pricegrabber_mid_us AS p4__pricegrabber_mid_us, p4.recombu_id AS p4__recombu_id, p4.is_active AS p4__is_active, p4.pricegrabber_description AS p4__pricegrabber_description, p4.no_main_image AS p4__no_main_image, p4.no_thumbnail AS p4__no_thumbnail, p4.created_at AS p4__created_at, p4.updated_at AS p4__updated_at, p4.slug AS p4__slug, p4.related_id AS p4__related_id, p5.id AS p5__id, p5.product_category_id AS p5__product_category_id, p5.product_id AS p5__product_id, p5.is_main AS p5__is_main, p6.id AS p6__id, p6.title AS p6__title, p6.title_singular AS p6__title_singular, p6.title_feed AS p6__title_feed, p6.in_nav AS p6__in_nav, p6.old_id AS p6__old_id, p6.google_adsense_channel_id AS p6__google_adsense_channel_id, p6.seo_best_heading AS p6__seo_best_heading, p6.seo_best_text AS p6__seo_best_text, p6.seo_best_description AS p6__seo_best_description, p6.seo_best_title AS p6__seo_best_title, p6.seo_cheapest_heading AS p6__seo_cheapest_heading, p6.seo_cheapest_text AS p6__seo_cheapest_text, p6.seo_cheapest_description AS p6__seo_cheapest_description, p6.seo_cheapest_title AS p6__seo_cheapest_title, p6.seo_latest_heading AS p6__seo_latest_heading, p6.seo_latest_text AS p6__seo_latest_text, p6.seo_latest_description AS p6__seo_latest_description, p6.seo_latest_title AS p6__seo_latest_title, p6.keywords AS p6__keywords, p6.search_limit_days AS p6__search_limit_days, p6.root_id AS p6__root_id, p6.lft AS p6__lft, p6.rgt AS p6__rgt, p6.level AS p6__level, p6.slug AS p6__slug, p6.position AS p6__position, e.id AS e__id, e.ebay_global_id AS e__ebay_global_id, e.ebay_category_id AS e__ebay_category_id, e.ebay_campaign_id AS e__ebay_campaign_id, e.iso3166 AS e__iso3166, p7.id AS p7__id, p7.name AS p7__name, p7.position AS p7__position, m.id AS m__id, m.name AS m__name, m.url AS m__url, m.description AS m__description, m.slug AS m__slug, p8.id AS p8__id, p8.product_id AS p8__product_id, p8.media_id AS p8__media_id, p8.caption AS p8__caption, p8.is_main AS p8__is_main, m2.id AS m2__id, m2.file AS m2__file, m2.alt AS m2__alt, m2.mime AS m2__mime, m2.dimensions AS m2__dimensions, p9.id AS p9__id, p9.position AS p9__position, p9.prioritised AS p9__prioritised, v.id AS v__id, v.copytext AS v__copytext, v.title AS v__title, v.brightcove_id AS v__brightcove_id, v2.id AS v2__id, v2.video_id AS v2__video_id, v2.media_id AS v2__media_id, v2.caption AS v2__caption, m3.id AS m3__id, m3.file AS m3__file, m3.alt AS m3__alt, m3.mime AS m3__mime, m3.dimensions AS m3__dimensions FROM review r LEFT JOIN author a ON r.author_id = a.id LEFT JOIN review_pages r2 ON (r.id = r2.review_id) LEFT JOIN page p ON p.id = r2.page_id LEFT JOIN preview_pages p3 ON (r.id = p3.review_id) LEFT JOIN page p2 ON p2.id = p3.page_id LEFT JOIN review_pages r3 ON r.id = r3.review_id LEFT JOIN product p4 ON r.product_id = p4.id LEFT JOIN product_product_category p5 ON p4.id = p5.product_id LEFT JOIN product_category p6 ON p5.product_category_id = p6.id LEFT JOIN ebay_region e ON p6.id = e.product_category_id LEFT JOIN product_key_feature p7 ON p4.id = p7.product_id LEFT JOIN manufacturer m ON p4.manufacturer_id = m.id LEFT JOIN product_media p8 ON p4.id = p8.product_id LEFT JOIN media m2 ON p8.media_id = m2.id LEFT JOIN product_video p9 ON p4.id = p9.product_id LEFT JOIN video v ON p9.video_id = v.id LEFT JOIN video_media v2 ON v.id = v2.video_id LEFT JOIN media m3 ON v2.media_id = m3.id WHERE r.id IN ('6974') AND (p4.slug = 'samsung-galaxy-s4' AND p5.is_main = '1' AND (p8.is_main = 1 OR p8.position = 0) AND r.is_published = '1') ORDER BY p.position ASC, p2.position ASC, p6.position ASC, p7.position ASC, p8.position ASC, p9.position ASC, v2.position ASC