begin:system.db.CDbCommand.query(SHOW COLUMNS FROM `user`)

end:system.db.CDbCommand.query(SHOW COLUMNS FROM `user`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `user`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `user`)

begin:system.db.CDbCommand.query(SELECT * FROM `user` `t` WHERE
`t`.`user_id` IS NULL LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `user` `t` WHERE `t`.`user_id`
IS NULL LIMIT 1)

begin:system.db.CDbCommand.query(SELECT COUNT(`b`.`business_id`)
                            FROM `business`  `b`
                            LEFT JOIN `user` `u`   ON `u`.`user_id` =
`b`.`user_owner_id`
                             WHERE `b`.`status` = 'approved' AND
`u`.`payment_status` <> 'pending')

end:system.db.CDbCommand.query(SELECT COUNT(`b`.`business_id`)
                            FROM `business`  `b`
                            LEFT JOIN `user` `u`   ON `u`.`user_id` =
`b`.`user_owner_id`
                             WHERE `b`.`status` = 'approved' AND
`u`.`payment_status` <> 'pending')

begin:system.db.CDbCommand.query(SELECT `b`.`business_id`, `b`.`title`,
`b`.`gooddeal`, `b`.`gooddeal_desc`, `b`.`category_id`,
`b`.`google_city_id`, `b`.`google_county_id`, `b`.`description`,
`b`.`address`, `b`.`phone`,
                                  `gct`.`county_name` as
`google_county_name`,
                                  `gc`.`city_name` as `google_city_name`,
                                  `gr`.`region_name` as
`google_region_name`,
                                  `gr`.`region_code` as
`google_region_code`,
                                  `gcn`.`country_name` as
`google_country_name`
                           FROM `business` `b`
    		               LEFT JOIN `google_city`     `gc`  ON `gc`.`city_id` =
`b`.`google_city_id`
    		               LEFT JOIN `google_county`   `gct` ON `gct`.`county_id`
= `b`.`google_county_id`
    		               LEFT JOIN `google_region`   `gr`  ON `gr`.`region_id`
= `b`.`google_region_id`
    		               LEFT JOIN `google_country`  `gcn` ON
`gcn`.`country_id` = `b`.`google_country_id`
    		               LEFT JOIN `user`           `u`   ON `u`.`user_id` =
`b`.`user_owner_id`

                            WHERE `b`.`status` = 'approved' AND
`u`.`payment_status` <> 'pending' )

end:system.db.CDbCommand.query(SELECT `b`.`business_id`, `b`.`title`,
`b`.`gooddeal`, `b`.`gooddeal_desc`, `b`.`category_id`,
`b`.`google_city_id`, `b`.`google_county_id`, `b`.`description`,
`b`.`address`, `b`.`phone`,
                                  `gct`.`county_name` as
`google_county_name`,
                                  `gc`.`city_name` as `google_city_name`,
                                  `gr`.`region_name` as
`google_region_name`,
                                  `gr`.`region_code` as
`google_region_code`,
                                  `gcn`.`country_name` as
`google_country_name`
                           FROM `business` `b`
    		               LEFT JOIN `google_city`     `gc`  ON `gc`.`city_id` =
`b`.`google_city_id`
    		               LEFT JOIN `google_county`   `gct` ON `gct`.`county_id`
= `b`.`google_county_id`
    		               LEFT JOIN `google_region`   `gr`  ON `gr`.`region_id`
= `b`.`google_region_id`
    		               LEFT JOIN `google_country`  `gcn` ON
`gcn`.`country_id` = `b`.`google_country_id`
    		               LEFT JOIN `user`           `u`   ON `u`.`user_id` =
`b`.`user_owner_id`

                            WHERE `b`.`status` = 'approved' AND
`u`.`payment_status` <> 'pending' )

begin:system.db.CDbCommand.query(SHOW COLUMNS FROM `business`)

end:system.db.CDbCommand.query(SHOW COLUMNS FROM `business`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `business`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `business`)

begin:system.db.CDbCommand.query(SELECT * FROM `business` `t` WHERE
`t`.`business_id`=43 LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `business` `t` WHERE
`t`.`business_id`=43 LIMIT 1)

begin:system.db.CDbCommand.query(SELECT `b`.`zip`, `b`.`address`,
`b`.`lat`, `b`.`lon`,`b`.`gooddeal`, `b`.`gooddeal_desc`,
                   `gct`.`county_name`,
                   `gc`.`city_name` as `google_city_name`,
                   `gr`.`region_name` as `google_region_name`,
                   `gr`.`region_code`,
                   `gcn`.`country_name` as `google_country_name`
                FROM `business` b
                LEFT JOIN `google_county`   `gct` ON `gct`.`county_id` =
`b`.`google_county_id`
                LEFT JOIN `google_city`     `gc`  ON `gc`.`city_id` =
`b`.`google_city_id`
                LEFT JOIN `google_region`   `gr`  ON `gr`.`region_id` =
`b`.`google_region_id`
                LEFT JOIN `google_country`  `gcn` ON `gcn`.`country_id` =
`b`.`google_country_id`
                WHERE `b`.`business_id` = '43')

end:system.db.CDbCommand.query(SELECT `b`.`zip`, `b`.`address`, `b`.`lat`,
`b`.`lon`,`b`.`gooddeal`, `b`.`gooddeal_desc`,
                   `gct`.`county_name`,
                   `gc`.`city_name` as `google_city_name`,
                   `gr`.`region_name` as `google_region_name`,
                   `gr`.`region_code`,
                   `gcn`.`country_name` as `google_country_name`
                FROM `business` b
                LEFT JOIN `google_county`   `gct` ON `gct`.`county_id` =
`b`.`google_county_id`
                LEFT JOIN `google_city`     `gc`  ON `gc`.`city_id` =
`b`.`google_city_id`
                LEFT JOIN `google_region`   `gr`  ON `gr`.`region_id` =
`b`.`google_region_id`
                LEFT JOIN `google_country`  `gcn` ON `gcn`.`country_id` =
`b`.`google_country_id`
                WHERE `b`.`business_id` = '43')

begin:system.db.CDbCommand.query(SELECT `b`.`zip`, `b`.`address`,
`b`.`lat`, `b`.`lon`,`b`.`gooddeal`, `b`.`gooddeal_desc`,
                   `gct`.`county_name`,
                   `gc`.`city_name` as `google_city_name`,
                   `gr`.`region_name` as `google_region_name`,
                   `gr`.`region_code`,
                   `gcn`.`country_name` as `google_country_name`
                FROM `business` b
                LEFT JOIN `google_county`   `gct` ON `gct`.`county_id` =
`b`.`google_county_id`
                LEFT JOIN `google_city`     `gc`  ON `gc`.`city_id` =
`b`.`google_city_id`
                LEFT JOIN `google_region`   `gr`  ON `gr`.`region_id` =
`b`.`google_region_id`
                LEFT JOIN `google_country`  `gcn` ON `gcn`.`country_id` =
`b`.`google_country_id`
                WHERE `b`.`business_id` = '9')

end:system.db.CDbCommand.query(SELECT `b`.`zip`, `b`.`address`, `b`.`lat`,
`b`.`lon`,`b`.`gooddeal`, `b`.`gooddeal_desc`,
                   `gct`.`county_name`,
                   `gc`.`city_name` as `google_city_name`,
                   `gr`.`region_name` as `google_region_name`,
                   `gr`.`region_code`,
                   `gcn`.`country_name` as `google_country_name`
                FROM `business` b
                LEFT JOIN `google_county`   `gct` ON `gct`.`county_id` =
`b`.`google_county_id`
                LEFT JOIN `google_city`     `gc`  ON `gc`.`city_id` =
`b`.`google_city_id`
                LEFT JOIN `google_region`   `gr`  ON `gr`.`region_id` =
`b`.`google_region_id`
                LEFT JOIN `google_country`  `gcn` ON `gcn`.`country_id` =
`b`.`google_country_id`
                WHERE `b`.`business_id` = '9')

begin:system.db.CDbCommand.query(SELECT `file_id`, `business_id`
    		        FROM `business_file`
    		        WHERE `business_id` IN
(43,33,29,37,9,18,24,28,5,10,48,46,20,31,36,40,26,54,19,30,23,44,13,45,8,39,57,22,17,11,42,15,25,16,47,34,6,41,53,61,52,60,49,14,7,35,56,38,21)
AND `file_type` = 'image')

end:system.db.CDbCommand.query(SELECT `file_id`, `business_id`
    		        FROM `business_file`
    		        WHERE `business_id` IN
(43,33,29,37,9,18,24,28,5,10,48,46,20,31,36,40,26,54,19,30,23,44,13,45,8,39,57,22,17,11,42,15,25,16,47,34,6,41,53,61,52,60,49,14,7,35,56,38,21)
AND `file_type` = 'image')

begin:system.db.CDbCommand.query(SELECT `c_s`.`category_id` AS
`selected_category`, c.*
                    FROM `category` c
                    LEFT JOIN `category` c_s ON ( `c`.`root_category_id` =
`c_s`.`root_category_id` AND `c`.`left_id` <= `c_s`.`left_id` AND
`c`.`right_id` >= `c_s`.`right_id`)
                    WHERE `c_s`.`category_id` IN
(61,26,201,63,200,25,55,14,11,169,88,92,18,62,15,144,218,179,46,210,206,27,21,208,156,1,126,123,151,51,20,221,16,214,91,19,44,28)
                    ORDER BY `c`.`root_category_id`, `c`.`left_id`)

