Home

Enjoy Great Britain

Category - Quick Browse

 A | B | C | D | E | F | G | H | I | J | K | L | M |
 N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
 ...

To help you get the most from Great Britain and find out why England, Scotland, Northern Ireland and Wales are great places to live, work and visit check out the website listings below.

TOP

Link Directory


                Cached Google PageRank

Cheap hotels in Yorkshire  

Reserve cheap hotels in Yorkshire and find places to visit close to a wealth of attractions and places to visit. The Yorkshire cities of Leeds, York and Sheffield are a great contrast to the Yorkshire Dales and North York Moors.

                Cached Google PageRank

Cheap hotels in Middlesex  

Find cheap hotels in Middlesex

                Cached Google PageRank

Cheap hotels in Worcestershire  

Find cheap hotels in Worcestershire

                Cached Google PageRank

Cheap hotels in Wiltshire  

Search for cheap hotels in Wiltshire close to attractions including Stonehenge.

                Cached Google PageRank

Cheap hotels in Warwickshire  

The visitors guide to Warwickshire including what's on, entertainment listings, events, Warwickshire hotels, restaurants and bars in the county of Warwickshire, England. Reserve cheap hotels in Warwickshire.

-

Copyright © 2012 Enjoy Great Britain. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.
 


Town, Postcode, Attraction...

Lottery

Profile Information

Application afterLoad: 0.000 seconds, 0.38 MB
Application afterInitialise: 0.072 seconds, 6.01 MB
Application afterRoute: 0.110 seconds, 8.91 MB
Application afterDispatch: 0.955 seconds, 13.95 MB
Application afterRender: 1.000 seconds, 15.20 MB

Memory Usage

15986904

71 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '8e526db22d07ebae6b0bf264a1b1734f'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1327707796' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '8e526db22d07ebae6b0bf264a1b1734f'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '8e526db22d07ebae6b0bf264a1b1734f','1327708696','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. 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
  8. 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
  9. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 65)
      ORDER BY menuid DESC
      LIMIT 0, 1
  10. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=a&lang=en&no_html=1&task=category'
  11. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  12. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=b&lang=en&no_html=1&task=category'
  13. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  14. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=c&lang=en&no_html=1&task=category'
  15. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  16. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=d&lang=en&no_html=1&task=category'
  17. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  18. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=e&lang=en&no_html=1&task=category'
  19. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  20. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=f&lang=en&no_html=1&task=category'
  21. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  22. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=g&lang=en&no_html=1&task=category'
  23. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  24. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=h&lang=en&no_html=1&task=category'
  25. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  26. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=i&lang=en&no_html=1&task=category'
  27. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  28. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=j&lang=en&no_html=1&task=category'
  29. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  30. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=k&lang=en&no_html=1&task=category'
  31. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  32. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=l&lang=en&no_html=1&task=category'
  33. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  34. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=m&lang=en&no_html=1&task=category'
  35. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  36. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=n&lang=en&no_html=1&task=category'
  37. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  38. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=o&lang=en&no_html=1&task=category'
  39. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  40. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=p&lang=en&no_html=1&task=category'
  41. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  42. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=q&lang=en&no_html=1&task=category'
  43. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  44. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=r&lang=en&no_html=1&task=category'
  45. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  46. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=s&lang=en&no_html=1&task=category'
  47. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  48. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=t&lang=en&no_html=1&task=category'
  49. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  50. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=u&lang=en&no_html=1&task=category'
  51. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  52. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=v&lang=en&no_html=1&task=category'
  53. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  54. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=w&lang=en&no_html=1&task=category'
  55. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  56. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=x&lang=en&no_html=1&task=category'
  57. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  58. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=y&lang=en&no_html=1&task=category'
  59. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  60. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=z&lang=en&no_html=1&task=category'
  61. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  62. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jvse&Itemid=65&alpha=others&lang=en&no_html=1&task=category'
  63. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_jvse%'
  64. 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 = 65 OR mm.menuid = 0 )
      ORDER BY position, ordering
  65. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND catid = 14
      ORDER BY sticky DESC, ordering
      LIMIT 0, 4
  66. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 9
  67. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 33
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  68. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 1
  69. 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
      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 a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-27 23:58:17' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 23:58:17' )
      AND cc.id = 3
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  70. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND catid = 13
      ORDER BY sticky DESC, ordering
      LIMIT 0, 4
  71. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 2

