git fetch origin pull/ID/head:BRANCHNAME
git checkout BRANCHNAME
git push origin BRANCHNAME
git checkout master
git merge BRANCHNAME
simmfins | |
simmfins_trail |
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 |
git fetch origin pull/ID/head:BRANCHNAME
git checkout BRANCHNAME
git push origin BRANCHNAME
git checkout master
git merge BRANCHNAME
<?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'), |
Concepts and definitions for SVG.
sudo timedatectl set-timezone Asia/Calcutta | |
date //will display current date and time |
<?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 ) | |
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 |
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; |