stay

Holiday Quick Search

Sleeps Up to
Area
 
 
 
 
You are here:: Where to Stay APPLETREES
 
 

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

APPLETREES

Price: Please phone for a price quotation
Town: Fordingbridge
Area:
New Forest
Beds: 3

Top quality accommodation for 6-8 people
APPLETREES
Children Welcome Dogs Welcome Parking No Smoking
Gallery - Click the images to enlarge
Description

Detached single storey farm cottage in its own secure garden with BBQ.
3 bedrooms plus double convertible in lounge. Sleeps 6-8 comfortably.
2 toilets – family bathroom with bath plus shower cubicle.
Log-burning stove and full central heating.
Furnished, equipped and maintained to the highest possible standards.
Garage for your car and secure lock-up for bicycles.
Games room with tennis, badminton, 2 pool tables, table tennis, etc.
We can provide on-site river fishing.
Grazing for visiting horses and ponies can be arranged.
No smoking. Dogs welcome.
Indian Take-away & Restaurant plus a popular family pub just across the road.
We also have other cottages on a separate section of this working farm. The letting units can sleep any number from 4 to 18.

Being detached and in its own enclosed garden, this cottage is your best choice for privacy and bringing pets, since it is secure, providing you remember to close the gate. The garden has a wooden picnic table and a plastic table with chairs. There is a lock-up garage where bicycles can be stored.
There is a log-burning stove in addition to the central heating, so your comfort is guaranteed even in the coldest weather. The bedrooms are double, twin, 2 singles, plus a double convertible in the lounge. There is one bathroom, comprising a bathtub with a hand-held hose/nozzle for hair washing, a shower cubicle, washbasin and toilet. There is also a second separate WC. The outlook is farmland in all directions.
The living room is very spacious and if you are also using other on-site cottages you may like to all eat together in Appletrees. The dining facilities can be made adequate for up to 24 if pre-arranged, and this of course would be ideal for family reunions, hen parties, etc.
The 40'x80' Games Room is available to all guests in our holiday units. There's tennis, badminton, 2 pool tables, table tennis, table football, and a wendy house.
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 a land-line number if you have one.
Contact and Booking Details
Contact: Peter or Ria
Tel: 01202-707885
Map - Click the marker to get directions
Date added: 2011-06-16 10:54:52

Other listings in this category

A BARN CONVERSION for up to 18 peopleBEECHWOOD COTTAGES Group 10
A BARN CONVERSION for up to 18 people
A magnificent barn conversion sleeping up to 18 - ideal for family get-togethers & hen ...
BEECHWOOD COTTAGES Group 10
Five newly converted farm buildings with original oak beams.
Ideal for adults, or families ...

RSS Feeds
 
 
 
 
 
 
 
 

Profile Information

Application afterLoad: 0.007 seconds, 0.25 MB
Application afterInitialise: 0.126 seconds, 2.90 MB
Application afterRoute: 0.161 seconds, 3.56 MB
Application afterDispatch: 1.899 seconds, 8.79 MB
Application afterRender: 2.244 seconds, 10.69 MB

Memory Usage

11301008

171 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'dllch8kipaef3p38gu7k7b6l26'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1438684890' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'dllch8kipaef3p38gu7k7b6l26'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'dllch8kipaef3p38gu7k7b6l26','1438688490','','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=1&sobi2Id=373'
  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` = 373
      AND `published` = 1
      AND (`publish_down` > '2015-08-04 04:41:30' 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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      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 = 373
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '43')  
      AND labels.sobi2Section != 'field_opt'
  137. SELECT *
      FROM `jos_sobi2_plugin_gallery`
      WHERE `itemid` = '373'
      ORDER BY `position` ASC
  138. SELECT `catid`
      FROM `jos_sobi2_cat_items_relations`
      WHERE `itemid` ='373'
  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-04 04:41:30' 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 = 371
  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 = 375
  144. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=5
  145. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=9
  146. SELECT name, icon, catid, introtext
      FROM `jos_sobi2_categories` AS cat
      WHERE catid IN (8 , 5)
      AND cat.published = 1
  147. SELECT name, icon, catid, introtext
      FROM `jos_sobi2_categories` AS cat
      WHERE catid IN (8 , 5)
      AND cat.published = 1
  148. SELECT `data_txt`
      FROM `jos_sobi2_fields_data`
      WHERE `fieldid` = '58'
      AND `itemid` = '373'
  149. SELECT `data_txt`
      FROM `jos_sobi2_fields_data`
      WHERE `fieldid` = '59'
      AND `itemid` = '373'
  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-04 04:41:32' 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-04 11:41:32' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-08-04 11:41:32' )
      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-04 04:41:32' 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=1&sobi2Id=373'
      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