"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
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`='57') 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
57 Commercial Project commercial-project <div class="page-title"><img class="img_left" alt="" src="/skin/frontend/alogg/default/images/snake_left.jpg" /> <h1>Commercial Project</h1> <img class="img_right" alt="" src="/skin/frontend/alogg/default/images/snake_right.jpg" /></div> <div class="about_text_wrapper"> <div class="about_text"><a href="/portfolio/design-service/commercial-projects/ecriture-nov2018.html"><img style="width: 250px;" alt="" src="{{media url="wysiwyg/20181109commercial_project/Ecriture-1.jpg"}}" /></a> <p style="line-height: 25px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">Ecriture</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Hong Kong</p> </div> <div class="about_text"><a href="/portfolio/design-service/commercial-projects/rauram-july2017.html"><img alt="" src="/skin/frontend/alogg/default/images/rauram-1.jpg" width="250px;" /></a> <p style="line-height: 25px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">Rau Ram</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Myanmar</p> </div> <div class="about_text"><a href="/portfolio/design-service/commercial-projects/hullet-house-july2017.html"><img alt="" src="/skin/frontend/alogg/default/images/hullet-july-1.jpg" width="250px;" /></a> <p style="line-height: 25px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">Hullet House</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Hong Kong</p> </div> <div class="about_text"><a href="/portfolio/design-service/commercial-projects/chabei-macau.html"><img alt="" src="/skin/frontend/alogg/default/images/chabei-interior-0.jpg" width="250px;" /></a> <p style="line-height: 25px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">CHA BEI</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Macau</p> </div> <div class="about_text"><a href="/design/design-service/commercial-projects/jouer-chater-house.html"><img alt="" src="/skin/frontend/alogg/default/images/com-icon-1.jpg" width="250px;" /></a> <p style="line-height: 25px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">Jouer Chater House<br />Pop-up Shop</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Hong Kong</p> </div> <div class="about_text"><a href="/design/design-service/commercial-projects/topiary-bar.html"><img alt="" src="/skin/frontend/alogg/default/images/com-icon-2.jpg" width="250px;" /></a> <p style="line-height: 40px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">Topiary Bar</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Hong Kong</p> </div> <div class="about_text"><a href="/design/design-service/commercial-projects/hullet-house.html"><img alt="" src="/skin/frontend/alogg/default/images/com-icon-3.jpg" width="250px;" /></a> <p style="line-height: 25px; min-height: 50px; margin-top: 30px; font-size: 15px; text-transform: uppercase;">Hullet House<br />Champagne Gallery</p> <hr /> <p style="margin-top: -30px; font-size: 13px; text-transform: uppercase;">Hong Kong</p> </div> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> </div> 2015-10-28 02:48:05 2018-11-09 10:34:17 1 0