Κονσόλα Αποσφαλάτωσης του Joomla!

Καταγράφηκαν 140 ερωτήματα

1. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM iola_menu AS m
  LEFT JOIN iola_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
2. SELECT joomlatablename,tablepkID
  FROM `iola_falang_tableinfo`
3. SELECT *
  FROM iola_languages
  ORDER BY ordering
4. SHOW FULL COLUMNS
  FROM `iola_languages`
5. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(101,213,214,215,216,102,210,219,220,221,265,222,223,267,224,225,226,227,228,229,230,109,110,189,188,187,186,185,184,183,182,181,191,192,193,194,195,241,245,243,246,264,269)
  AND falang_content.reference_table='menu'
6. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_xmap'
7. SELECT a.*
  FROM iola_xmap_sitemap AS a
  WHERE a.id = 1
  AND a.state = 1
  AND a.access IN (1,1)
8. SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
  WHERE n.lft > p.lft
  AND n.lft < p.rgt
  AND n.menutype = 'iolan-user-menu'
  AND n.published = 1
  AND n.access IN (1,1)
  AND n.language in ('el-GR','*')
  ORDER BY n.lft
9. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(245,243)
  AND falang_content.reference_table='menu'
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_hikashop'
11. SELECT *
  FROM iola_extensions AS n
  WHERE n.folder = 'xmap'
  AND n.enabled = 1
12. SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
  WHERE n.lft > p.lft
  AND n.lft < p.rgt
  AND n.menutype = 'topmenu'
  AND n.published = 1
  AND n.access IN (1,1)
  AND n.language in ('el-GR','*')
  ORDER BY n.lft
13. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(109,110,246,269)
  AND falang_content.reference_table='menu'
14. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_acymailing'
15. SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
  WHERE n.lft > p.lft
  AND n.lft < p.rgt
  AND n.menutype = 'mainmenu'
  AND n.published = 1
  AND n.access IN (1,1)
  AND n.language in ('el-GR','*')
  ORDER BY n.lft
16. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(101,213,214,215,216,102,210,219,220,221,265,222,223,267,224,225,226,227,228,229,230,241,264)
  AND falang_content.reference_table='menu'
17. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
18. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
19. SELECT a.rules
  FROM iola_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
20. SELECT b.rules
  FROM iola_assets AS a
  LEFT JOIN iola_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_xmap')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
21. SELECT *
  FROM iola_modules
  WHERE module='mod_menu'
  AND params LIKE '%"menutype":"iolan-user-menu"%'
  AND access IN (1,1)
  AND published=1
  AND client_id=0
  AND language in ('el-GR','*')
  LIMIT 1
22. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(141)
  AND falang_content.reference_table='modules'
23. SELECT *
  FROM iola_hikashop_config
24. SELECT *
  FROM iola_modules
  WHERE module='mod_menu'
  AND params LIKE '%"menutype":"topmenu"%'
  AND access IN (1,1)
  AND published=1
  AND client_id=0
  AND language in ('el-GR','*')
  LIMIT 1
25. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(31)
  AND falang_content.reference_table='modules'
26. SELECT *
  FROM iola_modules
  WHERE module='mod_menu'
  AND params LIKE '%"menutype":"mainmenu"%'
  AND access IN (1,1)
  AND published=1
  AND client_id=0
  AND language in ('el-GR','*')
  LIMIT 1
27. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(1)
  AND falang_content.reference_table='modules'
28. SELECT *
  FROM iola_menu
  WHERE id = '210'
  LIMIT 1
29. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(210)
  AND falang_content.reference_table='menu'
30. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=12
  AND category_published=1
  AND product_type='main'
31. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,47,60,67,68,69,70,71,72,84,85,92,983,1025,1027,1029)
  AND falang_content.reference_table='hikashop_product'
32. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(12)
  AND falang_content.reference_table='hikashop_category'
33. SELECT *
  FROM iola_menu
  WHERE id = '219'
  LIMIT 1
34. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(219)
  AND falang_content.reference_table='menu'
35. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=13
  AND category_published=1
  AND product_type='main'
36. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(79,80,81,82,83,96,99,100,101,102,107,110,111,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132)
  AND falang_content.reference_table='hikashop_product'
37. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(13)
  AND falang_content.reference_table='hikashop_category'
38. SELECT *
  FROM iola_menu
  WHERE id = '220'
  LIMIT 1
39. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(220)
  AND falang_content.reference_table='menu'
40. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=14
  AND category_published=1
  AND product_type='main'
41. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(133,134,135,136,137,141,145,149,150,151,152,153,154,155,156,157,158,159,160,161,203,255,256)
  AND falang_content.reference_table='hikashop_product'
42. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(14)
  AND falang_content.reference_table='hikashop_category'
43. SELECT *
  FROM iola_menu
  WHERE id = '221'
  LIMIT 1
44. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(221)
  AND falang_content.reference_table='menu'
45. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=15
  AND category_published=1
  AND product_type='main'
46. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(95,162,163,167,171,175,185,186,187,188,189,190,191,192,193,194,197,200,201,202,843,844,845,846,847,893,894,895,896,897,898,899,900,909)
  AND falang_content.reference_table='hikashop_product'
47. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(15)
  AND falang_content.reference_table='hikashop_category'
48. SELECT *
  FROM iola_menu
  WHERE id = '265'
  LIMIT 1
49. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(265)
  AND falang_content.reference_table='menu'
50. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=25
  AND category_published=1
  AND product_type='main'
51. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(238,239,240,241,242,243,244,245,246,248,249,250,251,252,253,254)
  AND falang_content.reference_table='hikashop_product'
52. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(25)
  AND falang_content.reference_table='hikashop_category'
53. SELECT *
  FROM iola_menu
  WHERE id = '222'
  LIMIT 1
54. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(222)
  AND falang_content.reference_table='menu'
55. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=16
  AND category_published=1
  AND product_type='main'
56. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(204,205,206,207,208,209,210,215,224,225,226,227,228,229,230,231,232,233,234,235,236,237,554,922,1042,1043)
  AND falang_content.reference_table='hikashop_product'
57. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(16)
  AND falang_content.reference_table='hikashop_category'
58. SELECT *
  FROM iola_menu
  WHERE id = '223'
  LIMIT 1
59. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(223)
  AND falang_content.reference_table='menu'
60. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=17
  AND category_published=1
  AND product_type='main'
61. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(880,901,902,903,904,905,906,907,908,930,931,938,949,957,964,965,971,973)
  AND falang_content.reference_table='hikashop_product'
62. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(17)
  AND falang_content.reference_table='hikashop_category'
63. SELECT *
  FROM iola_menu
  WHERE id = '224'
  LIMIT 1
64. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(224)
  AND falang_content.reference_table='menu'
65. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=18
  AND category_published=1
  AND product_type='main'
66. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(257,258,259,260,261,612,923)
  AND falang_content.reference_table='hikashop_product'
67. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(18)
  AND falang_content.reference_table='hikashop_category'
68. SELECT *
  FROM iola_menu
  WHERE id = '225'
  LIMIT 1
69. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(225)
  AND falang_content.reference_table='menu'
70. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=19
  AND category_published=1
  AND product_type='main'
71. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(271,350,355,365,618)
  AND falang_content.reference_table='hikashop_product'
72. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(19)
  AND falang_content.reference_table='hikashop_category'
73. SELECT *
  FROM iola_menu
  WHERE id = '226'
  LIMIT 1
74. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(226)
  AND falang_content.reference_table='menu'
75. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=20
  AND category_published=1
  AND product_type='main'
76. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(376,383,395,407,507,535,542,555,562,864,881,887,923)
  AND falang_content.reference_table='hikashop_product'
77. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(20)
  AND falang_content.reference_table='hikashop_category'
78. SELECT *
  FROM iola_menu
  WHERE id = '227'
  LIMIT 1
79. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(227)
  AND falang_content.reference_table='menu'
80. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=21
  AND category_published=1
  AND product_type='main'
81. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(574,581,587,600)
  AND falang_content.reference_table='hikashop_product'
82. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(21)
  AND falang_content.reference_table='hikashop_category'
83. SELECT *
  FROM iola_menu
  WHERE id = '228'
  LIMIT 1
84. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(228)
  AND falang_content.reference_table='menu'
85. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=22
  AND category_published=1
  AND product_type='main'
86. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(628,635,653,665,677,689,701,706,713,792)
  AND falang_content.reference_table='hikashop_product'
87. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(22)
  AND falang_content.reference_table='hikashop_category'
88. SELECT *
  FROM iola_menu
  WHERE id = '229'
  LIMIT 1
89. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(229)
  AND falang_content.reference_table='menu'
90. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=23
  AND category_published=1
  AND product_type='main'
91. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(753,754,755,756,757,759,760,761,762,763,797)
  AND falang_content.reference_table='hikashop_product'
92. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(23)
  AND falang_content.reference_table='hikashop_category'
93. SELECT *
  FROM iola_menu
  WHERE id = '267'
  LIMIT 1
94. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(267)
  AND falang_content.reference_table='menu'
95. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=26
96. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(18,19,20,21,22,23)
  AND falang_content.reference_table='hikashop_category'
97. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=18
98. SELECT *
  FROM iola_modules
  WHERE id = '150'
  LIMIT 1
99. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(150)
  AND falang_content.reference_table='modules'
100. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=18
  AND category_published=1
  AND product_type='main'
101. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(257,258,259,260,261,612,923)
  AND falang_content.reference_table='hikashop_product'
102. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(18)
  AND falang_content.reference_table='hikashop_category'
103. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=19
104. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=19
  AND category_published=1
  AND product_type='main'
105. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(271,350,355,365,618)
  AND falang_content.reference_table='hikashop_product'
106. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(19)
  AND falang_content.reference_table='hikashop_category'
107. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=20
108. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=20
  AND category_published=1
  AND product_type='main'
109. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(376,383,395,407,507,535,542,555,562,864,881,887,923)
  AND falang_content.reference_table='hikashop_product'
110. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(20)
  AND falang_content.reference_table='hikashop_category'
111. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=21
112. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=21
  AND category_published=1
  AND product_type='main'
113. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(574,581,587,600)
  AND falang_content.reference_table='hikashop_product'
114. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(21)
  AND falang_content.reference_table='hikashop_category'
115. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=22
116. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=22
  AND category_published=1
  AND product_type='main'
117. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(628,635,653,665,677,689,701,706,713,792)
  AND falang_content.reference_table='hikashop_product'
118. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(22)
  AND falang_content.reference_table='hikashop_category'
119. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=23
120. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=23
  AND category_published=1
  AND product_type='main'
121. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(753,754,755,756,757,759,760,761,762,763,797)
  AND falang_content.reference_table='hikashop_product'
122. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(23)
  AND falang_content.reference_table='hikashop_category'
123. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=26
  AND category_published=1
  AND product_type='main'
124. SELECT *
  FROM iola_menu
  WHERE id = '230'
  LIMIT 1
125. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(230)
  AND falang_content.reference_table='menu'
126. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=24
  AND category_published=1
  AND product_type='main'
127. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(791,798,799,800,809,826)
  AND falang_content.reference_table='hikashop_product'
128. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(24)
  AND falang_content.reference_table='hikashop_category'
129. UPDATE iola_xmap_sitemap
  SET views_html = views_html + 1, count_html = 35, lastvisit_html = 1696236603
  WHERE id = 1
130. SELECT params
  FROM iola_extensions AS e
  WHERE e.element='com_widgetkit'
131. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_media'
132. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM iola_modules AS m
  LEFT JOIN iola_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN iola_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-10-02 08:50:03')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-02 08:50:03')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 269 OR mm.menuid <= 0)
  AND m.language IN ('el-GR','*')
  ORDER BY m.position, m.ordering
133. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(31,32,38,86,1,143,40,122,141,149,61,137)
  AND falang_content.reference_table='modules'
134. SELECT `link`
  FROM `iola_menu`
  WHERE `published`=1
  AND `id`='193'
135. SELECT a.*
  FROM iola_hikashop_cart AS a
  WHERE (a.session_id = '0d684bacce9db548d3e7ccf4ab4f4fa1')
  AND a.cart_type = 'cart'
  ORDER BY a.cart_modified DESC
  LIMIT 1
136. SELECT currency_id
  FROM iola_hikashop_currency
  WHERE currency_published=1 OR currency_id = 1
137. SELECT *
  FROM iola_hikashop_field as a
  WHERE a.`field_published` = 1
  AND a.`field_frontcomp` = 1
  AND a.field_table='item'
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%')
  ORDER BY a.`field_ordering` ASC
138. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_installer'
139. SELECT `value`
  FROM `iola_admintools_storage`
  WHERE `key` = 'atoolsjupdatecheck_lastrun'
140. UPDATE `iola_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696236603;s:18:\"session.timer.last\";i:1696236603;s:17:\"session.timer.now\";i:1696236603;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"zone_id\";s:2:\"84\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"57b10fcaadc3afde96f6632e9da883ab\";}' , `time` = '1696236604'
  WHERE `session_id` = '0d684bacce9db548d3e7ccf4ab4f4fa1'

Καταγράφηκαν 25 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

1. 65 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
2. 21 × SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
3. 15 × SELECT *
  FROM iola_menu
4. 7 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
5. 7 × SELECT *
  FROM iola_hikashop_category
6. 4 × SELECT *
  FROM iola_modules
7. 3 × SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
8. 1 × SELECT `link`
  FROM `iola_menu`
9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM iola_modules AS m
  LEFT JOIN iola_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN iola_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
10. 1 × SELECT a.*
  FROM iola_hikashop_cart AS a
11. 1 × SELECT currency_id
  FROM iola_hikashop_currency
12. 1 × SELECT `value`
  FROM `iola_admintools_storage`
13. 1 × SELECT *
  FROM iola_hikashop_field as a
14. 1 × SELECT params
  FROM iola_extensions AS e
15. 1 × SELECT *
  FROM iola_languages
16. 1 × SELECT a.rules
  FROM iola_assets AS a
17. 1 × SELECT *
  FROM iola_extensions AS n
18. 1 × SELECT b.rules
  FROM iola_assets AS a
  LEFT JOIN iola_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
19. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM iola_menu AS m
  LEFT JOIN iola_extensions AS e
  ON m.component_id = e.extension_id
20. 1 × SELECT a.*
  FROM iola_xmap_sitemap AS a
21. 1 × SELECT *
  FROM iola_hikashop_confi
22. 1 × SELECT joomlatablename,tablepkID
  FROM `iola_falang_tableinfo

ΑΛΛΟΙ Πίνακες:

1. 1 × UPDATE `iola_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696236603;s:18:\"session.timer.last\";i:1696236603;s:17:\"session.timer.now\";i:1696236603;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"zone_id\";s:2:\"84\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"57b10fcaadc3afde96f6632e9da883ab\";}' , `time` = '1696236604'
2. 1 × UPDATE iola_xmap_sitemap
  SET views_html = views_html + 1, count_html = 35, lastvisit_html = 1696236603
3. 1 × SHOW FULL COLUMNS
  FROM `iola_languages