Real Estate Panama - Real Estate Costa Rica

page = country
country_id =

SELECT settings FROM ec3_hw_settings

---

SELECT * FROM ec3_modules WHERE state="A" OR state="I" ORDER BY name

---

SELECT data FROM ec3_session WHERE session_id="38.103.63.56" AND expires>1227206270

---

SELECT id,name FROM ec3_multi_lang_language WHERE enabled="1" ORDER BY name

---

SELECT * FROM ec3_multi_lang_language WHERE id="en"

---

SELECT count(*) FROM ec3_field WHERE fset="lot"

---

SELECT ID,DB_F,TITLE,ERR_MSG,TYPE,INPUT,CHARS,SIZE,MIN,MAX,VALUE,REQUIRED,EDITABLE,SEARCH,SEARCH_K,ACTIVE,EXTRA,TXT FROM ec3_field WHERE fset="lot" ORDER BY weight

---

SELECT id, template_suffix, userid, category_id, region_id, postallowed FROM ec3_subdomains WHERE subdomain_name="beta.swisspanama.com"

---

SELECT id, code, name FROM ec3_regions_category WHERE pid=0 AND code<>"" ORDER BY name

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='left1top'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='left2bs'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='left3ss'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='left4so'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='left5os'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='left6sm'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='leftbot'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='right1top'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='right2'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='rightbot'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='country'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='topsmall'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='1-top728'

---

SELECT id,html_code,banner_url,link_url FROM ec3_banner_ads_banner WHERE active="1" AND date_start<=NOW() AND date_end>=NOW() AND (max_clicks=0 OR clicks<max_clicks) AND (max_imp=0 OR impressions<max_imp) AND cid='' AND rid='' AND zone='consortemedia728'

---

SELECT id FROM ec3_category WHERE pid IN("440")

---

SELECT id FROM ec3_category WHERE pid IN("441","442","443","464","504","527","573")

---

SELECT id FROM ec3_category WHERE pid IN("452","451","444","445","446","447","448","449","450","520","521","525","454","455","456","453","457","458","459","460","461","462","463","529","530")

---

SELECT id FROM ec3_category WHERE pid IN("531","532","533","534","535","536","537","538","539","540","541","542")

---

SELECT id FROM ec3_category WHERE pid IN("498")

---

SELECT id FROM ec3_category WHERE pid IN("499","503","500","501","502","563","581","584")

---

SELECT id FROM ec3_category WHERE pid IN("564","565","566","567","568","569","570","571","572")

---

SELECT link_id FROM ec3_ad WHERE hw_feat="1" AND catid IN ("440","441","442","443","464","504","527","573","452","451","444","445","446","447","448","449","450","520","521","525","454","455","456","453","457","458","459","460","461","462","463","529","530","531","532","533","534","535","536","537","538","539","540","541","542","498","499","503","500","501","502","563","581","584","564","565","566","567","568","569","570","571","572")

---

SELECT DISTINCT(db_f) FROM ec3_field WHERE fset NOT LIKE "{%"

---

SELECT link_id,images,catid,hw_auct_bid,hw_auct_bid_inc,hw_auct_bid_init,v_255_1,v_255_2,v_255_3,v_255_4,v_255_5,v_255_6,v_255_7,v_255_8,v_descr,v_title,d_price,hw_sold,text_1,v_255_10,v_255_11,v_255_12,v_255_13,v_255_14,v_255_15,v_255_16,v_255_17,v_255_18,v_255_19,v_255_20,v_255_21,v_255_22,v_255_23,v_255_24,v_255_25,v_255_26,v_255_27,v_255_28,v_255_29,v_255_30,v_255_31,v_255_32,v_255_33,v_255_34,v_255_35,v_255_36,v_255_37,v_255_38,v_255_39,v_255_40,v_255_41,v_255_42,v_255_43,v_255_9,v_price,v_zip,text_2,v_rent,text_3,text_4,text_5,v_255_44,v_255_45,v_255_46,v_255_47,v_255_48,v_255_49,v_255_50,v_255_51,v_255_52,v_255_53,v_255_54,v_255_55,v_255_56,dec_1,hw_av_enabled FROM ec3_ad WHERE link_id IN (116375,116361,117338,118144) AND approved="1" AND user_approved="1" AND exp_date>=NOW() ORDER BY RAND() LIMIT 0,1

---

SELECT COUNT(*) FROM ec3_user_online WHERE (UNIX_TIMESTAMP()-UNIX_TIMESTAMP(accessdate))<300

---

SELECT COUNT(*) FROM ec3_session WHERE expires>1227207410

---

SELECT name FROM ec3_regions_category WHERE id="1866"

---