stay

Holiday Quick Search

Sleeps Up to
Area
 
 
 
 
You are here:: Where to Stay YEW TREE COTTAGE
 
 

Where to stay in Dorset & The New Forest

With miles of beautiful coastline and chocolate box villages Dorset and the New Forest are the perfect places for a long or short break. Looking for accommodation in a particular area? Try West Dorset, North Dorset, East Dorset, Christchurch, Bournemouth & Poole, Isle of Purbeck, Weymouth & Portland the New forest or why not try one of our featured listings.
 
 
 
 
Dorset & New Forest Guide

YEW TREE COTTAGE

Price: £390-£915
Town: Fordingbridge
Area:
New Forest
Beds: 4

Favourite thatched cottage with 4+ bedrooms. Sleeps 8-10. Traditional forester's cottage with inglenook fireplace and free logs.
YEW TREE COTTAGE
Children Welcome Dogs Welcome Parking No Smoking
Gallery - Click the images to enlarge
Description

All-time favourite New Forest cottage.
Detached thatched cottage in its own secluded grounds.
4/5 bedrooms, sleeps up to 6 adults and 2 children comfortably, more at your discretion.
Two Z-beds and a cot available if you want to cram extra children - but note that the lounge is only comfortable for up to 8. The separate dining room has a table seating 10.
Two bathrooms (upstairs and down), one has a shower over the bath. Heated towel rail, and a WC on each floor.
Automatic washing machine.
Fabulous Inglenook Fireplace with free logs (September to May).
Electric storage heaters (electricity by pre-pay card meter).
Situated within the cattle grid area – free-roaming ponies & donkeys.
Bistro/Tearooms nearby (highly recommended by our visitors). Choice of 2 pubs within half a mile.
Forest walks and country lanes for cycling in all directions.
No smoking. Pets welcome.
We welcome e-mail enquiries, but we really prefer to talk one-to-one with applicants whenever possible. So if it is convenient for you please phone 01202-707885 and we can tell you all the pros and cons about this property. If you would like us to phone you please e-mail your number to Riawood@aol.com
Contact and Booking Details
Contact: Peter or Ria
Address: Yew Tree Cottage,
Post Office Lane,
Hyde,
Fordingbridge,
Hampshire,
SP6 2QW
Map - Click the marker to get directions
Date added: 2011-06-10 19:54:12

Other listings in this category

