Skip to content

Instantly share code, notes, and snippets.

@LubosRemplik

LubosRemplik/gist:07877b83589e638e246ce8f55f918d09

Last active February 23, 2017 12:22
Show Gist options
  • Save LubosRemplik/07877b83589e638e246ce8f55f918d09 to your computer and use it in GitHub Desktop.
Save LubosRemplik/07877b83589e638e246ce8f55f918d09 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment