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 8 guests online
Ideas on Century 21

Jewels Refinery


A different pawn-shop, more like a Refinery
Economic crisis heat Greece. Crisis came to stay for a long time, and people will realise that will have to losen up their bondage with the material world and specifically the expensive Jewels that still posses at some hidden forgotten places at their home or Banks. The Idea is to create a "pawn-shop" at good places of the city , not stores , but i would suggest to expensive office floors next to lawyers and doctor offices. Usually such buildings have security at entrance so you dont have to be afraid for security so much. As for purpose , the purpose of the office will be to refine any Jewelry to the material that is made from, if its golden , then Gold , Silver etc. and be given to customer the equivalent in money (minus a commision).
Email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Contact Person: christos boubalos
0
Date added: 2010-06-23 17:27:30    Hits: 274
Rate now:  
0

Profile Information

Application afterLoad: 0.000 seconds, 0.40 MB
Application afterInitialise: 0.044 seconds, 2.34 MB
Application afterRoute: 0.053 seconds, 2.90 MB
Application afterDispatch: 0.139 seconds, 6.76 MB
Application afterRender: 0.171 seconds, 7.62 MB

Memory Usage

8053560

55 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'kdmd1cnq5c6fugmn7sr49ig0n0'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1582278885' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'kdmd1cnq5c6fugmn7sr49ig0n0'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'kdmd1cnq5c6fugmn7sr49ig0n0','1582284285','','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 *, params AS parameters 
      FROM jos_sobi2_item
      WHERE (`itemid` = 12
      AND `published` = 1
      AND (`publish_down` > '2020-02-21 11:24:45' OR `publish_down` = '0000-00-00 00:00:00' ) )
  19. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 12
      AND cid = 0
      AND cl = 0
      AND slang = 'english'
      AND oid = 0 );
  20. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_details`= 1
      AND `enabled` = 1
      ORDER BY position
  21. 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '16') 
      AND labels.sobi2Section != 'field_opt'
  22. 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '13') 
      AND labels.sobi2Section != 'field_opt'
  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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '7') 
      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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  25. 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '8') 
      AND labels.sobi2Section != 'field_opt'
  26. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '8'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  27. 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '9') 
      AND labels.sobi2Section != 'field_opt'
  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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '1') 
      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
      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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '1') 
      AND labels.sobi2Section != 'field_opt'
  30. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '1'
      AND `sobi2Lang` = 'english'
      AND 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '2') 
      AND labels.sobi2Section != 'field_opt'
  32. 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '2') 
      AND labels.sobi2Section != 'field_opt'
  33. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '2'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  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 = 12
      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
      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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '3') 
      AND labels.sobi2Section != 'field_opt'
  36. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '3'
      AND `sobi2Lang` = 'english'
      AND 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '6') 
      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
      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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '6') 
      AND labels.sobi2Section != 'field_opt'
  39. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '6'
      AND `sobi2Lang` = 'english'
      AND 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '5') 
      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
      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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '5') 
      AND labels.sobi2Section != 'field_opt'
  42. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '5'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  43. 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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '4') 
      AND labels.sobi2Section != 'field_opt'
  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
      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 = 12
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '4') 
      AND labels.sobi2Section != 'field_opt'
  45. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '4'
      AND `sobi2Lang` = 'english'
      AND sobi2Section != 'field_opt'
  46. SELECT *
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 12
      AND `published` = 1
      AND (`review` != '' OR `updateInfo` = 1) )
      ORDER BY `added` DESC
      LIMIT 0 , 10
  47. SELECT COUNT(*)
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = 12
      AND `published` = 1
      AND NOT (`review` = '') )
  48. SELECT `vote`
      FROM `jos_sobi2_plugin_reviews`
      WHERE `ip` = '34.226.244.70'
      AND `itemid` = '12'
      AND NOT (`vote` = '')
  49. SELECT COUNT(vote) AS votes, SUM(vote) AS vres
      FROM `jos_sobi2_plugin_reviews`
      WHERE (`itemid` = '12'
      AND NOT (`vote` = 0)
      AND `published` = 1)
  50. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  51. 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 = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  52. 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-02-21 11:24:45' OR sitem.publish_down = '0000-00-00 00:00:00'))
      GROUP BY itemid
      ORDER BY reviews DESC
      LIMIT 0, 5
  53. SELECT `title`, `itemid`, `icon`, `image`
      FROM `jos_sobi2_item`
      WHERE `published` = 1
      AND (`publish_down` > '2020-02-21 11:24:45' OR `publish_down` = '0000-00-00 00:00:00')
      ORDER BY `publish_up` DESC
      LIMIT 6
  54. 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-02-21 11:24:45" ) 
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2020-02-21 11:24:45" )
      AND cc.id = 35
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  55. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None