Changes between Version 1 and Version 2 of Ticket #32963


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

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #32963 – Description

    v1 v2  
    1818COUNT("nakhll_market_product"."ID") AS "product_count"
    1919FROM "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()
     20LEFT OUTER JOIN
     21"nakhll_market_product" ON ("nakhll_market_shop"."ID" = "nakhll_market_product"."FK_Shop_id")
     22WHERE ("nakhll_market_shop"."Available" AND "nakhll_market_shop"."Publish")
     23GROUP BY "nakhll_market_shop"."ID" HAVING COUNT("nakhll_market_product"."ID") > 1 
     24ORDER BY RANDOM()
Back to Top