DELETE
FROM jos_session
WHERE ( time < '1268539391' )
SELECT *
FROM jos_session
WHERE session_id = 'vf4fek6lv5644h84mmu7ineut7'
SELECT value
FROM jos_core_acl_aro_groups
WHERE id IN ( 0,29 )
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'vf4fek6lv5644h84mmu7ineut7','1268540291','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access IN (0)
ORDER BY ordering
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'tu-casa/finanzas-personales/tu-casa/%' OR sefurl LIKE 'tu-casa/finanzas-personales/tu-casa/%'
SELECT `id`,`link`
FROM jos_menu
WHERE ((`name` LIKE '%tu casa%')
AND (`published` > 0))
SELECT oldurl, newurl
FROM jos_redirection
WHERE oldurl = 'tu-casa/finanzas-personales/tu-casa/'
ORDER BY rank ASC
LIMIT 1
UPDATE jos_redirection
SET cpt=(cpt+1)
WHERE `newurl` = 'index.php?option=com_content&Itemid=5&id=24&lang=es&layout=blog&view=category'
AND `oldurl` = 'tu-casa/finanzas-personales/tu-casa/'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT `option`
FROM jos_components
WHERE parent=0
AND iscore=0
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 5)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.section
WHERE c.id = 24
LIMIT 0, 1
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access IN (0)
AND a.catid = 24
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-03-14 04:18:12' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-03-14 04:18:12' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 9
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access IN (0)
AND a.catid = 24
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-03-14 04:18:12' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-03-14 04:18:12' )
ORDER BY a.created DESC, a.created DESC
SELECT *
FROM jos_jaclplus_acl
WHERE ( aro_section ='users'
AND aro_value IN ( 0,29 ) ) OR ( aro_section ='user'
AND aro_value = '0' )
SELECT id,tterm,tdefinition
FROM jos_definition
WHERE published=1
ORDER BY length(tterm) DESC
SELECT id,tterm,tdefinition
FROM jos_definition
WHERE published=1
ORDER BY length(tterm) DESC
SELECT *
FROM jos_content
WHERE id = '698'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=5&catid=24&id=698&lang=es&layout=default&page=&print=1&tmpl=component&view=article'
SELECT alias
FROM jos_content
WHERE id=698
SELECT s.title AS section, c.title AS category, a.alias AS title
FROM jos_content AS a
LEFT JOIN jos_sections AS s
ON a.sectionid=s.id
LEFT JOIN jos_categories AS c
ON a.catid=c.id
WHERE a.id=698
SELECT id,tterm,tdefinition
FROM jos_definition
WHERE published=1
ORDER BY length(tterm) DESC
SELECT *
FROM jos_content
WHERE id = '8'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=5&catid=24&id=8&lang=es&layout=default&page=&print=1&tmpl=component&view=article'
SELECT alias
FROM jos_content
WHERE id=8
SELECT s.title AS section, c.title AS category, a.alias AS title
FROM jos_content AS a
LEFT JOIN jos_sections AS s
ON a.sectionid=s.id
LEFT JOIN jos_categories AS c
ON a.catid=c.id
WHERE a.id=8
SELECT id,tterm,tdefinition
FROM jos_definition
WHERE published=1
ORDER BY length(tterm) DESC
SELECT *
FROM jos_content
WHERE id = '7'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=5&catid=24&id=7&lang=es&layout=default&page=&print=1&tmpl=component&view=article'
SELECT alias
FROM jos_content
WHERE id=7
SELECT s.title AS section, c.title AS category, a.alias AS title
FROM jos_content AS a
LEFT JOIN jos_sections AS s
ON a.sectionid=s.id
LEFT JOIN jos_categories AS c
ON a.catid=c.id
WHERE a.id=7
SELECT id,tterm,tdefinition
FROM jos_definition
WHERE published=1
ORDER BY length(tterm) DESC
SELECT *
FROM jos_content
WHERE id = '6'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=5&catid=24&id=6&lang=es&layout=default&page=&print=1&tmpl=component&view=article'
SELECT alias
FROM jos_content
WHERE id=6
SELECT s.title AS section, c.title AS category, a.alias AS title
FROM jos_content AS a
LEFT JOIN jos_sections AS s
ON a.sectionid=s.id
LEFT JOIN jos_categories AS c
ON a.catid=c.id
WHERE a.id=6
SELECT id,tterm,tdefinition
FROM jos_definition
WHERE published=1
ORDER BY length(tterm) DESC
SELECT *
FROM jos_content
WHERE id = '5'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=5&catid=24&id=5&lang=es&layout=default&page=&print=1&tmpl=component&view=article'
SELECT alias
FROM jos_content
WHERE id=5
SELECT s.title AS section, c.title AS category, a.alias AS title
FROM jos_content AS a
LEFT JOIN jos_sections AS s
ON a.sectionid=s.id
LEFT JOIN jos_categories AS c
ON a.catid=c.id
WHERE a.id=5
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access IN (0)
AND m.client_id = 0
AND ( mm.menuid = 5 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND s.id > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-14 04:18:12' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-14 04:18:12' )
AND a.access IN (0)
AND cc.access IN (0)
AND s.access IN (0)
AND (s.id=3)
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 0, 5
Finanzas personales 
Si alguna vez pensaste en probar suerte comprando una propiedad recuperada por el banco —porque sus dueños no pudieron pagarla—, este es el momento de ponerte los patines y empezar a informarte sobre cómo hacerlo.
Es importante de que estés consciente de que el préstamo para comprar tu casa quizá sea el más importante y el de mayor magnitud que obtengas en toda su vida. Por eso, antes de realizar cualquier acuerdo de préstamo, debes conocer ciertos derechos que tienes por ley.
En los últimos años, Estados Unidos ha realizado un esfuerzo enorme para que más familias tengan acceso al capital necesario para que puedan comprar sus casas. A pesar de este progreso, muchos en la actualidad sufren debido al creciente índice de prácticas abusivas en un segmento del mercado de préstamos hipotecarios.
Lo ideal sería encontrar la casa de tus sueños, hacer una oferta y comprarla al contado. Pero la realidad es otra, y en Estados Unidos nueve de cada 10 compradores de solicita un préstamo para financiar su casa, según la Asociación Nacional de Agentes Inmobiliarios.
Todo depende si prefieres viajar en limosina o si optas por llegar en taxi. La decisión de contratar a un abogado especializado en bienes raíces no es obligatoria. Sin embargo, tener a un profesional que cuide tus intereses podría ahorrarte mucho dinero a largo plazo.
RSS