(mysql): SELECT s.setting_key, s.input_id, IFNULL(sv.setting_value, s.default_value) AS value FROM s_setting s LEFT JOIN s_setting_to_value sv ON s.id = sv.setting_id WHERE s.active = 1 AND s.module_id = 100  
(mysql): SELECT c.*, #COUNT(DISTINCT cp.id) AS num_subcategories, COUNT(DISTINCT e.id) AS num_entries #IF(SUM(e.active), SUM(e.active), 0) as num_entries FROM s_kb_category c LEFT JOIN s_kb_entry_to_category ec ON c.id = ec.category_id LEFT JOIN s_kb_entry e ON e.id = ec.entry_id AND e.active = 1 #LEFT JOIN s_kb_category cp ON c.id = cp.parent_id WHERE 1 AND c.parent_id = '0' AND c.active = 1 AND 1 GROUP BY c.id ORDER BY sort_order  
(mysql): SELECT id as id1, id, parent_id, name, sort_order FROM s_kb_category c WHERE c.active = 1 ORDER BY sort_order  
(mysql): SELECT e.*, SUBSTRING_INDEX(e.body, ' ', 70) AS body, cat.id AS category_id, cat.name AS category_name, cat.private AS category_private, cat.commentable AS commentable, cat.ratingable, r.votes AS votes, (r.rate/r.votes) AS rating, IF(c.active = 1, COUNT(DISTINCT c.id), 0) AS comment_num, UNIX_TIMESTAMP(e.date_updated) AS ts_updated, 1 FROM s_kb_entry e, s_kb_category cat, s_kb_entry_to_category e_to_cat LEFT JOIN s_kb_comment c ON e.id = c.entry_id LEFT JOIN s_kb_rating r ON e.id = r.entry_id WHERE 1 AND e.active = 1 AND cat.active = 1 AND e.id = e_to_cat.entry_id AND cat.id = e_to_cat.category_id AND 1 AND cat.private = 0 GROUP BY e.id ORDER BY hits DESC LIMIT 0, 5  
(mysql): SELECT e.*, SUBSTRING_INDEX(e.body, ' ', 70) AS body, cat.id AS category_id, cat.name AS category_name, cat.private AS category_private, cat.commentable AS commentable, cat.ratingable, r.votes AS votes, (r.rate/r.votes) AS rating, IF(c.active = 1, COUNT(DISTINCT c.id), 0) AS comment_num, UNIX_TIMESTAMP(e.date_updated) AS ts_updated, 1 FROM s_kb_entry e, s_kb_category cat, s_kb_entry_to_category e_to_cat LEFT JOIN s_kb_comment c ON e.id = c.entry_id LEFT JOIN s_kb_rating r ON e.id = r.entry_id WHERE 1 AND e.active = 1 AND cat.active = 1 AND e.id = e_to_cat.entry_id AND cat.id = e_to_cat.category_id AND 1 AND cat.private = 0 GROUP BY e.id ORDER BY date_posted DESC LIMIT 0, 5  
Custom Complex Hosting | Managed Dedicated Servers | ICANN Accredited Reseller | Domain Registrar
  • Home
  • Hosting
  • Design
  • Marketing
  • E-commerce
  • Domain names
  • Support
  • Control panel
  • About us
  • Resellers
  • Contact us
Search:
Browse by category:
Knowledgebase home


Categories:
INTERNAL (0)
 GENERAL HOSTING (13)
 CGI (14)
ASP (3)
 BILLING (6)
 COLOCATED HOSTING (6)
DEDICATED HOSTING (10)
 DOMAIN NAMES (8)
 DNS (5)
E-COMMERCE (21)
 EMAIL (12)
 FTP (5)


Most viewed questions:
How do I transfer my sites to Webair.com hosting?
3 STEP DOMAIN TRANSFER INSTRUCTIONS:Transferring your domain to Webair servers is easy! Just follow the three simple steps below to...
rating 01 Dec, 2008
How do I set up my mail with the new information Webair sent me?
For a new account where the domain name is not fully transferred to Webair, your email account(s) may/may not work...
rating 01 Dec, 2008
What is the Webair Mail Server information?
Mail server:tiger.webair.com or mymail.webair.com.Incoming AND Outgoing mail servers should be: tiger.webair.com or mymail.webair.comHowever, these mail servers may/may not be accessible...
rating 01 Dec, 2008
After I sign up for a hosting account, how long until I can upload files?
You will be able to start uploading content for your website(s) the same day you signup for a hosting account....
Not rated 01 Dec, 2008
What is virtual hosting?
Hosting service that allows you to effectively manage your site by sharing server space with other clients allowing for a...
rating 01 Dec, 2008
Recently posted questions:
How do I update my credit card information?
Log in to your control panel and click on "billing center". In  there you will be able to update your...
Not rated 01 Dec, 2008
Does webair accept epassporte?
Yes please send an email to billing@webair.com to make payment  arrangements for epassporte payments....
Not rated 01 Dec, 2008
My account was suspended, what do I do now?
 Please email billing@webair.com or contact billing at  516-938-4100....
Not rated 01 Dec, 2008
How do I manage my e-mail with Webair?
Webair offers its clients an interface thru which they can administer various aspects of their email. First log into...
Not rated 01 Dec, 2008
Microsoft OUTLOOK SPAM Tutorial/s?
Purpose: ...
Not rated 01 Dec, 2008

Tech support call center
1.866.WEBAIR1 (932.2471)

Acceptable Use Policy Service Level Agreement Intellectual Property Policy Privacy Policy Banner Farm Careers

Terms of Use Webair Hosting FAQ Webair Hosting Forum
Copyright 1996 - 2008 Webair Internet Development, inc. All rights reserved.
Webair.com - New York - Amsterdam - Canada - California
ICANN ASACP