Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @seo_ids = { <? sql_implode(',', array('shoes-category-524', 'product-model-4865', 'product-id-1523', 'product-variation-3151')) ?> }
- FOR ( @i=0; @i<COUNT(@seo_ids); ++@i ) )
- IF ( !content_pages.module_id )
- SELECT
- content_pages.module_id,
- content_pages_names.name,
- structure_seo_entries.language_id
- FROM structure_seo_entries
- LEFT JOIN structure_seo_ids ON structure_seo_ids.id=structure_seo_entries.seo_id
- LEFT JOIN content_pages ON content_pages.id=structure_seo_ids.row_id
- LEFT JOIN content_pages_names ON content_pages_names.page_id=content_pages.id
- WHERE structure_seo_entries.seo_entry=seo_ids[@i];
- ELSE
- break
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement