msal4/hassah_book_server

Online bookstore backend for Hassah Book in Typescript and Graphql.

hassah_book_server's Issues

Logging and Analytics

Secure images

Secure images from s3 and imgix side

Add a province field in the user model

Tests are not working

Add admins query to list all admins

Ability to update phone number

Setup cors

Fulltext search is not setup correctly for authors

Backup the database automatically using dokku postgres backup feature

Create a user request subscription for the admin

The admin requests page and the user page updates in realtime when the status of the request changes.

Authenticate phone number using Firebase

Write a README

Include instructions on setup and common issues when installing the server

Return the total purchases price with the order

Add delete mutation for admin

add an SVG icon field to the category model

Should not accept an order with no purchases

Sync .env with .env.example and generate type defs automatically

Use a process manager in production

Should use a process manager like pm2 in production

Use .env to store the port and other customizable or sensitive data

Check if user is confirmed on specific routes

check if the user is confirmed when submitting orders or doing any operation that requires the user to be verified

Realtime order subscription

Updates the orders on the user page when the order status changes and on the admin dashboard when a new order is placed.

[global] Convert project to a monorepo

Setup yarn workspaces to reduce redunduncy

🌈 Store Images 🌈

Upload, resize, compress, and cache images.

Use docker for deployment

Implement forgot password mutation

Add the ability to search using the author's name.

Add a language field to Product

Implement search functionality using Postgres full-text search

Add tests ormconfig to gitignore

Add search cabability using elastic search

Use migrations for typorm

Add province field in order

Ordering

Setup github actions

Update user confirmed field

Update the user confirmed field to encompass three statuses (pending, confirmed, banned).
Since the user's phone number is confirmed immediately when they register it's unnecessary to use the field for phone verification status. Instead, the field should be turned into an enum to indicate the user status after their first delivery.
Status cases:

• The user is pending if they haven't ordered anything yet or their order is still on its way.
• The user is confirmed if they received their first package.
• The user is banned if they didn't receive their first package intentionally by their side.

Create a basic dashboard to share products, respond to requests, fulfill orders, and handle organizing products.

Add update query in admin resolver for updating the password or the email.

order resolver genreated SQL query is out of the ordinary

Server Log

Used query complexity points: 35
Version 9 of Highlight.js has reached EOL and is no longer supported.
Please upgrade or ask whatever dependency you are using to upgrade.
highlightjs/highlight.js#2877
query:

 SELECT DISTINCT "distinctAlias"."Order_id" as "ids_Order_id" FROM (SELECT "Order"."id" AS "Order_id", "Order"."province" AS "Order_province", "Order"."address" AS "Order_address", "Order"."phone" AS "Order_phone", "Order"."status" AS "Order_status", "Order"."totalPrice" AS "Order_totalPrice", "Order"."createdAt" AS "Order_createdAt", "Order"."updatedAt" AS "Order_updatedAt", "Order"."userId" AS "Order_userId", "Order__user"."id" AS "Order__user_id", "Order__user"."name" AS "Order__user_name", "Order__user"."password" AS "Order__user_password", "Order__user"."tokenVersion" AS "Order__user_tokenVersion", "Order__user"."createdAt" AS "Order__user_createdAt", "Order__user"."updatedAt" AS "Order__user_updatedAt", "Order__user"."phone" AS "Order__user_phone", "Order__user"."province" AS "Order__user_province", "Order__user"."address" AS "Order__user_address", "Order__user"."confirmed" AS "Order__user_confirmed" FROM "order" "Order" LEFT JOIN "user" "Order__user" ON "Order__user"."id"="Order"."userId" WHERE "Order"."id" = $1) "distinctAlias" ORDER BY "Order_id" ASC LIMIT 1 -- PARAMETERS: ["882fe4e4-cfc9-4eae-beb2-c1fba3db6c36"]

