Changes between Initial Version and Version 1 of Ticket #32963


Ignore:
Timestamp:
Jul 26, 2021, 5:39:20 AM (3 years ago)
Author:
mohamad ali Mehdizadeh
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #32963 – Description

    initial v1  
    1515
    1616SELECT
    17                 ... ,
    18                 COUNT("nakhll_market_product"."ID") AS "product_count"
    19             FROM "nakhll_market_shop"
    20             LEFT OUTER JOIN
    21                 "nakhll_market_product" ON ("nakhll_market_shop"."ID" = "nakhll_market_product"."FK_Shop_id")
    22             WHERE ("nakhll_market_shop"."Available" AND "nakhll_market_shop"."Publish")
    23             GROUP BY "nakhll_market_shop"."ID" HAVING COUNT("nakhll_market_product"."ID") > 1 
    24             ORDER BY RANDOM()
     17... ,
     18COUNT("nakhll_market_product"."ID") AS "product_count"
     19FROM "nakhll_market_shop"
     20 LEFT OUTER JOIN
     21 "nakhll_market_product" ON ("nakhll_market_shop"."ID" = "nakhll_market_product"."FK_Shop_id")
     22 WHERE ("nakhll_market_shop"."Available" AND "nakhll_market_shop"."Publish")
     23 GROUP BY "nakhll_market_shop"."ID" HAVING COUNT("nakhll_market_product"."ID") > 1 
     24 ORDER BY RANDOM()
Back to Top