Tools Add

Configuring Email Clients

Reference Number: AA-00259 Created: 2012-09-19 18:16 Last Updated: 2012-12-16 20:01

0 Rating/ Voters

Supported Email Clients

You can use any email client which supports POP3, SMTP and SMTP Authentication. Some examples of such email clients are:

Microsoft Outlook 2007
Windows Mail
Microsoft Outlook Express
Eudora
Mozilla Thunderbird
Mail for MacOS
Microsoft Entourage
Netscape Communicator
And many, many more!

Outlook 2007

Incoming Mail Server (POP3):

mail.yourdomain.com

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Open Outlook. Select Account Settings... from the Tools menu.
On the E-mail tab, click New
Select "Manually configure server settings or additional server types" and click Next ->
Select "Internet E-mail" and click Next ->
Enter your details as follows. Make sure to replace username@yourdomain.com and yourdomain.com with your actual email address and domain name.
Click on the Outgoing Server tab, and check the box labeled "My outgoing server (SMTP) requires authentication." Then choose to "Use same settings as my incoming mail server."
Click "OK", then "Next", and "Finish"

Outlook 2003

To configure your Microsoft® Outlook® 2003 to send email with your email account, follow the instructions bellow:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Click on Tools - Email Accounts... Select "Add a new email account" and click Next. Select POP3 and click Next.
Enter your details as follows. Make sure to replace username@yourdomain.com and yourdomain.com with your actual email address and domain name.
When you have finished entering your details, click on More Settings... From the window that opens, click on the Outgoing Server tab. Check mark "My outgoing server (SMTP) requires authentication" and then select "Use same settings as my incoming mail server. Then click OK.
Click Next and then Finish.

Outlook Express

To configure your Microsoft® Outlook® Express to send email with your email account, follow the instructions bellow:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Click on Tools and then Accounts. Click on the Add button and select Mail...
Enter your display name in the field provided and then click Next.
Enter your email address in the field provided and then click Next.
Select the server type POP3 and enter your incoming and outgoing mail server names. (Make sure to replace "yourdomain.com" with your actual domain name). Click Next.
Enter your account name and password in the fields provided. Please note that your account name is the same as your full email address. Then click Next and then Finish.
You should then see your server in the list of Mail accounts. Select the newly added account and click on the Properties button.
Click on the Servers tab and then check mark the box labeled My server requires Authentication.
Click on the Settings... button. In the next window make sure that the option Use same settings as my incoming mail server is selected.
Click OK, then OK, and finally Close. You're now ready to send and receive email.

Mozilla Thunderbird 5

To configure Mozilla Thunderbird 5 to send email with your email account, follow the instructions bellow:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Run Thunderbird. From the Tools menu select Account Settings...
In the next window, click Account Actions and then Add Mail Account...
The Account Wizard will begin. Enter Your name (as you want to be seen by others), Email address and Password and then click on Continue
You'll then need to click on Manual config
From here you can enter in the account information. Be sure to change your username to use the full email address.
Once complete click on Create Account

Mozilla Thunderbird

To configure Mozilla Thunderbird to send email with your email account, follow the instructions bellow:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Run Thunderbird. From the Tools menu select Account Settings...
In the next window, click Add Account...
The Account Wizard will begin. Select Email account and click Next.
Enter your full name in the Your Name field and your full email address in the Email Address field. Then click Next.
On the server information page, select POP as your incoming server type. Then enter mail.yourdomain.com and smtp.yourdomain.com as your Incoming Server and Outgoing Server. Make sure to replace yourdomain.com with your actual domain name. Then click Next.
On the usernames page, enter your full email address as both your incoming username and outgoing username. Then click Next.
On the Account name page, you can enter any Name you choose to help you identify the account from within Thunderbird. Then click Next.
You'll then see a confirmation page with all your account details. To complete the setup, click on Finish. You can then start using yoru account.

Outlook 2000/2002

To configure your Microsoft® Outlook® 2000/2002 to send email with your email account, follow the instructions bellow:

Incoming Mail Server (POP3):

'mail'.yourdomain.com

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Click on Tools - Accounts. There you will see:
Click on the Mail tab.
Click Add - Mail, this will run the Internet Connection Wizard.
Enter your name here, like Firstname Lastname, click Next.
Enter your email address, (for example: admin@yourdomain.com) and click Next.
Leave incoming mail server type as POP3, enter mail.yourdomain.com as Incoming Mail Server and enter smtp.yourdomain.com as Outgoing Mail Server, click Next.
Change the account name to your email address (for example: admin@yourdomain.com), enter your password for that account, click Next.
Click Finish.
Click on your newly created account in Outlook and click Properties.
Click Servers tab.
Click "My server requires authentication" checkbox and click Settings button.
Select the Log on using option and enter Account name as admin@yourdomain.com, enter your password for your admin mailbox in Password field, click OK.
Click OK, click Close. You have just setup your email account and Outgoing SMTP Server.
For additional email addresses, simply repeat these steps using your desired email account.