query:

 SELECT "Order"."id" AS "Order_id", "Order"."province" AS "Order_province", "Order"."address" AS "Order_address", "Order"."phone" AS "Order_phone", "Order"."status" AS "Order_status", "Order"."totalPrice" AS "Order_totalPrice", "Order"."createdAt" AS "Order_createdAt", "Order"."updatedAt" AS "Order_updatedAt", "Order"."userId" AS "Order_userId", "Order__user"."id" AS "Order__user_id", "Order__user"."name" AS "Order__user_name", "Order__user"."password" AS "Order__user_password", "Order__user"."tokenVersion" AS "Order__user_tokenVersion", "Order__user"."createdAt" AS "Order__user_createdAt", "Order__user"."updatedAt" AS "Order__user_updatedAt", "Order__user"."phone" AS "Order__user_phone", "Order__user"."province" AS "Order__user_province", "Order__user"."address" AS "Order__user_address", "Order__user"."confirmed" AS "Order__user_confirmed" FROM "order" "Order" LEFT JOIN "user" "Order__user" ON "Order__user"."id"="Order"."userId" WHERE ("Order"."id" = $1) AND "Order"."id" IN ($2) -- PARAMETERS: ["882fe4e4-cfc9-4eae-beb2-c1fba3db6c36","882fe4e4-cfc9-4eae-beb2-c1fba3db6c36"]

query:

 SELECT "purchase"."id" AS "id", "purchase"."orderId" AS "orderId" FROM "purchase" "purchase" WHERE (("purchase"."orderId" = $1)) -- PARAMETERS: ["882fe4e4-cfc9-4eae-beb2-c1fba3db6c36"]

query:

 SELECT "purchase"."id" AS "purchase_id", "purchase"."quantity" AS "purchase_quantity", "purchase"."createdAt" AS "purchase_createdAt", "purchase"."updatedAt" AS "purchase_updatedAt", "purchase"."productId" AS "purchase_productId", "purchase"."orderId" AS "purchase_orderId" FROM "purchase" "purchase" WHERE "purchase"."orderId" = $1 LIMIT 10 -- PARAMETERS: ["882fe4e4-cfc9-4eae-beb2-c1fba3db6c36"]

query:

 SELECT COUNT(DISTINCT("purchase"."id")) as "cnt" FROM "purchase" "purchase" WHERE "purchase"."orderId" = $1 -- PARAMETERS: ["882fe4e4-cfc9-4eae-beb2-c1fba3db6c36"]

query:

 SELECT "Product"."id" AS "Product_id", "Product"."name" AS "Product_name", "Product"."overview" AS "Product_overview", "Product"."price" AS "Product_price", "Product"."image" AS "Product_image", "Product"."pages" AS "Product_pages", "Product"."status" AS "Product_status", "Product"."language" AS "Product_language", "Product"."publishedAt" AS "Product_publishedAt", "Product"."createdAt" AS "Product_createdAt", "Product"."updatedAt" AS "Product_updatedAt", "Product"."authorId" AS "Product_authorId", "Product"."publisherId" AS "Product_publisherId", "Product__publisher"."id" AS "Product__publisher_id", "Product__publisher"."name" AS "Product__publisher_name", "Product__publisher"."createdAt" AS "Product__publisher_createdAt", "Product__publisher"."updatedAt" AS "Product__publisher_updatedAt", "Product__author"."id" AS "Product__author_id", "Product__author"."name" AS "Product__author_name", "Product__author"."createdAt" AS "Product__author_createdAt", "Product__author"."updatedAt" AS "Product__author_updatedAt", "Product__author"."overview" AS "Product__author_overview", "Product__author"."image" AS "Product__author_image", "Product__categories"."id" AS "Product__categories_id", "Product__categories"."name" AS "Product__categories_name", "Product__categories"."createdAt" AS "Product__categories_createdAt", "Product__categories"."updatedAt" AS "Product__categories_updatedAt", "Product__collections"."id" AS "Product__collections_id", "Product__collections"."name" AS "Product__collections_name", "Product__collections"."image" AS "Product__collections_image", "Product__collections"."createdAt" AS "Product__collections_createdAt", "Product__collections"."updatedAt" AS "Product__collections_updatedAt" FROM "product" "Product" LEFT JOIN "publisher" "Product__publisher" ON "Product__publisher"."id"="Product"."publisherId"  LEFT JOIN "author" "Product__author" ON "Product__author"."id"="Product"."authorId"  LEFT JOIN "category_products_product" "Product__categories_Product" ON "Product__categories_Product"."productId"="Product"."id" LEFT JOIN "category" "Product__categories" ON "Product__categories"."id"="Product__categories_Product"."categoryId"  LEFT JOIN "collection_products_product" "Product__collections_Product" ON "Product__collections_Product"."productId"="Product"."id" LEFT JOIN "collection" "Product__collections" ON "Product__collections"."id"="Product__collections_Product"."collectionId" WHERE "Product"."id" IN ($1, $2) -- PARAMETERS: ["1964f489-1a93-497f-b6e2-2c217648d859","6930cb1d-2f6a-4932-b526-cd74e11c01dc"]

