SELECT * FROM cms_1_contents_ WHERE SUB='0' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="" ORDER BY POSITION ASC
SELECT * FROM cms_1_slider_ WHERE ACTIVE="1" ORDER BY NUMBER DESC
SELECT * FROM cms_1_shop_ WHERE MAINPAGE='1'
SELECT * FROM cms_1_contents_ WHERE ACTIVE='1' AND MODULE='home'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_contents_ WHERE ACTIVE='1' AND MAIN!='0' ORDER BY MAIN ASC LIMIT 9
SELECT * FROM cms_1_workers_ WHERE ACTIVE="1" ORDER BY NO ASC LIMIT 3
SELECT * FROM cms_1_news_ WHERE ACTIVE='1' ORDER BY PUBDATE DESC LIMIT 3
SELECT * FROM cms_1_shop_ WHERE ACTIVE='1' AND MAINPAGE='1' AND STOCK!='1' ORDER BY RAND(),VIEW DESC LIMIT 6
SELECT * FROM cms_1_comments WHERE CONTENTTYPE='5' AND ACTIVE='1' ORDER BY RAND() LIMIT 1
SELECT * FROM cms_1_contents_ WHERE ACTIVE='1' AND MODULE='home' AND SUB='0'
| maingatlan.hu
SELECT * FROM cms_1_news_ WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_contents_ WHERE ACTIVE='1' AND SUB='0' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_contents_ WHERE ACTIVE='1' AND SUB='' ORDER BY NO ASC
Serényi Annamáriát ingatlanunk eladásával bíztuk meg.Nagyon kellemesen csalódtunk személyével kapcsolatban.Igazán kedves , segítőkész , barátságos a modora.A szakmai hozzáértése is kifogástalan, sok jó tanáccsal is ellátott minket.Zavarhattuk problémákkal,bármikor állt rendelkezésünkre.Ügyintézése gyors,pontos.
Szívből ajánlom minenkinek sok szeretettel !
Gabi & Lali