Login Form



  • What is Century 21?

    Century 21 is the storehouse of ideas. It collects ideas from the user and from the guest and keep here for other's reviews.

  • How this work?

    Here you can share your idea by clicking on Add an Idea. After writing your idea you will submit it here. Then the administrator of century 21 will approve it and the idea will be published. Other user can rate an idea by writing their reviews about the idea.

  • Why Post?

    If you want to share your ideas with the world or if you want to justify your ideas according the the ideas of other, then you will post here. The other will read it and make a comments or reviews about your idea.

Who's Online

We have 19 guests online
Ideas on Century 21
Most Popular Entries

Kids/ Prenatal Yoga!


Yoga has tremendous benefits for all of us. Our physical body is healthier and happier, and the way we view ourselves, others and life in general is healthier. We become more balanced and therefore happier people!!
Website
10Reviews: 1

Talentbase


base of talents for Net users to Judge
8Reviews: 1

Farms to Families


Land of 1000-10000sq.m. should be given to poor families
0Reviews: 0

Follow the Money


Follow the Money
8Reviews: 1

Reform Greece


Hire Architects and reform ugly buildings of Greece
8Reviews: 1

Art-Hub


Art Cafe Gathering Place where Art expresses itself
10Reviews: 2

Kill Fire Device


Device that would kill fire
0Reviews: 0

Web Diary


Daily Diary @ Web
10Reviews: 1

Emergency Landing


Method For Landing Every Aircraft in Emergency Landing
10Reviews: 1

Small car


Small car with maximum speed 80 km/h
8Reviews: 1
<< Start < Prev 1 2 Next > End >>

Profile Information

Application afterLoad: 0.000 seconds, 0.40 MB
Application afterInitialise: 0.028 seconds, 2.34 MB
Application afterRoute: 0.034 seconds, 2.90 MB
Application afterDispatch: 0.123 seconds, 6.20 MB
Application afterRender: 0.163 seconds, 7.18 MB

Memory Usage

7594144

