"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`='142') 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
142 sitemap-locate test_locate <p style="margin: 5px;"><span style="color: #000000;"><strong>LOCATE</strong></span></p> <p style="margin: 5px;"><span style="color: #000000;">SHOP</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/locate/shop/boutiques.html" target="_self">Boutiques</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/locate/shop/partners.html" target="_self">partners</a></p> <p style="margin: 5px;">&nbsp;</p> <p style="margin: 5px;"><span style="color: #000000;">CONTACT</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/locate/contact/enquiry.html" target="_self">Enquiries</a></p> <p style="margin: 5px;"><span style="color: #000000;">&nbsp;</span></p> 2018-04-16 04:17:29 2018-04-16 05:04:18 1 0