Efficient pagination using OFFSET-FETCH on SQL Server.
| ID | Name | Category | Price | Stock | Rating | Reviews | SKU |
|---|---|---|---|---|---|---|---|
| 22760 | Bulk Product ac33c255 | Books | $754.40 | 368 | ★ 3.0 | 37 | BULK-8c069807 |
| 22761 | Bulk Product 5e6af62b | Electronics | $626.43 | 181 | ★ 4.7 | 2 | BULK-9e0c82db |
| 22762 | Bulk Product de492824 | Home & Garden | $751.37 | 205 | ★ 3.0 | 79 | BULK-16a2b4d3 |
| 22763 | Bulk Product 2c9d6b87 | Books | $655.79 | 305 | ★ 2.4 | 69 | BULK-095d0137 |
| 22764 | Bulk Product f8dd8995 | Toys & Games | $893.24 | 298 | ★ 0.1 | 60 | BULK-c0c073be |
| 22765 | Bulk Product 07faf390 | Toys & Games | $57.64 | 215 | ★ 4.7 | 79 | BULK-5142ff87 |
| 22766 | Bulk Product 89d13df3 | Electronics | $668.24 | 119 | ★ 2.5 | 81 | BULK-5801599e |
| 22767 | Bulk Product ef1fccc3 | Clothing | $887.94 | 461 | ★ 0.3 | 36 | BULK-2ae360a4 |
| 22768 | Bulk Product bda14bcd | Clothing | $569.04 | 84 | ★ 3.3 | 90 | BULK-2ab458c6 |
| 22769 | Bulk Product 5c987145 | Toys & Games | $616.03 | 138 | ★ 4.7 | 17 | BULK-52b1917d |
| 22770 | Bulk Product 7c74840b | Toys & Games | $579.53 | 434 | ★ 1.0 | 34 | BULK-00da8ac7 |
| 22771 | Bulk Product f3f157b6 | Toys & Games | $420.91 | 307 | ★ 4.9 | 48 | BULK-79dd97b7 |
| 22772 | Bulk Product e8e6c521 | Clothing | $578.87 | 142 | ★ 0.6 | 1 | BULK-1b85f0de |
| 22773 | Bulk Product d0fda2fe | Toys & Games | $355.00 | 107 | ★ 1.4 | 68 | BULK-072ed0dc |
| 22774 | Bulk Product 8cec4feb | Toys & Games | $299.69 | 111 | ★ 2.1 | 78 | BULK-6c3b2213 |
| 22775 | Bulk Product 1c08e803 | Sports & Outdoors | $781.83 | 420 | ★ 3.1 | 73 | BULK-42d2cc60 |
| 22776 | Bulk Product f72b3399 | Clothing | $838.98 | 165 | ★ 2.1 | 77 | BULK-ceb8c16e |
| 22777 | Bulk Product d12ab782 | Clothing | $308.21 | 432 | ★ 1.2 | 78 | BULK-5f8ccdec |
| 22778 | Bulk Product c9fc9844 | Sports & Outdoors | $755.37 | 82 | ★ 0.7 | 11 | BULK-451f15c2 |
| 22779 | Bulk Product b0140aab | Sports & Outdoors | $936.44 | 377 | ★ 3.9 | 9 | BULK-08e8ec79 |
| 22780 | Bulk Product 6c12eb29 | Sports & Outdoors | $447.04 | 37 | ★ 3.8 | 67 | BULK-31a5e10b |
| 22781 | Bulk Product ae6646db | Clothing | $626.06 | 95 | ★ 0.8 | 95 | BULK-bdf3fa0d |
| 22782 | Bulk Product 2450badd | Books | $779.10 | 280 | ★ 0.5 | 17 | BULK-af45f6a3 |
| 22783 | Bulk Product 28cabc0f | Electronics | $809.18 | 69 | ★ 0.1 | 37 | BULK-eba207ce |
| 22784 | Bulk Product da9d9a20 | Clothing | $481.61 | 408 | ★ 1.0 | 95 | BULK-9aaea43e |
| 22785 | Bulk Product 2807fc69 | Clothing | $932.42 | 496 | ★ 0.2 | 11 | BULK-512b0f76 |
| 22786 | Bulk Product 686bfd83 | Electronics | $785.97 | 489 | ★ 1.7 | 45 | BULK-86960fd0 |
| 22787 | Bulk Product d6496d14 | Home & Garden | $467.56 | 469 | ★ 2.1 | 36 | BULK-ae30091f |
| 22788 | Bulk Product eb5023aa | Toys & Games | $821.28 | 223 | ★ 0.8 | 38 | BULK-01b8815f |
| 22789 | Bulk Product 98d31e9d | Electronics | $759.96 | 81 | ★ 0.6 | 64 | BULK-fb7b8e5c |
| 22790 | Bulk Product 6e9c5394 | Sports & Outdoors | $151.40 | 284 | ★ 3.3 | 30 | BULK-b2cf7aa9 |
| 22791 | Bulk Product 798e666c | Books | $555.10 | 291 | ★ 1.9 | 28 | BULK-bd8afc2f |
| 22792 | Bulk Product 8ac669e1 | Electronics | $204.40 | 81 | ★ 1.3 | 81 | BULK-fc8b11d4 |
| 22793 | Bulk Product 357454d7 | Home & Garden | $885.52 | 446 | ★ 2.6 | 84 | BULK-e6ff5531 |
| 22794 | Bulk Product 95d3357f | Sports & Outdoors | $292.91 | 154 | ★ 2.2 | 83 | BULK-28ef3811 |
| 22795 | Bulk Product 2ba50fde | Sports & Outdoors | $380.45 | 227 | ★ 3.9 | 61 | BULK-d4962a8b |
| 22796 | Bulk Product ceb61787 | Clothing | $803.39 | 249 | ★ 0.4 | 83 | BULK-e37aad38 |
| 22797 | Bulk Product 4eab2793 | Clothing | $348.66 | 499 | ★ 1.6 | 5 | BULK-aab359a8 |
| 22798 | Bulk Product 6fe9e0e6 | Books | $247.23 | 134 | ★ 2.3 | 76 | BULK-95e91412 |
| 22799 | Bulk Product 6bb18ff6 | Electronics | $225.24 | 72 | ★ 3.9 | 80 | BULK-956a9550 |
| 22800 | Bulk Product b0deec7e | Electronics | $796.30 | 335 | ★ 2.9 | 69 | BULK-b3baa14f |
| 22801 | Bulk Product d04aa0db | Toys & Games | $978.95 | 166 | ★ 3.7 | 86 | BULK-eb313e4b |
| 22802 | Bulk Product 01587062 | Books | $169.23 | 330 | ★ 2.1 | 93 | BULK-b722aa64 |
| 22803 | Bulk Product d3a86e18 | Electronics | $366.29 | 240 | ★ 2.0 | 31 | BULK-ff5736eb |
| 22804 | Bulk Product d8edb2b2 | Sports & Outdoors | $304.82 | 410 | ★ 1.4 | 80 | BULK-ff127a3d |
| 22805 | Bulk Product b86aafcf | Toys & Games | $57.65 | 446 | ★ 3.9 | 57 | BULK-be299165 |
| 22806 | Bulk Product f0d19dc3 | Books | $575.61 | 209 | ★ 4.2 | 50 | BULK-d58ca801 |
| 22807 | Bulk Product 58486435 | Books | $255.78 | 56 | ★ 2.7 | 94 | BULK-7dc4a026 |
| 22808 | Bulk Product 7d2b4379 | Home & Garden | $304.48 | 91 | ★ 0.9 | 69 | BULK-391f83fc |
| 22809 | Bulk Product ce564213 | Toys & Games | $646.39 | 56 | ★ 4.3 | 9 | BULK-0310fbc5 |
| 22810 | Bulk Product 23dd811b | Home & Garden | $603.12 | 287 | ★ 1.4 | 74 | BULK-7d7999a9 |
| 22811 | Bulk Product 6e188926 | Electronics | $670.51 | 419 | ★ 5.0 | 78 | BULK-b2618f50 |
| 22812 | Bulk Product 774bbfc3 | Clothing | $893.91 | 373 | ★ 1.8 | 22 | BULK-0337a9c1 |
| 22813 | Bulk Product a1e1f4df | Books | $116.90 | 199 | ★ 2.0 | 42 | BULK-e8bce11f |
| 22814 | Bulk Product 1796e91e | Toys & Games | $848.07 | 55 | ★ 1.1 | 15 | BULK-154b5582 |
| 22815 | Bulk Product 81810454 | Electronics | $926.24 | 424 | ★ 2.3 | 9 | BULK-faf5b01e |
| 22816 | Bulk Product 3cbf44ab | Clothing | $437.26 | 36 | ★ 0.2 | 36 | BULK-cf4d8306 |
| 22817 | Bulk Product 1eccbf60 | Toys & Games | $648.55 | 181 | ★ 0.5 | 45 | BULK-f27a1e2e |
| 22818 | Bulk Product d4701e4e | Home & Garden | $975.93 | 27 | ★ 3.3 | 98 | BULK-206a0f22 |
| 22819 | Bulk Product 13284db4 | Electronics | $85.54 | 372 | ★ 4.5 | 25 | BULK-c3b2c22f |
| 22820 | Bulk Product fd980643 | Home & Garden | $233.77 | 348 | ★ 1.0 | 29 | BULK-68ec7ec4 |
| 22821 | Bulk Product 51dccc08 | Electronics | $57.27 | 50 | ★ 4.4 | 15 | BULK-fa9663ae |
| 22822 | Bulk Product 74fdcab3 | Home & Garden | $866.66 | 229 | ★ 4.0 | 42 | BULK-5df255bc |
| 22823 | Bulk Product c7b871a1 | Clothing | $170.89 | 107 | ★ 2.7 | 67 | BULK-7e57baf7 |
| 22824 | Bulk Product 73d7f442 | Toys & Games | $684.78 | 190 | ★ 4.8 | 56 | BULK-50c51fce |
| 22825 | Bulk Product ac22f685 | Electronics | $413.05 | 110 | ★ 1.7 | 96 | BULK-df1e59bb |
| 22826 | Bulk Product 2a8ec819 | Sports & Outdoors | $779.33 | 391 | ★ 2.7 | 28 | BULK-ad44441a |
| 22827 | Bulk Product 1b930cc7 | Clothing | $833.43 | 247 | ★ 1.7 | 12 | BULK-d53b5854 |
| 22828 | Bulk Product 24b0749c | Books | $95.11 | 405 | ★ 3.4 | 1 | BULK-71cf60d3 |
| 22829 | Bulk Product 9531ab2f | Clothing | $144.50 | 211 | ★ 2.0 | 99 | BULK-128d8b15 |
| 22830 | Bulk Product 3a5978ea | Sports & Outdoors | $349.07 | 384 | ★ 4.3 | 72 | BULK-4dae7114 |
| 22831 | Bulk Product 25571995 | Books | $68.99 | 380 | ★ 3.9 | 58 | BULK-c114b4ea |
| 22832 | Bulk Product c983bb19 | Toys & Games | $988.35 | 396 | ★ 0.7 | 7 | BULK-0aa86e44 |
| 22833 | Bulk Product 878fc26b | Sports & Outdoors | $614.00 | 216 | ★ 1.1 | 10 | BULK-d7204134 |
| 22834 | Bulk Product f625bc43 | Books | $986.85 | 409 | ★ 4.3 | 63 | BULK-1896e791 |
| 22835 | Bulk Product df7534b7 | Sports & Outdoors | $856.05 | 241 | ★ 0.8 | 58 | BULK-19c97d50 |
| 22836 | Bulk Product d94753c5 | Electronics | $641.37 | 323 | ★ 2.8 | 30 | BULK-82c11062 |
| 22837 | Bulk Product 1a2cff0e | Sports & Outdoors | $917.17 | 415 | ★ 3.1 | 91 | BULK-4b648f40 |
| 22838 | Bulk Product e8f26c47 | Clothing | $120.08 | 40 | ★ 2.4 | 17 | BULK-2d486e1d |
| 22839 | Bulk Product 0d349734 | Toys & Games | $175.72 | 329 | ★ 2.0 | 23 | BULK-22c60015 |
| 22840 | Bulk Product e6097907 | Sports & Outdoors | $521.96 | 472 | ★ 3.6 | 30 | BULK-d0979364 |
| 22841 | Bulk Product c68c8fb4 | Electronics | $389.43 | 382 | ★ 0.7 | 1 | BULK-6a13ae0c |
| 22842 | Bulk Product 7988b50e | Electronics | $711.24 | 26 | ★ 1.8 | 88 | BULK-5d3acc34 |
| 22843 | Bulk Product 17d40a4a | Home & Garden | $177.31 | 268 | ★ 0.6 | 10 | BULK-3112c27a |
| 22844 | Bulk Product a48c5ccf | Toys & Games | $181.28 | 415 | ★ 1.5 | 69 | BULK-4ba130f7 |
| 22845 | Bulk Product fd85a2b5 | Sports & Outdoors | $71.12 | 92 | ★ 1.4 | 98 | BULK-5c6a67e3 |
| 22846 | Bulk Product 4c984a7c | Clothing | $658.22 | 433 | ★ 1.8 | 57 | BULK-bdbf0865 |
| 22847 | Bulk Product 154133b5 | Electronics | $677.92 | 197 | ★ 0.5 | 30 | BULK-12a074e3 |
| 22848 | Bulk Product abf93a05 | Electronics | $282.46 | 96 | ★ 1.6 | 9 | BULK-8e7d76e3 |
| 22849 | Bulk Product 66e33c13 | Books | $242.64 | 436 | ★ 2.1 | 8 | BULK-1c123d9d |
| 22850 | Bulk Product 867e1afb | Toys & Games | $573.02 | 322 | ★ 3.2 | 85 | BULK-cb07ec14 |
| 22851 | Bulk Product dfaed327 | Electronics | $431.96 | 175 | ★ 2.6 | 74 | BULK-2d18cf9d |
| 22852 | Bulk Product 49830541 | Clothing | $282.73 | 93 | ★ 2.0 | 56 | BULK-98e3f378 |
| 22853 | Bulk Product 92da39cd | Clothing | $571.87 | 459 | ★ 4.0 | 40 | BULK-3d3fca57 |
| 22854 | Bulk Product e513d2cd | Electronics | $466.16 | 375 | ★ 2.4 | 45 | BULK-955d848d |
| 22855 | Bulk Product 31b9c98c | Home & Garden | $452.63 | 303 | ★ 0.1 | 74 | BULK-e33ae38e |
| 22856 | Bulk Product cb00d940 | Electronics | $290.70 | 451 | ★ 2.3 | 38 | BULK-258a9009 |
| 22857 | Bulk Product 3534bfa0 | Clothing | $64.37 | 142 | ★ 0.7 | 3 | BULK-4b44c911 |
| 22858 | Bulk Product 62e2a37c | Toys & Games | $995.74 | 172 | ★ 1.8 | 42 | BULK-c42a5302 |
| 22859 | Bulk Product 7b3ae66b | Home & Garden | $551.45 | 3 | ★ 4.7 | 69 | BULK-6ea49916 |
| 22860 | Bulk Product 147b4821 | Books | $211.54 | 94 | ★ 1.6 | 42 | BULK-757d72bf |
| 22861 | Bulk Product 85991ef7 | Electronics | $683.11 | 274 | ★ 3.6 | 44 | BULK-3b70686f |
| 22862 | Bulk Product 38bfe46f | Toys & Games | $577.70 | 448 | ★ 2.0 | 13 | BULK-45b20bbc |
| 22863 | Bulk Product 59dea050 | Home & Garden | $767.40 | 157 | ★ 3.8 | 12 | BULK-36a070e4 |
| 22864 | Bulk Product d5787862 | Clothing | $194.16 | 364 | ★ 2.8 | 14 | BULK-4782ebd8 |
| 22865 | Bulk Product 47b55780 | Sports & Outdoors | $45.78 | 151 | ★ 1.6 | 44 | BULK-a0b88eb1 |
| 22866 | Bulk Product 22f30d91 | Home & Garden | $628.70 | 24 | ★ 1.2 | 56 | BULK-03003b32 |
| 22867 | Bulk Product 1c705c78 | Clothing | $920.81 | 378 | ★ 2.1 | 96 | BULK-87bdc1fc |
| 22868 | Bulk Product 9a4b6876 | Toys & Games | $60.83 | 175 | ★ 2.5 | 49 | BULK-fb9af2db |
| 22869 | Bulk Product e018665f | Clothing | $36.16 | 393 | ★ 0.0 | 22 | BULK-e26e2cd0 |
| 22870 | Bulk Product 6a486a0f | Toys & Games | $953.59 | 309 | ★ 1.4 | 34 | BULK-329f0c35 |
| 22871 | Bulk Product 20aca22d | Electronics | $553.75 | 303 | ★ 0.6 | 17 | BULK-5c247147 |
| 22872 | Bulk Product 3e98d47a | Home & Garden | $480.52 | 459 | ★ 1.3 | 49 | BULK-dba0df2a |
| 22873 | Bulk Product 60478455 | Clothing | $816.58 | 145 | ★ 3.1 | 53 | BULK-b6579212 |
| 22874 | Bulk Product 458baea8 | Clothing | $676.12 | 464 | ★ 5.0 | 41 | BULK-fc17399c |
| 22875 | Bulk Product 47653b93 | Clothing | $525.92 | 310 | ★ 3.7 | 62 | BULK-1dfb2a12 |
| 22876 | Bulk Product f834430a | Toys & Games | $281.85 | 74 | ★ 3.4 | 75 | BULK-e6e219a4 |
| 22877 | Bulk Product eb6797a6 | Books | $813.48 | 217 | ★ 4.7 | 88 | BULK-6d8b1f76 |
| 22878 | Bulk Product 1206b7a9 | Clothing | $721.50 | 35 | ★ 1.0 | 29 | BULK-7a666c04 |
| 22879 | Bulk Product 980eb4e4 | Clothing | $538.60 | 247 | ★ 1.3 | 81 | BULK-5dab4038 |
| 22880 | Bulk Product 7469e375 | Toys & Games | $375.75 | 25 | ★ 1.7 | 47 | BULK-870dafd8 |
| 22881 | Bulk Product 1d9e27f4 | Toys & Games | $251.08 | 60 | ★ 0.4 | 41 | BULK-f74c38d0 |
| 22882 | Bulk Product 36ca45c2 | Clothing | $667.00 | 330 | ★ 0.4 | 11 | BULK-da8e4b60 |
| 22883 | Bulk Product 72c1e54b | Home & Garden | $393.49 | 432 | ★ 4.1 | 57 | BULK-ee99c362 |
| 22884 | Bulk Product d55e78a4 | Books | $165.85 | 136 | ★ 2.0 | 48 | BULK-114360d8 |
| 22885 | Bulk Product 13a7f271 | Clothing | $360.36 | 311 | ★ 4.4 | 43 | BULK-62adb7d5 |
| 22886 | Bulk Product f9b9e622 | Clothing | $742.01 | 499 | ★ 1.4 | 95 | BULK-ecdfda02 |
| 22887 | Bulk Product 50a5b2f9 | Clothing | $446.65 | 154 | ★ 2.2 | 45 | BULK-1768d4e0 |
| 22888 | Bulk Product 1c02dbd8 | Electronics | $154.13 | 379 | ★ 0.0 | 78 | BULK-7c16d619 |
| 22889 | Bulk Product feb2f8af | Home & Garden | $795.00 | 464 | ★ 3.1 | 98 | BULK-a9c8dabf |
| 22890 | Bulk Product e37400b9 | Electronics | $593.69 | 228 | ★ 3.2 | 87 | BULK-ee26d5fd |
| 22891 | Bulk Product c944aa8d | Sports & Outdoors | $281.83 | 6 | ★ 0.7 | 23 | BULK-34d0fb72 |
| 22892 | Bulk Product 82f88c09 | Sports & Outdoors | $845.80 | 79 | ★ 3.2 | 28 | BULK-ea5dbac1 |
| 22893 | Bulk Product 761a6223 | Sports & Outdoors | $485.07 | 4 | ★ 3.7 | 6 | BULK-d7b1827b |
| 22894 | Bulk Product cb157c4a | Sports & Outdoors | $836.40 | 354 | ★ 2.6 | 37 | BULK-11cd78f9 |
| 22895 | Bulk Product ba80a0e0 | Books | $529.62 | 25 | ★ 1.7 | 76 | BULK-91bebc7d |
| 22896 | Bulk Product 6ed00e45 | Home & Garden | $735.71 | 371 | ★ 2.4 | 44 | BULK-269ed5c0 |
| 22897 | Bulk Product ba81e032 | Electronics | $105.64 | 493 | ★ 0.3 | 26 | BULK-5c4f9483 |
| 22898 | Bulk Product d75799ad | Toys & Games | $799.46 | 343 | ★ 3.4 | 66 | BULK-2b18da8d |
| 22899 | Bulk Product fe62c649 | Electronics | $474.56 | 283 | ★ 1.5 | 45 | BULK-b8a8ec4d |
| 22900 | Bulk Product 33026166 | Sports & Outdoors | $848.70 | 268 | ★ 0.9 | 32 | BULK-079df7ac |
| 22901 | Bulk Product 144131c0 | Sports & Outdoors | $901.47 | 331 | ★ 2.3 | 31 | BULK-954c79ba |
| 22902 | Bulk Product 87ff5ec6 | Home & Garden | $350.35 | 488 | ★ 2.8 | 92 | BULK-91b7f2dd |
| 22903 | Bulk Product 0486ace7 | Clothing | $578.90 | 461 | ★ 0.9 | 93 | BULK-aaf8b09a |
| 22904 | Bulk Product 77835a24 | Clothing | $1,008.14 | 216 | ★ 1.4 | 65 | BULK-6508e808 |
| 22905 | Bulk Product c0231bb1 | Electronics | $720.08 | 461 | ★ 0.2 | 84 | BULK-595ab9ae |
| 22906 | Bulk Product 7c8b6847 | Clothing | $363.38 | 211 | ★ 1.4 | 35 | BULK-c37bf582 |
| 22907 | Bulk Product 5bf376f3 | Toys & Games | $89.55 | 445 | ★ 2.8 | 20 | BULK-29b4cdbd |
| 22908 | Bulk Product d715941e | Clothing | $681.97 | 3 | ★ 0.7 | 8 | BULK-73860007 |
| 22909 | Bulk Product 5f1e5bd0 | Clothing | $970.58 | 72 | ★ 4.7 | 58 | BULK-8b934b53 |
| 22910 | Bulk Product c4bbee81 | Clothing | $505.40 | 423 | ★ 3.7 | 38 | BULK-5e83fb1f |
| 22911 | Bulk Product fc5f62ec | Home & Garden | $593.56 | 408 | ★ 2.0 | 64 | BULK-f100afd8 |
| 22912 | Bulk Product b8dbb596 | Home & Garden | $575.00 | 240 | ★ 1.3 | 18 | BULK-9ba0064d |
| 22913 | Bulk Product 5d537553 | Toys & Games | $269.37 | 470 | ★ 0.2 | 35 | BULK-a2d28379 |
| 22914 | Bulk Product d8025f2f | Sports & Outdoors | $974.21 | 220 | ★ 0.3 | 57 | BULK-0c41d7af |
| 22915 | Bulk Product b5b38a4e | Electronics | $528.84 | 186 | ★ 0.7 | 3 | BULK-a4cd3849 |
| 22916 | Bulk Product cfc8c62e | Electronics | $1,006.46 | 395 | ★ 4.4 | 51 | BULK-7e5abff9 |
| 22917 | Bulk Product e8ad70e0 | Sports & Outdoors | $465.06 | 251 | ★ 3.7 | 49 | BULK-87353733 |
| 22918 | Bulk Product 7c7079f0 | Home & Garden | $834.91 | 422 | ★ 3.4 | 73 | BULK-75633678 |
| 22919 | Bulk Product b14256a5 | Electronics | $481.86 | 225 | ★ 4.4 | 24 | BULK-c5ef576f |
| 22920 | Bulk Product 79c23208 | Clothing | $127.46 | 339 | ★ 0.6 | 91 | BULK-0235b8c2 |
| 22921 | Bulk Product 1da08d50 | Books | $703.30 | 25 | ★ 2.8 | 26 | BULK-7754d0c2 |
| 22922 | Bulk Product 0336662e | Home & Garden | $189.07 | 64 | ★ 0.7 | 0 | BULK-689f90b4 |
| 22923 | Bulk Product 68cbd3d6 | Toys & Games | $10.76 | 33 | ★ 2.4 | 44 | BULK-386e2e4b |
| 22924 | Bulk Product 235717d3 | Home & Garden | $255.44 | 226 | ★ 3.1 | 8 | BULK-f130db6a |
| 22925 | Bulk Product d47f93bb | Electronics | $414.69 | 227 | ★ 3.7 | 56 | BULK-cf959298 |
| 22926 | Bulk Product 0b6d7c35 | Books | $933.70 | 36 | ★ 0.2 | 56 | BULK-c23ad07d |
| 22927 | Bulk Product 8be111aa | Toys & Games | $726.68 | 285 | ★ 2.6 | 99 | BULK-70f1b4a5 |
| 22928 | Bulk Product 20bf5ee5 | Home & Garden | $830.43 | 229 | ★ 1.3 | 9 | BULK-06a50480 |
| 22929 | Bulk Product 5feb5213 | Toys & Games | $453.90 | 72 | ★ 3.2 | 90 | BULK-275aeb2f |
| 22930 | Bulk Product a52a17f3 | Sports & Outdoors | $524.34 | 271 | ★ 2.3 | 36 | BULK-08fe2f16 |
| 22931 | Bulk Product bc1c8620 | Home & Garden | $535.19 | 33 | ★ 3.0 | 2 | BULK-09fba6ce |
| 22932 | Bulk Product c55b4e12 | Home & Garden | $655.98 | 12 | ★ 4.2 | 66 | BULK-1b80477e |
| 22933 | Bulk Product 2c17bd73 | Toys & Games | $741.66 | 442 | ★ 1.8 | 75 | BULK-e73cf40e |
| 22934 | Bulk Product 6a097a04 | Books | $280.61 | 53 | ★ 3.2 | 64 | BULK-e914ec47 |
| 22935 | Bulk Product 53f880f6 | Home & Garden | $806.86 | 344 | ★ 1.1 | 34 | BULK-202dcfd6 |
| 22936 | Bulk Product 3d1425c3 | Books | $673.13 | 197 | ★ 2.6 | 74 | BULK-69e59027 |
| 22937 | Bulk Product 1dcc3349 | Home & Garden | $384.02 | 88 | ★ 1.5 | 4 | BULK-8861ccaa |
| 22938 | Bulk Product fa015074 | Sports & Outdoors | $661.48 | 464 | ★ 1.4 | 85 | BULK-8bbaebea |
| 22939 | Bulk Product cbc770d0 | Books | $192.74 | 473 | ★ 0.3 | 87 | BULK-d089c35d |
| 22940 | Bulk Product b2b338d5 | Clothing | $337.09 | 215 | ★ 2.3 | 5 | BULK-e5f399c2 |
| 22941 | Bulk Product 2a28a027 | Electronics | $751.83 | 171 | ★ 1.7 | 88 | BULK-933ca73f |
| 22942 | Bulk Product ea36a8c3 | Electronics | $998.41 | 470 | ★ 4.1 | 93 | BULK-8ae5739a |
| 22943 | Bulk Product 5ef9b416 | Sports & Outdoors | $729.69 | 497 | ★ 1.4 | 74 | BULK-c806a371 |
| 22944 | Bulk Product 39098860 | Electronics | $272.04 | 258 | ★ 3.9 | 4 | BULK-8f4923f2 |
| 22945 | Bulk Product 94b196ec | Home & Garden | $731.83 | 211 | ★ 3.4 | 79 | BULK-cf404d6b |
| 22946 | Bulk Product 84f37e54 | Electronics | $151.51 | 116 | ★ 2.5 | 77 | BULK-9d5bb89d |
| 22947 | Bulk Product 64808320 | Books | $365.47 | 116 | ★ 3.8 | 89 | BULK-8212e4dc |
| 22948 | Bulk Product 54958b17 | Clothing | $603.25 | 98 | ★ 3.7 | 71 | BULK-1b60250a |
| 22949 | Bulk Product 7ff21faf | Home & Garden | $885.06 | 63 | ★ 3.2 | 93 | BULK-02735574 |
| 22950 | Bulk Product 83393223 | Toys & Games | $460.56 | 210 | ★ 0.0 | 64 | BULK-0398d728 |
| 22951 | Bulk Product d874b0a8 | Sports & Outdoors | $44.00 | 308 | ★ 3.3 | 20 | BULK-67980398 |
| 22952 | Bulk Product d7dc507e | Home & Garden | $145.02 | 388 | ★ 3.9 | 83 | BULK-94a58e2c |
| 22953 | Bulk Product 16c0455a | Books | $298.20 | 400 | ★ 4.2 | 38 | BULK-d4845e8e |
| 22954 | Bulk Product a7edbf39 | Toys & Games | $1,002.25 | 9 | ★ 2.8 | 81 | BULK-31abbc6d |
| 22955 | Bulk Product 4c6abac4 | Toys & Games | $153.38 | 184 | ★ 2.2 | 51 | BULK-25a4119e |
| 22956 | Bulk Product 22d586fe | Clothing | $255.72 | 79 | ★ 5.0 | 65 | BULK-85fae57d |
| 22957 | Bulk Product 2fed60ae | Books | $486.80 | 358 | ★ 1.0 | 7 | BULK-1f0deb8e |
| 22958 | Bulk Product c40152e4 | Toys & Games | $924.19 | 219 | ★ 3.9 | 29 | BULK-fc25539b |
| 22959 | Bulk Product 0d9a7892 | Clothing | $418.57 | 436 | ★ 1.5 | 40 | BULK-1acd29dd |
// 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
};
}