query:

 SELECT "favorite"."id" AS "id", "favorite"."productId" AS "productId" FROM "favorite" "favorite" WHERE (("favorite"."productId" = $1) OR ("favorite"."productId" = $2) OR ("favorite"."productId" = $3) OR ("favorite"."productId" = $4) OR ("favorite"."productId" = $5) OR ("favorite"."productId" = $6) OR ("favorite"."productId" = $7) OR ("favorite"."productId" = $8) OR ("favorite"."productId" = $9) OR ("favorite"."productId" = $10) OR ("favorite"."productId" = $11) OR ("favorite"."productId" = $12) OR ("favorite"."productId" = $13) OR ("favorite"."productId" = $14) OR ("favorite"."productId" = $15) OR ("favorite"."productId" = $16) OR ("favorite"."productId" = $17) OR ("favorite"."productId" = $18) OR ("favorite"."productId" = $19) OR ("favorite"."productId" = $20) OR ("favorite"."productId" = $21) OR ("favorite"."productId" = $22) OR ("favorite"."productId" = $23) OR ("favorite"."productId" = $24) OR ("favorite"."productId" = $25) OR ("favorite"."productId" = $26) OR ("favorite"."productId" = $27) OR ("favorite"."productId" = $28) OR ("favorite"."productId" = $29) OR ("favorite"."productId" = $30) OR ("favorite"."productId" = $31) OR ("favorite"."productId" = $32) OR ("favorite"."productId" = $33) OR ("favorite"."productId" = $34) OR ("favorite"."productId" = $35) OR ("favorite"."productId" = $36) OR ("favorite"."productId" = $37) OR ("favorite"."productId" = $38) OR ("favorite"."productId" = $39) OR ("favorite"."productId" = $40) OR ("favorite"."productId" = $41) OR ("favorite"."productId" = $42) OR ("favorite"."productId" = $43) OR ("favorite"."productId" = $44) OR ("favorite"."productId" = $45) OR ("favorite"."productId" = $46) OR ("favorite"."productId" = $47) OR ("favorite"."productId" = $48) OR ("favorite"."productId" = $49) OR ("favorite"."productId" = $50) OR ("favorite"."productId" = $51) OR ("favorite"."productId" = $52) OR ("favorite"."productId" = $53) OR ("favorite"."productId" = $54) OR ("favorite"."productId" = $55) OR ("favorite"."productId" = $56) OR ("favorite"."productId" = $57) OR ("favorite"."productId" = $58) OR ("favorite"."productId" = $59) OR ("favorite"."productId" = $60) OR ("favorite"."productId" = $61) OR ("favorite"."productId" = $62) OR ("favorite"."productId" = $63) OR ("favorite"."productId" = $64) OR ("favorite"."productId" = $65) OR ("favorite"."productId" = $66) OR ("favorite"."productId" = $67) OR ("favorite"."productId" = $68) OR ("favorite"."productId" = $69) OR ("favorite"."productId" = $70) OR ("favorite"."productId" = $71) OR ("favorite"."productId" = $72) OR ("favorite"."productId" = $73) OR ("favorite"."productId" = $74) OR ("favorite"."productId" = $75) OR ("favorite"."productId" = $76) OR ("favorite"."productId" = $77) OR ("favorite"."productId" = $78) OR ("favorite"."productId" = $79) OR ("favorite"."productId" = $80) OR ("favorite"."productId" = $81) OR ("favorite"."productId" = $82) OR ("favorite"."productId" = $83) OR ("favorite"."productId" = $84) OR ("favorite"."productId" = $85) OR ("favorite"."productId" = $86) OR ("favorite"."productId" = $87) OR ("favorite"."productId" = $88) OR ("favorite"."productId" = $89) OR ("favorite"."productId" = $90) OR ("favorite"."productId" = $91) OR ("favorite"."productId" = $92) OR ("favorite"."productId" = $93) OR ("favorite"."productId" = $94) OR ("favorite"."productId" = $95) OR ("favorite"."productId" = $96) OR ("favorite"."productId" = $97) OR ("favorite"."productId" = $98) OR ("favorite"."productId" = $99) OR ("favorite"."productId" = $100) OR ("favorite"."productId" = $101) OR ("favorite"."productId" = $102) OR ("favorite"."productId" = $103) OR ("favorite"."productId" = $104) OR ("favorite"."productId" = $105) OR ("favorite"."productId" = $106) OR ("favorite"."productId" = $107) OR ("favorite"."productId" = $108) OR ("favorite"."productId" = $109) OR ("favorite"."productId" = $110)) -- PARAMETERS: ["6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859"]

