(0)
SEARCH

SAXX

SELECT p.*, vo.Item_Price1,vo.Item_Price2 ,vo.samefldALU FROM qc_products as p, qc_productInCategories as pc,qc_categories as c, qc_variantOptions AS vo, qc_variants AS v WHERE p.productId = pc.productId AND v.productId = p.productId and pc.categoryId=c.categoryId AND v.variantId = vo.variantId AND c.parentCategoryId = 5 AND p.productId IN(11314,11322,11575,11312,11321,11505,13471,11694,11316,208,13434,12885,90,2934,6117,12841,13436,12889,12203,11588,12516,12580,13116,13121,13717,11135,12896,12667,940,821,12823,13883,12843,12523,12842,1049,146,2930,424,3754,11138,12514,12513,11315,11313,843,6454,5532,10003,622,11407,13887,12856,12529,12830,12694,13463,13452,231,12892,13433,163,140,2925,2924,5386,2926,6118,12867,12863,12202,12522,12552,13118,13117,13701,12792,11394,12833,12521,12691,13462,425,12884,13468,166,12834,12883,12528,12608,13120,6455,10004,10005,10020,11690,12895,11358,3749,13458,5528,8824,11157,11693,12898,12484,12658,12676,1001,12790,13192,182,8068,567,941,12690,7127,13147,13530,11659,1980,12574,5313,533,13012,12983,13024,13029,13042,12995,12986,12993,2133,13723,13036,4472,9370,5317,262,5330,13726,9359,2,9127,7755,11572,12551,7547,11747,11763,10679,11451,21,12662,11626,12665,13259,13100,13265,8268,12669,12680,8267,176,39,592,1698,12785,915,8,11288,2759,2760,11359,11331,7504,10869,5332,420,5307,13286,12788,13444,8204,12782,13445,5321,9846,807,924,9640,1127,1854,5302,11477,7769,11653,349,13392,13391,13480,13510,13511,13405,13409,12912,12964,5318,7371,6190,6471,6470,7368,6913,10009,8837,9431,9412,11649,787,295,12205,9492,9457,13177,43,12903,10166,12212,12200,10923,10927,10924,10874,8896,7702,7063,12243,11778,11787,11777,11783,1237,504,13765,13758,13762,11059,11417,11418,11422,11455,9185,9171,9353,5210,292,3904,3908,5126,5691,11956,1112,13052,13004,13056,13046,13115,13039,12997,13048,12994,13020,13377,12498,788,13520,13481,12899,350,11476,6672,6505,2677,117,169,526,13082,3412,194,6423,121,582,597,10111,10114,7820,7822,7823,9537,9542,987,12312,11708,13460,7824,7819,13178,10806,1059,13188,11740,487,5213,7515,12947,12837,12127,901,857,13304,13307,13302,949,601,545,13430,13459,842,248,12055,12056,6534,13802,6563,13820,12906,12829,12172,986,13806,13815,13811,13474,8850,463,13801,12188,188,4669,12340,4659,12306,8733,4635,12368,8716,12768,12369,12770,12376,3033,7625,7646,9647,11479,11334,13187,11333,11338,11480,6338,11329,6328,8551,11478,10282,11328,11332,11342,10812,10809,12427,10279,6980,13426,12769,12777,12622,12918,12914,12314,13437,9101,12213,5260,11921,114,13250,12410,12568,10307,10289,12072,12333,7238,10276,8553,12419,11584,725,9283,5628,12764,5627,9274,7500,12766,9757,6348,8574,8545,12074,12067,12732,9566,12264,7811,430,399,860,902,4,190,12573,12614,10139,48,10723,2828,10138,10140,12808,10918,10929,12597,12949,12953,13456,13435,12959,11601,12929,6642,12955,12902,13182,13189,11593,13439,11715,11721,10784,12857,12827,17,11091,11167,344,11595,11596,154,7219,158,4675,10946,10764,13306,13375,12226,12231,10044,4768,10884,10882,10890,13742,13740,12262,10849,11964,12465,13743,13738,11993,12233,12554,12576,12555,12566,12600,13378,13374,12229,12219,12273,11099,11102,11095,11980,12819,12362,12394,12752,12332,12396,12384,12304,12759,13258,12382,12383,12311,12757,12387,12390,12324,13737,12402,12406,12405,12403,12404,12407,1673,9521,13239,11152,12372,9514,10146,13246,11132,12359,13236,12977,13232,12974,8392,13238,12975,13229,12978,8635,8636,9212,12674,9194,12518,12517,12515,10401,10406,10426,12866,12858,12979,12980,12976,12981,13228,13208,13212,13242,13217,7700,13214,4355,10562,5343,13247,13241,4334,11151,13231,12126,11153,13219,12117,13234,13235,13216,13249,13245,12078,12129,12150,12178,2193,4425,13211,11570,11568,11208,11222,11569,2254,1667,1735,1432,3662,8601,8608,10839,10838,12811,12846,12861,12845,5803,12288,10939,10941,13084,13073,13707,11753,13628,12486,11713,11704,13067,13142,5833,12158,12095,12163,12060,12061,12062,13314,13311,13671,13697,13634,8290,8019,9484,9453,10724,9435,9269,9263,12678,12086,9262,12282,13449,9268,9384,13076,13878,11983,12504,13065,13879,12040,12496,9260,13893,11759,9832,11269,6380,13702,13698,13691,13630,13695,13648,13643,8729,6402,621,10847,11564,12705,12082,11352,12236,12704,12539,12965,10598,10623,7088,1421,8606,7771,7736,7767,8890,9839,9997,9995,12804,12786,12778,13096,13089,12063,520,1436,11347,13467,5316,12266,12269,12954,12926,600,1073,11699,9541,9221,12718,7577,710,13545,12329,13766,13768,11018,13798,2146,10756,13774,13788,13777,12303,13779,13739,12431,8085,10885,3366,11831,13683,13647,11636,13744,13741,4241,4253) AND c.name='SAXX' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
Shop By       
Shop By Colour:
    MAIN ITEM
  • SAXX Vibe Boxer Brief - 2 Pack
    S - XXL
    Checking inventory...
    SAXX Vibe Boxer Brief - 2 Pack
    $ 59.99
    SAXX Vibe Boxer Brief - 2 Pack
  • SAXX 3Six Five Boxer Brief
    S - XXL
    Checking inventory...
    SAXX 3Six Five Boxer Brief
    $ 34.95
    SAXX 3Six Five Boxer Brief
  • MAIN ITEM
  • SAXX Ultra Free Agent Loose Fit Boxer with Fly
    S - XXL
    Checking inventory...
    SAXX Ultra Free Agent Loose Fit Boxer with Fly
    $ 34.95
    SAXX Ultra Free Agent Loose Fit Boxer with Fly
  • MAIN ITEM
  • SAXX Ultra Free Agent Loose Fit Boxer with Fly
    S - XXL
    Checking inventory...
    SAXX Ultra Free Agent Loose Fit Boxer with Fly
    $ 36.95
    SAXX Ultra Free Agent Loose Fit Boxer with Fly
  • MAIN ITEM
  • SAXX Ultra Boxer Brief with Fly
    S - XXL
    Checking inventory...
    SAXX Ultra Boxer Brief with Fly
    $ 33.95
    SAXX Ultra Boxer Brief with Fly
  • MAIN ITEM
  • SAXX Quest 2.0 Boxer Brief with Fly
    S - XXL
    Checking inventory...
    SAXX Quest 2.0 Boxer Brief with Fly
    $ 35.95
    SAXX Quest 2.0 Boxer Brief with Fly
  • MAIN ITEM
  • SAXX Fuse Boxer Brief
    S - XXL
    Checking inventory...
    SAXX Fuse Boxer Brief
    $ 33.95
    SAXX Fuse Boxer Brief
  • MAIN ITEMNEW ITEM
  • SAXX Impact Boxer Brief
    S - XXL
    Checking inventory...
    SAXX Impact Boxer Brief
    $ 31.95
    SAXX Impact Boxer Brief
  • MAIN ITEMNEW ITEM
  • SAXX Kinetic Boxer Brief
    S - XXL
    Checking inventory...
    SAXX Kinetic Boxer Brief
    $ 37.95
    SAXX Kinetic Boxer Brief
  • MAIN ITEM
  • SAXX Kinetic Long Leg Boxer Brief
    S - XXL
    Checking inventory...
    SAXX Kinetic Long Leg Boxer Brief
    $ 39.95
    SAXX Kinetic Long Leg Boxer Brief
  • MAIN ITEMNEW ITEM
  • SAXX Platinum Boxer Brief with Fly
    S - XXL
    Checking inventory...
    SAXX Platinum Boxer Brief with Fly
    $ 36.95
    SAXX Platinum Boxer Brief with Fly
  • MAIN ITEMNEW ITEM
  • SAXX Vibe Boxer Brief
    S - XXL
    Checking inventory...
    SAXX Vibe Boxer Brief
    $ 33.95
    SAXX Vibe Boxer Brief
  • MAIN ITEM
  • SAXX Vibe Modern Fit Boxer Brief
    S - XXL
    Checking inventory...
    SAXX Vibe Modern Fit Boxer Brief
    $ 32.99
    SAXX Vibe Modern Fit Boxer Brief