•Banner•

All independent businesses, all under one virtual roof.  Shop local, independent first.



 

State:PA

•Listings• RSS

•Profile Information•

Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.050 seconds, 5.38 MB
Application afterRoute: 0.073 seconds, 8.53 MB
Application afterDispatch: 0.222 seconds, 13.70 MB
Application afterRender: 0.246 seconds, 14.49 MB

•Memory Usage•

15565064

•222 queries logged•

  1. DELETE
      FROM jos_session
      WHERE ( TIME < '1529808889' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'ja8dpeb8klk4v7t4kmn32q3rg5'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'ja8dpeb8klk4v7t4kmn32q3rg5','1529816089','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT setting,VALUE
      FROM jos_jfbconnect_config
  7. SELECT `value`

      FROM `jos_admintools_storage`

      WHERE `key` = 'cparams'
  8. SELECT *
      FROM jos_redj
      WHERE ( (('/directory/search-by/state/PA' REGEXP BINARY fromurl)>0
      AND case_sensitive<>'0') OR (('/directory/search-by/state/PA' REGEXP fromurl)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  9. 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
  10. SELECT `varname`, `value`, `default`
      FROM jos_mt_config
  11. SELECT cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  12. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 247)
      ORDER BY menuid DESC
      LIMIT 0, 1
  13. SELECT *
      FROM jos_mt_customfields AS cf
      WHERE cf.cf_id = '6'
      AND published = 1
      AND tag_search = 1
      LIMIT 1
  14. SELECT l.*, u.username, c.*, img.filename AS link_image
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
           
      LEFT JOIN jos_mt_images AS img
      ON img.link_id = l.link_id
      AND img.ordering = 1
           
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = cl.cat_id
     
      LEFT JOIN jos_users AS u
      ON u.id = l.user_id
           
      WHERE
            link_published='1'
      AND link_approved='1'
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-06-24 04:54:49'  )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-06-24 04:54:49' )
     
      AND cl.link_id = l.link_id
     
      AND cl.main = 1
     
      AND l.state LIKE '%PA%'
     
      ORDER BY link_featured DESC, link_hits DESC
     
      LIMIT 0, 20
  15. SELECT COUNT(DISTINCT l.link_id)
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
           
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = cl.cat_id
           
      WHERE link_published='1'
      AND link_approved='1'
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-06-24 04:54:49'  )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-06-24 04:54:49' )
     
      AND cl.link_id = l.link_id
     
      AND cl.main = 1
     
      AND l.state LIKE '%PA%'
  16. SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS VALUE, field_type
      FROM jos_mt_customfields
  17. SELECT cf.*, cfv.link_id, cfv.VALUE, cfv.attachment, cfv.counter, ft.ft_class
      FROM jos_mt_customfields AS cf

      LEFT JOIN jos_mt_cfvalues AS cfv
      ON cf.cf_id=cfv.cf_id

      LEFT JOIN jos_mt_fieldtypes AS ft
      ON ft.field_type=cf.field_type

      WHERE cf.published = '1'
      AND cf.summary_view = '1'

      AND cfv.link_id IN (211,265,274,306,213,205,16,161,230,264,204,193,101,189,106,242,28,298,277,307)

      ORDER BY cf.ordering ASC, link_id DESC
  18. SELECT cf. * , NULL AS link_id, '' AS VALUE, NULL AS attachment, ft.ft_class

      FROM jos_mt_customfields AS cf

      LEFT JOIN jos_mt_fieldtypes AS ft
      ON ft.field_type=cf.field_type

      WHERE cf.published = '1'

      AND cf.summary_view = '1'

      AND cf.iscore = '1'

      ORDER BY cf.ordering ASC
  19. SELECT r.link_id, COUNT( * ) AS total
      FROM jos_mt_cl AS cl
     
      LEFT JOIN jos_mt_reviews AS r
      ON cl.link_id = r.link_id
     
      WHERE cl.link_id IN ('211','265','274','306','213','205','16','161','230','264','204','193','101','189','106','242','28','298','277','307')
      AND r.rev_approved = '1'
      AND cl.main = '1'
     
      GROUP BY r.link_id
  20. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  21. SELECT cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  22. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  23. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  24. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  25. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  26. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  27. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  28. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  29. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  30. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  31. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  32. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  33. SELECT params
      FROM jos_mt_templates
      WHERE tem_name = 'm2'
      LIMIT 1
  34. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '211'
      AND main = 1
  35. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '111'
  36. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 56
      AND rgt > 57
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  37. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  38. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  39. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  40. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  41. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  42. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  43. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '265'
      AND main = 1
  44. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  45. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  46. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  47. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  48. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  49. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  50. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  51. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  52. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '274'
      AND main = 1
  53. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  54. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  55. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  56. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  57. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  58. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  59. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '306'
      AND main = 1
  60. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '100'
  61. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 38
      AND rgt > 39
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  62. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '100'
      LIMIT 1
  63. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  64. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  65. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '100'
      LIMIT 1
  66. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  67. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  68. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '213'
      AND main = 1
  69. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  70. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  71. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  72. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  73. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  74. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  75. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '205'
      AND main = 1
  76. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  77. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  78. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  79. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  80. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  81. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  82. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '16'
      AND main = 1
  83. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '84'
  84. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 6
      AND rgt > 7
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  85. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '84'
      LIMIT 1
  86. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  87. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  88. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '84'
      LIMIT 1
  89. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  90. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  91. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '161'
      AND main = 1
  92. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '99'
  93. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 36
      AND rgt > 37
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  94. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '99'
      LIMIT 1
  95. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  96. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  97. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '99'
      LIMIT 1
  98. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  99. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  100. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '230'
      AND main = 1
  101. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '112'
  102. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 58
      AND rgt > 59
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  103. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '112'
      LIMIT 1
  104. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  105. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  106. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '112'
      LIMIT 1
  107. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  108. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  109. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '264'
      AND main = 1
  110. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  111. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  112. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  113. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  114. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  115. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  116. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  117. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  118. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '204'
      AND main = 1
  119. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  120. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  121. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  122. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  123. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  124. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  125. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '193'
      AND main = 1
  126. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '108'
  127. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 50
      AND rgt > 51
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  128. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '108'
      LIMIT 1
  129. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  130. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  131. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '108'
      LIMIT 1
  132. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  133. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  134. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '101'
      AND main = 1
  135. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '93'
  136. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 24
      AND rgt > 25
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  137. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '93'
      LIMIT 1
  138. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  139. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  140. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '93'
      LIMIT 1
  141. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  142. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  143. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '189'
      AND main = 1
  144. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '106'
  145. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 46
      AND rgt > 47
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  146. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '106'
      LIMIT 1
  147. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  148. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  149. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '106'
      LIMIT 1
  150. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  151. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  152. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '106'
      AND main = 1
  153. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '94'
  154. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 26
      AND rgt > 27
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  155. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '94'
      LIMIT 1
  156. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  157. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  158. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '94'
      LIMIT 1
  159. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  160. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  161. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '242'
      AND main = 1
  162. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '86'
  163. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 10
      AND rgt > 11
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  164. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '86'
      LIMIT 1
  165. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  166. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  167. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '86'
      LIMIT 1
  168. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  169. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  170. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '28'
      AND main = 1
  171. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '122'
  172. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 74
      AND rgt > 75
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  173. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '122'
      LIMIT 1
  174. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  175. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  176. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '122'
      LIMIT 1
  177. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  178. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  179. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '298'
      AND main = 1
  180. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '115'
  181. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 62
      AND rgt > 63
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  182. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '115'
      LIMIT 1
  183. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  184. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  185. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '115'
      LIMIT 1
  186. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  187. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  188. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '277'
      AND main = 1
  189. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '121'
  190. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 72
      AND rgt > 73
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  191. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '121'
      LIMIT 1
  192. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  193. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  194. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '121'
      LIMIT 1
  195. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  196. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  197. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '307'
      AND main = 1
  198. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '100'
      LIMIT 1
  199. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  200. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  201. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '100'
      LIMIT 1
  202. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  203. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  204. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  205. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  206. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  207. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  208. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  209. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  210. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  211. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  212. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  213. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  214. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  215. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  216. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  217. 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 = 247 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  218. SELECT cat_id, cat_name
      FROM jos_mt_cats  
      WHERE cat_approved=1
      AND cat_published=1
      AND cat_parent = 0
      ORDER BY cat_name ASC
  219. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND catid = 8
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  220. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 30
  221. SELECT a.id, a.alias AS username, a.title AS fullname, a.catid, a.sectionid, a.introtext AS intro, u.email AS email, u.id AS user_id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.username = a.alias
      WHERE a.sectionid = 15
      AND a.state = 1
  222. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1

•0 legacy queries logged•

    •Language Files Loaded•

    •Untranslated Strings Diagnostic•

    •None•

    •Untranslated Strings Designer•

    •None•