Home » Questions And Answers » Miscellaneous

Questions And Answers



Browse By Category
Search Questions


Category  > Miscellaneous


Page 1 of 1, showing records 0-0 out of 0.

WHLArchitects.com © 2012 Phone: (408) 730-9500
Fax: (408) 730-9588
1136 West Evelyn Avenue
Sunnyvale, California 94086-5742 
 
12 queries took 26 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1003
2SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1112
3SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 003
4SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3) 25253
5SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 222
6SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `categories` AS `Category` WHERE `Category`.`id` = 2 LIMIT 1113
7SELECT `Question`.`id`, `Question`.`category_id`, `Question`.`question`, `Question`.`answer`, `Question`.`question_date`, `Question`.`answer_date`, `Question`.`active` FROM `questions` AS `Question` WHERE `Question`.`category_id` IN (2) 002
8SELECT COUNT(*) AS `count` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`category_id` = 2 AND `Question`.`active` = 1 111
9SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `categories` AS `Category` WHERE 1 = 1 112
10SELECT COUNT(*) AS `count` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`category_id` = 2 AND `Question`.`active` = 1 111
11SELECT COUNT(*) AS `count` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`active` = 1 AND `Question`.`category_id` = 2 111
12SELECT `Question`.`id`, `Question`.`category_id`, `Question`.`question`, `Question`.`answer`, `Question`.`question_date`, `Question`.`answer_date`, `Question`.`active`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`name`, `Parent`.`date_created`, `Parent`.`date_modified`, `Parent`.`rght`, `Parent`.`lft`, `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`active` = 1 AND `Question`.`category_id` = 2 LIMIT 10003