"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`='138') 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
138 sitemap-furniture test_furniture <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture.html" target="_self"><strong>FURNITURE</strong>&nbsp;</a></p> <p style="margin: 5px;"><span style="color: #000000;">BY ROOM</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/by-room/salon.html" target="_self">Salon</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/by-room/dining-room.html" target="_self">Dining Room</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/by-room/bedroom.html" target="_self">Bedroom</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/by-room/bedroom.html" target="_self">Library</a></p> <p style="margin: 5px;"><span style="color: #000000;">&nbsp;</span></p> <p style="margin: 5px;"><span style="color: #000000;">BY CATEGORY</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/sofas.html" target="_self">Sofas</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/chairs.html" target="_self">Chairs</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/benches.html" target="_self">Benches</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/ottomans.html" target="_self">Ottomans</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/screens.html" target="_self">Screens</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/tables.html" target="_self">Tables</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/casegoods.html" target="_self">Casegoods</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/bedside-tables.html" target="_self">Bedside Tables</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/headbroads.html" target="_self">Headbords</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/furniture/furniture-by-category/wardrobe.html" target="_self">Wardrobe</a></p> <br> 2018-04-13 03:50:08 2018-04-17 02:35:52 1 0