query:

 SELECT "purchase"."id" AS "id", "purchase"."productId" AS "productId" FROM "purchase" "purchase" WHERE (("purchase"."productId" = $1) OR ("purchase"."productId" = $2) OR ("purchase"."productId" = $3) OR ("purchase"."productId" = $4) OR ("purchase"."productId" = $5) OR ("purchase"."productId" = $6) OR ("purchase"."productId" = $7) OR ("purchase"."productId" = $8) OR ("purchase"."productId" = $9) OR ("purchase"."productId" = $10) OR ("purchase"."productId" = $11) OR ("purchase"."productId" = $12) OR ("purchase"."productId" = $13) OR ("purchase"."productId" = $14) OR ("purchase"."productId" = $15) OR ("purchase"."productId" = $16) OR ("purchase"."productId" = $17) OR ("purchase"."productId" = $18) OR ("purchase"."productId" = $19) OR ("purchase"."productId" = $20) OR ("purchase"."productId" = $21) OR ("purchase"."productId" = $22) OR ("purchase"."productId" = $23) OR ("purchase"."productId" = $24) OR ("purchase"."productId" = $25) OR ("purchase"."productId" = $26) OR ("purchase"."productId" = $27) OR ("purchase"."productId" = $28) OR ("purchase"."productId" = $29) OR ("purchase"."productId" = $30) OR ("purchase"."productId" = $31) OR ("purchase"."productId" = $32) OR ("purchase"."productId" = $33) OR ("purchase"."productId" = $34) OR ("purchase"."productId" = $35) OR ("purchase"."productId" = $36) OR ("purchase"."productId" = $37) OR ("purchase"."productId" = $38) OR ("purchase"."productId" = $39) OR ("purchase"."productId" = $40) OR ("purchase"."productId" = $41) OR ("purchase"."productId" = $42) OR ("purchase"."productId" = $43) OR ("purchase"."productId" = $44) OR ("purchase"."productId" = $45) OR ("purchase"."productId" = $46) OR ("purchase"."productId" = $47) OR ("purchase"."productId" = $48) OR ("purchase"."productId" = $49) OR ("purchase"."productId" = $50) OR ("purchase"."productId" = $51) OR ("purchase"."productId" = $52) OR ("purchase"."productId" = $53) OR ("purchase"."productId" = $54) OR ("purchase"."productId" = $55) OR ("purchase"."productId" = $56) OR ("purchase"."productId" = $57) OR ("purchase"."productId" = $58) OR ("purchase"."productId" = $59) OR ("purchase"."productId" = $60) OR ("purchase"."productId" = $61) OR ("purchase"."productId" = $62) OR ("purchase"."productId" = $63) OR ("purchase"."productId" = $64) OR ("purchase"."productId" = $65) OR ("purchase"."productId" = $66) OR ("purchase"."productId" = $67) OR ("purchase"."productId" = $68) OR ("purchase"."productId" = $69) OR ("purchase"."productId" = $70) OR ("purchase"."productId" = $71) OR ("purchase"."productId" = $72) OR ("purchase"."productId" = $73) OR ("purchase"."productId" = $74) OR ("purchase"."productId" = $75) OR ("purchase"."productId" = $76) OR ("purchase"."productId" = $77) OR ("purchase"."productId" = $78) OR ("purchase"."productId" = $79) OR ("purchase"."productId" = $80) OR ("purchase"."productId" = $81) OR ("purchase"."productId" = $82) OR ("purchase"."productId" = $83) OR ("purchase"."productId" = $84) OR ("purchase"."productId" = $85) OR ("purchase"."productId" = $86) OR ("purchase"."productId" = $87) OR ("purchase"."productId" = $88) OR ("purchase"."productId" = $89) OR ("purchase"."productId" = $90) OR ("purchase"."productId" = $91) OR ("purchase"."productId" = $92) OR ("purchase"."productId" = $93) OR ("purchase"."productId" = $94) OR ("purchase"."productId" = $95) OR ("purchase"."productId" = $96) OR ("purchase"."productId" = $97) OR ("purchase"."productId" = $98) OR ("purchase"."productId" = $99) OR ("purchase"."productId" = $100) OR ("purchase"."productId" = $101) OR ("purchase"."productId" = $102) OR ("purchase"."productId" = $103) OR ("purchase"."productId" = $104) OR ("purchase"."productId" = $105) OR ("purchase"."productId" = $106) OR ("purchase"."productId" = $107) OR ("purchase"."productId" = $108) OR ("purchase"."productId" = $109) OR ("purchase"."productId" = $110)) -- PARAMETERS: ["6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859"]

