Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`first_letter`, `Article`.`short_title`, `Article`.`snazzy_title`, `Article`.`country_id`, `Article`.`live_date`, `Article`.`featured_date`, `Article`.`hide_date`, `Article`.`no_autolink`, `Article`.`suggested_by`, `Article`.`int_title`, `Article`.`channel_id`, `Article`.`editor1_id`, `Article`.`editor2_id`, `Article`.`author_id`, `Article`.`code`, `Article`.`blurb`, `Article`.`small_image_url`, `Article`.`small_image_credit`, `Article`.`edit1`, `Article`.`edit2`, `Article`.`completed`, `Article`.`created`, `Article`.`modified`, `Article`.`exported`, `Article`.`is_fine_living`, `Article`.`is_advertorial`, `Article`.`not_owned`, `Article`.`filename`, `Article`.`type_of`, `Article`.`object_type_id`, `Article`.`object_name`, `Article`.`no_product`, `Article`.`ref_id`, `Article`.`source`, `Article`.`is_commercial`, `Article`.`render_template`, `Article`.`status`, `Channel`.`id`, `Channel`.`name`, `Channel`.`name_bc`, `Channel`.`root`, `Channel`.`parent_id`, `Channel`.`color`, `Channel`.`article_extension`, `Channel`.`template_id`, `Channel`.`pindex`, `Channel`.`image_url`, `Channel`.`image_credit`, `Channel`.`blurb`, `Channel`.`country_id`, `FirstEditor`.`id`, `FirstEditor`.`name`, `FirstEditor`.`location`, `FirstEditor`.`email`, `FirstEditor`.`is_active`, `FirstEditor`.`ap_default_editor_1`, `FirstEditor`.`ap_default_editor_2`, `FirstEditor`.`ap_default_country`, `SecondEditor`.`id`, `SecondEditor`.`name`, `SecondEditor`.`location`, `SecondEditor`.`email`, `SecondEditor`.`is_active`, `SecondEditor`.`ap_default_editor_1`, `SecondEditor`.`ap_default_editor_2`, `SecondEditor`.`ap_default_country`, `Author`.`id`, `Author`.`name`, `Author`.`title`, `Author`.`alias`, `Author`.`website_url`, `Author`.`website_name`, `Author`.`writes_on`, `Author`.`recurrence`, `Author`.`ap_default_author`, `Author`.`ap_default_country`, `SquareThumb`.`id`, `SquareThumb`.`image_url`, `SquareThumb`.`credit`, `SquareThumb`.`article_id`, `SquareThumb`.`pindex`, `SquareThumb`.`content`, `SquareThumb`.`mime_type`, `SquareThumb`.`type_of` FROM `articles` AS `Article` LEFT JOIN `channels` AS `Channel` ON `Article`.`channel_id` = `Channel`.`id` LEFT JOIN `editors` AS `FirstEditor` ON `Article`.`editor1_id` = `FirstEditor`.`id` LEFT JOIN `editors` AS `SecondEditor` ON `Article`.`editor2_id` = `SecondEditor`.`id` LEFT JOIN `authors` AS `Author` ON `Article`.`author_id` = `Author`.`id` LEFT JOIN `article_images` AS `SquareThumb` ON (SquareThumb.type_of = "square_thumb" AND `SquareThumb`.`article_id` = `Article`.`id`) WHERE ( live_date <= "2010-02-07") AND (`status` IN ('', 'live') ) AND (`Article`.`type_of` = 'ap') AND ( live_date >= "2010-02-05") AND ( FIND_IN_SET('uk', Article.country_id)) ORDER BY `Article`.`live_date` desc, `Article`.`id` desc LIMIT 4 | 0 | 0 | 5 | |
2 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`first_letter`, `Article`.`short_title`, `Article`.`snazzy_title`, `Article`.`country_id`, `Article`.`live_date`, `Article`.`featured_date`, `Article`.`hide_date`, `Article`.`no_autolink`, `Article`.`suggested_by`, `Article`.`int_title`, `Article`.`channel_id`, `Article`.`editor1_id`, `Article`.`editor2_id`, `Article`.`author_id`, `Article`.`code`, `Article`.`blurb`, `Article`.`small_image_url`, `Article`.`small_image_credit`, `Article`.`edit1`, `Article`.`edit2`, `Article`.`completed`, `Article`.`created`, `Article`.`modified`, `Article`.`exported`, `Article`.`is_fine_living`, `Article`.`is_advertorial`, `Article`.`not_owned`, `Article`.`filename`, `Article`.`type_of`, `Article`.`object_type_id`, `Article`.`object_name`, `Article`.`no_product`, `Article`.`ref_id`, `Article`.`source`, `Article`.`is_commercial`, `Article`.`render_template`, `Article`.`status` FROM `articles` AS `Article` WHERE ( live_date <= "2010-02-07") AND (`status` IN ('', 'live') ) AND (`Article`.`type_of` = 'gossip') AND ( FIND_IN_SET('uk', Article.country_id)) ORDER BY `Article`.`live_date` desc, `Article`.`id` desc LIMIT 15 | 15 | 15 | 132 |
Proving that funny pictures are worth a thousand words.
Paddy was in New York. He was patiently waiting and watching the traffic cop on a busy street crossing. The cop stopped the flow of traffic and shouted: “OK, pedestrians.” Then...
The Renaultsport Clio 200 Cup places performance and sheer driving pleasure over visual impac.
Strengthening your ab muscles is a crucial step in preventing back pain from recurring.
Ground rules are crucial for having threesomes. Your rules might be different from hers, so talk about it first.
Why stick with one major search engine when you can use both?
Two inebriated Irishmen are sitting at the bar, and on the side of the bar is a huge mirror. Murphy looks over and says: "Don’t look now, Patrick, but the chap sitting over there looks...
To lose those extra five pounds that have been dogging you, try switching up your rep cycles.
Here's a condom tip: Always take it off immediately after use. And dispose of it right away so she won't have to see it later.
Find great independent fashion at this easy-to-navigate online shop.
You don't have to leave the UK for a unique dating experience that she'll love you for.
A little boy wanted $100 badly and prayed for two weeks, but nothing happened. Then he decided to write God a letter requesting $100. When the postal authorities received the letter...
The Duracell myGrid Charging Pad is here to make your life just a tad easier.
Using an exercise ball will help you hone in on lesser-worked ab muscles.
Why will you find a film about an illiterate prison inmate essential viewing?
Even if you don’t want to be a “leader,” it’s still worth studying how to do it.
If you're headed for a one-night stand, do both of you a favor and go back to her place. You haven't cleaned your bathroom, and she doesn't want to see that.
If you've been dying to whisper nasty nothings in her ear but have been biting your tongue, we'll ease you into it step by step.
BBC Radio 5 live will be the official broadcaster at the most sexually safe sports tournament of all time.
She's a liar and a cheater. Hmm...what two worse qualities could you ask for in any woman?
Read the writing on the walls - literally.
Wearing pink isn't the only thing a truly confident man can get away with.
Raymond was puzzled that Jim was so nonchalant after he saw his girlfriend with another man. "You love her, saw her with another man and you didn't knock the guy down?" "I'm...
Is your daily grooming routine making you prematurely bald?
"Whatever doesn't kill you leaves you susceptible to a secondary infection. " - David Duchovny
The odds a high school football player will make the NFL and eventually win a Super Bowl: 1 in 8,089. The odds an NFL player will ever win a Super Bowl: 1 in 8.
How do you handle a boring girlfriend? Try taking your clothes off, suggests Leslie Nielsen.
You don't need to leave the UK for a unique dating experience that she'll love you for.
Join the IGN webathon and check updates for how you can help.
Indonesian supporter takes matters into his own hands.
Which beast would you most like to take to the boozer?