sathish ssatz

🏠

Working from home

#Entrepreneur #developer #fullstack

ssatz / .dbs

Created May 19, 2023 07:00 — forked from raymadrona/.dbs

MySQL Replication Tuned for Laravel

	simmfins
	simmfins_trail

ssatz / builder.php

Created May 24, 2020 10:49 — forked from ollieread/builder.php

Laravel query builder recursive CTE support

	<?php
	$recursive = $this->query()
	->recursive('parents', function (Builder $query) {
	$query
	->select([
	'*',
	new Alias('slug', 'fullslug'),
	new Alias(0, 'depth'),
	new Alias('id', 'tree_id'),
	new Alias('name', 'path'),

ssatz / README.md

Created May 18, 2020 13:33 — forked from hofmannsven/README.md

Notes on working with SVG on the web

SVG

Concepts and definitions for SVG.

ssatz / WP-Query

Created January 14, 2019 13:09 — forked from hoangitk/WP-Query

SQL Query to get Latest Wordpress Post with Featured Image.

	select DISTINCT wp_posts.id, wp_posts.post_title, wp_posts.post_content, wp_posts.post_type, featured_image.guid as post_image, wp_posts.post_modified, wp_users.display_name
	from wp_posts
	inner join wp_postmeta on wp_posts.id = wp_postmeta.post_id and wp_postmeta.meta_key = '_thumbnail_id'
	inner join wp_posts as featured_image on featured_image.id = wp_postmeta.meta_value
	inner join wp_users on wp_users.id = wp_posts.post_author
	where wp_posts.post_status = 'publish'
	order by wp_posts.ID desc
	limit 10

ssatz / media-query.css

Created July 18, 2018 06:13 — forked from gokulkrishh/media-query.css

CSS Media Queries for Desktop, Tablet, Mobile.


	/*
	##Device = Desktops
	##Screen = 1281px to higher resolution desktops
	*/

	@media (min-width: 1281px) {

	//CSS