query:

 SELECT "Product_categories_rid"."categoryId" AS "categoryId", "Product_categories_rid"."productId" AS "productId" FROM "category" "category" INNER JOIN "category_products_product" "Product_categories_rid" ON ("Product_categories_rid"."productId" = $1 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $2 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $3 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $4 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $5 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $6 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $7 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $8 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $9 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $10 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $11 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $12 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $13 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $14 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $15 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $16 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $17 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $18 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $19 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $20 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $21 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $22 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $23 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $24 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $25 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $26 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $27 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $28 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $29 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $30 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $31 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $32 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $33 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $34 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $35 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $36 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $37 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $38 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $39 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $40 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $41 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $42 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $43 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $44 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $45 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $46 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $47 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $48 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $49 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $50 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $51 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $52 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $53 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $54 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $55 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $56 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $57 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $58 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $59 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $60 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $61 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $62 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $63 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $64 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $65 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $66 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $67 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $68 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $69 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $70 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $71 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $72 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $73 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $74 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $75 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $76 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $77 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $78 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $79 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $80 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $81 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $82 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $83 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $84 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $85 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $86 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $87 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $88 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $89 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $90 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $91 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $92 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $93 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $94 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $95 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $96 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $97 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $98 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $99 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $100 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $101 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $102 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $103 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $104 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $105 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $106 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $107 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $108 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $109 AND "Product_categories_rid"."categoryId" = "category"."id") OR ("Product_categories_rid"."productId" = $110 AND "Product_categories_rid"."categoryId" = "category"."id") ORDER BY "Product_categories_rid"."categoryId" ASC, "Product_categories_rid"."productId" ASC -- PARAMETERS: ["6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859"]

query:

 SELECT "Product_collections_rid"."collectionId" AS "collectionId", "Product_collections_rid"."productId" AS "productId" FROM "collection" "collection" INNER JOIN "collection_products_product" "Product_collections_rid" ON ("Product_collections_rid"."productId" = $1 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $2 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $3 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $4 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $5 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $6 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $7 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $8 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $9 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $10 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $11 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $12 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $13 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $14 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $15 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $16 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $17 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $18 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $19 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $20 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $21 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $22 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $23 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $24 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $25 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $26 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $27 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $28 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $29 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $30 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $31 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $32 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $33 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $34 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $35 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $36 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $37 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $38 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $39 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $40 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $41 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $42 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $43 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $44 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $45 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $46 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $47 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $48 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $49 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $50 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $51 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $52 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $53 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $54 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $55 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $56 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $57 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $58 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $59 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $60 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $61 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $62 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $63 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $64 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $65 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $66 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $67 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $68 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $69 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $70 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $71 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $72 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $73 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $74 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $75 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $76 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $77 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $78 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $79 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $80 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $81 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $82 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $83 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $84 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $85 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $86 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $87 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $88 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $89 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $90 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $91 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $92 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $93 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $94 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $95 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $96 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $97 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $98 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $99 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $100 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $101 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $102 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $103 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $104 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $105 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $106 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $107 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $108 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $109 AND "Product_collections_rid"."collectionId" = "collection"."id") OR ("Product_collections_rid"."productId" = $110 AND "Product_collections_rid"."collectionId" = "collection"."id") ORDER BY "Product_collections_rid"."collectionId" ASC, "Product_collections_rid"."productId" ASC -- PARAMETERS: ["6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","6930cb1d-2f6a-4932-b526-cd74e11c01dc","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859","1964f489-1a93-497f-b6e2-2c217648d859"]

