Filippo Pisano fulippo

fulippo / gist:4066855

Created November 13, 2012 16:41

Find duplicates in MySQL

SELECT <field_name>, COUNT(*) c FROM <table> GROUP BY <field_name> HAVING c > 1;

fulippo / gist:3986307

Created October 31, 2012 10:26

Query to remove orphaned taxonomy terms from a WordPress DB

	-- Replace %s with table prefix
	DELETE tr
	FROM %s_term_relationships tr
	INNER JOIN %s_term_taxonomy tt
	ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
	WHERE tt.taxonomy != 'link_category'
	AND tr.object_id NOT IN (SELECT ID FROM %s_posts);

fulippo / gist:3800324

Created September 28, 2012 14:48

Update di una tabella con select sulla stessa tabella

	UPDATE data_table t, (SELECT DISTINCT ID, NAME, VALUE
	FROM data_table
	WHERE VALUE IS NOT NULL AND VALUE != '') t1
	SET t.VALUE = t1.VALUE
	WHERE t.ID = t1.ID
	AND t.NAME = t1.NAME

fulippo / gist:3664125

Created September 7, 2012 07:36 — forked from mataspetrikas/gist:2300296

Check if the DOM node is visible in the viewport

	function elementInViewport(el) {
	var rect = el.getBoundingClientRect()
	return rect.top < (window.innerHeight \|\| document.body.clientHeight) && rect.left < (window.innerWidth \|\| document.body.clientWidth);
	}
	// and then you can use it:
	alert(elementInViewport(document.getElementById('inner')));
	// or
	alert(elementInViewport($('#inner')[0]));
	`

fulippo / .hgignore

Created September 3, 2012 07:48

.hgignore for WordPress