Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.78 KB | None | 0 0
  1.     @seo_ids = { <? sql_implode(',', array('shoes-category-524', 'product-model-4865', 'product-id-1523', 'product-variation-3151')) ?> }
  2.  
  3.     FOR ( @i=0; @i<COUNT(@seo_ids); ++@i ) )
  4.         IF ( !content_pages.module_id )
  5.             SELECT
  6.                 content_pages.module_id,
  7.                 content_pages_names.name,
  8.                 structure_seo_entries.language_id
  9.             FROM structure_seo_entries
  10.             LEFT JOIN structure_seo_ids ON structure_seo_ids.id=structure_seo_entries.seo_id
  11.             LEFT JOIN content_pages ON content_pages.id=structure_seo_ids.row_id
  12.             LEFT JOIN content_pages_names ON content_pages_names.page_id=content_pages.id
  13.  
  14.             WHERE structure_seo_entries.seo_entry=seo_ids[@i];
  15.         ELSE
  16.             break
  17.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement