Clasificados de Mexico
bienes raices y autos usados en Encuentra24

page = search
s_res = AND
cid = 504
off = 0
country_id = 1859
lang = es

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>1227206951

---

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

---

SELECT * FROM ec3_multi_lang_language WHERE id="es"

---

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

---

SELECT id,phrase FROM ec3_multi_lang_data WHERE lang_id="es"

---

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="projects" ORDER BY weight

---

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

---

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="{user_fields}" ORDER BY weight

---

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

---

SELECT COUNT(DISTINCT(fset)) FROM ec3_category WHERE id IN("504")

---

SELECT name AS country_name, descr FROM ec3_multi_lang_region WHERE id="1859" AND lang_id="es"

---

SELECT id FROM ec3_regions_category WHERE pid IN("1859")

---

SELECT id FROM ec3_regions_category WHERE pid IN("1860","1861")

---

SELECT name FROM ec3_regions_category WHERE id="1859"

---

SELECT id FROM ec3_category WHERE id IN("504") AND fset="projects"

---

LOCK TABLE ec3_ad AS l WRITE

---

SELECT COUNT(*) FROM ec3_ad l WHERE 1 AND (1=1) AND l.approved="1" AND l.user_approved="1" AND l.exp_date>=NOW() AND hw_region_id IN("1859","1860","1861") AND l.catid IN("504")

---

UNLOCK TABLES

---

DROP TEMPORARY TABLE IF EXISTS _func_cat_sql_ec3_category_es

---

CREATE TEMPORARY TABLE _func_cat_sql_ec3_category_es SELECT id,name,descr FROM ec3_multi_lang_category WHERE lang_id="es"

---

SELECT c.pid,IF(m.name<>'',m.name,c.name) AS name FROM ec3_category c LEFT JOIN _func_cat_sql_ec3_category_es m ON c.id=m.id WHERE 1 AND c.id="504"

---

SELECT c.pid,IF(m.name<>'',m.name,c.name) AS name FROM ec3_category c LEFT JOIN _func_cat_sql_ec3_category_es m ON c.id=m.id WHERE 1 AND c.id="440"

---

SELECT latitude, longitude, zoom FROM ec3_regions_category WHERE id=1859

---

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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR rid='') AND zone='rightbotes'

---

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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR rid='') AND zone='topsmalles'

---

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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR rid='') AND zone='1es-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 LIKE '%,504,%' OR cid='') AND (rid LIKE '%,1859,%' OR 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() AND hw_region_id IN("1859","1860","1861") ORDER BY RAND() LIMIT 0,1

---

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 LEFT JOIN ec3_ad_views ON ec3_ad.link_id = ec3_ad_views.linkid WHERE 1=1 AND approved="1" AND user_approved="1" AND exp_date>=NOW() AND hw_region_id IN("1859","1860","1861") AND catid IN ("504") ORDER BY views DESC LIMIT 0,10

---

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

---

SELECT COUNT(*) FROM ec3_session WHERE expires>1227208091

---