gistfile1.txt

SELECT `ShopProduct`.`id`, `ShopProduct`.`shop_category_id`, `ShopProduct`.`name`, `ShopProduct`.`slug`, `ShopProduct`.`meta_title`, `ShopProduct`.`meta_description`, `ShopProduct`.`meta_keywords`, `ShopProduct`.      `heading`, `ShopProduct`.`overview`, `ShopProduct`.`excerpt`, `ShopProduct`.`content`, `ShopProduct`.`sorting`, `ShopProduct`.`upload`, `ShopProduct`.`status`, `ShopProduct`.`created`, `ShopProduct`.`created_by`,      `ShopProduct`.`modified`, `ShopProduct`.`modified_by`, `ShopProduct`.`shop_order_item_count`, (`I18n__name`.`content`) AS `ShopProduct__i18n_name`, (`I18n__slug`.`content`) AS `ShopProduct__i18n_slug`,                 (`I18n__meta_title`.`content`) AS `ShopProduct__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `ShopProduct__i18n_meta_description`, (`I18n__meta_keywords`.`content`) AS `ShopProduct__i18n_meta_keywords`,   (`I18n__overview`.`content`) AS `ShopProduct__i18n_overview`, (`I18n__heading`.`content`) AS `ShopProduct__i18n_heading`, (`I18n__excerpt`.`content`) AS `ShopProduct__i18n_excerpt`, (`I18n__content`.`content`) AS      `ShopProduct__i18n_content`
    FROM `amex_partner_new`.`oc_shop_products` AS `ShopProduct`
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__name` ON (`ShopProduct`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ShopProduct' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__slug` ON (`ShopProduct`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'ShopProduct' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__meta_title` ON (`ShopProduct`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'ShopProduct' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__meta_description` ON (`ShopProduct`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'ShopProduct' AND            `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__meta_keywords` ON (`ShopProduct`.`id` = `I18n__meta_keywords`.`foreign_key` AND `I18n__meta_keywords`.`model` = 'ShopProduct' AND                     `I18n__meta_keywords`.`field` = 'meta_keywords' AND `I18n__meta_keywords`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__overview` ON (`ShopProduct`.`id` = `I18n__overview`.`foreign_key` AND `I18n__overview`.`model` = 'ShopProduct' AND `I18n__overview`.`field` =         'overview' AND `I18n__overview`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__heading` ON (`ShopProduct`.`id` = `I18n__heading`.`foreign_key` AND `I18n__heading`.`model` = 'ShopProduct' AND `I18n__heading`.`field` = 'heading'   AND `I18n__heading`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__excerpt` ON (`ShopProduct`.`id` = `I18n__excerpt`.`foreign_key` AND `I18n__excerpt`.`model` = 'ShopProduct' AND `I18n__excerpt`.`field` = 'excerpt'   AND `I18n__excerpt`.`locale` = 'de_ch')
    INNER JOIN `amex_partner_new`.`oc_shop_products_i18n` AS `I18n__content` ON (`ShopProduct`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'ShopProduct' AND `I18n__content`.`field` = 'content'   AND `I18n__content`.`locale` = 'de_ch')
    WHERE 1 = 1
    ORDER BY `ShopProduct`.`modified` asc
    LIMIT 20