106 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'de8omf00m67hbbpg7rr5ng92r1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1586049595' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'de8omf00m67hbbpg7rr5ng92r1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'de8omf00m67hbbpg7rr5ng92r1','1586054995','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT id, link, name
      FROM jos_menu
      WHERE link LIKE "%index.php?option=com_sobi2%"
      AND type = "component"
      AND published = 1
  9. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%index.php?option=com_sobi2'
      AND `type` = 'component'
      AND `published` = '1'
      LIMIT 1
  10. SELECT `configValue`, `configKey`
      FROM `jos_sobi2_config`
  11. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%index.php?option=com_sobi2'
      AND `type` = 'component'
      AND `published` = '1'
      LIMIT 1
  12. SELECT *
      FROM jos_menu
      WHERE id = '1'
  13. SELECT *
      FROM `jos_sobi2_language`
      ORDER BY `sobi2Lang`
  14. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'checkReferer'
      AND `sobi2Section` = 'editForm')
  15. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'needToConfirmNew'
      AND `sobi2Section` = 'editForm')
  16. SELECT `init_file`, `name_id`
      FROM `jos_sobi2_plugins`
      WHERE `enabled` = 1
      ORDER BY `position` ASC
  17. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'RtextLimit'
      AND `sobi2Section` = 'sobi_reviews')
  18. SELECT itemid
      FROM jos_sobi2_item
      WHERE (published = 1
      AND publish_down > '2020-04-05 02:49:55' OR publish_down = '0000-00-00 00:00:00')
      ORDER BY hits DESC
      LIMIT 0, 30
  19. SELECT COUNT(*)
      FROM jos_sobi2_item
      WHERE itemid IN(20 , 18 , 17 , 15 , 16 , 13 , 19 , 11 , 8 , 10 , 9 , 14 , 12) 
      AND ( published = 1
      AND ( publish_down > '2020-04-05 02:49:55' OR publish_down = '0000-00-00 00:00:00' ) )
  20. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 53)
      ORDER BY menuid DESC
      LIMIT 0, 1
  21. SELECT *
      FROM jos_sobi2_item
      WHERE itemid IN(20 , 18 , 17 , 15 , 16 , 13 , 19 , 11 , 8 , 10 , 9 , 14 , 12) 
      AND ( published = 1
      AND ( publish_down > '2020-04-05 02:49:55' OR publish_down = '0000-00-00 00:00:00' ) )   
      ORDER BY hits DESC 
      LIMIT 0, 10
  22. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  23. 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 = 20
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      AND labels.sobi2Section != 'field_opt'
  24. 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 = 20
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  25. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '20'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  26. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 20
      AND `published` = 1
      AND NOT (`review` = '') )
  27. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '20'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  28. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 20
      AND `published` = 1
      AND NOT (`review` = '') )
  29. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 18
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      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 = 18
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  32. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '18'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  33. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 18
      AND `published` = 1
      AND NOT (`review` = '') )
  34. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '18'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  35. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 18
      AND `published` = 1
      AND NOT (`review` = '') )
  36. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 17
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      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 = 17
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      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
      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 = 17
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  40. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '8'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  41. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '17'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  42. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 17
      AND `published` = 1
      AND NOT (`review` = '') )
  43. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '17'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  44. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 17
      AND `published` = 1
      AND NOT (`review` = '') )
  45. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  46. 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 = 15
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      AND labels.sobi2Section != 'field_opt'
  47. 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 = 15
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  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
      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 = 15
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  49. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '8'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  50. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '15'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  51. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 15
      AND `published` = 1
      AND NOT (`review` = '') )
  52. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '15'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  53. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 15
      AND `published` = 1
      AND NOT (`review` = '') )
  54. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 16
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      AND labels.sobi2Section != 'field_opt'
  56. 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 = 16
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  57. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '16'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  58. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 16
      AND `published` = 1
      AND NOT (`review` = '') )
  59. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '16'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  60. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 16
      AND `published` = 1
      AND NOT (`review` = '') )
  61. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 13
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      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 = 13
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  64. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '13'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  65. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 13
      AND `published` = 1
      AND NOT (`review` = '') )
  66. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '13'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  67. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 13
      AND `published` = 1
      AND NOT (`review` = '') )
  68. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 19
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      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 = 19
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      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
      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 = 19
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  72. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '8'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  73. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '19'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  74. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 19
      AND `published` = 1
      AND NOT (`review` = '') )
  75. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '19'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  76. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 19
      AND `published` = 1
      AND NOT (`review` = '') )
  77. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 11
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      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 = 11
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  80. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '11'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  81. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 11
      AND `published` = 1
      AND NOT (`review` = '') )
  82. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '11'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  83. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 11
      AND `published` = 1
      AND NOT (`review` = '') )
  84. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  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 = 8
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      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 = 8
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  87. 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
      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 = 8
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  88. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '8'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  89. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '8'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  90. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 8
      AND `published` = 1
      AND NOT (`review` = '') )
  91. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '8'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  92. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 8
      AND `published` = 1
      AND NOT (`review` = '') )
  93. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_vcard`= 1
      AND `enabled` = 1
      ORDER BY position
  94. 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 = 10
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      AND labels.sobi2Section != 'field_opt'
  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 = 10
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      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
      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 = 10
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  97. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '8'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  98. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '10'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  99. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 10
      AND `published` = 1
      AND NOT (`review` = '') )
  100. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '10'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  101. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 10
      AND `published` = 1
      AND NOT (`review` = '') )
  102. 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 = 53 OR mm.menuid = 0 )
      ORDER BY position, ordering
  103. SELECT sitem.itemid, sitem.title, sitem.icon, sitem.image, SUM(vote) / COUNT(*) AS votingResult, COUNT(*) AS reviews
      FROM jos_sobi2_plugin_reviews AS rev
      LEFT JOIN  jos_sobi2_item AS sitem
      ON sitem.itemid = rev.itemid
      WHERE  (rev.review != ''
      AND rev.published = 1
      AND sitem.published = 1
      AND (sitem.publish_down > '2020-04-05 02:49:55' OR sitem.publish_down = '0000-00-00 00:00:00'))
      GROUP BY itemid
      ORDER BY reviews DESC
      LIMIT 0, 5
  104. SELECT `title`, `itemid`, `icon`, `image`
      FROM `jos_sobi2_item`
      WHERE `published` = 1
      AND (`publish_down` > '2020-04-05 02:49:55' OR `publish_down` = '0000-00-00 00:00:00')
      ORDER BY `publish_up` DESC
      LIMIT 6
  105. 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.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2020-04-05 02:49:55" ) 
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2020-04-05 02:49:55" )
      AND cc.id = 35
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  106. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None