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 jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(20,213,51,133,52,24,47,293,225,237,157,1,187,209,61,211,37,215,182,18,48,271,273,283,285,73,281,277,275,279)
AND jf_content.reference_table='menu'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 18)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 263
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 06:55:09' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 06:55:09' ) ) OR ( a.state = -1 ) )
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(263)
AND jf_content.reference_table='content'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(263)
AND jf_content.reference_table='users'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(55)
AND jf_content.reference_table='categories'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(21)
AND jf_content.reference_table='sections'
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='263'
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '263'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
SELECT *
FROM jos_chrono_comments
WHERE id = '678'
SELECT *
FROM jos_chrono_comments
WHERE parentid='678'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT *
FROM jos_chrono_comments
WHERE id = '709'
SELECT *
FROM jos_chrono_comments
WHERE parentid='709'
AND published='1'
AND verify='1'
ORDER BY datetime
SELECT a.id, 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_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 55
AND a.state = 1
AND a.access <= 0
AND ( a.state = 1 OR a.state = -1 )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-05-20 06:55:09' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-05-20 06:55:09' )
ORDER BY a.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(345,341,339,331,325,271,263,259,257,239,229,227,197,165,195)
AND jf_content.reference_table='content'
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 <= 0
AND m.client_id = 0
AND ( mm.menuid = 18 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(83,33,1,103,75,16,113,101,27,95,25,29)
AND jf_content.reference_table='modules'
Written by Eduardo Vales | 
| 
| 
Comments
It does not take very long for Jack to fall under the spell of goodwill shown by the cheery inhabitants of Christmas town.
He soon becomes completely captivated with Christmas town and Christmas. After Jack learns about the legend of Santa Claus, he decides to tell all of his friends in Halloween town about the wonders he has just witnessed.
cheapest dvd movies,cheapest dvd online,cheapest dvd player,cheapest dvd prices,cheapest dvd recorder
cheapest dvd s,cheapest dvds,cheapest dvds for sale,cheapest dvds online,cheapest movies