Brouwer Turf :: Products

Load Lifter Agri Lifter

Used Equipment

Designed for the Turf Industry

5000 lbs. Capacity

Roomy Operator's Compartment

Low Machine Weight to Reduce Ground Pressure

Fully Componentized Power Train

Oil Immersed Disc Brakes

Independent Left and Right Brake Pedals

High Ground Clearance

Fast Agile Performance

Standard Differential Lock

Heavy Duty Steer Axle

Reconditioned Load Lifter Agri Lifter

Re-painted with a new set of decals

$16500 USD

Contact

Tel: (905) 476-6222

Fax: (905) 476-6744

Email: info@kesmac.com

39 queries took 14 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `products`	16	16	1
2	DESCRIBE `product_categories`	10	10	1
3	DESCRIBE `product_images`	8	8	6
4	DESCRIBE `product_option_groups`	7	7	0
5	DESCRIBE `users`	25	25	1
6	DESCRIBE `groups`	5	5	0
7	DESCRIBE `accesses`	6	6	0
8	SELECT `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 1	0	0	0
9	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
10	SELECT `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)	1	1	0
11	SELECT `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)	35	35	0
12	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	5	5	0
13	SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`product_category_id`, `Product`.`product_brand_id`, `Product`.`active`, `Product`.`date_created`, `Product`.`date_modified`, `Product`.`features`, `Product`.`specifications`, `Product`.`accessories`, `Product`.`standard_model`, `Product`.`upgrades`, `Product`.`featured`, `Product`.`featured_image`, `Product`.`order`, `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`image`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`date_created`, `ProductCategory`.`date_modified`, `ProductCategory`.`order` FROM `products` AS `Product` LEFT JOIN `product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) WHERE `Product`.`slug` = 'load-lifter-agri-lifter' LIMIT 1	1	1	0
14	SELECT `ProductImage`.`id`, `ProductImage`.`caption`, `ProductImage`.`default`, `ProductImage`.`product_id`, `ProductImage`.`order`, `ProductImage`.`image`, `ProductImage`.`date_created`, `ProductImage`.`date_modified` FROM `product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (43) ORDER BY `ProductImage`.`order` ASC	1	1	0
15	SELECT `ProductOptionGroup`.`id`, `ProductOptionGroup`.`name`, `ProductOptionGroup`.`options`, `ProductOptionGroup`.`product_id`, `ProductOptionGroup`.`order`, `ProductOptionGroup`.`date_created`, `ProductOptionGroup`.`date_modified` FROM `product_option_groups` AS `ProductOptionGroup` WHERE `ProductOptionGroup`.`product_id` IN (43) ORDER BY `ProductOptionGroup`.`order` ASC	0	0	0
16	SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`image`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`date_created`, `ProductCategory`.`date_modified`, `ProductCategory`.`order` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`slug` = 'load-lifter-agri-lifter' LIMIT 1	0	0	0
17	SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`image`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`date_created`, `ProductCategory`.`date_modified`, `ProductCategory`.`order` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 0 LIMIT 1	0	0	0
18	SELECT `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 1	0	0	0
19	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
20	SELECT `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)	1	1	0
21	SELECT `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)	35	35	0
22	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	5	5	0
23	SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`product_category_id`, `Product`.`product_brand_id`, `Product`.`active`, `Product`.`date_created`, `Product`.`date_modified`, `Product`.`features`, `Product`.`specifications`, `Product`.`accessories`, `Product`.`standard_model`, `Product`.`upgrades`, `Product`.`featured`, `Product`.`featured_image`, `Product`.`order`, `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`image`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`date_created`, `ProductCategory`.`date_modified`, `ProductCategory`.`order` FROM `products` AS `Product` LEFT JOIN `product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) WHERE `Product`.`featured` > 0 AND `Product`.`active` = 1 ORDER BY `Product`.`featured` DESC LIMIT 5	5	5	0
24	SELECT `ProductImage`.`id`, `ProductImage`.`caption`, `ProductImage`.`default`, `ProductImage`.`product_id`, `ProductImage`.`order`, `ProductImage`.`image`, `ProductImage`.`date_created`, `ProductImage`.`date_modified` FROM `product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (25, 27, 30, 28, 29) ORDER BY `ProductImage`.`order` ASC	8	8	0
25	SELECT `ProductOptionGroup`.`id`, `ProductOptionGroup`.`name`, `ProductOptionGroup`.`options`, `ProductOptionGroup`.`product_id`, `ProductOptionGroup`.`order`, `ProductOptionGroup`.`date_created`, `ProductOptionGroup`.`date_modified` FROM `product_option_groups` AS `ProductOptionGroup` WHERE `ProductOptionGroup`.`product_id` IN (25, 27, 30, 28, 29) ORDER BY `ProductOptionGroup`.`order` ASC	0	0	0
26	DESCRIBE `navigations`	8	8	1
27	DESCRIBE `navigation_sections`	21	21	1
28	DESCRIBE `groups_navigations`	3	3	2
29	DESCRIBE `pages`	9	9	0
30	DESCRIBE `page_histories`	9	9	0
31	DESCRIBE `groups_pages`	3	3	0
32	SELECT `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 1	0	0	0
33	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
34	SELECT `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)	1	1	0
35	SELECT `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)	35	35	0
36	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	5	5	0
37	SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'bottom' LIMIT 1	1	1	0
38	SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`order`, `Navigation`.`parent_id`, `Navigation`.`date_created`, `Navigation`.`date_modified` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 2 ORDER BY `Navigation`.`order` ASC	12	12	0
39	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (11, 12, 15, 14, 25, 26, 27, 28, 29, 30, 31, 32) AND `GroupsNavigation`.`group_id` = `Group`.`id`)	31	31	1

39 queries took 14 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `products`

DESCRIBE `product_categories`

DESCRIBE `product_images`

DESCRIBE `product_option_groups`

DESCRIBE `users`

DESCRIBE `groups`

DESCRIBE `accesses`

SELECT `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 1

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