234 legacy queries logged

  1. SELECT `debug_mode`
      FROM `jos_jvse_settings`
  2. SELECT `debug_mode`
      FROM `jos_jvse_settings`
  3. SELECT *
      FROM `jos_jvse_settings`
  4. SELECT *
      FROM `jos_jvse_settings`
  5. SELECT count(id) AS CNT
      FROM `jos_jvse_categories`
  6. SELECT count(id) AS CNT
      FROM `jos_jvse_categories`
  7. SELECT *
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED' 
      AND `link_status` = 'ESTABLISHED'
      ORDER BY `link_published_on`  DESC
      LIMIT 0, 5
  8. SELECT *
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED' 
      AND `link_status` = 'ESTABLISHED'
      ORDER BY `link_published_on`  DESC
      LIMIT 0, 5
  9. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '78'
      AND `bby` = ''
  10. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '78'
      AND `bby` = ''
  11. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '78'
      AND STATUS = '1'
  12. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '78'
      AND STATUS = '1'
  13. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  14. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  15. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '78'
      AND `status` = '1'
      AND `defprofile` = '1'
  16. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '78'
      AND `status` = '1'
      AND `defprofile` = '1'
  17. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '105'
  18. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '105'
  19. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '105'
  20. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '105'
  21. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '77'
      AND `bby` = ''
  22. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '77'
      AND `bby` = ''
  23. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '77'
      AND STATUS = '1'
  24. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '77'
      AND STATUS = '1'
  25. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  26. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  27. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '77'
      AND `status` = '1'
      AND `defprofile` = '1'
  28. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '77'
      AND `status` = '1'
      AND `defprofile` = '1'
  29. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '308'
  30. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '308'
  31. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '308'
  32. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '308'
  33. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '76'
      AND `bby` = ''
  34. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '76'
      AND `bby` = ''
  35. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '76'
      AND STATUS = '1'
  36. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '76'
      AND STATUS = '1'
  37. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  38. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  39. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '76'
      AND `status` = '1'
      AND `defprofile` = '1'
  40. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '76'
      AND `status` = '1'
      AND `defprofile` = '1'
  41. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '276'
  42. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '276'
  43. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '276'
  44. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '276'
  45. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '75'
      AND `bby` = ''
  46. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '75'
      AND `bby` = ''
  47. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '75'
      AND STATUS = '1'
  48. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '75'
      AND STATUS = '1'
  49. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  50. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  51. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '75'
      AND `status` = '1'
      AND `defprofile` = '1'
  52. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '75'
      AND `status` = '1'
      AND `defprofile` = '1'
  53. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '287'
  54. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '287'
  55. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '287'
  56. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '287'
  57. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '74'
      AND `bby` = ''
  58. SELECT `bid`
      FROM `jos_jvse_bookmarks`
      WHERE `lid` = '74'
      AND `bby` = ''
  59. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '74'
      AND STATUS = '1'
  60. SELECT count(revid) AS CNT
      FROM jos_jvse_linkreviews
      WHERE lid = '74'
      AND STATUS = '1'
  61. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  62. SELECT `enable_gpr`, `gpr_show_fe`, `gpr_show_be`
      FROM `jos_jvse_settings`
  63. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '74'
      AND `status` = '1'
      AND `defprofile` = '1'
  64. SELECT *
      FROM `jos_jvse_linkprof`
      WHERE `lid` = '74'
      AND `status` = '1'
      AND `defprofile` = '1'
  65. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '274'
  66. SELECT `snap_status`
      FROM `jos_jvse_categories`
      WHERE `id` = '274'
  67. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '274'
  68. SELECT `name`
      FROM `jos_jvse_categories`
      WHERE `id` = '274'
  69. SELECT id, cpid, name, description
      FROM jos_jvse_categories
      WHERE id = '0'
  70. SELECT id, cpid, name, description
      FROM jos_jvse_categories
      WHERE id = '0'
  71. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '0'
      AND `visibility` = '1'
      ORDER BY name ASC
  72. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '0'
      AND `visibility` = '1'
      ORDER BY name ASC
  73. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '1'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  74. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '1'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  75. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '4'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  76. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '4'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  77. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '2'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  78. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '2'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  79. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '259'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  80. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '259'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  81. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '3'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  82. SELECT *
      FROM `jos_jvse_categories`
      WHERE `cpid` = '3'
      AND `visibility` = '1'
      ORDER BY `name` ASC
  83. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '1'
      AND `link_status` = 'ESTABLISHED'
  84. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '1'
      AND `link_status` = 'ESTABLISHED'
  85. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '278'
      AND `link_status` = 'ESTABLISHED'
  86. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '278'
      AND `link_status` = 'ESTABLISHED'
  87. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '286'
      AND `link_status` = 'ESTABLISHED'
  88. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '286'
      AND `link_status` = 'ESTABLISHED'
  89. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '284'
      AND `link_status` = 'ESTABLISHED'
  90. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '284'
      AND `link_status` = 'ESTABLISHED'
  91. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '279'
      AND `link_status` = 'ESTABLISHED'
  92. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '279'
      AND `link_status` = 'ESTABLISHED'
  93. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '272'
      AND `link_status` = 'ESTABLISHED'
  94. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '272'
      AND `link_status` = 'ESTABLISHED'
  95. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '264'
      AND `link_status` = 'ESTABLISHED'
  96. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '264'
      AND `link_status` = 'ESTABLISHED'
  97. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '296'
      AND `link_status` = 'ESTABLISHED'
  98. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '296'
      AND `link_status` = 'ESTABLISHED'
  99. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '102'
      AND `link_status` = 'ESTABLISHED'
  100. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '102'
      AND `link_status` = 'ESTABLISHED'
  101. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '262'
      AND `link_status` = 'ESTABLISHED'
  102. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '262'
      AND `link_status` = 'ESTABLISHED'
  103. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '295'
      AND `link_status` = 'ESTABLISHED'
  104. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '295'
      AND `link_status` = 'ESTABLISHED'
  105. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '294'
      AND `link_status` = 'ESTABLISHED'
  106. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '294'
      AND `link_status` = 'ESTABLISHED'
  107. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '103'
      AND `link_status` = 'ESTABLISHED'
  108. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '103'
      AND `link_status` = 'ESTABLISHED'
  109. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '283'
      AND `link_status` = 'ESTABLISHED'
  110. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '283'
      AND `link_status` = 'ESTABLISHED'
  111. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '281'
      AND `link_status` = 'ESTABLISHED'
  112. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '281'
      AND `link_status` = 'ESTABLISHED'
  113. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '261'
      AND `link_status` = 'ESTABLISHED'
  114. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '261'
      AND `link_status` = 'ESTABLISHED'
  115. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '292'
      AND `link_status` = 'ESTABLISHED'
  116. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '292'
      AND `link_status` = 'ESTABLISHED'
  117. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '277'
      AND `link_status` = 'ESTABLISHED'
  118. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '277'
      AND `link_status` = 'ESTABLISHED'
  119. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '282'
      AND `link_status` = 'ESTABLISHED'
  120. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '282'
      AND `link_status` = 'ESTABLISHED'
  121. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '293'
      AND `link_status` = 'ESTABLISHED'
  122. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '293'
      AND `link_status` = 'ESTABLISHED'
  123. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '290'
      AND `link_status` = 'ESTABLISHED'
  124. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '290'
      AND `link_status` = 'ESTABLISHED'
  125. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '106'
      AND `link_status` = 'ESTABLISHED'
  126. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '106'
      AND `link_status` = 'ESTABLISHED'
  127. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '268'
      AND `link_status` = 'ESTABLISHED'
  128. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '268'
      AND `link_status` = 'ESTABLISHED'
  129. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '263'
      AND `link_status` = 'ESTABLISHED'
  130. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '263'
      AND `link_status` = 'ESTABLISHED'
  131. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '285'
      AND `link_status` = 'ESTABLISHED'
  132. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '285'
      AND `link_status` = 'ESTABLISHED'
  133. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '260'
      AND `link_status` = 'ESTABLISHED'
  134. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '260'
      AND `link_status` = 'ESTABLISHED'
  135. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '308'
      AND `link_status` = 'ESTABLISHED'
  136. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '308'
      AND `link_status` = 'ESTABLISHED'
  137. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '270'
      AND `link_status` = 'ESTABLISHED'
  138. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '270'
      AND `link_status` = 'ESTABLISHED'
  139. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '273'
      AND `link_status` = 'ESTABLISHED'
  140. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '273'
      AND `link_status` = 'ESTABLISHED'
  141. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '101'
      AND `link_status` = 'ESTABLISHED'
  142. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '101'
      AND `link_status` = 'ESTABLISHED'
  143. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '265'
      AND `link_status` = 'ESTABLISHED'
  144. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '265'
      AND `link_status` = 'ESTABLISHED'
  145. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '280'
      AND `link_status` = 'ESTABLISHED'
  146. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '280'
      AND `link_status` = 'ESTABLISHED'
  147. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '269'
      AND `link_status` = 'ESTABLISHED'
  148. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '269'
      AND `link_status` = 'ESTABLISHED'
  149. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '267'
      AND `link_status` = 'ESTABLISHED'
  150. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '267'
      AND `link_status` = 'ESTABLISHED'
  151. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '288'
      AND `link_status` = 'ESTABLISHED'
  152. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '288'
      AND `link_status` = 'ESTABLISHED'
  153. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '266'
      AND `link_status` = 'ESTABLISHED'
  154. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '266'
      AND `link_status` = 'ESTABLISHED'
  155. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '275'
      AND `link_status` = 'ESTABLISHED'
  156. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '275'
      AND `link_status` = 'ESTABLISHED'
  157. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '289'
      AND `link_status` = 'ESTABLISHED'
  158. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '289'
      AND `link_status` = 'ESTABLISHED'
  159. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '291'
      AND `link_status` = 'ESTABLISHED'
  160. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '291'
      AND `link_status` = 'ESTABLISHED'
  161. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '104'
      AND `link_status` = 'ESTABLISHED'
  162. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '104'
      AND `link_status` = 'ESTABLISHED'
  163. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '274'
      AND `link_status` = 'ESTABLISHED'
  164. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '274'
      AND `link_status` = 'ESTABLISHED'
  165. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '271'
      AND `link_status` = 'ESTABLISHED'
  166. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '271'
      AND `link_status` = 'ESTABLISHED'
  167. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '287'
      AND `link_status` = 'ESTABLISHED'
  168. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '287'
      AND `link_status` = 'ESTABLISHED'
  169. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '276'
      AND `link_status` = 'ESTABLISHED'
  170. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '276'
      AND `link_status` = 'ESTABLISHED'
  171. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '105'
      AND `link_status` = 'ESTABLISHED'
  172. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '105'
      AND `link_status` = 'ESTABLISHED'
  173. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '4'
      AND `link_status` = 'ESTABLISHED'
  174. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '4'
      AND `link_status` = 'ESTABLISHED'
  175. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '257'
      AND `link_status` = 'ESTABLISHED'
  176. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '257'
      AND `link_status` = 'ESTABLISHED'
  177. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '251'
      AND `link_status` = 'ESTABLISHED'
  178. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '251'
      AND `link_status` = 'ESTABLISHED'
  179. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '252'
      AND `link_status` = 'ESTABLISHED'
  180. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '252'
      AND `link_status` = 'ESTABLISHED'
  181. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '253'
      AND `link_status` = 'ESTABLISHED'
  182. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '253'
      AND `link_status` = 'ESTABLISHED'
  183. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '254'
      AND `link_status` = 'ESTABLISHED'
  184. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '254'
      AND `link_status` = 'ESTABLISHED'
  185. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '255'
      AND `link_status` = 'ESTABLISHED'
  186. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '255'
      AND `link_status` = 'ESTABLISHED'
  187. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '256'
      AND `link_status` = 'ESTABLISHED'
  188. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '256'
      AND `link_status` = 'ESTABLISHED'
  189. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '2'
      AND `link_status` = 'ESTABLISHED'
  190. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '2'
      AND `link_status` = 'ESTABLISHED'
  191. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '303'
      AND `link_status` = 'ESTABLISHED'
  192. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '303'
      AND `link_status` = 'ESTABLISHED'
  193. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '306'
      AND `link_status` = 'ESTABLISHED'
  194. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '306'
      AND `link_status` = 'ESTABLISHED'
  195. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '299'
      AND `link_status` = 'ESTABLISHED'
  196. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '299'
      AND `link_status` = 'ESTABLISHED'
  197. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '153'
      AND `link_status` = 'ESTABLISHED'
  198. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '153'
      AND `link_status` = 'ESTABLISHED'
  199. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '152'
      AND `link_status` = 'ESTABLISHED'
  200. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '152'
      AND `link_status` = 'ESTABLISHED'
  201. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '154'
      AND `link_status` = 'ESTABLISHED'
  202. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '154'
      AND `link_status` = 'ESTABLISHED'
  203. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '301'
      AND `link_status` = 'ESTABLISHED'
  204. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '301'
      AND `link_status` = 'ESTABLISHED'
  205. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '300'
      AND `link_status` = 'ESTABLISHED'
  206. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '300'
      AND `link_status` = 'ESTABLISHED'
  207. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '304'
      AND `link_status` = 'ESTABLISHED'
  208. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '304'
      AND `link_status` = 'ESTABLISHED'
  209. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '305'
      AND `link_status` = 'ESTABLISHED'
  210. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '305'
      AND `link_status` = 'ESTABLISHED'
  211. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '302'
      AND `link_status` = 'ESTABLISHED'
  212. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '302'
      AND `link_status` = 'ESTABLISHED'
  213. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '151'
      AND `link_status` = 'ESTABLISHED'
  214. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '151'
      AND `link_status` = 'ESTABLISHED'
  215. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '297'
      AND `link_status` = 'ESTABLISHED'
  216. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '297'
      AND `link_status` = 'ESTABLISHED'
  217. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '298'
      AND `link_status` = 'ESTABLISHED'
  218. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '298'
      AND `link_status` = 'ESTABLISHED'
  219. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '307'
      AND `link_status` = 'ESTABLISHED'
  220. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '307'
      AND `link_status` = 'ESTABLISHED'
  221. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '259'
      AND `link_status` = 'ESTABLISHED'
  222. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '259'
      AND `link_status` = 'ESTABLISHED'
  223. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '205'
      AND `link_status` = 'ESTABLISHED'
  224. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '205'
      AND `link_status` = 'ESTABLISHED'
  225. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '204'
      AND `link_status` = 'ESTABLISHED'
  226. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '204'
      AND `link_status` = 'ESTABLISHED'
  227. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '3'
      AND `link_status` = 'ESTABLISHED'
  228. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '3'
      AND `link_status` = 'ESTABLISHED'
  229. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '202'
      AND `link_status` = 'ESTABLISHED'
  230. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '202'
      AND `link_status` = 'ESTABLISHED'
  231. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '201'
      AND `link_status` = 'ESTABLISHED'
  232. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '201'
      AND `link_status` = 'ESTABLISHED'
  233. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '203'
      AND `link_status` = 'ESTABLISHED'
  234. SELECT count(*) AS CNT
      FROM `jos_jvse_links`
      WHERE `link_status` != 'RECYCLED'
      AND `link_category` = '203'
      AND `link_status` = 'ESTABLISHED'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None