"Back"

SQL Select

Executed SQL
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`='139') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
block_id title identifier content creation_time update_time is_active store_id
139 sitemap-HOME_DÉCOR test_home_decor <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor.html" target="_self"><strong>HOME DECOR</strong>&nbsp;</a></p> <p style="margin: 5px;"><span style="color: #000000;">OBJECTS</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/boxes.html" target="_self">Boxes</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/decorative-objects.html" target="_self">Decorative Objects</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/candle-holders.html" target="_self">Candle Holders</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/trays.html" target="_self">Trays</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/tabletop.html" target="_self">Tabletop</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/picture-frames.html" target="_self">Picture Frames</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/vanity.html" target="_self">Vanity</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/objects/vases.html" target="_self">Vases</a></p> <p style="margin: 5px;"><span style="color: #000000;">&nbsp;</span></p> <p style="margin: 5px;"><span style="color: #000000;">WALL DECOR</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/wall-decor/mirrors.html" target="_self">Mirrors</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/wall-decor/wall-decor.html" target="_self">Wall Decor</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/wall-decor/wall-paper.html" target="_self">Wall paper</a></p> <p style="margin: 5px;">&nbsp;</p> <p style="margin: 5px;"><span style="color: #000000;">SOFTGOODS</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/softgoods/beddings.html" target="_self">Beddings</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/softgoods/pillows.html" target="_self">Pillows</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/softgoods/throws.html" target="_self">Throws</a></p> <p style="margin: 5px;">&nbsp;</p> <p style="margin: 5px;"><span style="color: #000000;">LIGHTING</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/lighting/chandeliers.html" target="_self">Chandeliers</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/lighting/table-lamps.html" target="_self">Table Lamps</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/lighting/wall-sconces.html" target="_self">Wall Sconces</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/home-decor/lighting/floor-lamps.html" target="_self">Floor Lamps</a></p> <p style="margin: 5px;">&nbsp;</p> 2018-04-16 02:28:02 2018-04-17 02:49:14 1 0