Array
(
    [filter_category_id] => 233
    [filter_filter] => 
    [sort] => p.sort_order
    [order] => ASC
    [start] => 0
    [limit] => 10000
    [pagelimit] => 24
    [page] => 1
    [attributes] => Array
        (
            [0] => padangos-tracmax-x-privilo-tx3-205-45-r16-87-w-xl
            [1] => gamintojas-bridgestone
            [2] => dregme-b
        )

)
TestTSELECT p.product_id, p.price AS sprice, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, pd.url FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '233' AND p.product_id IN (20210,20211,20213,20215,20216,20217,20218,20229,20260,20268,20308,20313,20317,20321,20341,20342,20352,20362,20363,22906,16690,16697,16754,16786,16799,16749,20226) AND p.quantity > 0 GROUP BY p.product_id ORDER BY CASE WHEN p.quantity <= 0 THEN 1 ELSE 0 END, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,10000TestTSELECT p.product_id, p.price AS sprice, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, pd.url FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '233' AND p.product_id IN (16624,16625,16626,16627,16628,16629,16630,16631,16632,16633,16634,16635,16636,16637,16638,16639,16640,16641,16642,16643,16644,16645,16646,16647,16648,16649,16650,16651,16652,16653,16654,16655,16656,16657,16658,16659,16660,16661,16662,16663,16664,16665,16666,16667,16668,16669,16670,16671,16672,16673,16690,16697,16749,16754,16786,16799,18032,18033,18038,18039,18042,18045,18046,18048,18052,18053,18054,18058,18063,18064,18065,18066,18068,18069,18070,18072,18074,18079,18086,18087,18094,18098,18099,18100,18112,18113,18116,18117,18120,18122,18124,18127,18130,18131,18132,18133,18135,18136,18137,18140,18145,18146,18147,18152,18154,18158,18159,18160,18161,18163,18166,18167,18171,18172,18173,18179,18180,18181,18182,18185,18189,18191,18192,18193,18194,18195,18196,18197,18198,18199,18200,18201,18202,18203,18204,18205,18206,18207,18208,18209,18210,18211,18212,18213,18215,18216,18217,18218,18219,18220,18221,18222,18223,18225,18226,18230,18231,18232,18237,18238,18244,18247,18251,18252,18257,18259,18260,18262,18265,18266,18278,18279,18280,18300,18307,18308,18309,18310,18311,18312,18313,18314,18315,18316,18317,18318,18319,18320,18321,18322,18323,18324,18325,18326,18327,18328,18329,18330,18331,18332,18333,18334,18335,18336,18337,18338,18339,18340,18341,18342,18343,18344,18345,18346,18347,18348,18349,18350,18351,18352,18353,18354,18355,18356,18357,18358,18359,18360,18361,18362,18363,18364,18365,18366,18367,18368,18369,18370,18371,18372,18373,18374,18375,18376,18377,18378,18379,18380,18381,18382,18383,18384,18385,18386,18387,18388,18389,18390,18391,18392,18393,18394,18395,18396,18397,18398,18399,18400,18401,18402,18403,18404,18405,18406,18407,18408,18409,18410,18411,18412,18413,18414,18415,18416,18417,18418,18419,18420,18422,18423,18424,18425,18426,18427,18428,18497,18498,18499,18500,18501,18502,18503,18504,18505,18506,18507,18508,18509,18510,18513,18518,18519,18525,18528,18529,18530,18531,18535,18536,18537,18539,18541,18542,18545,18547,18549,18550,18551,18552,18553,18554,18558,18559,18563,18565,18566,18568,18570,18571,18572,18573,18574,18575,18576,18577,18578,18579,18580,18581,18582,18583,18584,18585,18586,18587,18588,18589,18590,18591,18592,18593,18594,18595,18596,18597,18598,18599,18600,18601,18602,18603,18604,18605,18606,18607,18608,18609,18610,18611,18612,18613,18614,18615,18616,18617,18618,18619,18620,18621,18622,18623,18624,18625,18626,18627,18628,18629,18630,18631,18632,18633,18634,18680,18681,18682,18683,18684,18685,18686,18687,18688,18689,18690,18691,18692,18754,18755,18756,18758,18759,18761,18762,18763,18764,18765,18766,18767,18768,18769,18770,18771,18772,18773,18774,18778,18779,18780,18781,18782,18783,18784,18788,18790,18791,18793,18794,18796,18799,18800,18801,18802,18805,18807,18808,18809,18810,18811,18812,18813,18814,18815,18816,18818,18820,18821,18822,18823,18824,18826,18827,18828,18830,18831,18832,18833,18834,18835,18836,18837,18840,18841,18842,18843,18844,18845,18846,18848,18849,18850,18851,18854,18857,18862,18863,18866,18867,18868,18869,18870,18871,18872,18873,18874,18876,18878,18880,18881,18882,18885,18892,18894,18897,18902,18908,18916,18919,18930,18935,18946,18947,18948,18949,18950,18951,18952,18953,18954,18955,18956,18957,18958,18959,18960,18961,18962,18963,18964,18965,18966,18967,18968,18969,18970,18971,18972,18973,18974,18975,18976,18977,18978,18979,18980,18981,18982,18983,18984,18985,18986,18987,18988,18989,18990,18991,18992,18993,18994,18995,18996,18997,18998,18999,19000,19001,19002,19003,19004,19005,19006,19007,19008,19009,19010,19011,19012,19013,19014,19015,19016,19017,19018,19019,19020,19021,19022,19023,19024,19025,19026,19027,19028,19029,19030,19031,19032,19033,19034,19035,19036,19037,19038,19039,19040,19041,19042,19043,19044,19045,19046,19047,19048,19049,19050,19051,19052,19053,19054,19055,19056,19057,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19095,19132,19133,19134,19135,19136,19137,19138,19139,19140,19141,19142,19143,19144,19145,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19287,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19336,19337,19338,19339,19340,19341,19342,19343,19344,19345,19346,19347,19348,19349,19350,19351,19352,19353,19354,19355,19356,19357,19358,19359,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19375,19376,19377,19378,19379,19380,19383,19384,19385,19386,19387,19388,19389,19391,19392,19393,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19407,19408,19409,19410,19411,19412,19413,19414,19415,19416,19417,19418,19419,19420,19421,19422,19423,19424,19425,19426,19427,19431,19435,19436,19438,19443,19447,19448,19449,19451,19455,19456,19459,19465,19485,19488,19493,19615,19618,19620,19624,19625,19626,19627,19629,19630,19631,19655,19669,19670,19671,19672,19673,19674,19675,19678,19679,19680,19681,19730,19735,19736,19738,19772,19773,19776,19787,19789,19799,19800,19802,19805,19807,19812,19813,19814,19815,19816,19817,19819,19823,19824,19828,19829,19830,19831,19834,19836,19837,19839,19841,19842,19849,19851,19855,19856,19858,19895,19919,19921,19924,19925,19929,19936,19940,19943,20015,20016,20017,20018,20019,20020,20021,20022,20023,20024,20025,20026,20027,20028,20029,20030,20031,20032,20033,20034,20035,20036,20037,20038,20039,20040,20041,20042,20043,20044,20045,20046,20047,20048,20049,20050,20051,20052,20053,20054,20055,20056,20057,20058,20059,20060,20061,20062,20063,20064,20065,20066,20067,20068,20069,20070,20071,20072,20073,20074,20075,20076,20077,20078,20079,20080,20081,20082,20083,20084,20085,20086,20087,20088,20089,20090,20091,20092,20093,20094,20095,20096,20097,20098,20099,20100,20101,20102,20103,20104,20105,20106,20107,20108,20109,20110,20111,20112,20113,20114,20115,20116,20117,20118,20119,20120,20121,20122,20123,20124,20125,20126,20127,20128,20129,20130,20131,20132,20133,20134,20135,20136,20137,20138,20139,20140,20141,20142,20143,20144,20145,20179,20180,20181,20182,20183,20184,20185,20186,20187,20188,20189,20190,20191,20192,20193,20194,20195,20196,20197,20198,20199,20200,20201,20202,20203,20204,20205,20206,20207,20208,20209,20210,20211,20213,20215,20216,20217,20218,20226,20229,20260,20268,20308,20313,20317,20321,20341,20342,20352,20362,20363,20376,20377,20387,20388,20389,20391,20392,20393,20394,20395,20396,20398,20399,20402,20403,20405,20407,20409,20411,20414,20416,20417,20426,20430,20435,20436,20438,20444,20447,20449,20450,20453,20457,20458,20468,20479,20486,20496,20497,20498,20506,20507,20539,20550,20560,20569,20570,20595,20598,20599,20602,20604,20607,20610,20611,20614,20616,20618,20619,20620,20621,20623,20624,20625,20627,20628,20629,20630,20631,20633,20634,20639,20642,20643,20645,20652,20653,20657,20658,20660,20661,20663,20664,20665,20666,20667,20668,20669,20670,20671,20672,20678,20685,20708,20709,20711,20731,20732,20737,20742,20750,20791,20851,20852,20880,20883,20885,20886,20892,20897,20899,20905,20906,20907,20915,20919,20920,20921,20922,20923,20925,20926,20927,20928,20929,20930,20931,20933,20934,20935,20936,20937,20973,20974,20975,20977,20980,20983,21005,21006,21052,21053,21054,21055,21056,21057,21058,21059,21066,21067,21068,21069,21070,21071,21072,21073,21074,21075,21076,21077,21078,21079,21080,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21091,21092,21093,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21105,21107,21112,21117,21121,21122,21123,21124,21127,21128,21129,21133,21134,21135,21137,21138,21141,21143,21149,21152,21154,21156,21157,21158,21161,21162,21164,21165,21166,21167,21168,21169,21170,21171,21179,21181,21183,21184,21185,21186,21188,21193,21197,21200,21216,21244,21251,21254,21269,21275,21316,21319,21321,21322,21349,21350,21351,21352,21353,21355,21356,21357,21358,21359,21360,21362,21363,21364,21365,21366,21367,21389,21397,21400,21406,21408,21410,21412,21415,21417,21421,21422,21425,21428,21430,21432,21433,21435,21438,21439,21440,21442,21443,21445,21447,21448,21449,21450,21451,21452,21453,21454,21460,21461,21462,21465,21467,21468,21469,21470,21471,21472,21473,21474,21477,21478,21479,21482,21487,21491,21494,21497,21499,21502,21503,21505,21508,21511,21518,21567,21568,21569,21570,21571,21572,21590,21591,21596,21622,21625,21626,21663,21664,21665,21666,21668,21709,21711,21716,21717,21718,21719,21779,21874,21878,21882,21888,21890,21892,21893,21910,21911,21914,21915,21916,21917,21918,21919,21920,21921,21922,21923,21924,21925,21926,21927,21928,21929,21930,21957,22002,22021,22026,22036,22063,22066,22077,22088,22091,22092,22094,22100,22101,22102,22107,22108,22109,22113,22114,22115,22117,22118,22119,22124,22129,22130,22132,22134,22135,22139,22143,22148,22149,22150,22154,22155,22156,22160,22161,22162,22173,22174,22175,22176,22177,22178,22187,22190,22205,22238,22241,22288,22320,22322,22332,22335,22339,22341,22345,22348,22356,22364,22370,22373,22379,22383,22384,22390,22393,22396,22397,22398,22447,22499,22500,22501,22502,22503,22504,22505,22506,22507,22508,22509,22510,22511,22512,22513,22514,22515,22516,22517,22518,22519,22520,22521,22522,22523,22524,22525,22526,22527,22528,22529,22530,22531,22532,22533,22534,22535,22536,22537,22538,22539,22540,22541,22542,22543,22544,22545,22546,22547,22548,22549,22550,22551,22552,22553,22554,22555,22556,22557,22561,22562,22569,22570,22571,22572,22573,22575,22576,22578,22580,22582,22583,22585,22586,22587,22588,22589,22590,22591,22592,22593,22595,22596,22598,22599,22600,22601,22602,22603,22604,22605,22606,22607,22609,22610,22615,22618,22624,22626,22629,22632,22634,22636,22646,22647,22648,22650,22653,22654,22655,22656,22657,22661,22663,22664,22665,22667,22669,22670,22671,22674,22675,22676,22677,22678,22679,22680,22681,22682,22683,22684,22685,22686,22687,22690,22694,22695,22696,22697,22698,22701,22702,22703,22704,22706,22707,22714,22717,22718,22719,22721,22722,22726,22729,22730,22731,22732,22735,22738,22740,22741,22754,22755,22756,22757,22758,22759,22760,22761,22762,22763,22764,22766,22775,22776,22782,22786,22793,22796,22798,22799,22805,22816,22820,22821,22825,22833,22842,22843,22848,22849,22850,22851,22852,22853,22854,22855,22906,22928,22929,22930,22931,22932,22933,22934,22935,22936,22937,22938,22939,22940,22941,22942,22943,22944,22945,22946,22947,22948,22949,22950,22951,22952,22953,22954,22955,22956,22957,22958,22959,22960,22961,22962,22963,22964,22965,22966,22967,22968,22969,22970,22971,22972,22973,22974,22975,22976,22977,22978,22979,22980,22981,22982,22983,22984,22985,22986,22987,22988,22989,22990,22991,22992,22993,22994,22995,22996,22997,22998,22999,23000,23001,23003,23004,23005,23006,23007,23008,23009,23010,23011,23012,23013,23014,23015,23016,23017,23018,23020,23104,23105,23106,23107,23108,23109,23110,23111,23112,23113,23114,23115,23116,23117,23118,23119,23120,23121,23122,23123,23124,23125,23126,23127,23128,23129,23130,23131,23132,23133,23134,23135,23136,23137,23139,23143,23162,23163,23164,23165,23166,23167,23168,23169,23170,23171,23172,23173,23174,23175,23176,23177,23178,23179,23180,23181,23182,23183,23184,23185,23186,23187,23188,23189,23190,23191,23192,23193,23194,23195,23196,23197,23198,23199,23200,23201,23202,23203,23204,23205,23206,23207,23208,23210,23211,23212,23213,23214,23215,23216,23217,23218,23219,23220,23221,23222,23223,23224,23225,23226,23227,23229,23230,23231,23232,23233,23234,23235,23236,23237,23238,23239,23240,23241,23242,23243,23244,23280,23281,23282,23283,23284,23299,23317,23318,23319,23320,23321,23323,23324,23325,23326,23329,23332,23333,23334,23335,23336,23337,23338,23339,23340,23341,23342,23343,23344,23345,23346,23347,23348,23350,23371,23372,23373,23374,23375,23376,23377,23378,23379,23380,23381,23382,23383,23384,23385,23386,23387,23388,23389,23390,23391,23393,23395,23400,23403,23408,23419,23420,23421,23422,23423,23424,23425,23426,23428,23429,23430,23434,23435,23505,23506,23507,23552,23553,23554,23555,23556,23557,23558,23559,23560,23574,23581,23582,23583,23584,23585,23586,23587,23588,23589,23590,23605,23606,23607,23654,23660,23661,23662,23663,23664,23665,23666,23667,23668,23669,23670,23671,23672,23673,23674,23675,23677,23678,23679,23680,23681,23682,23683,23684,23685,23686,23692,23693,23694,23695,23696,23722,23723,23724,23725,23726,23727,23728,23729,23730,23731,23732,23733,23734,23735,23736,23737,23738,23740,23741,23742,23743,23744,23745,23746,23747,23748,23749,23750,23751,23752,23753,23754,23755,23756,23757,23758,23759,23760,23761,23762,23763,23764,23765,23766,23768,23769,23770,23771,23772,23773,23774,24987,24988,24989,24990,24991,24992,24993,24994,24995,24996,24997,24998,24999,25000,25001,25002,25042,25043,25044,25045,25046,25047,25048,25049,25050,25051,25052,25053,25054,25056,25057,25058,25059,25060,25061,25062,25063,25064,25065,25066,25067,25068,25069,25070,25071,25072,27486,27487,27488,27489,27490,27491,27492,27493,27494,27495,27496,27497,27499,27500,27501,27502,27503,27504,27505,27506,27507,27508,27509,27574,27575,27576,27577,27578,27579,27580,27581,27582,27583,27584,27585,27586,27587,27588,27589,27590,27591,27592,27593,27594,27595,27596,27597,27598,27599,27600,27601,27602,27603,27604,27605,27606,27607,27608,27609,27610,27611,27612,27613,27614,27615,27616,27617,27626,27627,27628,27629,27630,27631,27632,27633,27634,27635,27636,27637,27638,27639,27640,27641,27642,27643,27644,27645,27646,27647,27648,27649,27650,27651,27652,27653,27654,27655,27656,27657,27658,27659,27660,27663,27664,27665,27666,27667,27668,27669,27670,27671,27672,27673,27674,27675,27676,27677,27678,27679,27680,27681,27682,27683,27684,27693,27694,27696,27697,27698,27699,27700,27701,27702,27703,27704,27705,27706,27707,27708,27709,27710,27711,27712,27713,27714,27715,27716,27717,27718,27719,27720,27721,27722,27723,27724,27725,27726,27727,27774,27775,27776,27777,27778,27779,27780,27781,27782,27783,27784,27785,27786,27792,27793,27801,27803,27804,27805,27825,27826,27828,27893,27897,27902,27903,27912,27917,27918,27919,27920,27921,27922,27923,27924,27925,27926,27927,27928,27929,27930,27931,27932,27933,27934,27935,27936,27937,27938,27939,27940,27941,27942,27943,27944,27945,27946,27947,27948,27949,27950,27951,27952,27953,27954,27955,27956,27959,27960,27961,27962,27963,27964,27965,27994,28001,28019,28020,28021,28022,28023,28024,28025,28026,28027,28028,28029,28030,28031,28032,28033,28034,28035,28036,28037,28038,28039,28040,28041,28113,28114,28115,28116,28117,28118,28119,28120,28121,28122,28123,28124,28125,28126,28127,28128,28129,28130,28131,28132,28133,28134,28135,28136,28137,28138,28139,28140,28141,28142,28143,28144,28145,28146,28147,28148,28149,28150,28151,28152,28153,28154,28155,28156,28157,28158,28159,28160,28161,28162,28163,28164,28165,28166,28167,28168,28169,28170,28248,28261,28263,28266,28272,28276,28280,28281,28283,28287,28289,28292,28293,28294,28295,28298,28300,28301,28302,28303,28308,28310,28311,28323,28324,28331,28338,28339,28351,28353,28355,28358,28368,28369,28370,28371,28372,28373,28374,28375,28376,28377,28378,28379,28380,28381,28382,28383,28384,28385,28386,28387,28388,28389,28390,28392,28393,28420,28421,28422,28423,28424,28425,28426,28427,28428,28429,28430,28431,28432,28433,28434,28435,28436,28437,28438,28439,28440,28441,28442,28443,28444,28445,28446,28447,28448,28449,28450,28451,28452,28453,28454,28458,28463,28464,28465,28466,28483,28491,28492,28493,28494,28495,28496,28497,28498,28499,28500,28501,28502,28503,28504,28505,28506,28507,28508,28509,28510,28511,28512,28513,28514,28515,28516,28553,28560,28561,28562,28563,28568,28571,28572,28573,28574,28575,28578,28580,28582,28583,28584,28585,28586,28587,28589,28590,28592,28593,28594,28596,28598,28599,28600,28601,28602,28603,28605,28606,28607,28608,28609,28610,28612,28615,28616,28617,28618,28619,28620,28621,28622,28624,28625,28628,28634,28635,28640,28641,28642,28654,28667,28668,28672,28676,28680,28681,28683,28686,28687,28691,28693,28694,28696,28698,28703,28704,28711,28713,28779,28787,28800,28816,28846,28848,28849,28851,28852,28853,28854,28855,28856,28858,28859,28860,28862,28885,28886,28888,28890,28892,28893,28894,28895,28897,28898,28899,28900,28901,28903,28904,28905,28906,28907,28909,28910,28912,28913,28914,28916,28917,28918,28920,28921,28922,28923,28924,28925,28926,28927,28929,28930,28931,28933,28934,28949,28950,28951,28953,29055,29056,29057,29058,29059,29060,29061,29062,29063,29175,29176,29177,29178,29179,29180,29181,29182,29183,29184,29185,29186,29187,29188,29189,29190,29191,29192,29265,29266,29267,29268,29270,29271,29272,29274,29275,29276,29277,29278,29279,29280,29281,29282,29283,29284,29285,29286,29287,29288,29289,29290,29291,29292,29293,29294,29295,29296,29297,29298,29299,29300,29301,29302,29303,29304,29305,29306,29307,29308,29309,29310,29311,29312,29313,29314,29315,29316,29317,29318,29319,29320,29321,29322,29323,29324,29325,29326,29327,29328,29329,29330,29331,29332,29333,29334,29335,29336,29337,29338,29339,29340,29341,29342,29343,29344,29345,29346,29347,29348,29349,29350,29351,29352,29353,29354,29355,29356,29357,29358,29359,29360,29361,29362,29363,29364,29365,29366,29367,29368,29369,29370,29371,29373,29374,29375,29376,29377,29378,29379,29380,29381,29382,29384,29387,29388,29389,29390,29391,29395,29397,29398,29399,29401,29402,29405,29406,29407,29408,29411,29413,29414,29415,29416,29417,29419,29422,29423,29424,29426,29428,29430,29432,29433,29434,29435,29436,29439,29442,29443,29445,29465,29467,29468,29469,29471,29473,29475,29477,29479,29481,29482,29485,29487,29491,29493,29495,29496,29503,29504,29505,29506,29507,29509,29510,29516,29523,29553,29555,29556,29557,29560,29561,29562,29563,29564,29571,29573,29578,29580,29585,29586,29598,29599,29602,29609,29612,29614,29616,29647,29657,29667,29676,29686,29689,29690,29691,29696,29698,29702,29706,29707,29708,29709,29710,29715,29716,29717,29718,29721,29722,29723,29724,29736,29762,29767,29777,29778,29779,29780,29781,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29795,29797,29798,29801,29810,29823,29826,29827,29828,29832,29850,29855,29866,29870,29871,29875,29876,29877,29878,29884,29938,29939,29940,29941,29942,29943,29944,29945,29946,29947,29948,29949,29950,29951,29952,29953,29954,29955,29956,29957,29958,29959,29960,29961,29962,29963,29964,29965,29966,29967,29968,29969,29970,29971,29972,29973,29974,29975,29976,29977,29978,29979,29980,29981,29982,29983,29984,29985,30000,30001,30002,30003,30005,30006,30007,30008,30009,30010,30011,30012,30013,30014,30044,30046,30047,30048,30049,30050,30051,30052,30053,30054,30056,30057,30058,30059,30060,30061,30062,30063,30064,30065,30066,30067,30068,30069,30070,30071,30072,30073,30074,30075,30076,30077,30078,30079,30080,30155,30157,30158,30159,30163,30167,30168,30169,30170,30171,30172,30173,30174,30175,30176,30177,30178,30179,30180,30181,30182,30183,30184,30185,30186,30187,30188,30189,30190,30191,30192,30193,30194,30195,30196,30197,30198,30199,30200,30201,30202,30203,30204,30205,30206,30207,30208,30209,30210,30211,30212,30213,30214,30215,30216,30217,30218,30256,30257,30258,30259,30260,30261,30262,30263,30264,30265,30266,30267,30268,30269,30287,30292,30293,30294,30295,30377,30378,30379,30380,30381,30382,30383,30384,30385,30387,30389,30390,30391,30394,30395,30396,30397,30398,30399,30400,30401,30402,30403,30404,30405,30406,30408,30409,30410,30411,30413,30414,30415,30416,30418,30419,30420,30423,30424,30425,30426,30427,30428,30430,30431,30432,30433,30434,30435,30436,30437,30438,30439,30440,30441,30443,30444,30445,30447,30448,30449,30450,30474,30513,30514,30515,30517,30518,30519,30520,30521,30522,30523,30524,30525,30529,30530,30531,30532,30533,30534,30535,30536,30538,30539,30540,30541,30542,30543,30545,30546,30547,30549,30550,30552,30553,30554,30555,30556,30557,30558,30559,30569,30570,30572,30573,30577,30582,30583,30587,30593,30595,30596,30603,30612,30613,30625,30647,30655,30656,30657,30664,30669,30673,30674,30675,30677,30684,30685,30687,30688,30691,30698,30701,30703,30710,30711,30713,30715,30720,30726,30729,30733,30739,30740,30741,30743,30744,30751,30752,30764,30766,30767,30768,30777,30778,30781,30784,30786,30787,30792,30793,30795,30796,30798,30799,30803,30809,30810,30815,30816,30818,30819,30822,30827,30828,30831,30832,30833,30836,30839,30842,30846,30847,30848,30851,30859,30870,30871,30883,30886,30903,30910,30921,30925,30936,30940,30950,30951,30998,30999,31001,31003,31004,31005,31006,31007,31008,31009,31010,31011,31012,31015,31016,31017,31018,31019,31020,31021,31023,31025,31026,31030,31033,31034,31035,31037,31043,31045,31046,31049,31051,31054,31057,31065,31099,31100,31102,31103,31104,31105,31106,31107,31108,31109,31113,31114,31115,31116,31119,31120,31121,31122,31123,31124,31125,31126,31127,31129,31130,31131,31133,31137,31138,31139,31140,31141,31142,31143,31144,31146,31147,31148,31218,31228,31279,31280,31281,31282,31283,31284,31285,31286,31287,31288,31289,31290,31291,31292,31293,31294,31325,31326,31327,31329,31330,31331,31332,31333,31334,31335,31336,31337,31338,31339,31340,31341,31342,31343,31344,31345,31346,31347,31349,31350,31352,31354,31355,31356,31357,31358,31360,31361,31362,31363,31364,31365,31366,31367,31368,31369,31371,31372,31373,31374,31375,31376,31378,31379,31380,31382,31383,31385,31386,31392,31394,31397,31398,31399,31400,31401,31403,31404,31407,31408,31410,31411,31412,31416,31417,31420,31421,31426,31429,31431,31432,31433,31434,31435,31438,31440,31441,31442,31446,31448,31450,31451,31453,31454,31455,31457,31458,31459,31460,31461,31464,31465,31467,31468,31469,31470,31473,31474,31477,31479,31480,31481,31482,31483,31485,31486,31487,31488,31490,31491,31495,31496,31497,31498,31499,31500,31501,31502,31503,31505,31506,31508,31511,31512,31514,31520,31524,31525,31526,31529,31530,31536,31537,31540,31541,31542,31543,31545,31549,31551,31552,31553,31555,31557,31566,31570,31580,31599,31601,31602,31605,31607,31609,31610,31611,31612,31616,31620,31622,31624,31625,31631,31632,31634,31635,31636,31638,31641,31642,31643,31644,31650,31651,31652,31653,31657,31658,31662,31666,31667,31668,31670,31671,31672,31676,31678,31679,31680,31681,31682,31684,31686,31688,31689,31693,31699,31702,31713,31714,31720,31722,31725,31728,31729,31733,31736,31737,31739,31740,31741,31742,31743,31744,31746,31747,31749,31750,31753,31754,31755,31756,31757,31758,31760,31761,31762,31764,31768,31771,31773,31774,31776,31779,31783,31786,31788,31789,31794,31801,31803,31804,31805,31806,31817,31818,31819,31822,31823,31824,31826,31829,31833,31836,31837,31838,31841,31842,31843,31844,31846,31847,31848,31850,31853,31857,31862,31864,31868,31871,31881,31884,31887,31890,31892,31900,31901,31902,31908,31914,31917,31930,31963,31968,31971,31973,31974,31978,31980,31981,31982,31984,31985,31986,31988,31990,31992,31994,31995,32005,32007,32008,32009,32010,32011,32013,32014,32015,32016,32018,32019,32020,32021,32022,32023,32024,32026,32027,32028,32029,32030,32031,32032,32033,32037,32038,32039,32040,32041,32042,32043,32044,32046,32047,32124,32125,32126,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32138,32139,32140,32141,32142,32143,32144,32145,32146,32147,32148,32149,32150,32151,32152,32153,32154,32155,32156,32157,32158,32185,32186,32187,32188,32189,32190,32191,32192,32193,32194,32195,32196,32206,32207,32208,32209,32210,32211,32212,32213,32214,32215,32216,32217,32218,32219,32220,32221,32222,32223,32224,32240,32241,32242,32243,32244,32245,32246,32249,32250,32251,32294,32295,32296,32297,32298,32299,32300,32301,32302,32303,32304,32305,32306,32307,32308,32309,32310,32311,32345,32431,32432,32433,32434,32435,32436,32437,32438,32439,32440) AND p.quantity > 0 GROUP BY p.product_id ORDER BY CASE WHEN p.quantity <= 0 THEN 1 ELSE 0 END, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,10000 Naujos vasarinės padangos internetu pigiau | Autorolis.lt

