Jump to content

Search the Community

Showing results for tags 'query '.


More search options

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type


Forums

  • Main
    • News & Announcements
    • Forum Rules
    • Issues, complaints to administration
  • OpenCart 3.х
    • OpenCart 3.x: General Support
    • Opencart 3.x: Installation, Upgrade
    • Opencart 3.x: Config & Optimization
    • Opencart 3.x: Localisation
    • Opencart 3.x: Search for extensions
    • Opencart 3.x: Sandbox
    • Opencart 3.x: Bug Reports
  • OpenCart 2.х
    • OpenCart 2.x: General Support
    • Opencart 2.x: Installation, Upgrade
    • Opencart 2.x: Config & Optimization
    • Opencart 2.x: Localisation
    • Opencart 2.x: Search for extensions
    • Opencart 2.x: Sandbox
    • Opencart 2.x: Bug Reports
  • Extensions & Themes support
    • Themes
    • Filters
    • Modules
    • Promotions & Pricing
    • Coupons & Reward Points
    • Affiliate Programs
    • Blogs, News & Reviews
    • Design & Navigation
    • Shopping Cart & Order
    • SEO & Optimization
    • Sitemap & Feeds
    • Caching & Server Performance
    • Shipping & Tracking
    • Payment Methods & Gateways
    • Product Options
    • Product Combinations
    • Product Attributes
    • Email Marketing & SMS Integration
    • Banners, Slideshows & Galleries
    • Services
    • Order Totals
    • Text Editors
    • Tools & Developer Tools
    • Export / Import
    • Languages
    • Inventory Synchronization & Multi-Channel Management
    • Parsers
    • Multi Store Integration
    • Customer Support & Chat
    • Reports
    • Search
    • Compare & Wishlist
    • Social Media Integration & Marketing
    • Other
  • Other
    • Live Shops
    • Off-Topic

Categories

  • Themes
  • Modules
  • Reports
  • Services
  • Other
  • Filters
  • Promotions & Pricing
  • Coupons & Reward Points
  • Affiliate Programs
  • Blogs, News & Reviews
  • Design & Navigation
  • Shopping Cart & Order
  • SEO & Optimization
  • Sitemap & Feeds
  • Caching & Server Performance
  • Shipping & Tracking
  • Payment Methods & Gateways
  • Product Options
  • Product Combinations
  • Product Attributes
  • Email Marketing & SMS Integration
  • Banners, Slideshows & Galleries
  • Order Totals
  • Text Editors
  • Tools & Developer Tools
  • Export / Import
  • Inventory Synchronization & Multi-Channel Management
  • Parsers
  • Multi Store Integration
  • Customer Support & Chat
  • Search
  • Compare & Wishlist
  • Social Media Integration & Marketing
  • Languages

Find results in...

Find results that contain...


Date Created

  • Start

    End

Last Updated

  • Start

    End

Filter by number of...

Joined

  • Start

    End

Group

About Me

Found 1 result

  1. Designer

    Useful SQL queries

    Designer posted a topic in Other

    We collect useful SQL queries, to help novice developers. Everything, that is connected with a database -- Quantity Of Goods In Orders -- DB_PREFIX -- $product_id - Product ID -- $this->config->get('config_complete_status_id') - Order Complete Status SELECT COUNT(*) AS `total` FROM ' . DB_PREFIX . 'order_product op JOIN ' . DB_PREFIX . 'order o ON op.`order_id` = o.`order_id` WHERE op.product_id = ' . (int)$product_id . ' AND o.`order_status_id` = ' . (int)$this->config->get('config_complete_status_id') . ' GROUP BY o.`order_status_id`
×