-- name: ListProducts :many
SELECT
  id,
  item_code,
  barcode,
  name,
  brand,
  category,
  gender,
  function,
  size,
  collection,
  base_price,
  is_active,
  created_at,
  updated_at
FROM bazzar_pos.products
ORDER BY id DESC
LIMIT $1 OFFSET $2;

