SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id FROM zen_products p LEFT JOIN zen_specials s on p.products_id = s.products_id LEFT JOIN zen_products_description pd on p.products_id = pd.products_id LEFT JOIN zen_manufacturers m on p.manufacturers_id = m.manufacturers_id WHERE p.products_status = 1
and pd.language_id = '2'
and m.manufacturers_id = '31' GROUP BY p.products_id
SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(2448,2449,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2462,2466,2467,2469,2470,2471,2472,2473,2475,2478,2480,2482,2485,2949,3250,3279,3281,3282,3285,3286,3287,3288,3289,3292,3293,3297,3298,3299,3301,3302,3304,3306,3308,3309,3314,3315,3317,3318,3321,3322,3324,3325,3326,3327,3328,3329,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3385,3533,3560,3563,3566,3567,3568,3570,3571,3572,3581,3582,3583,3584,3586,3587,3590,3593,3594,3596,3601,3604,3607,3731,3816,3817,3943,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4181,4182,4184), 1, 0)) as flag FROM zen_products_attributes p2a JOIN zen_products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN zen_products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 WHERE p2a.products_id IN (2448,2449,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2462,2466,2467,2469,2470,2471,2472,2473,2475,2478,2480,2482,2485,2949,3250,3279,3281,3282,3285,3286,3287,3288,3289,3292,3293,3297,3298,3299,3301,3302,3304,3306,3308,3309,3314,3315,3317,3318,3321,3322,3324,3325,3326,3327,3328,3329,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3385,3533,3560,3563,3566,3567,3568,3570,3571,3572,3581,3582,3583,3584,3586,3587,3590,3593,3594,3596,3601,3604,3607,3731,3943,3816,3817,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4181,4182,4184) AND p2a.options_id IN (8,10) AND p2a.options_id NOT IN (4,5,6,7,2,3,1) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_sort_order, pov.products_options_values_sort_order
CARACTERISTICI & AVANTAJE Anvelopele Ozka KNK50 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta. Constructia carcasei, componentele si designul...
CARACTERISTICI & AVANTAJE Anvelopele Ozka KNK50 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta. Constructia carcasei, componentele si designul...
CARACTERISTICI & AVANTAJE Anvelopele Ozka KNK50 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta. Constructia carcasei, componentele si designul...
CARACTERISTICI & AVANTAJE Anvelopele Ozka KNK50 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta. Constructia carcasei, componentele si designul...
CARACTERISTICI & AVANTAJE Anvelopele Ozka KNK50 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta. Constructia carcasei, componentele si designul...
CARACTERISTICI & AVANTAJE Anvelopele agricole Ozka sunt dezvoltate pentru a eficientiza activitatile agricole. Datorita modelelor cu caneluri si suprafete de rulare imbunatatite, anvelopele Ozka ofera tractiune maxima pe camp si o manevrare mai buna pe sosea. Tractiunea excelenta si autocuratarea , impreuna cu posibilitatea de a suporta unelte mai grele sau incarcaturi mai mari, permit un...