inovarti inovarti

inovarti / iOS-7-web-app.html

Created August 27, 2014 03:22 — forked from tfausak/ios-8-web-app.html

	<!doctype html>

	<html>
	<head>
	<!-- Run in full-screen mode. -->
	<meta name="apple-mobile-web-app-capable" content="yes">

	<!-- Make the status bar black with white text. -->
	<meta name="apple-mobile-web-app-status-bar-style" content="black">

inovarti / Category.sql

Created August 22, 2014 19:06 — forked from ticean/Category.sql

	SET @entityid = '3';

	SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
	FROM catalog_category_entity e
	JOIN catalog_category_entity_varchar eav
	ON e.entity_id = eav.entity_id
	JOIN eav_attribute ea
	ON eav.attribute_id = ea.attribute_id
	WHERE e.entity_id = @entityid
	UNION