Etxebizitza Ministeriotik iragarritako Etxebizitza Gaiari buruzko Berehalako Neurriei buruz honakoa da Euskadiko Gazteriaren Kontseiluak (EGK) gizarteratu nahi duen balorazioa:
- Aurkeztutako neurriek euskal gazteriarengan ez dute inongo eraginik izango, gure lurraldean indarrean dauden etxebizitza politiken eskumenak EAEren menpe baitaude.
- Hartutako berehalako erabaki hauek EZ dute gazteok etxebizitzaren sarbiderako jasaten dugun arazoa konponduko. Izan ere, neurri hauek ez diote arazoaren muinari (eskubide baten merkantilizazioa) erreparatzen. Arazoak sortutako ondorioari nolabaiteko estalki eskasa baino ez diote jartzen.
- Neurri hauek (zeharkako laguntzak eta zenbait zergen arintzea) gizarte mailan atzerakoiak dira oso. Zergatik? Ez dituztelako laguntza hauek jasoko dituzten hartzaileen errenta maila ezberdinak diskriminatzen edo bereizten.
- Era berean, kontrajarriak eta kaltegarriak izango dira. Ikerketa askok argi uzten dute laguntza mota hauek edota zergen arintzeak, alokairuen prezioen garestitzea eragingo dutela (etxebizitzetako jabeek hala erabakita).
- EGKtik, uste dugu etxebizitzaren sarbiderako arazoaren konponketak ezinbestean honako ideiak barneratu behar dituela:
o Etxebizitzarako eskubidea, merkatu librearen logikatik at utzi. o Etxebizitza duin bat edukitzeko Eskubide Unibertsala onartu. o Pertsonen diru iturri ezberdinak kontuan hartu barik, guztiontzako sarbidea bermatuko duen alokairuzko etxebizitza publikoen parke bat sortu. o Erabilerarik gabeko etxebizitzak eta etxebizitza hutsak mobilizatu, hauen jabeei zigor neurriak edota sustapen neurriak ezarriz.
1
SELECT * FROM mos_mbf_language WHERE iso='es_ES'2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='2' LIMIT 14
DELETE FROM mos_session
WHERE (time < 1283720831)5
SELECT * FROM mos_session WHERE session_id='07729e7cc1996613f1fe54405e6862ac'6
SELECT session_id FROM mos_session WHERE session_id=MD5('0a1320544293e10f8c763b24647d7d33')7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '96a0f2d1b1007524773f704c633a780e','1283721731','','0','1' )8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering9
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering10
SELECT access FROM mos_menu WHERE id='2'11
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.id='276' AND (a.state = '1' OR a.state = '-1')
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-05 23:22:11')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-05 23:22:11')
AND a.access <= 012
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='276'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'13
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 1
AND a.state = 1 AND ordering < 16
AND a.access <= '0'
ORDER BY a.ordering DESC
LIMIT 114
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='295'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'15
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 1
AND a.state = 1 AND ordering > 16
AND a.access <= '0'
ORDER BY a.ordering
LIMIT 116
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='203'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'17
UPDATE mos_content SET hits=(hits+1) WHERE id='276'18
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2010-09-05' AND item_table='#__content' AND item_id='276'19
INSERT INTO mos_core_log_items VALUES
('2010-09-05','#__content','276','1')20
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering21
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'22
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'23
SELECT * FROM mos_mambots WHERE id='20'24
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'25
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'26
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'27
SELECT * FROM mos_mambots WHERE id='20'28
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'29
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'30
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'31
SELECT * FROM mos_mambots WHERE id='20'32
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'33
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'34
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'35
SELECT * FROM mos_mambots WHERE id='20'36
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='20'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'37
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'38
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='16'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'39
SELECT * FROM mos_mambots WHERE id='16'40
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='16'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'41
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'42
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'43
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering44
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='1'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'45
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='2'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'46
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='9'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'47
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='23'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'48
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='3'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'49
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='5'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'50
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='25'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'51
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='26'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'52
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='28'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'53
SELECT a.id
FROM mos_components AS a
WHERE a.name = 'Syndicate'54
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='17'
AND mbf_content.reference_table='components'
AND mbf_language.mambo='spanishi'55
SELECT * FROM mos_components WHERE id='17'56
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='17'
AND mbf_content.reference_table='components'
AND mbf_language.mambo='spanishi'57
SELECT id FROM mos_mambots WHERE element = 'tinymce' AND folder = 'editors'58
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='10'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'59
SELECT * FROM mos_mambots WHERE id='10'60
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='10'
AND mbf_content.reference_table='mambots'
AND mbf_language.mambo='spanishi'61
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'62
SELECT * FROM mos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering63
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='1'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'64
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='2'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'65
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='9'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'66
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='23'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'67
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='3'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'68
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='5'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'69
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='25'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'70
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='26'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'71
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='28'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'72
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '2' OR mm.menuid = '0')
ORDER BY ordering73
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='18'
AND mbf_content.reference_table='modules'
AND mbf_language.mambo='spanishi'74
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='15'
AND mbf_content.reference_table='modules'
AND mbf_language.mambo='spanishi'75
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='2'
AND mbf_content.reference_table='modules'
AND mbf_language.mambo='spanishi'76
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='31'
AND mbf_content.reference_table='modules'
AND mbf_language.mambo='spanishi'77
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='9'
AND mbf_content.reference_table='modules'
AND mbf_language.mambo='spanishi'78
SELECT m.* FROM mos_menu AS m
WHERE menutype='Menu_Usuario' AND published='1' AND access <= '0'
ORDER BY parent,ordering79
SELECT m.* FROM mos_menu AS m
WHERE menutype='Menu_Administrador' AND published='1' AND access <= '0'
ORDER BY parent,ordering80
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='11'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'81
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=182
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 3,183
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='21'84
SELECT a.id, a.title, a.sectionid, a.catid
FROM mos_content AS a
LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 23:22:11' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 23:22:11' )
AND a.access <= '0'
ORDER BY a.hits DESC LIMIT 585
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='273'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'86
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='143'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'87
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='179'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'88
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='166'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'89
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='276'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'90
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'91
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'92
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=093
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=27394
SELECT id
FROM mos_menu
WHERE type='content_blog_section' AND published='1' AND componentid=095
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='9'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'96
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=14397
SELECT id
FROM mos_menu
WHERE type='content_blog_section' AND published='1' AND componentid=098
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='9'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'99
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=179100
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='2'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'101
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=166102
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='2'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'103
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=276104
SELECT mbf_content.reference_field, mbf_content.value
FROM mos_mbf_content AS mbf_content,
mos_mbf_language as mbf_language
WHERE mbf_content.language_id=mbf_language.id
AND mbf_content.published=1
AND mbf_content.reference_id='2'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'
Etxebizitza Ministeriotik iragarritako Etxebizitza Gaiari buruzko Berehalako Neurriei buruz honakoa da Euskadiko Gazteriaren Kontseiluak (EGK) gizarteratu nahi duen balorazioa: