Skip to

  1. navigation
  2. content
www
us
SELECT `blog-templates`.`language` AS postLanguage, COALESCE(`blog-urls`.`url`, `blog-posts`.`url`) AS postUrl, `blog-posts`.`title` AS postTitle, `blog-posts`.`subtitle` AS postSubtitle, `blog-posts`.`styles` AS postStyles, `blog-posts`.`landing-page` AS postLandingPage, `blog-posts`.`test-landing-page` AS postTestLandingPage, `blog-posts`.`posted_on` AS postPostedOn, `blog-templates`.`id` AS templateId, `blog-templates`.`postId` AS postId, `blog-templates`.`linked-post` AS templateLinkedPost, `linked-post`.`url` AS templateLinkedPost, if(`linked-post`.`url` IS NOT NULL,`linked-post`.`url`,`blog-templates`.`linked-url` ) AS templateLinkedPost, 'bezels' AS template, `blog-templates`.`title` AS templateTitle, `blog-templates`.`subtitle` AS templateSubtitle, `blog-templates`.`order` AS templateOrder, `blog-bezels`.`id` AS bezelsId,`blog-bezels`.`language` AS bezelsLanguage,`blog-bezels`.`title` AS bezelsTitle,`blog-bezels`.`legend` AS bezelsLegend,`blog-bezels`.`footer` AS bezelsFooter,`blog-bezels`.`button-url` AS bezelsButtonUrl,`blog-bezels`.`button-label` AS bezelsButtonLabel,`blog-bezels`.`classes` AS bezelsClasses,`blog-bezels`.`padding` AS bezelsPadding,`blog-bezels`.`updated_on` AS bezelsUpdatedOn,`blog-bezels`.`created_on` AS bezelsCreatedOn FROM `blog-bezels` LEFT JOIN `blog-templates` ON `blog-templates`.`id` = `blog-bezels`.`templateId` LEFT JOIN `blog-posts` ON `blog-templates`.`postId` = `blog-posts`.`id` LEFT JOIN `blog-posts` AS `linked-post` ON `blog-templates`.`linked-post` = `linked-post`.`id` LEFT JOIN `blog-urls` ON (`blog-urls`.`postId` = `blog-posts`.`id` AND `blog-urls`.`language` = `blog-templates`.`language` AND `blog-urls`.`url` = '/blog/') WHERE (`blog-urls`.`url` = '/blog/' OR `blog-posts`.`url` = '/blog/') AND `blog-posts`.`deleted` != '1' AND `blog-templates`.`deleted` != '1' AND `blog-posts`.`published` = 1 AND `blog-templates`.`published` = 1 AND `blog-templates`.`language` = 'en' ORDER BY -`blog-templates`.`order` DESC, -`blog-bezels`.`order` DESC
SELECT `blog-templates`.`language` AS postLanguage, COALESCE(`blog-urls`.`url`, `blog-posts`.`url`) AS postUrl, `blog-posts`.`title` AS postTitle, `blog-posts`.`subtitle` AS postSubtitle, `blog-posts`.`styles` AS postStyles, `blog-posts`.`landing-page` AS postLandingPage, `blog-posts`.`test-landing-page` AS postTestLandingPage, `blog-posts`.`posted_on` AS postPostedOn, `blog-templates`.`id` AS templateId, `blog-templates`.`postId` AS postId, `blog-templates`.`linked-post` AS templateLinkedPost, `linked-post`.`url` AS templateLinkedPost, if(`linked-post`.`url` IS NOT NULL,`linked-post`.`url`,`blog-templates`.`linked-url` ) AS templateLinkedPost, 'bezels' AS template, `blog-templates`.`title` AS templateTitle, `blog-templates`.`subtitle` AS templateSubtitle, `blog-templates`.`order` AS templateOrder, `blog-bezels`.`id` AS bezelsId,`blog-bezels`.`language` AS bezelsLanguage,`blog-bezels`.`title` AS bezelsTitle,`blog-bezels`.`legend` AS bezelsLegend,`blog-bezels`.`footer` AS bezelsFooter,`blog-bezels`.`button-url` AS bezelsButtonUrl,`blog-bezels`.`button-label` AS bezelsButtonLabel,`blog-bezels`.`classes` AS bezelsClasses,`blog-bezels`.`padding` AS bezelsPadding,`blog-bezels`.`updated_on` AS bezelsUpdatedOn,`blog-bezels`.`created_on` AS bezelsCreatedOn FROM `blog-bezels` LEFT JOIN `blog-templates` ON `blog-templates`.`id` = `blog-bezels`.`templateId` LEFT JOIN `blog-posts` ON `blog-templates`.`postId` = `blog-posts`.`id` LEFT JOIN `blog-posts` AS `linked-post` ON `blog-templates`.`linked-post` = `linked-post`.`id` LEFT JOIN `blog-urls` ON (`blog-urls`.`postId` = `blog-posts`.`id` AND `blog-urls`.`language` = `blog-templates`.`language` AND `blog-urls`.`url` = '/blog/') WHERE (`blog-urls`.`url` = '/blog/' OR `blog-posts`.`url` = '/blog/') AND `blog-posts`.`deleted` != '1' AND `blog-templates`.`deleted` != '1' AND `blog-posts`.`published` = 1 AND `blog-templates`.`published` = 1 AND `blog-templates`.`language` = 'en' ORDER BY -`blog-templates`.`order` DESC, -`blog-bezels`.`order` DESC

Meet High Jump Superstar Isobel Pooley

The LTS Ambassador and British high jump record holder on growing up tall, destroying the competition and dating...

Read more

15 Things Only A True Shoeaholic Will Understand

Addiction is an understatement

Read more

168K INSTAGRAM FOLLOWERS IN ONE YEAR

It's all in a day's work for Emma

Read more

You Be The Stylist

How would YOU style these four summer staples?

Read more

8 times Gwendoline Christie wowed us

We can’t get enough of the 6’3” Game Of Thrones star

READ MORE

Advantage Tall

Wimbledon women to watch

Read more

A-list blogger's on their must-buy sale pieces

To resist is to regret; 7 pieces your wardrobe needs now

Read more

My Personal Journey To Loving My Curves

6'4" Bree talks body confidence

REad more

ONE DRESS THREE BLOGGERS

Three fashion bloggers on how to wear the Shimmer Dress

See the looks

Get the Celebrity Look: Summer '16

Steal these celebrity summer looks

READ MORE

PICK UP LINES THAT WON'T WORK ON TALL GIRLS

How many of these have you heard before?

Read now

Making Peace With My Big Feet

Lauren's journey to accepting her size 12 feet

Read more

ADVICE TO MY TEENAGE SELF

We asked our Facebook friends what advice they’d give their former selves.

READ MORE

Four Essential Steps To Perfect Summer Skin

Elkie, our A/W shoot makeup artist, tells all.

READ MORE

Archive