•Banner•

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



 

Home Improvement

•Listings• RSS
•Add your listing here•

Aerus Electrolux

186 Wyoming Avenue, Wyoming, PA, 18644
Telephone570-288-4531

Arbor Garden

419 Washington Ave, Larksville, PA, USA, 18651
Telephone570-779-9437
E-mail

Borton-Lawson

613 Baltimore Drive, Wilkes-Barre, PA, 18702
Telephone570-821-1999

Boyle Fireplace

168 Main Street, Luzerne, PA, 18709
Telephone570-714-0447

Chorba’s Cabinet Shop

315 West 6th Street, Wyoming, PA, 18644
Telephone570-693-3502

Heads Up Flooring

23 Tener Street, Luzerne, PA, 18709
Telephone570-283-8488

Hi-Tech Flooring

125 Main Street #2, Luzerne, PA, 18709
Telephone570-287-5090

Ideal Windows

2330 Broadway #110, Denver, CO, United States, 80205
Telephone303-934-4508
E-mail

J.K's Carpentry & Handywork

1351 Scott Street, Wilkes-Barre, PA, 18705
Telephone570-793-5501
E-mail

Karasinski Architecture

14 Priestly Street, Wilkes-Barre, PA, 18702
Telephone570-829-3922

Kebo Insulation

Telephone570-779-5651

Kitchen Express

55 W. Seventh Street, Wyoming, PA, 18644
Telephone570-693-0258

KW Carpets & More

PO Box 652, Dallas, PA, 18612
Telephone570-675-8691

Luzerne Lumber

445 Main Street, Luzerne, PA, 18709
Telephone570-287-1177

Mr. Honey-Do

Telephone(570) 332-8187

Name Brand Liquidations

1600 Highway 315, Wilkes Barre, PA, USA, 18702
Telephone570-592-3426
E-mail

Relyt Construction LLC

338 Bunker Hill RD, Wyoming, PA, USA, 18644
Telephone(570) 574-0334
E-mail

Sarnak Roofing

Telephone570-313-0617

Summit Pointe Builders, Inc.

122 Memorial Highway, Dallas, PA, 18612
Telephone570-675-7900

•Profile Information•

Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.086 seconds, 5.38 MB
Application afterRoute: 0.132 seconds, 8.51 MB
Application afterDispatch: 0.377 seconds, 13.54 MB
Application afterRender: 0.418 seconds, 14.33 MB

•Memory Usage•

15393360

•155 queries logged•

  1. DELETE
      FROM jos_session
      WHERE ( TIME < '1544562573' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = '34qkdonuruseuqntutjb55ucq6'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '34qkdonuruseuqntutjb55ucq6','1544569773','','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/home-improvement' REGEXP BINARY fromurl)>0
      AND case_sensitive<>'0') OR (('/directory/home-improvement' 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 cat_id, cat_parent, alias
      FROM jos_mt_cats
      WHERE cat_published='1'
      AND cat_approved='1' && BINARY alias = 'home-improvement'
  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 cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '98'
  14. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 34
      AND rgt > 35
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  15. SELECT *
      FROM jos_mt_cats
      WHERE cat_id='98'
      AND cat_published = 1
      LIMIT 1
  16. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  17. SELECT COUNT(*)
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
      WHERE l.link_published = 1
      AND l.link_approved = 1 && cl.cat_id = '98'
     
      AND ( l.publish_up = '0000-00-00 00:00:00' OR l.publish_up <= '2018-12-11 23:09:33'  )
     
      AND ( l.publish_down = '0000-00-00 00:00:00' OR l.publish_down >= '2018-12-11 23:09:33' )
     
      AND cl.link_id = l.link_id
  18. SELECT cat.*
      FROM jos_mt_cats AS cat
      WHERE cat_published=1 && cat_approved=1 && cat_parent= '98'
      ORDER BY cat_name ASC
  19. SELECT r.rel_id
      FROM jos_mt_relcats AS r
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = r.rel_id
      WHERE r.cat_id = '98'
      AND c.cat_published = 1
  20. SELECT l.*, cl.*, cat.*, u.username AS username, u.name AS owner, img.filename AS link_image
      FROM jos_mt_links AS l
     
      LEFT JOIN jos_mt_cl AS cl
      ON cl.link_id = l.link_id
     
      LEFT JOIN jos_users AS u
      ON u.id = l.user_id
     
      LEFT JOIN jos_mt_cats AS cat
      ON cl.cat_id = cat.cat_id
     
      LEFT JOIN jos_mt_images AS img
      ON img.link_id = l.link_id
      AND img.ordering = 1
     
      WHERE link_published='1' && link_approved='1' && cl.cat_id = '98'
     
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-12-11 23:09:33'  )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-12-11 23:09:33' )
     
      ORDER BY link_featured DESC, link_name ASC
     
      LIMIT 0, 20
  21. SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS VALUE, field_type
      FROM jos_mt_customfields
  22. 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 (138,789,139,140,141,142,143,650,355,144,407,145,146,147,295,497,520,150,152,153)

      ORDER BY cf.ordering ASC, link_id DESC
  23. 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
  24. 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 ('138','789','139','140','141','142','143','650','355','144','407','145','146','147','295','497','520','150','152','153')
      AND r.rev_approved = '1'
      AND cl.main = '1'
     
      GROUP BY r.link_id
  25. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  26. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  27. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  28. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  29. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  30. SELECT params
      FROM jos_mt_templates
      WHERE tem_name = 'm2'
      LIMIT 1
  31. 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 = '138'
      AND main = 1
  32. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  33. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  34. SELECT cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  35. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  36. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  37. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  38. 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 = '789'
      AND main = 1
  39. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  40. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  44. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  45. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  46. 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 = '139'
      AND main = 1
  47. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  48. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 = '140'
      AND main = 1
  53. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 = '0'
      LIMIT 1
  57. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  58. 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 = '141'
      AND main = 1
  59. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  60. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  61. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  62. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  63. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  64. 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 = '142'
      AND main = 1
  65. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  69. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  70. 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 = '143'
      AND main = 1
  71. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  72. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  76. 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 = '650'
      AND main = 1
  77. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 = '0'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  83. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  84. 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 = '355'
      AND main = 1
  85. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 = '0'
      LIMIT 1
  89. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  90. 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 = '144'
      AND main = 1
  91. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  92. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  93. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  94. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  95. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  96. 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 = '407'
      AND main = 1
  97. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  98. 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 = '145'
      AND main = 1
  99. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  100. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  101. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  102. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  103. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  104. 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 = '146'
      AND main = 1
  105. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  106. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  110. 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 = '147'
      AND main = 1
  111. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 = '0'
      LIMIT 1
  115. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  116. 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 = '295'
      AND main = 1
  117. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 = '497'
      AND main = 1
  119. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      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 = '0'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  126. 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 = '520'
      AND main = 1
  127. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  128. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 = '0'
      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 = '150'
      AND main = 1
  135. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  136. 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 = '152'
      AND main = 1
  137. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  138. 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 = '153'
      AND main = 1
  139. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  140. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  144. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  145. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  146. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  147. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  148. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  149. 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
  150. 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
  151. 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
  152. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 30
  153. 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
  154. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1
  155. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '98'
      LIMIT 1

•0 legacy queries logged•

    •Language Files Loaded•

    •Untranslated Strings Diagnostic•

    •None•

    •Untranslated Strings Designer•

    •None•