SELECT `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)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`product_category_id`, `Product`.`product_brand_id`, `Product`.`active`, `Product`.`date_created`, `Product`.`date_modified`, `Product`.`features`, `Product`.`specifications`, `Product`.`accessories`, `Product`.`standard_model`, `Product`.`upgrades`, `Product`.`featured`, `Product`.`featured_image`, `Product`.`order`, `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`image`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`date_created`, `ProductCategory`.`date_modified`, `ProductCategory`.`order` FROM `products` AS `Product` LEFT JOIN `product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) WHERE `Product`.`slug` = 'load-lifter-agri-lifter' LIMIT 1

SELECT `ProductImage`.`id`, `ProductImage`.`caption`, `ProductImage`.`default`, `ProductImage`.`product_id`, `ProductImage`.`order`, `ProductImage`.`image`, `ProductImage`.`date_created`, `ProductImage`.`date_modified` FROM `product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (43) ORDER BY `ProductImage`.`order` ASC

SELECT `ProductOptionGroup`.`id`, `ProductOptionGroup`.`name`, `ProductOptionGroup`.`options`, `ProductOptionGroup`.`product_id`, `ProductOptionGroup`.`order`, `ProductOptionGroup`.`date_created`, `ProductOptionGroup`.`date_modified` FROM `product_option_groups` AS `ProductOptionGroup` WHERE `ProductOptionGroup`.`product_id` IN (43) ORDER BY `ProductOptionGroup`.`order` ASC

SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`image`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`date_created`, `ProductCategory`.`date_modified`, `ProductCategory`.`order` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`slug` = 'load-lifter-agri-lifter' LIMIT 1

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

SELECT `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)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

DESCRIBE `navigations`

DESCRIBE `navigation_sections`

DESCRIBE `groups_navigations`

DESCRIBE `pages`

DESCRIBE `page_histories`

DESCRIBE `groups_pages`

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

SELECT `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)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'bottom' LIMIT 1

SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`order`, `Navigation`.`parent_id`, `Navigation`.`date_created`, `Navigation`.`date_modified` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 2 ORDER BY `Navigation`.`order` ASC

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (11, 12, 15, 14, 25, 26, 27, 28, 29, 30, 31, 32) AND `GroupsNavigation`.`group_id` = `Group`.`id`)