SELECT * FROM cms_1_contents_sitemap.xml WHERE SUB='0' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC

SELECT * FROM cms_1_sidebar WHERE CONTENTID="" ORDER BY POSITION ASC

SELECT * FROM cms_1_slider_sitemap.xml WHERE ACTIVE="1" ORDER BY NUMBER DESC

SELECT * FROM cms_1_shop_sitemap.xml WHERE MAINPAGE='1'

SELECT * FROM cms_1_contents_sitemap.xml WHERE ACTIVE='1' AND MODULE='home'

SELECT * FROM cms_1_contents_sitemap.xml WHERE ACTIVE='1' AND MAIN !='0' AND MAIN IS NOT NULL ORDER BY MAIN ASC LIMIT 6

SELECT * FROM cms_1_news_sitemap.xml WHERE ACTIVE='1' ORDER BY PUBDATE DESC LIMIT 3

SELECT * FROM cms_1_shop_sitemap.xml WHERE ACTIVE='1' AND MAIN='1' ORDER BY RAND(),VIEW DESC LIMIT 8

SELECT *,(VIEW + CART + BUY) AS STATS FROM cms_1_shop_sitemap.xml WHERE ACTIVE='1' ORDER BY STATS DESC LIMIT 8

SELECT * FROM cms_1_shop_sitemap.xml WHERE ACTIVE='1' ORDER BY DATE DESC LIMIT 8

SELECT * FROM cms_1_shop_sitemap.xml WHERE ACTIVE='1' ORDER BY RAND(),VIEW DESC LIMIT 8

SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'

SELECT * FROM cms_1_contents_sitemap.xml WHERE ACTIVE='1' AND MODULE='home' AND SUB='0'

SELECT * FROM cms_1_news_sitemap.xml WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2

SELECT * FROM cms_1_contents_sitemap.xml WHERE ACTIVE='1' AND SUB='0' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO DESC LIMIT 1

SELECT * FROM cms_1_contents_sitemap.xml WHERE ACTIVE='1' AND SUB='' ORDER BY NO ASC

SELECT * FROM cms_1_templates_sitemap.xml WHERE EXTRA="0"