| 1 | SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`title`, `Contest`.`url`, `Contest`.`active`, `Contest`.`body_upper`, `Contest`.`body`, `Contest`.`awards`, `Contest`.`banner_id`, `Contest`.`image_id`, `Contest`.`link`, `Contest`.`start`, `Contest`.`end`, `Contest`.`lft`, `Contest`.`rght`, `Contest`.`parent_id`, `Contest`.`keywords`, `Contest`.`description`, `Contest`.`created`, `Contest`.`modified` FROM `properad_test`.`contests` AS `Contest` WHERE ((NOT (`Contest`.`active` = '0')) AND (YEAR(`Contest`.`end`) >= 'YEAR(NOW)')) ORDER BY `Contest`.`start` DESC | | 3 | 3 | 0 |
| 2 | SELECT `ContestPartner`.`id`, `ContestPartner`.`contest_id`, `ContestPartner`.`partner_id`, `ContestPartner`.`lft`, `ContestPartner`.`rght`, `ContestPartner`.`parent_id` FROM `properad_test`.`contest_partners` AS `ContestPartner` WHERE `ContestPartner`.`contest_id` IN (6, 4, 5) | | 2 | 2 | 0 |
| 3 | SELECT `Partner`.`id`, `Partner`.`type`, `Partner`.`name`, `Partner`.`name_premium`, `Partner`.`symbol`, `Partner`.`body`, `Partner`.`summary`, `Partner`.`image`, `Partner`.`image_premium`, `Partner`.`show_logo_front`, `Partner`.`order_logo_front`, `Partner`.`register_url`, `Partner`.`login_url`, `Partner`.`payment_threshold`, `Partner`.`pluses`, `Partner`.`minuses`, `Partner`.`campaign_count`, `Partner`.`user_rates_count`, `Partner`.`avg_rate`, `Partner`.`avg_commission_settlement`, `Partner`.`avg_commission_amount`, `Partner`.`avg_tracking_capabilities`, `Partner`.`avg_campaign_amount`, `Partner`.`avg_new_campaign_frequency`, `Partner`.`avg_customer_service`, `Partner`.`avg_publisher_panel`, `Partner`.`avg_registration`, `Partner`.`show_register`, `Partner`.`show_landing`, `Partner`.`recommended`, `Partner`.`month`, `Partner`.`show_contact`, `Partner`.`company_data`, `Partner`.`contact_data`, `Partner`.`campaign_rate`, `Partner`.`premium`, `Partner`.`is_premium_in_ranking`, `Partner`.`premium_ranking_spot`, `Partner`.`lft`, `Partner`.`rght`, `Partner`.`parent_id`, `Partner`.`created`, `Partner`.`modified`, `Partner`.`visibility` FROM `properad_test`.`partners` AS `Partner` WHERE `Partner`.`id` = 34 ORDER BY `Partner`.`lft` ASC | | 1 | 1 | 1 |
| 4 | SELECT `Partner`.`id`, `Partner`.`type`, `Partner`.`name`, `Partner`.`name_premium`, `Partner`.`symbol`, `Partner`.`body`, `Partner`.`summary`, `Partner`.`image`, `Partner`.`image_premium`, `Partner`.`show_logo_front`, `Partner`.`order_logo_front`, `Partner`.`register_url`, `Partner`.`login_url`, `Partner`.`payment_threshold`, `Partner`.`pluses`, `Partner`.`minuses`, `Partner`.`campaign_count`, `Partner`.`user_rates_count`, `Partner`.`avg_rate`, `Partner`.`avg_commission_settlement`, `Partner`.`avg_commission_amount`, `Partner`.`avg_tracking_capabilities`, `Partner`.`avg_campaign_amount`, `Partner`.`avg_new_campaign_frequency`, `Partner`.`avg_customer_service`, `Partner`.`avg_publisher_panel`, `Partner`.`avg_registration`, `Partner`.`show_register`, `Partner`.`show_landing`, `Partner`.`recommended`, `Partner`.`month`, `Partner`.`show_contact`, `Partner`.`company_data`, `Partner`.`contact_data`, `Partner`.`campaign_rate`, `Partner`.`premium`, `Partner`.`is_premium_in_ranking`, `Partner`.`premium_ranking_spot`, `Partner`.`lft`, `Partner`.`rght`, `Partner`.`parent_id`, `Partner`.`created`, `Partner`.`modified`, `Partner`.`visibility` FROM `properad_test`.`partners` AS `Partner` WHERE `Partner`.`id` = 13 ORDER BY `Partner`.`lft` ASC | | 1 | 1 | 0 |
| 5 | SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`body`, `Banner`.`url`, `Banner`.`name`, `Banner`.`alt`, `Banner`.`active`, `Banner`.`active_contests`, `Banner`.`active_events`, `Banner`.`active_articles`, `Banner`.`target`, `Banner`.`form`, `Banner`.`lft`, `Banner`.`rght`, `Banner`.`parent_id`, `Banner`.`lp_id`, `Banner`.`created`, `Banner`.`modified` FROM `properad_test`.`banners` AS `Banner` WHERE `Banner`.`active_contests` = '1' ORDER BY `lft` ASC, `id` DESC | | 0 | 0 | 0 |
| 6 | SELECT `Ad`.`id`, `Ad`.`parent_id`, `Ad`.`lft`, `Ad`.`rght`, `Ad`.`title`, `Ad`.`body`, `Ad`.`position`, `Ad`.`width`, `Ad`.`height`, `Ad`.`order`, `Ad`.`active`, `Ad`.`created`, `Ad`.`modified` FROM `properad_test`.`ads` AS `Ad` WHERE `Ad`.`position` = 'front_home_top' AND `Ad`.`active` = 1 | | 2 | 2 | 0 |
.jpg)
