| 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`, `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`, `Image`.`id`, `Image`.`title`, `Image`.`body`, `Image`.`url`, `Image`.`name`, `Image`.`alt`, `Image`.`active`, `Image`.`active_contests`, `Image`.`active_events`, `Image`.`active_articles`, `Image`.`target`, `Image`.`form`, `Image`.`lft`, `Image`.`rght`, `Image`.`parent_id`, `Image`.`lp_id`, `Image`.`created`, `Image`.`modified` FROM `properad_test`.`contests` AS `Contest` LEFT JOIN `properad_test`.`banners` AS `Banner` ON (`Contest`.`banner_id` = `Banner`.`id`) LEFT JOIN `properad_test`.`banners` AS `Image` ON (`Contest`.`image_id` = `Image`.`id`) WHERE `Contest`.`id` = 6 LIMIT 1 | | 1 | 1 | 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` = (6) | | 0 | 0 | 0 |
| 3 | 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`.`id` IS NULL ORDER BY `lft` ASC, `id` DESC | | 0 | 0 | 0 |
| 4 | 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`.`id` IS NULL ORDER BY `lft` ASC, `id` DESC | | 0 | 0 | 0 |
| 5 | 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 | 1 |
.jpg)
porównywarka sieci afiliacyjnych