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

Add Css And Js Files on Specific Page In laravel

  1. Using Blade Layout Sections: Laravel's Blade templating engine provides a powerful way to manage layouts and include specific content on different pages. Here's how to achieve this: a. Base Layout ( layouts/app.blade.php ): <!DOCTYPE html> <html> <head> <title>My Website</title> @yield('page-css') <link rel="stylesheet" href="{{ asset('css/app.css') }}"> </head> <body> @include('partials.header') <main>@yield('content')</main> @include('partials.footer') @yield('page-js') <script src="{{ asset('js/app.js') }}"></script> </body> </html> b. Specific Page View ( views/home.blade.php ): @extends('layouts.app') @section('content')   @endsection @section('page-css')   <link rel="stylesheet" href="{{ asset('css/home.css') }}">  @endsection @se...
Read more

Be 10x 10 tools from sessions

 gamma.app  create ppt paywallhub.com sci-hub.se ui.playground.ai  for creating images with prompt  app.yoodli.ai   for job search resume practice for your speech ChatGPT codedamn.com/ai    help to find out the bug in your code Gemini formula.dog creates the formula for Excel
Read more

Print Laravel Query Or Debug Laravel Query

Method 1:-  $posts = Post::where('id',' '> ,10)->toSql(); dd($posts); Method 2:- DB::enabLeQueryLog(); // Enable query tog $posts = Post::with('comments')->where('id',' '> ,10)->get(); dd(DB::getQueryLog()); // Show results of tog Method 3:- $posts = Post::with('comments')->where('id',' '> ,10)->get(); $comments = Comments::all(); DB::listen (function($query) { print_r(value: "DB:" . $query->sql ."[".implode(separator. " , " , $query->bindings) . "]"); });
Read more