Vasarinės padangos

Rūšiuoti:
Rodyti:
Rodoma nuo 1 iki 3 iš 3 (1 puslapių)

Vasarinių padangų svarba ir savybės

Vasarinių padangų svarba yra milžiniška, kai kalbame apie saugumą važiuojant automobiliu. Esant aukštai oro temperatūrai, šios rūšies padangos yra būtinos, norint užtikrinti gerą sukibimą su sausa kelio danga. Tinkamai parinktos vasarinės padangos gali padėti išvengti daugybės nelaimingų atsitikimų, kai kelio paviršius yra sausas. Svarbu atsiminti, kad padangos nėra vienodos ir jų savybės priklauso nuo gamintojo ir naudojamų medžiagų.

Vasarinių padangų privalumai

Pagrindinis privalumas - geras sukibimas su sausa danga. Taip pat vasarinės padangos išsiskiria tuo jog yra lengvesnės, sutrumpėja stabdymo kelias, turi mažiau gumos, tačiau jos yra kietesnės nei žieminiės padangos. Naudojant šios rūšies padangas šiltuoju sezono metu, vairavimas tampa patogesnis bei malonesnis.

Vasarinių padangų kaina

Vasarinės padangos gali turėti gana platų kainų spektrą, priklausomai nuo jų kokybės, dydžio ir gamintojo. Ekonominės klasės vasarinės padangos gali kainuoti 30-40 eurų už vieną, o aukščiausios kokybės ir didžiausių dydžių, kaina gali siekti net kelis šimtus eurų. Vis dėlto, kokybiškos padangos yra investicija į jūsų saugumą ir patogumą vairuojant, todėl tikrai verta skirti daugiau dėmesio kokybei nei kainai.

Populiariausios vasarinės padangos

Gamintojų populiarumas gali skirtis priklausomai nuo šalies, regiono ar netgi miesto, tačiau jei žiūrint bendrai, yra keletas prekės ženklų, kurie dažniausiai minimi kaip populiariausi pasirinkimai rinkoje. Šie gamintojai yra žinomi dėl aukštos padangų kokybės ir savo didžiulės patirties gamyboje.

Padangų gamintojai

Elektroininėje parduotuvėje AUTOROLIS.LT rasite tokių garsių gamintojų padangų kaip Barum, BFGoodrich, Bridgestone, Continental, Dunlop, Falken, Firestone, Gislaved, Goodyear, Hankook, Kelly, Kormoran, Kumho, Matador, Michelin, Nankang, Nexen, Pirelli, Sava, Yokohama ir aibę kitų.

Visos teisės saugomos © 2019-2024 AUTOROLIS.LT
Hey.lt - Nemokamas lankytojų skaitliukas