end:system.db.CDbCommand.query(SELECT `c_s`.`category_id` AS
`selected_category`, c.*
                    FROM `category` c
                    LEFT JOIN `category` c_s ON ( `c`.`root_category_id` =
`c_s`.`root_category_id` AND `c`.`left_id` <= `c_s`.`left_id` AND
`c`.`right_id` >= `c_s`.`right_id`)
                    WHERE `c_s`.`category_id` IN
(61,26,201,63,200,25,55,14,11,169,88,92,18,62,15,144,218,179,46,210,206,27,21,208,156,1,126,123,151,51,20,221,16,214,91,19,44,28)
                    ORDER BY `c`.`root_category_id`, `c`.`left_id`)

begin:system.db.CDbCommand.query(SELECT `business_id`, `rate`
		        FROM `business_review`
		        WHERE `business_id` IN
(43,33,29,37,9,18,24,28,5,10,48,46,20,31,36,40,26,54,19,30,23,44,13,45,8,39,57,22,17,11,42,15,25,16,47,34,6,41,53,61,52,60,49,14,7,35,56,38,21)
AND `is_last` = 1)

end:system.db.CDbCommand.query(SELECT `business_id`, `rate`
		        FROM `business_review`
		        WHERE `business_id` IN
(43,33,29,37,9,18,24,28,5,10,48,46,20,31,36,40,26,54,19,30,23,44,13,45,8,39,57,22,17,11,42,15,25,16,47,34,6,41,53,61,52,60,49,14,7,35,56,38,21)
AND `is_last` = 1)

begin:system.db.CDbCommand.query(SELECT `c_s`.`category_id` AS
`selected_category`, c.*
                    FROM `category` c
                    LEFT JOIN `category` c_s ON ( `c`.`root_category_id` =
`c_s`.`root_category_id` AND `c`.`left_id` <= `c_s`.`left_id` AND
`c`.`right_id` >= `c_s`.`right_id`)
                    WHERE `c_s`.`category_id` IN (61)
                    ORDER BY `c`.`root_category_id`, `c`.`left_id`)

end:system.db.CDbCommand.query(SELECT `c_s`.`category_id` AS
`selected_category`, c.*
                    FROM `category` c
                    LEFT JOIN `category` c_s ON ( `c`.`root_category_id` =
`c_s`.`root_category_id` AND `c`.`left_id` <= `c_s`.`left_id` AND
`c`.`right_id` >= `c_s`.`right_id`)
                    WHERE `c_s`.`category_id` IN (61)
                    ORDER BY `c`.`root_category_id`, `c`.`left_id`)

begin:system.db.CDbCommand.query(SELECT `category_id`,
`category_filter_id`, `name`
                FROM `category_filter`
                WHERE `category_id` IN (61)
                 AND `position` = '0' 
                ORDER BY `category_id`, `name`)

end:system.db.CDbCommand.query(SELECT `category_id`, `category_filter_id`,
`name`
                FROM `category_filter`
                WHERE `category_id` IN (61)
                 AND `position` = '0' 
                ORDER BY `category_id`, `name`)

begin:system.db.CDbCommand.query(SELECT `category_id`,
`category_filter_id`, `name`
                FROM `category_filter`
                WHERE `category_id` IN (61)
                 AND `position` = '1' 
                ORDER BY `category_id`, `name`)

end:system.db.CDbCommand.query(SELECT `category_id`, `category_filter_id`,
`name`
                FROM `category_filter`
                WHERE `category_id` IN (61)
                 AND `position` = '1' 
                ORDER BY `category_id`, `name`)

begin:system.db.CDbCommand.query(SELECT c.*
                FROM `category` c
                LEFT JOIN `category` c_s ON ( `c`.`root_category_id` =
`c_s`.`root_category_id` AND `c`.`left_id` <= `c_s`.`left_id` AND
`c`.`right_id` >= `c_s`.`right_id`)
                WHERE `c_s`.`category_id` = '61'
                ORDER BY `c`.`left_id` DESC)

end:system.db.CDbCommand.query(SELECT c.*
                FROM `category` c
                LEFT JOIN `category` c_s ON ( `c`.`root_category_id` =
`c_s`.`root_category_id` AND `c`.`left_id` <= `c_s`.`left_id` AND
`c`.`right_id` >= `c_s`.`right_id`)
                WHERE `c_s`.`category_id` = '61'
                ORDER BY `c`.`left_id` DESC)

begin:system.db.CDbCommand.query(SELECT category_id, name
                        FROM `category`
                        WHERE `category_id` IN (46,21,201))

end:system.db.CDbCommand.query(SELECT category_id, name
                        FROM `category`
                        WHERE `category_id` IN (46,21,201))

begin:system.db.CDbCommand.query(SHOW COLUMNS FROM `category`)

end:system.db.CDbCommand.query(SHOW COLUMNS FROM `category`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `category`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `category`)

begin:system.db.CDbCommand.query(SELECT * FROM `category` `t` WHERE
`t`.`category_id`=61 LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `category` `t` WHERE
`t`.`category_id`=61 LIMIT 1)