Efficient pagination using OFFSET-FETCH on SQL Server.
| ID | Name | Category | Price | Stock | Rating | Reviews | SKU |
|---|---|---|---|---|---|---|---|
| 19760 | Bulk Product 054005f4 | Sports & Outdoors | $947.17 | 231 | ★ 3.0 | 81 | BULK-e881c7ee |
| 19761 | Bulk Product f10e5cb2 | Electronics | $984.46 | 226 | ★ 3.4 | 56 | BULK-81e06de1 |
| 19762 | Bulk Product d3989c07 | Sports & Outdoors | $357.83 | 255 | ★ 4.8 | 17 | BULK-2fc78484 |
| 19763 | Bulk Product 32d03f22 | Electronics | $206.48 | 364 | ★ 4.7 | 26 | BULK-9bab7382 |
| 19764 | Bulk Product 35211777 | Sports & Outdoors | $556.38 | 322 | ★ 3.9 | 74 | BULK-d00debe4 |
| 19765 | Bulk Product aadc53d1 | Sports & Outdoors | $54.00 | 432 | ★ 2.7 | 10 | BULK-0794075b |
| 19766 | Bulk Product c9101d3e | Clothing | $362.01 | 320 | ★ 1.5 | 19 | BULK-e98b60b2 |
| 19767 | Bulk Product 399ca27c | Toys & Games | $185.67 | 142 | ★ 2.8 | 95 | BULK-ac241c9c |
| 19768 | Bulk Product cd134d29 | Sports & Outdoors | $624.74 | 258 | ★ 4.1 | 74 | BULK-499898fc |
| 19769 | Bulk Product ecf9602a | Clothing | $508.84 | 156 | ★ 0.6 | 18 | BULK-b11765f6 |
| 19770 | Bulk Product af470f0c | Electronics | $759.30 | 187 | ★ 1.2 | 4 | BULK-108cbf77 |
| 19771 | Bulk Product 37fd5215 | Sports & Outdoors | $87.42 | 258 | ★ 3.1 | 91 | BULK-76d839c8 |
| 19772 | Bulk Product 04163b98 | Clothing | $337.61 | 110 | ★ 4.1 | 94 | BULK-4e172b83 |
| 19773 | Bulk Product 6583f1a2 | Clothing | $416.73 | 321 | ★ 0.9 | 9 | BULK-b1309aa0 |
| 19774 | Bulk Product 256bf2f4 | Clothing | $541.68 | 331 | ★ 2.2 | 64 | BULK-c5ebb1a8 |
| 19775 | Bulk Product 6285d0bf | Toys & Games | $253.56 | 35 | ★ 2.6 | 38 | BULK-249d6f5d |
| 19776 | Bulk Product 9cbf938a | Electronics | $644.46 | 188 | ★ 4.4 | 91 | BULK-1e6d4101 |
| 19777 | Bulk Product 85b8bb71 | Home & Garden | $801.26 | 443 | ★ 3.6 | 89 | BULK-4f1d1dcf |
| 19778 | Bulk Product 4ed34f89 | Books | $731.64 | 41 | ★ 5.0 | 50 | BULK-8cef2b9b |
| 19779 | Bulk Product f22de828 | Clothing | $487.90 | 248 | ★ 4.7 | 82 | BULK-ce315bae |
| 19780 | Bulk Product 89159b06 | Clothing | $39.61 | 497 | ★ 4.6 | 74 | BULK-85b78725 |
| 19781 | Bulk Product 8e26cc97 | Home & Garden | $829.24 | 382 | ★ 0.1 | 62 | BULK-6a41361c |
| 19782 | Bulk Product 95882bff | Electronics | $837.92 | 449 | ★ 1.1 | 52 | BULK-3863d049 |
| 19783 | Bulk Product 3077695c | Home & Garden | $618.49 | 95 | ★ 2.1 | 21 | BULK-4323e765 |
| 19784 | Bulk Product b07eaac3 | Books | $802.93 | 306 | ★ 4.9 | 45 | BULK-4036613d |
| 19785 | Bulk Product 55f0ad1a | Toys & Games | $762.34 | 11 | ★ 0.4 | 7 | BULK-e9b2c4cd |
| 19786 | Bulk Product c3f9527f | Home & Garden | $564.97 | 242 | ★ 0.9 | 4 | BULK-bf0926a4 |
| 19787 | Bulk Product b1e2b9ea | Toys & Games | $142.22 | 391 | ★ 1.3 | 57 | BULK-7e634aab |
| 19788 | Bulk Product b2f6fd1b | Clothing | $428.72 | 134 | ★ 2.3 | 18 | BULK-217df683 |
| 19789 | Bulk Product 8682bb95 | Books | $340.70 | 404 | ★ 4.2 | 80 | BULK-de50f763 |
| 19790 | Bulk Product 7da9fabe | Electronics | $563.59 | 50 | ★ 1.4 | 76 | BULK-abcde8ab |
| 19791 | Bulk Product 04ca4df3 | Books | $574.36 | 460 | ★ 3.9 | 45 | BULK-64e50766 |
| 19792 | Bulk Product 3954739c | Clothing | $309.72 | 319 | ★ 3.6 | 51 | BULK-d57f2623 |
| 19793 | Bulk Product 6d17948f | Toys & Games | $318.77 | 226 | ★ 2.9 | 50 | BULK-a20797fd |
| 19794 | Bulk Product fbe79ebc | Sports & Outdoors | $558.00 | 373 | ★ 0.3 | 70 | BULK-76e94d76 |
| 19795 | Bulk Product e1546ee5 | Home & Garden | $22.03 | 173 | ★ 2.6 | 34 | BULK-ca4f71b9 |
| 19796 | Bulk Product fed4efce | Home & Garden | $84.73 | 73 | ★ 3.4 | 81 | BULK-8273810b |
| 19797 | Bulk Product 8dbc2ff5 | Books | $10.97 | 224 | ★ 4.8 | 51 | BULK-d0982648 |
| 19798 | Bulk Product 2c6e7f42 | Clothing | $465.64 | 204 | ★ 2.6 | 1 | BULK-b76fe253 |
| 19799 | Bulk Product ee9b2bf1 | Sports & Outdoors | $409.36 | 21 | ★ 1.1 | 85 | BULK-06dc64ea |
| 19800 | Bulk Product 0d14b160 | Sports & Outdoors | $704.21 | 147 | ★ 4.8 | 86 | BULK-47a2f686 |
| 19801 | Bulk Product d061118d | Electronics | $459.84 | 158 | ★ 4.6 | 19 | BULK-374e58d4 |
| 19802 | Bulk Product 6d62f3b4 | Home & Garden | $53.24 | 184 | ★ 2.4 | 46 | BULK-22b1a081 |
| 19803 | Bulk Product 11ad4708 | Electronics | $324.84 | 349 | ★ 1.1 | 21 | BULK-0aa154d0 |
| 19804 | Bulk Product 1caba4b7 | Home & Garden | $158.48 | 347 | ★ 1.3 | 56 | BULK-ff390d59 |
| 19805 | Bulk Product e6c9deae | Home & Garden | $703.35 | 177 | ★ 4.7 | 99 | BULK-bbae0005 |
| 19806 | Bulk Product 2fa379fd | Books | $670.44 | 104 | ★ 4.2 | 31 | BULK-ce1aef76 |
| 19807 | Bulk Product 5316bfc5 | Clothing | $872.07 | 331 | ★ 1.0 | 70 | BULK-e2ee9917 |
| 19808 | Bulk Product 99e3fbb3 | Books | $197.04 | 350 | ★ 0.5 | 57 | BULK-24d8184c |
| 19809 | Bulk Product 925f2943 | Toys & Games | $647.45 | 31 | ★ 4.0 | 8 | BULK-b5c9aa54 |
| 19810 | Bulk Product d977279d | Toys & Games | $15.58 | 333 | ★ 2.8 | 63 | BULK-aee13fd1 |
| 19811 | Bulk Product baa1c570 | Clothing | $10.94 | 11 | ★ 0.3 | 47 | BULK-f50adb2e |
| 19812 | Bulk Product 19f78085 | Clothing | $987.71 | 273 | ★ 0.8 | 32 | BULK-8eaee4db |
| 19813 | Bulk Product 840ca83b | Home & Garden | $281.44 | 211 | ★ 1.8 | 99 | BULK-9c1c896a |
| 19814 | Bulk Product 6b59a64c | Electronics | $494.66 | 27 | ★ 2.8 | 89 | BULK-c9bc0d1c |
| 19815 | Bulk Product d77f47b0 | Clothing | $406.18 | 357 | ★ 1.4 | 43 | BULK-63624574 |
| 19816 | Bulk Product a0e87d7c | Books | $191.92 | 318 | ★ 1.5 | 31 | BULK-3da35b3b |
| 19817 | Bulk Product 956a63f3 | Home & Garden | $424.57 | 86 | ★ 0.5 | 32 | BULK-623002bb |
| 19818 | Bulk Product ad2b33bd | Clothing | $935.53 | 415 | ★ 4.5 | 97 | BULK-4ad005b5 |
| 19819 | Bulk Product c30d6adf | Toys & Games | $301.54 | 455 | ★ 4.7 | 36 | BULK-a01378de |
| 19820 | Bulk Product b5e77f58 | Home & Garden | $510.44 | 101 | ★ 4.2 | 50 | BULK-7f7887c5 |
| 19821 | Bulk Product 9d097f1a | Electronics | $488.97 | 443 | ★ 3.3 | 1 | BULK-5af25c2b |
| 19822 | Bulk Product 14d6a2a3 | Toys & Games | $708.46 | 360 | ★ 2.3 | 7 | BULK-3528eb26 |
| 19823 | Bulk Product 14af7dc4 | Home & Garden | $527.22 | 499 | ★ 2.4 | 16 | BULK-d0acd1e4 |
| 19824 | Bulk Product 27462006 | Books | $326.81 | 387 | ★ 4.9 | 34 | BULK-bfa920a9 |
| 19825 | Bulk Product a9d96c80 | Clothing | $660.08 | 37 | ★ 0.9 | 73 | BULK-b4d804f3 |
| 19826 | Bulk Product 664b3a21 | Clothing | $428.59 | 458 | ★ 4.9 | 0 | BULK-90776048 |
| 19827 | Bulk Product 7729b2fe | Home & Garden | $833.46 | 456 | ★ 4.1 | 8 | BULK-6be61576 |
| 19828 | Bulk Product b5ab8869 | Home & Garden | $801.21 | 101 | ★ 2.2 | 41 | BULK-8a2c1a38 |
| 19829 | Bulk Product 6232f3b8 | Home & Garden | $970.57 | 118 | ★ 3.5 | 47 | BULK-eb44ca29 |
| 19830 | Bulk Product d90ec00c | Clothing | $929.00 | 1 | ★ 2.0 | 74 | BULK-d434a029 |
| 19831 | Bulk Product a651b7c6 | Sports & Outdoors | $209.51 | 136 | ★ 1.7 | 79 | BULK-4ba167d4 |
| 19832 | Bulk Product 8da1be87 | Clothing | $315.08 | 420 | ★ 2.2 | 90 | BULK-2fdd8815 |
| 19833 | Bulk Product cc3f2470 | Books | $532.40 | 494 | ★ 3.1 | 35 | BULK-06a79f6e |
| 19834 | Bulk Product 73a9b617 | Clothing | $698.90 | 446 | ★ 0.7 | 2 | BULK-ed5d9993 |
| 19835 | Bulk Product d710c864 | Home & Garden | $128.66 | 155 | ★ 3.8 | 10 | BULK-7ec930e8 |
| 19836 | Bulk Product 72b439f0 | Books | $1,008.42 | 420 | ★ 4.3 | 18 | BULK-2563b051 |
| 19837 | Bulk Product 18de59d3 | Clothing | $572.82 | 244 | ★ 4.1 | 27 | BULK-9a1bfbdc |
| 19838 | Bulk Product 40e54ac7 | Clothing | $142.23 | 489 | ★ 1.3 | 29 | BULK-b71799f8 |
| 19839 | Bulk Product 1d733388 | Electronics | $797.66 | 276 | ★ 3.2 | 49 | BULK-efc86b7a |
| 19840 | Bulk Product 6f2c5e68 | Books | $322.68 | 41 | ★ 4.1 | 11 | BULK-1895152d |
| 19841 | Bulk Product c7c577f0 | Sports & Outdoors | $629.22 | 330 | ★ 3.3 | 90 | BULK-b66bf248 |
| 19842 | Bulk Product e695921a | Home & Garden | $75.28 | 275 | ★ 2.3 | 99 | BULK-442fbb1e |
| 19843 | Bulk Product 9b359da6 | Clothing | $152.64 | 395 | ★ 4.2 | 30 | BULK-1abb9e1c |
| 19844 | Bulk Product 172790fc | Books | $177.09 | 323 | ★ 1.4 | 85 | BULK-f6c81322 |
| 19845 | Bulk Product e493f363 | Toys & Games | $793.00 | 1 | ★ 4.5 | 87 | BULK-0410c1a1 |
| 19846 | Bulk Product 2c1941c0 | Books | $955.88 | 350 | ★ 0.5 | 35 | BULK-7c67f391 |
| 19847 | Bulk Product 03f75c56 | Home & Garden | $442.23 | 23 | ★ 2.0 | 90 | BULK-288d39e1 |
| 19848 | Bulk Product 57551a85 | Toys & Games | $52.89 | 294 | ★ 1.6 | 41 | BULK-c35ca783 |
| 19849 | Bulk Product 11bb813c | Electronics | $803.51 | 179 | ★ 4.7 | 80 | BULK-cb533f90 |
| 19850 | Bulk Product bd0467f6 | Electronics | $447.68 | 104 | ★ 4.6 | 1 | BULK-d1b9597b |
| 19851 | Bulk Product b16a3903 | Books | $912.34 | 322 | ★ 2.8 | 2 | BULK-85fe1708 |
| 19852 | Bulk Product 627fb990 | Toys & Games | $195.12 | 147 | ★ 1.4 | 15 | BULK-2e186f05 |
| 19853 | Bulk Product c72c1430 | Books | $788.53 | 319 | ★ 0.5 | 92 | BULK-78d2d5bc |
| 19854 | Bulk Product 592d8fa6 | Home & Garden | $195.93 | 72 | ★ 4.6 | 94 | BULK-783234ff |
| 19855 | Bulk Product e1b55e1e | Clothing | $578.95 | 176 | ★ 3.7 | 54 | BULK-32a53ed3 |
| 19856 | Bulk Product b8118554 | Home & Garden | $899.85 | 344 | ★ 3.5 | 94 | BULK-9c22058e |
| 19857 | Bulk Product 616a008d | Clothing | $60.26 | 54 | ★ 3.2 | 75 | BULK-d4676815 |
| 19858 | Bulk Product 3bfa6aad | Toys & Games | $658.40 | 427 | ★ 2.5 | 93 | BULK-16babcbd |
| 19859 | Bulk Product 3c4d2b2c | Toys & Games | $614.86 | 306 | ★ 1.8 | 71 | BULK-e35937bb |
| 19860 | Bulk Product 555dde41 | Home & Garden | $250.23 | 72 | ★ 1.1 | 97 | BULK-f6f7a755 |
| 19861 | Bulk Product 97ed1e3a | Sports & Outdoors | $766.81 | 437 | ★ 1.0 | 44 | BULK-6f66deca |
| 19862 | Bulk Product 839466af | Books | $272.09 | 294 | ★ 2.2 | 57 | BULK-980ec95f |
| 19863 | Bulk Product 08d2976c | Electronics | $137.79 | 143 | ★ 0.8 | 2 | BULK-378c46d4 |
| 19864 | Bulk Product affbd540 | Home & Garden | $281.95 | 216 | ★ 3.8 | 47 | BULK-6b6ecaa5 |
| 19865 | Bulk Product 32bdc2b3 | Home & Garden | $449.11 | 465 | ★ 1.3 | 95 | BULK-fdee6d7c |
| 19866 | Bulk Product ae3733a2 | Toys & Games | $572.25 | 383 | ★ 0.3 | 78 | BULK-badf3cf4 |
| 19867 | Bulk Product b6422d53 | Clothing | $290.14 | 75 | ★ 4.4 | 55 | BULK-e5796cc1 |
| 19868 | Bulk Product 810df8c7 | Books | $279.32 | 316 | ★ 1.2 | 43 | BULK-4e91177d |
| 19869 | Bulk Product 4b5fe02e | Home & Garden | $594.92 | 298 | ★ 0.5 | 19 | BULK-b6670bf4 |
| 19870 | Bulk Product b5da8d89 | Home & Garden | $453.27 | 122 | ★ 1.5 | 94 | BULK-1e614e19 |
| 19871 | Bulk Product 30a4eb03 | Sports & Outdoors | $866.02 | 252 | ★ 1.2 | 59 | BULK-a191084d |
| 19872 | Bulk Product 28763b49 | Home & Garden | $659.22 | 403 | ★ 2.9 | 59 | BULK-502c2420 |
| 19873 | Bulk Product 671b285e | Clothing | $935.12 | 460 | ★ 4.2 | 31 | BULK-cd7a109e |
| 19874 | Bulk Product 5e91a10d | Books | $492.51 | 493 | ★ 4.7 | 48 | BULK-4ee3bf0a |
| 19875 | Bulk Product 53c8e014 | Electronics | $189.45 | 11 | ★ 1.4 | 94 | BULK-5ed18321 |
| 19876 | Bulk Product eb5dd840 | Electronics | $279.19 | 490 | ★ 3.3 | 35 | BULK-d853fe08 |
| 19877 | Bulk Product a8e4c1e1 | Home & Garden | $995.98 | 203 | ★ 1.8 | 99 | BULK-d013af19 |
| 19878 | Bulk Product acf3fe29 | Sports & Outdoors | $65.19 | 231 | ★ 1.0 | 15 | BULK-99eaa2ee |
| 19879 | Bulk Product 87352fe0 | Home & Garden | $500.50 | 291 | ★ 0.9 | 26 | BULK-4fa690b0 |
| 19880 | Bulk Product 2adac319 | Clothing | $598.11 | 292 | ★ 4.0 | 38 | BULK-cd55f484 |
| 19881 | Bulk Product d1f28d91 | Toys & Games | $617.38 | 415 | ★ 4.6 | 81 | BULK-6f799c06 |
| 19882 | Bulk Product 5c1885e4 | Toys & Games | $35.43 | 219 | ★ 0.6 | 13 | BULK-a6d28806 |
| 19883 | Bulk Product ce2633bc | Electronics | $222.55 | 270 | ★ 4.0 | 21 | BULK-a96ed0a4 |
| 19884 | Bulk Product d28d2561 | Books | $296.33 | 412 | ★ 2.8 | 32 | BULK-a176f138 |
| 19885 | Bulk Product c1844824 | Toys & Games | $24.49 | 63 | ★ 2.4 | 80 | BULK-9da79ba6 |
| 19886 | Bulk Product 7f1f4756 | Sports & Outdoors | $551.71 | 313 | ★ 2.6 | 35 | BULK-5dbfcd72 |
| 19887 | Bulk Product 2e46e00f | Books | $218.22 | 498 | ★ 4.4 | 72 | BULK-ee8d1358 |
| 19888 | Bulk Product a7624b6a | Toys & Games | $843.16 | 382 | ★ 0.2 | 50 | BULK-28052bdb |
| 19889 | Bulk Product 91170f55 | Clothing | $747.80 | 339 | ★ 2.6 | 90 | BULK-42a74970 |
| 19890 | Bulk Product 6be5a774 | Electronics | $622.52 | 456 | ★ 0.5 | 54 | BULK-7c5eccb2 |
| 19891 | Bulk Product 21d103e7 | Books | $922.51 | 320 | ★ 0.5 | 50 | BULK-6872ed74 |
| 19892 | Bulk Product cb7067f9 | Home & Garden | $882.12 | 244 | ★ 0.0 | 34 | BULK-43e911a0 |
| 19893 | Bulk Product 8ba79e99 | Electronics | $32.72 | 233 | ★ 2.0 | 17 | BULK-371c9562 |
| 19894 | Bulk Product c8069233 | Clothing | $971.33 | 442 | ★ 1.7 | 23 | BULK-260c9827 |
| 19895 | Bulk Product 8e36d2cd | Sports & Outdoors | $765.26 | 379 | ★ 4.1 | 38 | BULK-8834a1d4 |
| 19896 | Bulk Product 320400a3 | Home & Garden | $593.26 | 66 | ★ 2.8 | 42 | BULK-02b78e26 |
| 19897 | Bulk Product b70dd52b | Books | $237.90 | 173 | ★ 3.6 | 55 | BULK-b936aed4 |
| 19898 | Bulk Product 30cdbf8a | Home & Garden | $706.29 | 108 | ★ 4.7 | 30 | BULK-9f6c7290 |
| 19899 | Bulk Product 22c7e54b | Home & Garden | $898.72 | 309 | ★ 4.8 | 45 | BULK-3f99d222 |
| 19900 | Bulk Product 1e5fc0c8 | Books | $969.19 | 488 | ★ 3.9 | 8 | BULK-7d6ab177 |
| 19901 | Bulk Product 418e50a8 | Home & Garden | $652.67 | 113 | ★ 2.8 | 4 | BULK-75b938f2 |
| 19902 | Bulk Product 78aa2458 | Clothing | $511.26 | 171 | ★ 0.2 | 27 | BULK-57d4deb8 |
| 19903 | Bulk Product f80fcf46 | Home & Garden | $18.72 | 363 | ★ 1.5 | 79 | BULK-02c3e357 |
| 19904 | Bulk Product a10a44b8 | Electronics | $292.61 | 217 | ★ 2.8 | 53 | BULK-8d83ff93 |
| 19905 | Bulk Product 972e6f86 | Toys & Games | $746.95 | 453 | ★ 0.8 | 1 | BULK-5e56ebf2 |
| 19906 | Bulk Product 441ccec5 | Sports & Outdoors | $717.37 | 177 | ★ 0.8 | 95 | BULK-5446821a |
| 19907 | Bulk Product a144dd40 | Home & Garden | $547.34 | 359 | ★ 3.9 | 76 | BULK-dc43856a |
| 19908 | Bulk Product 1578cbad | Clothing | $560.15 | 397 | ★ 0.4 | 22 | BULK-b5c991fe |
| 19909 | Bulk Product 0cd4f446 | Home & Garden | $595.36 | 68 | ★ 0.6 | 90 | BULK-5bc19392 |
| 19910 | Bulk Product d553097b | Books | $832.41 | 25 | ★ 3.1 | 56 | BULK-8240771b |
| 19911 | Bulk Product 7f3907e4 | Home & Garden | $755.32 | 331 | ★ 1.5 | 91 | BULK-546b5644 |
| 19912 | Bulk Product 49d25e3f | Clothing | $650.91 | 258 | ★ 4.1 | 6 | BULK-9cb1fdc8 |
| 19913 | Bulk Product 3f06a883 | Sports & Outdoors | $447.71 | 490 | ★ 4.6 | 82 | BULK-0d138266 |
| 19914 | Bulk Product 12d605e7 | Sports & Outdoors | $825.25 | 386 | ★ 1.7 | 52 | BULK-55cb95e9 |
| 19915 | Bulk Product 5fa6f0d2 | Books | $961.42 | 81 | ★ 4.1 | 58 | BULK-8e2befe3 |
| 19916 | Bulk Product e2c39073 | Books | $322.93 | 455 | ★ 3.9 | 50 | BULK-da07fb82 |
| 19917 | Bulk Product bd5a94dc | Books | $435.78 | 402 | ★ 1.4 | 44 | BULK-9a5d439b |
| 19918 | Bulk Product 87c46ecc | Electronics | $447.77 | 5 | ★ 3.9 | 48 | BULK-56ad9ff8 |
| 19919 | Bulk Product 8a870874 | Sports & Outdoors | $935.87 | 164 | ★ 5.0 | 96 | BULK-89ca2bc9 |
| 19920 | Bulk Product c5bb8458 | Electronics | $48.93 | 115 | ★ 4.1 | 20 | BULK-29752ece |
| 19921 | Bulk Product b43b1a00 | Electronics | $49.86 | 476 | ★ 2.5 | 87 | BULK-843ad966 |
| 19922 | Bulk Product eba377ff | Home & Garden | $926.38 | 493 | ★ 4.8 | 4 | BULK-820af19e |
| 19923 | Bulk Product 0a0fcab2 | Home & Garden | $108.63 | 83 | ★ 1.0 | 25 | BULK-99eb96ad |
| 19924 | Bulk Product 331b02a5 | Electronics | $460.51 | 31 | ★ 3.1 | 77 | BULK-24820e4b |
| 19925 | Bulk Product 1fd9609e | Sports & Outdoors | $54.96 | 254 | ★ 4.6 | 8 | BULK-cb97d4d8 |
| 19926 | Bulk Product 45a81c70 | Toys & Games | $747.24 | 246 | ★ 1.7 | 56 | BULK-fd0fd9c6 |
| 19927 | Bulk Product 4bb9a4ba | Books | $114.96 | 415 | ★ 5.0 | 2 | BULK-d983287f |
| 19928 | Bulk Product 1fca1de2 | Books | $399.86 | 215 | ★ 4.6 | 88 | BULK-b8cc22fd |
| 19929 | Bulk Product 404929e4 | Home & Garden | $873.34 | 495 | ★ 3.0 | 27 | BULK-34b92d2c |
| 19930 | Bulk Product 36e22cbd | Books | $101.55 | 485 | ★ 2.4 | 48 | BULK-bcea5ea1 |
| 19931 | Bulk Product 7c83d4d7 | Electronics | $798.13 | 453 | ★ 3.6 | 34 | BULK-a979da90 |
| 19932 | Bulk Product 475ae08d | Electronics | $498.71 | 168 | ★ 1.7 | 60 | BULK-48c71803 |
| 19933 | Bulk Product d797a794 | Toys & Games | $738.13 | 127 | ★ 2.2 | 36 | BULK-49aea9a0 |
| 19934 | Bulk Product e802d2a0 | Books | $443.91 | 458 | ★ 1.9 | 68 | BULK-15939c8f |
| 19935 | Bulk Product 4e309a40 | Books | $280.25 | 311 | ★ 3.3 | 87 | BULK-73c8d646 |
| 19936 | Bulk Product 41be9769 | Toys & Games | $624.05 | 106 | ★ 4.3 | 23 | BULK-ddac535e |
| 19937 | Bulk Product 0681d2dd | Books | $255.08 | 31 | ★ 0.1 | 38 | BULK-9e463312 |
| 19938 | Bulk Product 21313efa | Sports & Outdoors | $620.61 | 465 | ★ 0.7 | 98 | BULK-76a94d9c |
| 19939 | Bulk Product 3e8fbf9b | Toys & Games | $333.29 | 292 | ★ 3.5 | 7 | BULK-a397f91a |
| 19940 | Bulk Product 745cb988 | Sports & Outdoors | $204.13 | 338 | ★ 1.1 | 76 | BULK-ddf6c228 |
| 19941 | Bulk Product 6c6e8237 | Toys & Games | $61.44 | 486 | ★ 1.1 | 23 | BULK-0d4b3985 |
| 19942 | Bulk Product dd2c12a1 | Clothing | $898.80 | 46 | ★ 4.1 | 33 | BULK-b1f62e49 |
| 19943 | Bulk Product c529e9e8 | Sports & Outdoors | $288.20 | 474 | ★ 2.1 | 28 | BULK-0bde4bb7 |
| 19944 | Bulk Product f7f6e6e5 | Home & Garden | $237.07 | 168 | ★ 2.8 | 64 | BULK-795da64f |
| 19945 | Bulk Product df853c4a | Books | $569.99 | 124 | ★ 1.2 | 17 | BULK-ea49620e |
| 19946 | Bulk Product c4d22a62 | Sports & Outdoors | $388.54 | 120 | ★ 0.9 | 88 | BULK-fc58e184 |
| 19947 | Bulk Product a1478c1c | Home & Garden | $117.87 | 379 | ★ 2.6 | 6 | BULK-8b7f4bd5 |
| 19948 | Bulk Product d65925de | Clothing | $735.15 | 47 | ★ 2.6 | 31 | BULK-b1e1b149 |
| 19949 | Bulk Product 65d3b055 | Sports & Outdoors | $309.99 | 496 | ★ 2.2 | 28 | BULK-078bb201 |
| 19950 | Bulk Product 3301c4b0 | Books | $95.44 | 59 | ★ 1.3 | 3 | BULK-d0e8f5ce |
| 19951 | Bulk Product 59251112 | Electronics | $164.51 | 67 | ★ 2.1 | 97 | BULK-0453bb41 |
| 19952 | Bulk Product b143d4a4 | Toys & Games | $745.85 | 66 | ★ 0.0 | 11 | BULK-e75814c1 |
| 19953 | Bulk Product 063e0bbc | Books | $649.37 | 465 | ★ 3.2 | 98 | BULK-ad1f61c0 |
| 19954 | Bulk Product 81447ffb | Toys & Games | $377.87 | 89 | ★ 4.3 | 30 | BULK-3a379ec1 |
| 19955 | Bulk Product cfc40ff3 | Toys & Games | $241.81 | 32 | ★ 2.0 | 72 | BULK-912ad8e8 |
| 19956 | Bulk Product 06e1c587 | Clothing | $486.64 | 408 | ★ 2.2 | 10 | BULK-2252e271 |
| 19957 | Bulk Product 62799483 | Toys & Games | $771.83 | 420 | ★ 4.8 | 44 | BULK-c553e171 |
| 19958 | Bulk Product c57d7258 | Home & Garden | $379.99 | 180 | ★ 0.5 | 26 | BULK-88ce00c2 |
| 19959 | Bulk Product 7d01b02e | Electronics | $533.18 | 256 | ★ 3.3 | 82 | BULK-f1a3aaf3 |
// 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
};
}