"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`='141') 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
141 sitemap-portfolio test_portfolio <p style="margin: 5px;"><span style="color: #000000;"><strong>PORTFOLIO</strong></span></p> <p style="margin: 5px;"><span style="color: #000000;">DESIGN SERVICE</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/portfolio/design-service/residential-projects.html" target="_self">Residential Projects</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/portfolio/design-service/commercial-projects.html" target="_self">Commercial Projects</a></p> <p style="margin: 5px;">&nbsp;</p> <p style="margin: 5px;"><span style="color: #000000;">COLLABORATION</span></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/portfolio/collaborations/events.html" target="_self">Events</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/portfolio/collaborations/products.html" target="_self">Products</a></p> <p style="margin: 5px;"><a href="http://ec2-52-77-74-134.ap-southeast-1.compute.amazonaws.com/portfolio/collaborations/wholesale.html" target="_self">Wholesale</a></p> <p style="margin: 5px;"><span style="color: #000000;">&nbsp;</span></p> 2018-04-16 04:17:25 2018-04-17 10:33:34 1 0