BEECHWOOD HOUSE on Hyde CommonLITTLE HURST FARM COTTAGE
BEECHWOOD HOUSE on Hyde Common
A magnificent 5-bedroom detached house set in more than an acre of secluded grounds (including a ...
LITTLE HURST FARM COTTAGE
Detached 2-bedroom farm cottage sleeping up to 5 (plus a cot).
Wonderful value for a small ...

RSS Feeds
 
 
 
 
 
 
 
 

Profile Information

Application afterLoad: 0.000 seconds, 0.25 MB
Application afterInitialise: 0.060 seconds, 2.90 MB
Application afterRoute: 0.070 seconds, 3.56 MB
Application afterDispatch: 0.588 seconds, 8.78 MB
Application afterRender: 0.900 seconds, 10.68 MB

Memory Usage

11298604

171 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'rdjm83s5qa89ugn329ac3unjc6'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1438618015' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'rdjm83s5qa89ugn329ac3unjc6'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'rdjm83s5qa89ugn329ac3unjc6','1438621615','','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 *
      FROM jos_redirect
      WHERE original = 'accommodation?sobi2Task=sobi2Details&catid=0&sobi2Id=352'
  8. SELECT configValue
      FROM jos_sobi2_config
      WHERE configKey = 'lastExpCheck'
      AND sobi2Section = 'sobi2expBot'
  9. SELECT configValue
      FROM jos_sobi2_config
      WHERE configKey = 'lastExpCheck'
      AND sobi2Section = 'sobi2expBot'
  10. SELECT id
      FROM jos_menu
      WHERE link LIKE '%index.php?option=com_sobi2%'
      AND TYPE = 'component'
      AND published = '1'
      LIMIT 1
  11. SELECT configValue
      FROM jos_sobi2_config
      WHERE configKey = 'mailFieldId'
  12. SELECT itemid
      FROM jos_sobi2_fields_data
      WHERE fieldid IS NULL
  13. SELECT sobi.itemid, sobi.title, sobi.publish_down, sobi.hits, DATA.data_txt AS email
      FROM jos_sobi2_item AS sobi
      LEFT JOIN jos_sobi2_fields_data AS DATA
      ON sobi.itemid = DATA.itemid
      WHERE (sobi.publish_down BETWEEN DATE_SUB(CURDATE(),INTERVAL 30 DAY)
      AND DATE_ADD(CURDATE(),INTERVAL 30 DAY))
      AND DATA.fieldid = 7
      AND sobi.published = 1  
      AND sobi.itemid NOT IN ( 324,323,321,135,119,112,110,107,93,92,91,416,88,328,329,165,167,336,337,338,339,60,184,188,239,240,259,260,268,263,279,279,257,298,137,89,127,150,376,326,160,163,172,383,385,179,258,148,341,59,346,287,142,114,117,138,139,140,141,320,391,169,398,396,397,395,394,393,401,403,404,405,406,407,234,297,408,409,410,411,413,415,418,419,420,421,422,292,293,424,428,430,308,316,319,434,384,446,447,448,449,450,451,452,453,446,447,448,449,450,451,452,453,455,457,458,459,460,461,288,289,290,291,342,462,463,464,363,465,467,155,468,469,470,471,472,473,429,436,474,475,476,477,276,484,73,123,496,501)
  14. SELECT `configValue`, `configKey`
      FROM `jos_sobi2_config`
  15. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%index.php?option=com_sobi2'
      AND `type` = 'component'
      AND `published` = '1'
      LIMIT 1
  16. SELECT *
      FROM jos_menu
      WHERE id = '93'
  17. SELECT *
      FROM `jos_sobi2_language`
      ORDER BY `sobi2Lang`
  18. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'checkReferer'
      AND `sobi2Section` = 'editForm')
  19. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'needToConfirmNew'
      AND `sobi2Section` = 'editForm')
  20. SELECT `init_file`, `name_id`
      FROM `jos_sobi2_plugins`
      WHERE `enabled` = 1
      ORDER BY `position` ASC
  21. SELECT *
      FROM jos_sobi2_plugin_report_config
  22. SELECT collation( '#__users' )
  23. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'fieldBetween_0'
      AND `sobi2Section` = 'interval_search')
  24. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'fieldMinMax_1'
      AND `sobi2Section` = 'interval_search')
  25. SELECT id, link, name
      FROM jos_menu
      WHERE link LIKE "%index.php?option=com_sobi2%"
      AND TYPE = "component"
      AND published = 1
  26. SELECT *, params AS parameters  
      FROM jos_sobi2_item
      WHERE (`itemid` = 352
      AND `published` = 1
      AND (`publish_down` > '2015-08-03 10:06:55' OR `publish_down` = '0000-00-00 00:00:00' ) )
  27. SELECT fieldid
      FROM jos_sobi2_fields
      ORDER BY POSITION
  28. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '42')  
      AND labels.sobi2Section != 'field_opt'
  29. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '7')  
      AND labels.sobi2Section != 'field_opt'
  30. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '9')  
      AND labels.sobi2Section != 'field_opt'
  31. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '47')  
      AND labels.sobi2Section != 'field_opt'
  32. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 47
      AND sobi2Lang = 'english'
      ORDER BY ordering
  33. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 47  
      ORDER BY ordering
  34. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '3')  
      AND labels.sobi2Section != 'field_opt'
  35. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '18')  
      AND labels.sobi2Section != 'field_opt'
  36. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '25')  
      AND labels.sobi2Section != 'field_opt'
  37. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '10')  
      AND labels.sobi2Section != 'field_opt'
  38. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '60')  
      AND labels.sobi2Section != 'field_opt'
  39. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8')  
      AND labels.sobi2Section != 'field_opt'
  40. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '61')  
      AND labels.sobi2Section != 'field_opt'
  41. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '38')  
      AND labels.sobi2Section != 'field_opt'
  42. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 38
      AND sobi2Lang = 'english'
      ORDER BY ordering
  43. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 38  
      ORDER BY ordering
  44. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '62')  
      AND labels.sobi2Section != 'field_opt'
  45. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '39')  
      AND labels.sobi2Section != 'field_opt'
  46. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 39
      AND sobi2Lang = 'english'
      ORDER BY ordering
  47. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 39  
      ORDER BY ordering
  48. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '19')  
      AND labels.sobi2Section != 'field_opt'
  49. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '52')  
      AND labels.sobi2Section != 'field_opt'
  50. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '63')  
      AND labels.sobi2Section != 'field_opt'
  51. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '57')  
      AND labels.sobi2Section != 'field_opt'
  52. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 57
      AND sobi2Lang = 'english'
      ORDER BY ordering
  53. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 57  
      ORDER BY ordering
  54. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '64')  
      AND labels.sobi2Section != 'field_opt'
  55. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '53')  
      AND labels.sobi2Section != 'field_opt'
  56. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 53
      AND sobi2Lang = 'english'
      ORDER BY ordering
  57. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 53  
      ORDER BY ordering
  58. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '65')  
      AND labels.sobi2Section != 'field_opt'
  59. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '20')  
      AND labels.sobi2Section != 'field_opt'
  60. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '21')  
      AND labels.sobi2Section != 'field_opt'
  61. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '32')  
      AND labels.sobi2Section != 'field_opt'
  62. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '33')  
      AND labels.sobi2Section != 'field_opt'
  63. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '22')  
      AND labels.sobi2Section != 'field_opt'
  64. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '17')  
      AND labels.sobi2Section != 'field_opt'
  65. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '29')  
      AND labels.sobi2Section != 'field_opt'
  66. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '31')  
      AND labels.sobi2Section != 'field_opt'
  67. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '23')  
      AND labels.sobi2Section != 'field_opt'
  68. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '34')  
      AND labels.sobi2Section != 'field_opt'
  69. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '30')  
      AND labels.sobi2Section != 'field_opt'
  70. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '49')  
      AND labels.sobi2Section != 'field_opt'
  71. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '24')  
      AND labels.sobi2Section != 'field_opt'
  72. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '50')  
      AND labels.sobi2Section != 'field_opt'
  73. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '66')  
      AND labels.sobi2Section != 'field_opt'
  74. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '15')  
      AND labels.sobi2Section != 'field_opt'
  75. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '13')  
      AND labels.sobi2Section != 'field_opt'
  76. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '26')  
      AND labels.sobi2Section != 'field_opt'
  77. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '35')  
      AND labels.sobi2Section != 'field_opt'
  78. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '27')  
      AND labels.sobi2Section != 'field_opt'
  79. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '28')  
      AND labels.sobi2Section != 'field_opt'
  80. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '51')  
      AND labels.sobi2Section != 'field_opt'
  81. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '55')  
      AND labels.sobi2Section != 'field_opt'
  82. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '54')  
      AND labels.sobi2Section != 'field_opt'
  83. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '58')  
      AND labels.sobi2Section != 'field_opt'
  84. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '59')  
      AND labels.sobi2Section != 'field_opt'
  85. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '67')  
      AND labels.sobi2Section != 'field_opt'
  86. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '43')  
      AND labels.sobi2Section != 'field_opt'
  87. SELECT name, relation.catid, params
      FROM jos_sobi2_cat_items_relations AS relation
      LEFT JOIN jos_sobi2_categories AS cats
      ON relation.catid = cats.catid
      WHERE ( itemid = 352
      AND published = 1  
      AND relation.catid > 1 )
      LIMIT 5
  88. SELECT catid, name, introtext, description
      FROM jos_sobi2_categories
      WHERE catid = 8
  89. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_details`= 1
      AND `enabled` = 1
      ORDER BY POSITION
  90. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '42')  
      AND labels.sobi2Section != 'field_opt'
  91. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '9')  
      AND labels.sobi2Section != 'field_opt'
  92. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '47')  
      AND labels.sobi2Section != 'field_opt'
  93. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 47
      AND sobi2Lang = 'english'
      ORDER BY ordering
  94. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 47  
      ORDER BY ordering
  95. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '3')  
      AND labels.sobi2Section != 'field_opt'
  96. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '18')  
      AND labels.sobi2Section != 'field_opt'
  97. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '10')  
      AND labels.sobi2Section != 'field_opt'
  98. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '60')  
      AND labels.sobi2Section != 'field_opt'
  99. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8')  
      AND labels.sobi2Section != 'field_opt'
  100. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '61')  
      AND labels.sobi2Section != 'field_opt'
  101. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '62')  
      AND labels.sobi2Section != 'field_opt'
  102. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '19')  
      AND labels.sobi2Section != 'field_opt'
  103. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '52')  
      AND labels.sobi2Section != 'field_opt'
  104. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '63')  
      AND labels.sobi2Section != 'field_opt'
  105. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '57')  
      AND labels.sobi2Section != 'field_opt'
  106. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 57
      AND sobi2Lang = 'english'
      ORDER BY ordering
  107. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 57  
      ORDER BY ordering
  108. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '64')  
      AND labels.sobi2Section != 'field_opt'
  109. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '53')  
      AND labels.sobi2Section != 'field_opt'
  110. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 53
      AND sobi2Lang = 'english'
      ORDER BY ordering
  111. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 53  
      ORDER BY ordering
  112. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '65')  
      AND labels.sobi2Section != 'field_opt'
  113. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '20')  
      AND labels.sobi2Section != 'field_opt'
  114. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '21')  
      AND labels.sobi2Section != 'field_opt'
  115. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '32')  
      AND labels.sobi2Section != 'field_opt'
  116. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '33')  
      AND labels.sobi2Section != 'field_opt'
  117. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '22')  
      AND labels.sobi2Section != 'field_opt'
  118. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '17')  
      AND labels.sobi2Section != 'field_opt'
  119. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '29')  
      AND labels.sobi2Section != 'field_opt'
  120. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '31')  
      AND labels.sobi2Section != 'field_opt'
  121. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '23')  
      AND labels.sobi2Section != 'field_opt'
  122. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '34')  
      AND labels.sobi2Section != 'field_opt'
  123. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '30')  
      AND labels.sobi2Section != 'field_opt'
  124. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '49')  
      AND labels.sobi2Section != 'field_opt'
  125. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '24')  
      AND labels.sobi2Section != 'field_opt'
  126. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '50')  
      AND labels.sobi2Section != 'field_opt'
  127. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '66')  
      AND labels.sobi2Section != 'field_opt'
  128. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '15')  
      AND labels.sobi2Section != 'field_opt'
  129. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '13')  
      AND labels.sobi2Section != 'field_opt'
  130. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '26')  
      AND labels.sobi2Section != 'field_opt'
  131. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '35')  
      AND labels.sobi2Section != 'field_opt'
  132. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '54')  
      AND labels.sobi2Section != 'field_opt'
  133. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '58')  
      AND labels.sobi2Section != 'field_opt'
  134. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '59')  
      AND labels.sobi2Section != 'field_opt'
  135. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '67')  
      AND labels.sobi2Section != 'field_opt'
  136. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 352
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '43')  
      AND labels.sobi2Section != 'field_opt'
  137. SELECT *
      FROM `jos_sobi2_plugin_gallery`
      WHERE `itemid` = '352'
      ORDER BY `position` ASC
  138. SELECT `catid`
      FROM `jos_sobi2_cat_items_relations`
      WHERE `itemid` ='352'
  139. SELECT items.`itemid`, items.`title`, items.`icon`, items.`image` , FIELD.data_txt
      FROM `jos_sobi2_item` AS items  
      LEFT JOIN jos_sobi2_fields_data AS FIELD
      ON FIELD.itemid = items.itemid  
      WHERE items.`published` = 1
      AND (items.`publish_down` > '2015-08-03 10:06:55' OR items.`publish_down` = '0000-00-00 00:00:00' )
      AND items.`itemid` IN (SELECT `itemid`
      FROM `jos_sobi2_cat_items_relations`
      WHERE `catid` IN (8,5))  
      AND FIELD.fieldid = 13  
      ORDER BY items.ordering ASC
  140. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 351
  141. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=8
  142. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=9
  143. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 355
  144. SELECT name, icon, catid, introtext
      FROM `jos_sobi2_categories` AS cat
      WHERE catid IN (8 , 5)
      AND cat.published = 1
  145. SELECT name, icon, catid, introtext
      FROM `jos_sobi2_categories` AS cat
      WHERE catid IN (8 , 5)
      AND cat.published = 1
  146. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=5
  147. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=9
  148. SELECT `data_txt`
      FROM `jos_sobi2_fields_data`
      WHERE `fieldid` = '58'
      AND `itemid` = '352'
  149. SELECT `data_txt`
      FROM `jos_sobi2_fields_data`
      WHERE `fieldid` = '59'
      AND `itemid` = '352'
  150. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 82)
      ORDER BY menuid DESC
      LIMIT 0, 1
  151. 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 = 82 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  152. SELECT `title`, `itemid`, `icon`, `image`
      FROM `jos_sobi2_item`
      WHERE `published` = 1
      AND (`publish_down` > '2015-08-03 10:06:56' OR `publish_down` = '0000-00-00 00:00:00')
      ORDER BY `publish_up` DESC
      LIMIT 5
  153. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 501
  154. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 496
  155. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 486
  156. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 456
  157. SELECT rel.catid
      FROM jos_sobi2_categories AS cat
      LEFT JOIN jos_sobi2_cat_items_relations AS rel
      ON cat.catid = rel.catid
      AND cat.published = 1
      WHERE itemid = 435
  158. 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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-08-03 17:06:56' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-08-03 17:06:56' )
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (cc.id=4 OR cc.id=1)
      AND (s.id=1)
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 6
  159. SELECT *
      FROM jos_categories
      WHERE published=1
      AND count>=1
      AND (section>=1 OR SECTION='com_content')
      AND access <= 0
      AND ( id=4 OR id=1 )
  160. SELECT item.`itemid`, item.`title`, item.`icon`, item.`image`, item.`hits`, item.`last_update`, cf_itemid.`itemid`
                     
      FROM `jos_sobi2_fields_data` AS cf_itemid, `jos_sobi2_item` AS item
                           
      WHERE cf_itemid.`fieldid`='28'
      AND cf_itemid.`data_txt` = 'yes'
      AND item.`itemid`=cf_itemid.`itemid`
      AND (item.`published`='1'
      AND item.`approved`='1'
      AND (item.`publish_down`>'15-08-03 10:06:56' OR item.`publish_down`='0000-00-00 00:00:00'))
      ORDER BY RAND()
                           
      LIMIT 6
  161. SELECT  relations.catid, name,  ordering
      FROM `jos_sobi2_categories`
      LEFT JOIN `jos_sobi2_cats_relations` AS relations
      ON `jos_sobi2_categories`.catid = relations.catid
      WHERE published = 1
      AND relations.parentid = '1'
      ORDER BY ordering ASC
  162. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=16
  163. SELECT `init_file`, `name_id`
      FROM `jos_sobi2_plugins`
      WHERE `enabled` = 1
      ORDER BY `position` ASC
  164. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_search`= 2
      AND `enabled` = 1  
      AND fieldid NOT IN(21,32,33,22,17,29,31,23,34,30,24,38,39,53,57,3,51)
      ORDER BY POSITION
  165. SELECT  fieldType, wysiwyg, is_free,  payment,  fieldChars,  fieldRows,  fieldColumns,  preferred_size, isUrl,  CSSclass,  is_required,  POSITION,  langValue AS label,  description AS explanation, langKey AS fieldname,  fieldDescription AS customCode
      FROM `jos_sobi2_fields` AS sobifields
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sobifields.fieldid = labels.fieldid  
      WHERE `enabled` = 1
      AND `sobi2Lang` = 'english'
      AND sobifields.fieldid = '47'
      AND labels.sobi2Section != 'field_opt'
  166. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 47
      AND sobi2Lang = 'english'
      ORDER BY ordering
  167. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 47  
      ORDER BY ordering
  168. SELECT  fieldType, wysiwyg, is_free,  payment,  fieldChars,  fieldRows,  fieldColumns,  preferred_size, isUrl,  CSSclass,  is_required,  POSITION,  langValue AS label,  description AS explanation, langKey AS fieldname,  fieldDescription AS customCode
      FROM `jos_sobi2_fields` AS sobifields
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sobifields.fieldid = labels.fieldid  
      WHERE `enabled` = 1
      AND `sobi2Lang` = 'english'
      AND sobifields.fieldid = '62'
      AND labels.sobi2Section != 'field_opt'
  169. SELECT langValue
      FROM jos_sobi2_language
      WHERE fieldid = 62
      AND sobi2Lang = 'english'
      LIMIT 1
  170. SELECT *
      FROM jos_jre_sefpatch_urlrepository
      WHERE url = 'accommodation?sobi2Task=sobi2Details&catid=0&sobi2Id=352'
      AND is_published = '1'
  171. SELECT meta_name, meta_default
      FROM jos_jre_sefpatch_metadef
      WHERE (default_setting = '0' OR default_setting = '2')
      AND meta_name NOT IN ( 'robots','keywords','jredummy','description','generator' )

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None