query:

 SELECT "Author"."id" AS "Author_id", "Author"."name" AS "Author_name", "Author"."createdAt" AS "Author_createdAt", "Author"."updatedAt" AS "Author_updatedAt", "Author"."overview" AS "Author_overview", "Author"."image" AS "Author_image" FROM "author" "Author" WHERE "Author"."id" IN ($1, $2) -- PARAMETERS: ["42e31aa5-ad40-4906-b8b6-52e6eea7f337","f590ccd5-487b-4f08-9361-796f170bb82a"]

query:

 SELECT "product"."id" AS "id", "product"."authorId" AS "authorId" FROM "product" "product" WHERE (("product"."authorId" = $1) OR ("product"."authorId" = $2)) -- PARAMETERS: ["f590ccd5-487b-4f08-9361-796f170bb82a","42e31aa5-ad40-4906-b8b6-52e6eea7f337"]

query:

 SELECT "Category"."id" AS "Category_id", "Category"."name" AS "Category_name", "Category"."createdAt" AS "Category_createdAt", "Category"."updatedAt" AS "Category_updatedAt" FROM "category" "Category" WHERE "Category"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) -- PARAMETERS: ["07becb1e-8bed-4cff-8f63-d9e92094a5ba","19267213-2e90-4413-9f43-a786aa6a74a3","1a6913a2-1721-40c1-9377-62c6c1e30871","3ad64ce7-ca37-4713-a506-ffa18041a88f","7320ccb7-37b7-4890-a79d-e030e91ee855","b2bd1265-b624-4284-b9e0-0e86157ec9a1","c68fe849-751e-4f22-a29a-a84af4d98913","d69d07dd-9b6f-4778-a9d2-10dbcb4f5fdc","dd5b4681-cbeb-4820-b1c2-33eecaad8a24","f7cf2ec3-041d-4a6d-9121-9c77e76ea78e"]

query:

 SELECT "Category_products_rid"."categoryId" AS "categoryId", "Category_products_rid"."productId" AS "productId" FROM "product" "product" INNER JOIN "category_products_product" "Category_products_rid" ON ("Category_products_rid"."categoryId" = $1 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $2 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $3 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $4 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $5 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $6 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $7 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $8 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $9 AND "Category_products_rid"."productId" = "product"."id") OR ("Category_products_rid"."categoryId" = $10 AND "Category_products_rid"."productId" = "product"."id") ORDER BY "Category_products_rid"."productId" ASC, "Category_products_rid"."categoryId" ASC -- PARAMETERS: ["d69d07dd-9b6f-4778-a9d2-10dbcb4f5fdc","f7cf2ec3-041d-4a6d-9121-9c77e76ea78e","dd5b4681-cbeb-4820-b1c2-33eecaad8a24","07becb1e-8bed-4cff-8f63-d9e92094a5ba","c68fe849-751e-4f22-a29a-a84af4d98913","1a6913a2-1721-40c1-9377-62c6c1e30871","b2bd1265-b624-4284-b9e0-0e86157ec9a1","3ad64ce7-ca37-4713-a506-ffa18041a88f","19267213-2e90-4413-9f43-a786aa6a74a3","7320ccb7-37b7-4890-a79d-e030e91ee855"]

Create a simple frontend to test register and login mutations

Format graphql errors to be consistant and easy to display on the frontend

A collection should have an image