Skip to content

Instantly share code, notes, and snippets.

@ydenyshchenk
Created March 8, 2017 07:03
Show Gist options
  • Save ydenyshchenk/7838a35a56508709a43581d939aa0291 to your computer and use it in GitHub Desktop.
Save ydenyshchenk/7838a35a56508709a43581d939aa0291 to your computer and use it in GitHub Desktop.
select 'enterprise_url_rewrite_redirect_cl' as changelog, count(cl.version_id) from `enterprise_url_rewrite_redirect_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'enterprise_url_rewrite_redirect_cl' where cl.version_id > emm.version_id
union select 'cataloginventory_stock_status_cl' as changelog, count(cl.version_id) from `cataloginventory_stock_status_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'cataloginventory_stock_status_cl' where cl.version_id > emm.version_id
union select 'enterprise_url_rewrite_category_cl' as changelog, count(cl.version_id) from `enterprise_url_rewrite_category_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'enterprise_url_rewrite_category_cl' where cl.version_id > emm.version_id
union select 'enterprise_url_rewrite_product_cl' as changelog, count(cl.version_id) from `enterprise_url_rewrite_product_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'enterprise_url_rewrite_product_cl' where cl.version_id > emm.version_id
union select 'catalog_category_product_index_cl' as changelog, count(cl.version_id) from `catalog_category_product_index_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'catalog_category_product_index_cl' where cl.version_id > emm.version_id
union select 'catalog_category_product_cat_cl' as changelog, count(cl.version_id) from `catalog_category_product_cat_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'catalog_category_product_cat_cl' where cl.version_id > emm.version_id
union select 'catalog_product_index_price_cl' as changelog, count(cl.version_id) from `catalog_product_index_price_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'catalog_product_index_price_cl' where cl.version_id > emm.version_id
union select 'catalog_category_flat_cl' as changelog, count(cl.version_id) from `catalog_category_flat_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'catalog_category_flat_cl' where cl.version_id > emm.version_id
union select 'catalog_product_flat_cl' as changelog, count(cl.version_id) from `catalog_product_flat_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'catalog_product_flat_cl' where cl.version_id > emm.version_id
union select 'catalogsearch_fulltext_cl' as changelog, count(cl.version_id) from `catalogsearch_fulltext_cl` cl left join enterprise_mview_metadata emm on emm.changelog_name = 'catalogsearch_fulltext_cl' where cl.version_id > emm.version_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment