ssatz

simmfins
simmfins_trail

ssatz

select `email` as Email,IFNULL(SUBSTRING_INDEX(name,' ',1),"") AS "First Name",IFNULL(SUBSTRING_INDEX(name,' ',-1),"") AS "Last Name", IFNULL(CONCAT("91 ",`mobile`),"") as Phone,IFNULL(`pincode`,"") as Zip ,"IN" as Country from users left join address on address.user_id=users.id

ssatz

https://docs.github.com/en/github/collaborating-with-issues-and-pull-requests/checking-out-pull-requests-locally

git fetch origin pull/ID/head:BRANCHNAME

git checkout BRANCHNAME

git push origin BRANCHNAME

git checkout master git merge BRANCHNAME

ssatz

<?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

SVG

Concepts and definitions for SVG.

Read more

• Accessible SVGs

XML-SVG

ssatz

if (__sharethis__ && __sharethis__.config) {
    __sharethis__.init(__sharethis__.config);
}

ssatz

sudo timedatectl set-timezone Asia/Calcutta

date //will display current date and time

ssatz

<?php
$e =preg_split('/(?=[\s][0-9]+)/i','Red chilli powder  2.50 tbsp');
print_r($e);

//Array ( [0] => Red chilli powder [1] => 2.50 tbsp )
  

ssatz

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

SELECT * FROM wp_posts LEFT JOIN wp_term_relationships 
ON (wp_posts.ID = wp_term_relationships.object_id) 
LEFT JOIN wp_term_taxonomy 
ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) 
LEFT JOIN wp_terms 
ON (wp_term_relationships.term_taxonomy_id = wp_terms.term_id) 
WHERE wp_posts.post_type = 'post' 
AND wp_term_taxonomy.taxonomy = 'category' 
ORDER BY 
post_date DESC;