Mysql Subquery

 SELECT * FROM `xp_postmeta` WHERE `meta_key` = 'old_order_id' and post_id IN (SELECT order_id FROM `xp_failed_order_mail` WHERE `mail4` = '1' AND `order_total` < '40')


Comments

Post a Comment

Popular posts from this blog

Import csv file in laravel

           1. I nstall maatwebsite via the Composer package manager                composer require maatwebsite/excel        2.  Then open config/app.php file and add service provider and aliase.           'providers' => [ Maatwebsite\Excel\ExcelServiceProvider::class,           ],           'aliases' => [ 'Excel' => Maatwebsite\Excel\Facades\Excel::class,           ],          3 . Define Routes              In routes/web.php                Route :: get ( ' /upload ' , 'Post Controller@index ' );         Route :: post ( ' /pupload ' , 'Post Controller@uploadp ' )-> name ( ' uploadp ' );       ...
Read more

Remove css or js version wordpress

 // remove wp version number from scripts and styles function remove_css_js_version( $src ) {     if( strpos( $src, '?ver=' ) )         $src = remove_query_arg( 'ver', $src );     return $src; } add_filter( 'style_loader_src', 'remove_css_js_version', 9999 ); add_filter( 'script_loader_src', 'remove_css_js_version', 9999 );
Read more