Efficient pagination using OFFSET-FETCH on SQL Server.
| ID | Name | Category | Price | Stock | Rating | Reviews | SKU |
|---|---|---|---|---|---|---|---|
| 22960 | Bulk Product 5976ec26 | Electronics | $637.13 | 303 | ★ 1.0 | 54 | BULK-f7eb4c9e |
| 22961 | Bulk Product b54116d9 | Sports & Outdoors | $575.71 | 247 | ★ 4.5 | 91 | BULK-44bb1e87 |
| 22962 | Bulk Product 75e8a0de | Books | $499.64 | 489 | ★ 1.9 | 47 | BULK-9b618608 |
| 22963 | Bulk Product 5049f063 | Sports & Outdoors | $785.43 | 453 | ★ 3.1 | 29 | BULK-566848b8 |
| 22964 | Bulk Product 980b59cc | Books | $487.78 | 29 | ★ 4.7 | 79 | BULK-4c3025ca |
| 22965 | Bulk Product 31d7f73f | Home & Garden | $355.92 | 225 | ★ 1.9 | 72 | BULK-3d71fd75 |
| 22966 | Bulk Product 1842134f | Sports & Outdoors | $390.46 | 384 | ★ 0.8 | 26 | BULK-0bb47a51 |
| 22967 | Bulk Product bba802ec | Toys & Games | $224.56 | 232 | ★ 2.0 | 34 | BULK-f08e3d26 |
| 22968 | Bulk Product 8c028e65 | Toys & Games | $374.66 | 127 | ★ 1.7 | 55 | BULK-a534ee2f |
| 22969 | Bulk Product b018475b | Sports & Outdoors | $168.52 | 460 | ★ 4.0 | 50 | BULK-a885f16e |
| 22970 | Bulk Product d1d930cd | Home & Garden | $815.92 | 136 | ★ 0.9 | 17 | BULK-9a07e9f7 |
| 22971 | Bulk Product d9f16acf | Toys & Games | $407.34 | 325 | ★ 3.5 | 55 | BULK-06035a46 |
| 22972 | Bulk Product 0ba14421 | Home & Garden | $251.54 | 303 | ★ 2.3 | 86 | BULK-4e691c9b |
| 22973 | Bulk Product 21994e5d | Sports & Outdoors | $936.53 | 81 | ★ 0.7 | 12 | BULK-4f2795ba |
| 22974 | Bulk Product 07996ca5 | Electronics | $976.99 | 199 | ★ 0.9 | 12 | BULK-df39d813 |
| 22975 | Bulk Product 167348c1 | Home & Garden | $410.11 | 410 | ★ 4.4 | 77 | BULK-47920ec7 |
| 22976 | Bulk Product aab5dece | Electronics | $685.37 | 429 | ★ 4.7 | 19 | BULK-b717ed9b |
| 22977 | Bulk Product c379099e | Home & Garden | $983.03 | 80 | ★ 3.2 | 72 | BULK-9c19d525 |
| 22978 | Bulk Product 138569d7 | Home & Garden | $637.27 | 167 | ★ 1.2 | 68 | BULK-18d238d7 |
| 22979 | Bulk Product 39931af3 | Books | $240.38 | 215 | ★ 1.0 | 85 | BULK-1e188daf |
| 22980 | Bulk Product 30948161 | Toys & Games | $627.86 | 200 | ★ 4.0 | 19 | BULK-60afde80 |
| 22981 | Bulk Product 7f1d9d10 | Sports & Outdoors | $628.24 | 202 | ★ 2.2 | 84 | BULK-3f72c40f |
| 22982 | Bulk Product 4bc4b770 | Home & Garden | $955.79 | 192 | ★ 3.4 | 31 | BULK-466bc4b1 |
| 22983 | Bulk Product 9492df2b | Books | $27.90 | 339 | ★ 3.7 | 88 | BULK-5f75b510 |
| 22984 | Bulk Product 9dd56142 | Books | $244.75 | 343 | ★ 4.3 | 5 | BULK-711c96c8 |
| 22985 | Bulk Product 3f5f252b | Clothing | $301.28 | 458 | ★ 3.3 | 49 | BULK-db257bca |
| 22986 | Bulk Product a1105286 | Sports & Outdoors | $976.36 | 431 | ★ 2.7 | 39 | BULK-7a096e77 |
| 22987 | Bulk Product f067de14 | Toys & Games | $302.43 | 449 | ★ 1.6 | 13 | BULK-4300815b |
| 22988 | Bulk Product 59bb64ab | Books | $787.95 | 245 | ★ 2.3 | 86 | BULK-4f9905a8 |
| 22989 | Bulk Product 7b0fac35 | Sports & Outdoors | $306.69 | 476 | ★ 1.7 | 92 | BULK-fb98ebd2 |
| 22990 | Bulk Product 32c29591 | Sports & Outdoors | $170.07 | 67 | ★ 4.2 | 38 | BULK-bf4a990a |
| 22991 | Bulk Product 4817553f | Sports & Outdoors | $988.52 | 27 | ★ 0.9 | 30 | BULK-4fe62952 |
| 22992 | Bulk Product 541a4de9 | Sports & Outdoors | $586.76 | 421 | ★ 1.5 | 62 | BULK-b1d6ad30 |
| 22993 | Bulk Product 4561ec12 | Toys & Games | $730.89 | 32 | ★ 3.1 | 45 | BULK-69e56479 |
| 22994 | Bulk Product 6e67420b | Clothing | $416.17 | 227 | ★ 2.1 | 22 | BULK-4bbcab39 |
| 22995 | Bulk Product 1d16f9b9 | Books | $331.97 | 279 | ★ 4.3 | 98 | BULK-933747bd |
| 22996 | Bulk Product 13a0e770 | Electronics | $623.30 | 131 | ★ 3.8 | 92 | BULK-c8eb97e8 |
| 22997 | Bulk Product 1b901e34 | Home & Garden | $145.41 | 227 | ★ 4.1 | 96 | BULK-e3134176 |
| 22998 | Bulk Product ada7c034 | Home & Garden | $469.21 | 2 | ★ 4.2 | 7 | BULK-b07ffd44 |
| 22999 | Bulk Product cd894bfa | Toys & Games | $713.01 | 251 | ★ 1.0 | 76 | BULK-c2fca3c2 |
| 23000 | Bulk Product 5b72005c | Home & Garden | $696.61 | 240 | ★ 3.6 | 67 | BULK-e0ca6aa3 |
| 23001 | Bulk Product ed1060d7 | Home & Garden | $985.43 | 240 | ★ 0.1 | 9 | BULK-3507af0f |
| 23002 | Bulk Product fe2bc856 | Electronics | $798.77 | 224 | ★ 0.2 | 35 | BULK-3cd38a4b |
| 23003 | Bulk Product cb2d29cd | Clothing | $716.18 | 54 | ★ 4.7 | 32 | BULK-7098d3e7 |
| 23004 | Bulk Product 372e68f2 | Toys & Games | $10.85 | 290 | ★ 1.7 | 66 | BULK-0af4464a |
| 23005 | Bulk Product 5060c6b7 | Toys & Games | $105.77 | 348 | ★ 2.6 | 86 | BULK-3e1522f1 |
| 23006 | Bulk Product 1c62c2d1 | Books | $854.39 | 482 | ★ 2.3 | 52 | BULK-1da543d9 |
| 23007 | Bulk Product 05fb9ec7 | Home & Garden | $55.60 | 215 | ★ 3.2 | 53 | BULK-95d2dd5b |
| 23008 | Bulk Product 80e25945 | Electronics | $702.93 | 366 | ★ 4.7 | 96 | BULK-823221b3 |
| 23009 | Bulk Product d642ae68 | Home & Garden | $574.22 | 40 | ★ 4.9 | 23 | BULK-6ba6532b |
| 23010 | Bulk Product b9f0c648 | Electronics | $318.86 | 416 | ★ 1.5 | 22 | BULK-47bcab62 |
| 23011 | Bulk Product 08b8eb46 | Books | $420.49 | 248 | ★ 3.0 | 51 | BULK-647f1b55 |
| 23012 | Bulk Product c978eee4 | Books | $597.56 | 489 | ★ 4.3 | 1 | BULK-bc2a9d32 |
| 23013 | Bulk Product f81dcc36 | Electronics | $60.04 | 474 | ★ 0.5 | 75 | BULK-80b9a8a9 |
| 23014 | Bulk Product dfe54738 | Electronics | $133.55 | 85 | ★ 1.0 | 94 | BULK-5f91ad57 |
| 23015 | Bulk Product 1da9af08 | Electronics | $138.14 | 180 | ★ 4.9 | 61 | BULK-0bd0d471 |
| 23016 | Bulk Product e4b0baa3 | Toys & Games | $12.36 | 175 | ★ 1.8 | 62 | BULK-dc8d2292 |
| 23017 | Bulk Product abf20210 | Clothing | $732.26 | 438 | ★ 4.7 | 26 | BULK-8639666d |
| 23018 | Bulk Product db445af2 | Home & Garden | $967.79 | 165 | ★ 3.3 | 17 | BULK-9c7a4bf5 |
| 23019 | Bulk Product dfe91e1d | Home & Garden | $734.81 | 213 | ★ 3.3 | 85 | BULK-8e26cca3 |
| 23020 | Bulk Product 17e9b5d4 | Books | $705.90 | 205 | ★ 5.0 | 78 | BULK-f9c1d03a |
| 23021 | Bulk Product 279a9526 | Home & Garden | $129.19 | 375 | ★ 4.3 | 81 | BULK-b43ef217 |
| 23022 | Bulk Product 7f6ddd44 | Toys & Games | $727.78 | 223 | ★ 4.0 | 70 | BULK-09dae538 |
| 23023 | Bulk Product 047afea0 | Books | $273.63 | 140 | ★ 1.4 | 71 | BULK-d2c543b0 |
| 23024 | Bulk Product 3db13b1f | Clothing | $721.88 | 443 | ★ 3.2 | 12 | BULK-5e9e18bd |
| 23025 | Bulk Product 89b1025a | Books | $41.17 | 56 | ★ 3.2 | 22 | BULK-6d74ab01 |
| 23026 | Bulk Product 80478a6d | Books | $597.30 | 267 | ★ 3.5 | 85 | BULK-76902b64 |
| 23027 | Bulk Product 33f36bed | Books | $1,000.88 | 18 | ★ 2.8 | 0 | BULK-07664b4e |
| 23028 | Bulk Product 183fb346 | Clothing | $378.46 | 279 | ★ 1.9 | 94 | BULK-59ccd5a7 |
| 23029 | Bulk Product 43f6485b | Clothing | $293.46 | 87 | ★ 4.1 | 43 | BULK-4069cf37 |
| 23030 | Bulk Product 59664404 | Electronics | $246.86 | 422 | ★ 3.5 | 29 | BULK-bf7b03b2 |
| 23031 | Bulk Product 65c6d6bc | Books | $463.85 | 261 | ★ 0.7 | 63 | BULK-41db9aaf |
| 23032 | Bulk Product 2c10cca3 | Books | $170.55 | 486 | ★ 1.9 | 60 | BULK-2f47ba1a |
| 23033 | Bulk Product 8f829a52 | Books | $257.28 | 335 | ★ 4.2 | 67 | BULK-c5e14882 |
| 23034 | Bulk Product e8069411 | Sports & Outdoors | $689.34 | 283 | ★ 4.1 | 32 | BULK-6bc65795 |
| 23035 | Bulk Product c2f98a6f | Electronics | $728.13 | 66 | ★ 2.1 | 33 | BULK-af5bf0e2 |
| 23036 | Bulk Product 59b5edc0 | Home & Garden | $295.44 | 326 | ★ 1.9 | 64 | BULK-41c394cd |
| 23037 | Bulk Product 4aa6bc5f | Clothing | $785.76 | 110 | ★ 2.1 | 37 | BULK-20130544 |
| 23038 | Bulk Product 2aad1ebd | Home & Garden | $257.58 | 141 | ★ 2.2 | 61 | BULK-e9704886 |
| 23039 | Bulk Product 366e499a | Electronics | $413.96 | 61 | ★ 5.0 | 52 | BULK-1c1d91d7 |
| 23040 | Bulk Product 0aabccec | Books | $420.39 | 197 | ★ 4.0 | 13 | BULK-c444cc66 |
| 23041 | Bulk Product 71ae5cb9 | Electronics | $877.04 | 277 | ★ 4.7 | 91 | BULK-7e89d0eb |
| 23042 | Bulk Product 0abf43ab | Toys & Games | $164.73 | 487 | ★ 3.2 | 30 | BULK-87f455ce |
| 23043 | Bulk Product e8bb119d | Home & Garden | $178.85 | 119 | ★ 1.7 | 50 | BULK-f40120e7 |
| 23044 | Bulk Product c8258812 | Toys & Games | $556.40 | 57 | ★ 2.3 | 56 | BULK-f28d6658 |
| 23045 | Bulk Product 23219a84 | Clothing | $647.67 | 304 | ★ 4.2 | 79 | BULK-5ad31afb |
| 23046 | Bulk Product 9466051a | Home & Garden | $326.39 | 32 | ★ 3.2 | 76 | BULK-2e89b128 |
| 23047 | Bulk Product e78d79f0 | Books | $797.18 | 170 | ★ 4.0 | 13 | BULK-dce6975e |
| 23048 | Bulk Product 3dd53898 | Toys & Games | $249.53 | 78 | ★ 1.4 | 39 | BULK-fbdb8013 |
| 23049 | Bulk Product 23ccc14a | Electronics | $146.14 | 364 | ★ 0.3 | 49 | BULK-9bfd078c |
| 23050 | Bulk Product ce6b0707 | Books | $496.61 | 273 | ★ 0.1 | 2 | BULK-a876bf00 |
| 23051 | Bulk Product a2692ba7 | Books | $883.65 | 340 | ★ 0.0 | 86 | BULK-ba3c19f5 |
| 23052 | Bulk Product b1f812cc | Clothing | $291.84 | 293 | ★ 0.3 | 34 | BULK-064f6b44 |
| 23053 | Bulk Product ed874e29 | Clothing | $494.36 | 102 | ★ 2.1 | 71 | BULK-d6b28a06 |
| 23054 | Bulk Product 8bd4cda4 | Books | $57.93 | 46 | ★ 0.6 | 35 | BULK-1d7fb608 |
| 23055 | Bulk Product ece434b0 | Electronics | $517.26 | 379 | ★ 3.8 | 38 | BULK-8e6e666f |
| 23056 | Bulk Product c7163fc5 | Clothing | $474.82 | 245 | ★ 1.0 | 82 | BULK-7a5bbc74 |
| 23057 | Bulk Product 63e47941 | Books | $530.40 | 145 | ★ 4.7 | 43 | BULK-8e80230f |
| 23058 | Bulk Product 8a8314b9 | Home & Garden | $727.31 | 86 | ★ 1.8 | 58 | BULK-18a752b4 |
| 23059 | Bulk Product ade0706b | Sports & Outdoors | $833.43 | 195 | ★ 0.2 | 84 | BULK-e2c484ca |
| 23060 | Bulk Product 2a12ec37 | Clothing | $1,002.57 | 380 | ★ 1.2 | 48 | BULK-696f1e7d |
| 23061 | Bulk Product 628629b2 | Electronics | $988.31 | 64 | ★ 2.9 | 28 | BULK-d39e8694 |
| 23062 | Bulk Product 7961bd89 | Electronics | $901.69 | 235 | ★ 1.7 | 68 | BULK-675105e0 |
| 23063 | Bulk Product c9cf21ba | Electronics | $320.11 | 213 | ★ 1.1 | 14 | BULK-25bc65cc |
| 23064 | Bulk Product abc4bd62 | Sports & Outdoors | $465.23 | 259 | ★ 3.9 | 38 | BULK-95107bb6 |
| 23065 | Bulk Product 3087681e | Clothing | $890.31 | 256 | ★ 2.1 | 71 | BULK-37cc968b |
| 23066 | Bulk Product 2acc2468 | Books | $529.80 | 53 | ★ 0.5 | 67 | BULK-1e1aef15 |
| 23067 | Bulk Product c9da8658 | Books | $358.56 | 395 | ★ 0.7 | 4 | BULK-94981845 |
| 23068 | Bulk Product d57e529f | Electronics | $666.36 | 463 | ★ 0.8 | 84 | BULK-873139a7 |
| 23069 | Bulk Product a0dc781f | Books | $496.77 | 122 | ★ 4.7 | 48 | BULK-1b70a997 |
| 23070 | Bulk Product 99f3312e | Toys & Games | $291.64 | 282 | ★ 3.4 | 50 | BULK-bc68c363 |
| 23071 | Bulk Product 4fe23423 | Toys & Games | $808.90 | 35 | ★ 4.4 | 18 | BULK-8d5d7aee |
| 23072 | Bulk Product c04e3814 | Electronics | $793.63 | 387 | ★ 2.6 | 43 | BULK-d48964d2 |
| 23073 | Bulk Product c07b168a | Books | $434.72 | 380 | ★ 4.6 | 47 | BULK-7f52ee3e |
| 23074 | Bulk Product 6cc10db8 | Home & Garden | $75.96 | 494 | ★ 1.7 | 8 | BULK-e7010c0e |
| 23075 | Bulk Product 467a8019 | Clothing | $974.24 | 48 | ★ 1.0 | 26 | BULK-c6721427 |
| 23076 | Bulk Product c95c50e2 | Electronics | $65.32 | 401 | ★ 1.1 | 53 | BULK-0ed9249a |
| 23077 | Bulk Product 9cfca50d | Electronics | $592.11 | 422 | ★ 1.8 | 19 | BULK-34a9f61f |
| 23078 | Bulk Product cdcc4dd3 | Books | $183.81 | 172 | ★ 2.1 | 38 | BULK-9bb42de8 |
| 23079 | Bulk Product 2068534e | Sports & Outdoors | $976.85 | 436 | ★ 3.6 | 67 | BULK-891e897f |
| 23080 | Bulk Product 64aa84f7 | Home & Garden | $181.72 | 162 | ★ 1.7 | 88 | BULK-830b5a76 |
| 23081 | Bulk Product cfffcb54 | Electronics | $20.82 | 124 | ★ 0.0 | 46 | BULK-8a9fad57 |
| 23082 | Bulk Product cc2d542f | Electronics | $173.96 | 231 | ★ 0.3 | 47 | BULK-e727cda1 |
| 23083 | Bulk Product 4c2708ae | Toys & Games | $640.17 | 349 | ★ 3.3 | 75 | BULK-0bf07300 |
| 23084 | Bulk Product 5753c805 | Books | $432.43 | 408 | ★ 5.0 | 1 | BULK-2bea90ef |
| 23085 | Bulk Product 565e70ab | Electronics | $210.42 | 138 | ★ 2.6 | 52 | BULK-d18726b3 |
| 23086 | Bulk Product fef428dc | Home & Garden | $819.83 | 401 | ★ 3.8 | 82 | BULK-a83c56f9 |
| 23087 | Bulk Product 88819e56 | Home & Garden | $800.46 | 454 | ★ 3.2 | 23 | BULK-ee8ce416 |
| 23088 | Bulk Product f798292e | Clothing | $688.64 | 106 | ★ 2.0 | 17 | BULK-3d50339e |
| 23089 | Bulk Product 6a8efc92 | Clothing | $661.50 | 340 | ★ 2.4 | 33 | BULK-8304542a |
| 23090 | Bulk Product b149c84b | Electronics | $648.36 | 223 | ★ 4.9 | 38 | BULK-ecfe6ccb |
| 23091 | Bulk Product 91e187ce | Sports & Outdoors | $597.91 | 107 | ★ 4.1 | 56 | BULK-f12e0a3c |
| 23092 | Bulk Product a9f3162c | Home & Garden | $628.71 | 107 | ★ 2.1 | 47 | BULK-e723f96e |
| 23093 | Bulk Product 1f75a48b | Books | $323.23 | 144 | ★ 2.7 | 56 | BULK-ce48460d |
| 23094 | Bulk Product 31949c2c | Electronics | $280.91 | 192 | ★ 4.5 | 38 | BULK-380cd1ce |
| 23095 | Bulk Product dd46ccdf | Books | $664.29 | 449 | ★ 4.1 | 47 | BULK-988c7ffa |
| 23096 | Bulk Product bac21670 | Sports & Outdoors | $294.21 | 458 | ★ 5.0 | 47 | BULK-481f4780 |
| 23097 | Bulk Product eac69f17 | Home & Garden | $934.99 | 382 | ★ 4.4 | 69 | BULK-6833880b |
| 23098 | Bulk Product 8be9daf8 | Electronics | $1,004.00 | 218 | ★ 4.2 | 4 | BULK-4adc8906 |
| 23099 | Bulk Product 0a24b0b7 | Books | $858.97 | 23 | ★ 1.1 | 91 | BULK-f476cfaa |
| 23100 | Bulk Product 1d8994de | Clothing | $528.77 | 127 | ★ 3.6 | 33 | BULK-5230dc60 |
| 23101 | Bulk Product 740273b8 | Electronics | $983.94 | 299 | ★ 2.6 | 30 | BULK-54dcd94e |
| 23102 | Bulk Product 423989ec | Toys & Games | $76.97 | 433 | ★ 2.1 | 23 | BULK-61b3ba47 |
| 23103 | Bulk Product a974492c | Toys & Games | $289.22 | 196 | ★ 0.2 | 83 | BULK-c3d7220a |
| 23104 | Bulk Product e6086220 | Home & Garden | $636.40 | 384 | ★ 2.6 | 86 | BULK-4e3f079b |
| 23105 | Bulk Product 41d772e3 | Electronics | $373.48 | 41 | ★ 0.6 | 50 | BULK-1c9b6fff |
| 23106 | Bulk Product 8d994118 | Toys & Games | $752.62 | 1 | ★ 0.5 | 52 | BULK-c1050176 |
| 23107 | Bulk Product f394a27b | Sports & Outdoors | $235.28 | 290 | ★ 2.6 | 42 | BULK-8775f296 |
| 23108 | Bulk Product 4e740e48 | Books | $248.62 | 306 | ★ 1.9 | 48 | BULK-627d9475 |
| 23109 | Bulk Product f34a7c01 | Clothing | $963.10 | 166 | ★ 3.6 | 84 | BULK-0f13fa4a |
| 23110 | Bulk Product 73ce76ca | Electronics | $490.03 | 482 | ★ 2.6 | 6 | BULK-37ec2e74 |
| 23111 | Bulk Product ab44f3e6 | Toys & Games | $504.13 | 276 | ★ 1.9 | 97 | BULK-cf909e08 |
| 23112 | Bulk Product d6d3c198 | Sports & Outdoors | $880.70 | 98 | ★ 3.0 | 28 | BULK-156d984c |
| 23113 | Bulk Product b9e54415 | Books | $126.50 | 112 | ★ 1.7 | 76 | BULK-7ed4de83 |
| 23114 | Bulk Product 545ca592 | Toys & Games | $453.69 | 181 | ★ 4.6 | 26 | BULK-de55a12e |
| 23115 | Bulk Product 0c152c01 | Clothing | $775.64 | 103 | ★ 1.6 | 77 | BULK-92657719 |
| 23116 | Bulk Product fcdbb290 | Clothing | $223.16 | 317 | ★ 1.9 | 44 | BULK-eff03a86 |
| 23117 | Bulk Product f719f8fe | Home & Garden | $999.05 | 226 | ★ 2.8 | 35 | BULK-b114b946 |
| 23118 | Bulk Product 138749a3 | Clothing | $658.83 | 433 | ★ 1.3 | 10 | BULK-b8b081a1 |
| 23119 | Bulk Product 9a62c391 | Electronics | $703.94 | 295 | ★ 0.3 | 77 | BULK-508186db |
| 23120 | Bulk Product 8c5af2c3 | Clothing | $527.20 | 9 | ★ 3.6 | 17 | BULK-4d2cb9c7 |
| 23121 | Bulk Product 88e98c51 | Home & Garden | $227.22 | 382 | ★ 2.0 | 23 | BULK-69d6e0b1 |
| 23122 | Bulk Product f8008a4a | Clothing | $825.44 | 316 | ★ 4.0 | 10 | BULK-879c2a95 |
| 23123 | Bulk Product 5326b560 | Books | $725.08 | 407 | ★ 0.6 | 58 | BULK-fd74a260 |
| 23124 | Bulk Product 5ace989a | Clothing | $697.77 | 258 | ★ 3.1 | 39 | BULK-1732a6c6 |
| 23125 | Bulk Product 5cec10db | Toys & Games | $479.39 | 346 | ★ 1.0 | 43 | BULK-c282dba3 |
| 23126 | Bulk Product 8de0fb36 | Electronics | $846.84 | 426 | ★ 1.3 | 32 | BULK-28d387fe |
| 23127 | Bulk Product 30a493ec | Electronics | $212.39 | 170 | ★ 4.5 | 28 | BULK-2205d966 |
| 23128 | Bulk Product fa22dda2 | Books | $351.66 | 198 | ★ 4.3 | 94 | BULK-f20a40df |
| 23129 | Bulk Product 8e873dcd | Sports & Outdoors | $619.56 | 59 | ★ 4.8 | 32 | BULK-0701269d |
| 23130 | Bulk Product 8668ae52 | Home & Garden | $200.94 | 464 | ★ 0.9 | 2 | BULK-f07cf071 |
| 23131 | Bulk Product 0e2b6226 | Clothing | $489.04 | 243 | ★ 2.0 | 50 | BULK-5e93c7d1 |
| 23132 | Bulk Product 6c138e33 | Books | $383.43 | 337 | ★ 4.0 | 75 | BULK-61ef2e7e |
| 23133 | Bulk Product d5510403 | Books | $72.99 | 118 | ★ 2.2 | 61 | BULK-c7396c42 |
| 23134 | Bulk Product 3dd98267 | Electronics | $430.68 | 281 | ★ 4.7 | 92 | BULK-06bc386d |
| 23135 | Bulk Product 02569660 | Sports & Outdoors | $944.20 | 293 | ★ 2.5 | 19 | BULK-7fc6e503 |
| 23136 | Bulk Product 7f692f90 | Books | $26.85 | 38 | ★ 1.7 | 3 | BULK-37debc49 |
| 23137 | Bulk Product c63bc55b | Sports & Outdoors | $157.68 | 64 | ★ 1.1 | 2 | BULK-59d48492 |
| 23138 | Bulk Product 6de9bfde | Sports & Outdoors | $96.47 | 226 | ★ 3.4 | 39 | BULK-77536ec7 |
| 23139 | Bulk Product 34c879f3 | Electronics | $384.18 | 474 | ★ 1.9 | 59 | BULK-5ea8abed |
| 23140 | Bulk Product 94104bac | Clothing | $29.20 | 269 | ★ 5.0 | 53 | BULK-b741468f |
| 23141 | Bulk Product b62df384 | Toys & Games | $183.83 | 189 | ★ 0.0 | 10 | BULK-73ac60c2 |
| 23142 | Bulk Product eca8cf80 | Sports & Outdoors | $573.20 | 18 | ★ 4.2 | 14 | BULK-fca19e42 |
| 23143 | Bulk Product e7e91e3c | Toys & Games | $367.91 | 206 | ★ 2.5 | 31 | BULK-807a31da |
| 23144 | Bulk Product d2294ba2 | Books | $432.82 | 126 | ★ 1.8 | 81 | BULK-b58f2691 |
| 23145 | Bulk Product a4fe669b | Sports & Outdoors | $491.13 | 44 | ★ 4.1 | 34 | BULK-c8eba057 |
| 23146 | Bulk Product cc001d0d | Clothing | $167.07 | 70 | ★ 3.7 | 17 | BULK-d5ca9e5d |
| 23147 | Bulk Product c8953ce3 | Books | $885.60 | 192 | ★ 5.0 | 96 | BULK-33bdd3d4 |
| 23148 | Bulk Product abaa9ebc | Books | $661.92 | 429 | ★ 4.4 | 43 | BULK-60b3a068 |
| 23149 | Bulk Product 68b61c88 | Toys & Games | $845.49 | 292 | ★ 4.6 | 26 | BULK-ea51e120 |
| 23150 | Bulk Product 1d50277c | Electronics | $220.85 | 126 | ★ 2.5 | 35 | BULK-13261e83 |
| 23151 | Bulk Product 6ba8d731 | Toys & Games | $705.39 | 465 | ★ 4.9 | 9 | BULK-b15041c2 |
| 23152 | Bulk Product 8890651f | Home & Garden | $286.29 | 260 | ★ 4.1 | 50 | BULK-56992dfd |
| 23153 | Bulk Product ebaa1458 | Sports & Outdoors | $503.75 | 377 | ★ 0.6 | 90 | BULK-e21630a9 |
| 23154 | Bulk Product 81e135b4 | Toys & Games | $376.49 | 321 | ★ 3.0 | 45 | BULK-763516e2 |
| 23155 | Bulk Product 36b5255a | Sports & Outdoors | $66.54 | 180 | ★ 4.7 | 47 | BULK-3c2010d9 |
| 23156 | Bulk Product 7ff4e4ba | Clothing | $539.51 | 441 | ★ 5.0 | 37 | BULK-fa1a9642 |
| 23157 | Bulk Product cc7bdee0 | Books | $569.42 | 162 | ★ 2.3 | 76 | BULK-eddb7b4d |
| 23158 | Bulk Product f462d41b | Electronics | $170.11 | 280 | ★ 1.5 | 75 | BULK-885eb68c |
| 23159 | Bulk Product 845cd0a6 | Clothing | $447.23 | 241 | ★ 0.5 | 85 | BULK-3100754b |
// Efficient pagination with Skip and Take
public async Task<PaginatedResult<DemoProduct>> GetPaginatedProductsAsync(int page, int pageSize)
{
// Get total count (cached if possible)
var totalCount = await _context.DemoProducts.CountAsync(p => p.IsActive);
// Get page of results
var items = await _context.DemoProducts
.Where(p => p.IsActive)
.OrderBy(p => p.Id) // Important: Must have ORDER BY for consistent paging
.Skip((page - 1) * pageSize) // OFFSET in SQL
.Take(pageSize) // FETCH NEXT in SQL
.AsNoTracking() // No tracking needed for read-only
.ToListAsync();
return new PaginatedResult<DemoProduct>
{
Items = items,
TotalCount = totalCount,
Page = page,
PageSize = pageSize
};
}