Entourage 2008

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Click Tools and then click Accounts.
In the Accounts window click New.
The Account Setup Assistant will start. Click the Configure account manually button.
Select POP for Account type and click OK.
Enter your details in the appropriate section:
- Account Name Name your account something descriptive such as "myhosting.com email".
- Name Enter your full name as you would like it to appear on the messages that you send.
- Account ID enter your full email address again.
Click the button labeled Click here for advanced sending options in the sending mail section and check the SMTP server requires authentication. Leave the default on use same settings as receiving mail server.
Click "OK".

Entourage 2004

To configure Entourage 2004 to send email with your email account, follow the instructions bellow:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Run Entourage. From the Tools menu select Accounts.
From the Accounts window, click New.
Select Account type POP and click OK.
On the Edit Account page you'll be prompted to enter all of your email account details.
- The Account name can be anything you would like to identify the email account within Entourage.
- Enter your full name in the Name field.
- And your email address in the E-mail address field.
- For Account ID, enter your full email address.
- Enter your POP server as mail.yourdomain.com making sure to replace yourdomain.com with your actual domain name.
- Enter your email account password in the Password field
In the SMTP server field, enter smtp.yourdomain.com making sure to replace yourdomain.com with your actual domain name. Then click on the button below the field which reads Clic here for advanced sending options. This will open a sub-menu. On the sub-menu, select SMTP server requires authentication and Use same settings as receiving mail server.
Close the sub-menu by clicking on the small "-" in the top-left corner. Then click OK. Your account is now set up and ready to use.

Eudora

To configure your Eudora 6 to send email with your email account, follow the instructions below:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Click on Tools - Options. A window will open where you can enter all of your mail server options. You can enter them as follows:
Make sure to replace username@yourdomain.com and yourdomain.com with your actual email address and domain name.
Once you have finished entering your settings, click on OK to save your settings.
Then you can click on the "Check Mail" button to download your email.

Mail for Mac

To configure Mail for Macintosh to send and receive email with your email account, please follow the instructions below:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Run Mail for Macintosh. From the Mail menu, select Preferences...
In the Accounts window, click on the + located in the bottom-left corner.
Next, enter your full name and your email address in the fields provided. Make sure to replace username@yourdomain.com with your actual email address. Then click Continue.
Next, enter your incoming mail server name. (Replace yourdomain.com with your actual domain name). Your username should be the exact same as your email address as you entered in the previous step. Then click Continue.
Next, enter your outgoing mail server name. (Replace yourdomain.com with your actual domain name). Check mark the Use Authentication checkbox. Then enter your email address in the User Name field and your password. Then click Continue.
You'll then be presented an account summary with all the details you entered. Click Continue.
Click Done.
You should then see your new account in the "Accounts" list on the left side of the window. You can now begin using your account.

Outlook Express for Mac

To configure Outlook Express for Mac to send and receive email with your email account, please follow the instructions bellow:

Incoming Mail Server (POP3):

mail'.yourdomain.com'

Outgoing Mail Server (SMTP):	smtp.yourdomain.com
Username:	username@yourdomain.com
Password:	*your_mailbox_password*

Run Outlook Express.
Click the Tools menu and select Accounts. The Accounts window will appear:
Click New; this will start the Account Setup Assistant.
Enter your name in the Display Name field, and then click on the Right Arrow to continue.
Select "I already have an e-mail address that I'd like to use" and enter your e-mail address in the field. Then click the Right Arrow to continue.
Select the "My incoming mail server is a POP server" option and enter mail.domain_name.com as your Incoming mail server and smtp.domain_name.com as your Outgoing mail server (make sure to replace domain_name.com with your actual domain name). Then click the Right Arrow to continue.
Enter your username in the Account ID and enter your password in the Password field. Then click the Right Arrow to finish the Assistant.
NOTE: Your username is the same as your email address. For example, if your email address is youruser@domain_name.com, then your username will be youruser@domain_name.com.
You should now see the Accounts window, with your newly created account under Outlook Express. Select the new account and click Edit:
Click to the button saying "Click here for advanced sending options" on the bottom of the window. This will allow you to setup SMTP/Outgoing Mail Server authentication:
Select "SMTP server requires authentication" and select "Log on using". Under Account ID, enter youruser@domain_name.com and enter your password in the Password field. Click the little square button on the top left to close the advanced SMTP options:
Click OK to close the Account Properties, and then you can close the Accounts window from its handle. That's it! Now you can send and receive emails from your newly created account.

Comments

There are no comments for this article.

Add Comment

0.0048871040344238	SELECT `sys_settings`.`var_name`, `sys_settings`.`var_value` FROM `sys_settings`
0.00059700012207031	SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')
0.0077059268951416	SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.0073268413543701	SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.00063300132751465	SELECT `sys_settings`.`var_value` FROM `sys_settings` WHERE (var_name = 'session_life_time_unlimited')
0.0007631778717041	SELECT `ac`.`auto_relate`, `ac`.`max_staff_users`, `ac`.`max_client_users`, `ac`.`name`, (SELECT COUNT(*) FROM `users` WHERE (account_id = 2) AND (ldap_user = 'Y')) AS `ldap_users_num` FROM `accounts` AS `ac` WHERE (ac.account_id = 2)
0.00070595741271973	SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (type = 'staff') AND (active = 'Y') AND (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) AND (login != 'sales@web-site-scripts.com')
0.0005030632019043	SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (type = 'client') AND (active = 'Y') AND (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) AND (login != 'sales@web-site-scripts.com')
0.00050997734069824	SELECT COUNT(us.user_id) FROM `users` AS `us` WHERE (account_id = 2) AND ((SELECT COUNT(*) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) = 0) AND (login != 'sales@web-site-scripts.com')
0.00043392181396484	SELECT COUNT(*) AS `count` FROM `accounts` WHERE (LOWER(name) != 'preview')
0.00063490867614746	SELECT `accounts`.`name` FROM `accounts` WHERE (LOWER(name) != 'preview') ORDER BY `account_id` ASC LIMIT 1
0.0010631084442139	SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type = 'Hosted') AND (account_id = 2)
0.00098490715026855	SELECT `vm`.`view_id` AS `id`, `vm`.`name`, `vm`.`type`, `vm`.`hash`, `vm`.`settings` AS `tabs`, `vm`.`style_id` AS `styles`, `vm`.`gmt`, `vm`.`time_format`, `vm`.`date_format`, `vm`.`lang_id`, `vm`.`status`, `vm`.`access_mode`, `vm`.`voting_id` AS `voting`, `g`.`offset` AS `gmt_offset` FROM `view_manage` AS `vm` LEFT JOIN `gmt` AS `g` ON g.gmt_id = vm.gmt WHERE (view_id = 2)
0.00061202049255371	SELECT `votings`.`voting_id` AS `value`, `votings`.`voting_name` AS `text` FROM `votings` WHERE (account_id = 2) OR (system = 'Y') ORDER BY `voting_name` ASC
0.00357985496521	SELECT `tpl`.`theme_id`, `tpl`.`theme_name`, `tpl`.`based_on`, `tpl`.`system`, CASE WHEN ((vm.style_id = tpl.copy_of_theme OR vm.style_id = tpl.theme_id) AND vm.account_id = 2) THEN 'Y' ELSE 'N' END AS `current` FROM `tpl_themes` AS `tpl` LEFT JOIN `view_manage` AS `vm` ON (vm.style_id = tpl.copy_of_theme OR vm.style_id = tpl.theme_id) AND vm.type = 'Hosted' AND vm.account_id = 2 WHERE (tpl.account_id = 1 AND tpl.copy = 'N' AND tpl.system = 'Y') OR (tpl.account_id = 2 AND copy = 'N' AND tpl.system = 'N') ORDER BY `theme_name` ASC
0.00077605247497559	SELECT `votings`.* FROM `votings` WHERE (voting_id = 1)
0.0005190372467041	SELECT `voting_items`.`item_title` AS `title`, `voting_items`.`value` FROM `voting_items` WHERE (voting_id = 1) ORDER BY `value` DESC
0.0022158622741699	SELECT `view_styles`.* FROM `view_styles` WHERE (style_id = 4)
0.00070285797119141	SELECT `view_elements_styles`.`element_name` AS `name`, `view_elements_styles`.`element_type` AS `style` FROM `view_elements_styles` WHERE (style_id = 4) ORDER BY `element_name` ASC
0.00047111511230469	SELECT `languages`.`name` AS `text`, `languages`.`lang_id` AS `value` FROM `languages` WHERE (status = 'on') AND (lang != 'def') ORDER BY `lang_id` ASC
0.00091791152954102	SELECT `gmt`.* FROM `gmt` ORDER BY `offset` ASC
0.00056791305541992	SELECT `view_manage`.`view_id` AS `id`, `view_manage`.`hash`, `view_manage`.`status`, `view_manage`.`lang_id`, `view_manage`.`name` FROM `view_manage` WHERE (account_id = 2) AND (type = 'HOSTED') LIMIT 1
0.001039981842041	SELECT `view_manage`.`view_id`, `view_manage`.`name` FROM `view_manage` WHERE (type = 'Hosted') AND (account_id = 2)
0.00072002410888672	SELECT `view_manage`.`settings` FROM `view_manage` WHERE (view_id = 2)
0.00049114227294922	UPDATE `view_manage` SET `views_num` = views_num + 1, `last_view_date` = ? WHERE (view_id = 2)
0.00054597854614258	SELECT `faq_articles`.`faq_id` FROM `faq_articles` WHERE (code = 'AA-00259') AND (account_id = 2) AND (status = 'moderated')
0.0004889965057373	DROP TABLE IF EXISTS `tmp_visible_articles_20101`;
0.00049901008605957	DROP TABLE IF EXISTS `tmp_visible_articles_20101`;
0.00074982643127441	CREATE TEMPORARY TABLE `tmp_visible_articles_20101` (`faq_id` int PRIMARY KEY) ENGINE=MEMORY
0.10451793670654	INSERT INTO `tmp_visible_articles_20101` SELECT `faq`.`faq_id` AS `id` FROM `faq_articles` AS `faq` USE INDEX (`PRIMARY`) WHERE (account_id = 2) AND (freeAccess = 'Y') AND (draft = 'N') AND (status = 'moderated') AND ( `public` = 'Y' AND ((public_start_date <= '2013-05-23 22:38:35' OR public_start_date IS NULL) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:35') ))
0.0016238689422607	SELECT `tmp_visible_articles_20101`.`faq_id` FROM `tmp_visible_articles_20101`
0.043543100357056	SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') AND (far.featured = 'Y') ORDER BY `far`.`status_change_date` DESC, `faqId` DESC LIMIT 10
0.0020370483398438	SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:35') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:35'))) THEN 'Y' ELSE 'N' END AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4584,4814,4815,4816,4596,3565)) AND (fa.status = 'moderated') ORDER BY `fa`.`status_change_date` DESC, `faq_id` DESC
0.0006868839263916	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4584)
0.0009620189666748	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)
0.00055289268493652	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 17)
0.00051689147949219	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 8)
0.00073599815368652	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 35)
0.00073599815368652	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 17)
0.000518798828125	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 37)
0.00067996978759766	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 35)
0.00064897537231445	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 206)
0.00057411193847656	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 200)
0.00059413909912109	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 221)
0.00049495697021484	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 207)
0.0005190372467041	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 354)
0.00045204162597656	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 205)
0.00054693222045898	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 355)
0.00047898292541504	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4814)
0.00057220458984375	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 368)
0.00058984756469727	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4815)
0.0005640983581543	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4816)
0.00048494338989258	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4596)
0.00087308883666992	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 356)
0.00057101249694824	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 34)
0.0008690357208252	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 3565)
0.00055789947509766	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 284)
0.00078082084655762	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 315)
0.0005800724029541	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 215)
0.00046706199645996	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 212)
0.049633979797363	SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') ORDER BY `far`.`views` DESC, `faqId` DESC LIMIT 10
0.0046629905700684	SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:35') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:35'))) THEN 'Y' ELSE 'N' END AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (1064,1094,845,4584,1061,510,4614,842,698,907)) AND (fa.status = 'moderated') ORDER BY `fa`.`views` DESC, `faq_id` DESC
0.00063180923461914	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1064)
0.00079083442687988	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 147)
0.00050616264343262	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 357)
0.00075817108154297	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1094)
0.00056290626525879	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 845)
0.00072002410888672	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 36)
0.00052499771118164	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 358)
0.00084805488586426	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 1061)
0.00071096420288086	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 510)
0.00054478645324707	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 183)
0.00067901611328125	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 182)
0.00057697296142578	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4614)
0.00059795379638672	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 842)
0.00059103965759277	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 698)
0.00061297416687012	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 19)
0.00059795379638672	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 9)
0.00057291984558105	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 907)
0.00074505805969238	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 142)
0.00056815147399902	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 33)
0.00063610076904297	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 16)
0.049723863601685	SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') ORDER BY `far`.`rating` DESC, `faqId` DESC LIMIT 10
0.050000190734863	SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:35') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:35'))) THEN 'Y' ELSE 'N' END AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4625,4624,4614,4610,4584,4401,994,644,642,4873)) AND (fa.status = 'moderated') ORDER BY `fa`.`rating` DESC, `faq_id` DESC
0.00065088272094727	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4625)
0.0005497932434082	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4624)
0.00075721740722656	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 18)
0.00049591064453125	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 47)
0.00059103965759277	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 25)
0.00047802925109863	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 11)
0.00057315826416016	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 7)
0.0006709098815918	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 66)
0.00055813789367676	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 24)
0.00060105323791504	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4610)
0.00079178810119629	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4401)
0.00060606002807617	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 994)
0.00049901008605957	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 130)
0.00062918663024902	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 32)
0.00057101249694824	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 644)
0.00053310394287109	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 79)
0.00066900253295898	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 27)
0.00056290626525879	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 12)
0.00049996376037598	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 98)
0.00065016746520996	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 26)
0.00062298774719238	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 642)
0.00069713592529297	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 81)
0.00047802925109863	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4873)
0.00042510032653809	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 247)
0.00049185752868652	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 246)
0.051213026046753	SELECT `far`.`faq_id` AS `faqId`, `far`.`featured`, `far`.`question`, `far`.`views`, `far`.`rating`, `far`.`faq_date`, `far`.`status_change_date` FROM `faq_articles` AS `far` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON far.faq_id = tmp.faq_id WHERE (draft = 'N') ORDER BY `far`.`real_creation_date` DESC, `faqId` DESC LIMIT 10
0.10735297203064	SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:35') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:35'))) THEN 'Y' ELSE 'N' END AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4873,4872,4871,4870,4869,4865,4864,4863,4862,4861)) AND (fa.status = 'moderated') ORDER BY `fa`.`real_creation_date` DESC, `faq_id` DESC
0.00066208839416504	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4872)
0.00048995018005371	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4871)
0.00061202049255371	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 371)
0.00070714950561523	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 210)
0.00060677528381348	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4870)
0.00050902366638184	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4869)
0.00063204765319824	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4865)
0.00066709518432617	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 231)
0.00074386596679688	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 209)
0.00061702728271484	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4864)
0.00081896781921387	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4863)
0.00095009803771973	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 312)
0.00056886672973633	SELECT `faq_categories`.`cat_name`, `faq_categories`.`cat_id`, `faq_categories`.`parent_id` FROM `faq_categories` WHERE (cat_id = 310)
0.00068402290344238	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4862)
0.00060296058654785	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 4861)
0.004486083984375	SELECT `far`.`faq_id` AS `faqId`, `far`.`code`, `far`.`email`, `far`.`public` AS `public_`, `far`.`draft`, `far`.`locked`, `far`.`answer`, `far`.`lock_user_id`, `far`.`question`, `far`.`status`, `far`.`featured`, `far`.`freeAccess`, UNIX_TIMESTAMP(far.lock_date) AS `lock_date`, `far`.`author` AS `author_id`, `far`.`editor` AS `editor_id`, `far`.`faq_date` AS `date`, `far`.`rating`, `far`.`views`, `far`.`public_start_date` AS `publicStartDate_`, `far`.`public_end_date` AS `publicEndDate_`, CASE WHEN status_change_date IS NULL OR (status_change_date <= '1970-01-01 00:00:00') THEN faq_date ELSE status_change_date END AS `lastEditDate`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:36') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:36'))) THEN 'Y' ELSE 'N' END AS `public`, `far`.`meta_keywords`, `far`.`meta_description`, `far`.`KEYWORD_JSGUI`, `far`.`KEYWORD_KMP`, `far`.`KEYWORD_JSGUI_URL`, `far`.`KEYWORD_KMP_URL`, CONCAT_WS(' ', us.fname,us.lname) AS `author_login`, CONCAT_WS(' ', us_e.fname,us_e.lname) AS `editor_login`, CONCAT_WS(' ', us_l.fname,us_l.lname) AS `lock_login`, (SELECT COUNT(*) FROM `faq_attachments` WHERE (faq_id = 186)) AS `attaches` FROM `faq_articles` AS `far` LEFT JOIN `users` AS `us` ON far.author = us.user_id LEFT JOIN `users` AS `us_e` ON far.editor = us_e.user_id LEFT JOIN `users` AS `us_l` ON far.lock_user_id = us_l.user_id WHERE (far.faq_id = 186) AND ( (far.`public` = 'Y' AND (((far.public_start_date <= '2013-05-23 22:38:36') OR (far.public_start_date IS NULL)) AND (far.public_end_date IS NULL OR far.public_end_date >= '2013-05-23 22:38:36')))) LIMIT 1
0.00098919868469238	SELECT `v_com`.`faq_vc_id` AS `v_com_id`, `v_com`.`visitor_subject` AS `v_com_subject`, `v_com`.`visitor_comment` AS `v_com_comment`, `v_com`.`visitor_comment_date` AS `v_com_date`, `v_com`.`nickname` AS `v_com_nick`, `v_com`.`email` AS `v_com_email`, `v_com`.`user_ip` AS `v_com_ip`, `u_com`.`faq_uc_id` AS `u_com_id`, `u_com`.`user_subject` AS `u_com_subject`, `u_com`.`user_comment` AS `u_com_comment`, `u_com`.`user_comment_date` AS `u_com_date`, CASE WHEN u_com.faq_uc_id IS NULL THEN 0 ELSE 1 END AS `nouser`, `usr`.`fname`, `usr`.`lname` FROM `faq_visitors_comments` AS `v_com` LEFT JOIN `faq_users_comments` AS `u_com` ON v_com.faq_vc_id = u_com.faq_vc_id LEFT JOIN `users` AS `usr` ON u_com.author_id = usr.user_id WHERE (v_com.faq_id = 186) AND (v_com.comment_status != 'delete') AND (v_com.comment_status != 'new') ORDER BY `v_com_date` DESC, `u_com_date` ASC
0.0005040168762207	SELECT `faq_statistics`.`stat_id` AS `id`, `faq_statistics`.`feedback` AS `message`, `faq_statistics`.`stat_date` AS `date`, `faq_statistics`.`email`, `faq_statistics`.`rating` AS `voter` FROM `faq_statistics` WHERE (faq_id = 186) AND (feedback NOT LIKE '')
0.0037491321563721	SELECT SQL_CALC_FOUND_ROWS `custom_fields`.`cf_id` AS `id`, `custom_fields`.`name`, `custom_fields`.`type`, `custom_fields`.`position`, `custom_fields`.`required`, `custom_fields`.`internal`, `custom_fields`.`hint`, `custom_fields`.`use_hint`, `custom_fields`.`listHeight`, `custom_fields`.`search_back`, `custom_fields`.`search_front`, `custom_fields`.`show_empty`, `custom_fields`.`WYSIWYG`, `custom_fields`.`optionsDelimiter`, `custom_fields`.`format`, `custom_fields`.`isLink` FROM `custom_fields` WHERE (account_id = 2) ORDER BY `position` ASC
0.000762939453125	SELECT `cfa`.`cf_id`, `cfa`.`cf_o_id`, `cfa`.`value`, `cf`.`name`, `cf`.`optionsDelimiter`, `cf`.`internal`, `cf`.`type`, `cf`.`format`, `cf`.`position`, `cf`.`show_empty`, `cf`.`search_front` FROM `custom_fields_articles` AS `cfa` INNER JOIN `custom_fields` AS `cf` ON cf.cf_id = cfa.cf_id WHERE (cfa.faq_id = 186) ORDER BY `cf_id` ASC
0.00061798095703125	SELECT `fc`.`cat_id`, `fc`.`cat_name`, `fc`.`account_id` FROM `articles_categories` AS `ac` LEFT JOIN `faq_categories` AS `fc` ON fc.cat_id = ac.category_id WHERE (ac.faq_id = 186)
0.00096011161804199	SELECT `fa`.`faq_id` AS `id`, `fa`.`views`, `fa`.`rating`, `fs`.`stat_id` AS `voters`, `fs`.`stat_date` AS `statDate` FROM `faq_articles` AS `fa` LEFT JOIN (SELECT `faq_statistics`.`faq_id`, MAX(stat_date) AS `stat_date`, COUNT(stat_id) AS `stat_id` FROM `faq_statistics` GROUP BY `faq_id`) AS `fs` ON fa.faq_id = fs.faq_id WHERE (fa.faq_id = 186)
0.00096297264099121	SELECT SQL_CALC_FOUND_ROWS `us`.`user_id`, `us`.`allow_delete` AS `editable`, `us`.`type`, CASE WHEN (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0 THEN 'N' ELSE 'Y' END AS `unassigned`, `us`.`active`, `us`.`ldap_user`, `us`.`login`, `us`.`fname`, `us`.`lname`, `us`.`email`, CONCAT_WS(' ', us.fname,us.lname) AS `text` FROM `users` AS `us` WHERE (us.login != 'sales@web-site-scripts.com') AND (us.account_id = 2) AND (us.type = 'staff' AND us.active <> 'P' AND (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.user_id = us.user_id)) > 0) ORDER BY `login` ASC
0.00054192543029785	SELECT FOUND_ROWS()
0.00075984001159668	SELECT `fa`.`revision_id`, `fa`.`revision_date` AS `date`, CONCAT_WS(' ', us.fname,us.lname) AS `author`, CONCAT_WS(' ', us_e.fname,us_e.lname) AS `editor` FROM `faq_history` AS `fa` LEFT JOIN `users` AS `us` ON fa.author = us.user_id LEFT JOIN `users` AS `us_e` ON fa.editor = us_e.user_id WHERE (fa.faq_id = 186) ORDER BY `date` DESC
0.00060701370239258	SELECT `faq_articles`.`freeAccess`, `faq_articles`.`account_id` FROM `faq_articles` WHERE (faq_id = 186)
0.0012688636779785	SELECT DISTINCT `g`.`group_id`, `g`.`name`, `g`.`description`, `g`.`allow_delete` FROM `articles_categories` AS `ac` LEFT JOIN `groups_categories_permissions` AS `gcp` ON ac.category_id = gcp.category_id OR gcp.category_id = 0 LEFT JOIN `groups` AS `g` ON g.group_id = gcp.group_id WHERE (ac.faq_id = 186) AND (g.account_id = 2) ORDER BY `g`.`name` ASC
0.0077590942382812	SELECT COUNT(*) AS `num` FROM `drafts` WHERE (account_id = 2) AND (user_id = -1) AND (question NOT LIKE '' OR answer NOT LIKE '')
0.008634090423584	SELECT `dr`.`faq_id`, `dr`.`draft_id`, `dr`.`draft_date`, `dr`.`question`, `dr`.`answer`, `fa`.`draft`, CONCAT_WS(' ', us.fname,us.lname) AS `author_login`, CONCAT_WS(' ', us_e.fname,us_e.lname) AS `editor_login` FROM `drafts` AS `dr` LEFT JOIN `faq_articles` AS `fa` ON dr.faq_id = fa.faq_id LEFT JOIN `users` AS `us` ON fa.author = us.user_id LEFT JOIN `users` AS `us_e` ON fa.editor = us_e.user_id WHERE (dr.faq_id = 186) AND (dr.user_id = -1) AND ((fa.faq_date < dr.draft_date OR fa.status_change_date < dr.draft_date))
0.00078511238098145	UPDATE `faq_articles` SET `views` = ? WHERE (faq_id = 186)
0.0005338191986084	SELECT `terms`.`term_id`, `terms`.`term`, `terms`.`term_description` AS `description` FROM `terms` WHERE (account_id = 2)
0.0010578632354736	SELECT SQL_CALC_FOUND_ROWS `faq_attachments`.`faq_attachment_id` AS `id`, `faq_attachments`.`attach_name` AS `name`, `faq_attachments`.`file_path` AS `path`, `faq_attachments`.`mime_type` AS `type`, `faq_attachments`.`file_name` FROM `faq_attachments` WHERE (faq_id = 186) ORDER BY `name` ASC
0.00066709518432617	SELECT FOUND_ROWS()
0.00087904930114746	SELECT `g`.`group_id` AS `gid`, `g`.`name`, `g`.`allow_delete`, `g`.`description`, `g`.`type`, (SELECT COUNT(user_id) FROM `users_groups` AS `ug` WHERE (ug.group_id = g.group_id)) AS `users_count` FROM `groups` AS `g` WHERE (account_id = 2) ORDER BY `name` ASC
0.0054690837860107	SELECT `ac`.`category_id` FROM `articles_categories` AS `ac` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON ac.faq_id = tmp.faq_id UNION SELECT `fc`.`cat_id` AS `category_id` FROM `faq_categories` AS `fc` WHERE (fc.`public` = 'Y') AND (fc.account_id = 2)
0.015480041503906	SELECT `fc`.`cat_id` AS `id`, `fc`.`parent_id` AS `pid`, `fc`.`cat_name` AS `text`, `fc`.`position`, `fc`.`meta_keywords`, `fc`.`meta_description`, `fc`.`public`, CASE WHEN childCount.`count` IS NULL THEN 0 ELSE childCount.`count` END AS `childCount`, CASE WHEN totalArticles.`count` IS NULL THEN 0 ELSE totalArticles.`count` END AS `totalArticles` FROM `faq_categories` AS `fc` LEFT JOIN (SELECT `faq_categories`.`parent_id`, COUNT(cat_id) AS `count` FROM `faq_categories` GROUP BY `parent_id`) AS `childCount` ON childCount.parent_id = fc.cat_id LEFT JOIN (SELECT `ac`.`category_id`, COUNT(ac.faq_id) AS `count` FROM `articles_categories` AS `ac` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON ac.faq_id = tmp.faq_id GROUP BY `category_id`) AS `totalArticles` ON totalArticles.category_id = fc.cat_id WHERE (fc.account_id = 2) ORDER BY `fc`.`position` ASC, `fc`.`cat_name` ASC
0.00084114074707031	SELECT `gcp`.`category_id` FROM `users_groups` AS `ug` LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmCategoryCreateEdit') AND (gp.value = '1')
0.00066995620727539	SELECT `gcp`.`category_id` FROM `users_groups` AS `ug` LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmCategoryDelete') AND (gp.value = '1')
0.00065708160400391	SELECT `gcp`.`category_id` FROM `users_groups` AS `ug` LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmArticleCreateEdit') AND (gp.value = '1')
0.00062394142150879	SELECT `gcp`.`category_id` FROM `users_groups` AS `ug` LEFT JOIN `groups_permissions` AS `gp` ON gp.group_id = ug.group_id LEFT JOIN `groups_categories_permissions` AS `gcp` ON gcp.group_id = gp.group_id WHERE (user_id = -1) AND (gp.permission = 'ActPrmArticleDelete') AND (gp.value = '1')
0.0018589496612549	SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`featured`, `fa`.`rating`, `fa`.`views`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:36') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:36'))) THEN 'Y' ELSE 'N' END AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `ac`.`category_id` FROM `faq_articles` AS `fa` INNER JOIN `tmp_visible_articles_20101` AS `tmp` ON fa.faq_id = tmp.faq_id LEFT JOIN `articles_categories` AS `ac` ON ac.faq_id = fa.faq_id WHERE (ac.category_id IN (7,11,25,47) ) ORDER BY `fa`.`featured` ASC, `fa`.`question` asc
0.000823974609375	SELECT `tpl_layouts`.`layout_id`, `tpl_layouts`.`template` FROM `tpl_layouts` WHERE (theme_id = 4) AND (layout_name = 'Article')
0.0011758804321289	SELECT `lb`.`block_id`, `lbc`.`block_name`, `lbc`.`template` FROM `tpl_layouts_blocks` AS `lb` INNER JOIN `tpl_blocks` AS `lbc` ON lbc.block_id = lb.block_id WHERE (layout_id = 59)
0.0018150806427002	SELECT `tpl_snippets`.`template`, `tpl_snippets`.`snippet_name`, `tpl_snippets`.`block_id` FROM `tpl_snippets` WHERE (theme_id = 4)
0.0009310245513916	SELECT `languages`.`lang_id` FROM `languages` WHERE (lang = 'def')
0.0084130764007568	SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 1) AND (type != 'notification')
0.011163949966431	SELECT `languages_vars`.`language_var`, `languages_vars`.`value` FROM `languages_vars` WHERE (lang_id = 2) AND (type != 'notification')
Max Query Time:	Query:
0.10735297203064	SELECT `fa`.`faq_id` AS `faqId`, `fa`.`question`, `fa`.`code`, `fa`.`views`, `fa`.`rating`, `fa`.`featured`, `fa`.`answer`, CASE WHEN (`public` = 'Y' AND (((public_start_date <= '2013-05-23 22:38:35') OR (public_start_date IS NULL)) AND (public_end_date IS NULL OR public_end_date >= '2013-05-23 22:38:35'))) THEN 'Y' ELSE 'N' END AS `public`, `fa`.`faq_date` AS `date`, `fa`.`status_change_date` AS `lastEditDate`, `fa`.`public_start_date` AS `publicStartDate` FROM `faq_articles` AS `fa` WHERE (fa.faq_id IN (4873,4872,4871,4870,4869,4865,4864,4863,4862,4861)) AND (fa.status = 'moderated') ORDER BY `fa`.`real_creation_date` DESC, `faq_id` DESC
Total SQL Time:	Queries Num:
0.64631581306458	158