Database_Result_Cached Object ( [_query:protected] => SELECT DISTINCT `cats_products`.`product_id`, `products`.`active`, `products`.`template_id` FROM `cats_products` JOIN `products` ON (`products`.`id` = `cats_products`.`product_id`) WHERE `products`.`variant` = 0 AND (`cats_products`.`cat_id` = 24 OR `cats_products`.`cat_id` = 167 OR `cats_products`.`cat_id` = 162 OR `cats_products`.`cat_id` = 163 OR `cats_products`.`cat_id` = 164 OR `cats_products`.`cat_id` = 165 OR `cats_products`.`cat_id` = 25 OR `cats_products`.`cat_id` = 33 OR `cats_products`.`cat_id` = 56 OR `cats_products`.`cat_id` = 47 OR `cats_products`.`cat_id` = 62 OR `cats_products`.`cat_id` = 63 OR `cats_products`.`cat_id` = 67 OR `cats_products`.`cat_id` = 71 OR `cats_products`.`cat_id` = 66 OR `cats_products`.`cat_id` = 72 OR `cats_products`.`cat_id` = 117 OR `cats_products`.`cat_id` = 123 OR `cats_products`.`cat_id` = 78 OR `cats_products`.`cat_id` = 90 OR `cats_products`.`cat_id` = 97 OR `cats_products`.`cat_id` = 98 OR `cats_products`.`cat_id` = 145 OR `cats_products`.`cat_id` = 146 OR `cats_products`.`cat_id` = 147 OR `cats_products`.`cat_id` = 148 OR `cats_products`.`cat_id` = 150 OR `cats_products`.`cat_id` = 151 OR `cats_products`.`cat_id` = 149 OR `cats_products`.`cat_id` = 152 OR `cats_products`.`cat_id` = 153 OR `cats_products`.`cat_id` = 154 OR `cats_products`.`cat_id` = 155 OR `cats_products`.`cat_id` = 156) AND `products`.`active` = 1 ORDER BY `products`.`price` DESC LIMIT 24 OFFSET 24 [_result:protected] => Array ( [0] => Array ( [product_id] => 2397 [active] => 1 [template_id] => -11 ) [1] => Array ( [product_id] => 2612 [active] => 1 [template_id] => -11 ) [2] => Array ( [product_id] => 2570 [active] => 1 [template_id] => -11 ) [3] => Array ( [product_id] => 2569 [active] => 1 [template_id] => -11 ) [4] => Array ( [product_id] => 2384 [active] => 1 [template_id] => -11 ) [5] => Array ( [product_id] => 2649 [active] => 1 [template_id] => -11 ) [6] => Array ( [product_id] => 4441 [active] => 1 [template_id] => -11 ) [7] => Array ( [product_id] => 2587 [active] => 1 [template_id] => -11 ) [8] => Array ( [product_id] => 2611 [active] => 1 [template_id] => -11 ) [9] => Array ( [product_id] => 2562 [active] => 1 [template_id] => -11 ) [10] => Array ( [product_id] => 2610 [active] => 1 [template_id] => -11 ) [11] => Array ( [product_id] => 2579 [active] => 1 [template_id] => -11 ) [12] => Array ( [product_id] => 4611 [active] => 1 [template_id] => -11 ) [13] => Array ( [product_id] => 2381 [active] => 1 [template_id] => -11 ) [14] => Array ( [product_id] => 2380 [active] => 1 [template_id] => -11 ) [15] => Array ( [product_id] => 2379 [active] => 1 [template_id] => -11 ) [16] => Array ( [product_id] => 2378 [active] => 1 [template_id] => -11 ) [17] => Array ( [product_id] => 4710 [active] => 1 [template_id] => -11 ) [18] => Array ( [product_id] => 2376 [active] => 1 [template_id] => -11 ) [19] => Array ( [product_id] => 4613 [active] => 1 [template_id] => -11 ) [20] => Array ( [product_id] => 4617 [active] => 1 [template_id] => -11 ) [21] => Array ( [product_id] => 2382 [active] => 1 [template_id] => -11 ) [22] => Array ( [product_id] => 4609 [active] => 1 [template_id] => -11 ) [23] => Array ( [product_id] => 4606 [active] => 1 [template_id] => -11 ) ) [_total_rows:protected] => 24 [_current_row:protected] => 0 [_as_object:protected] => [_object_params:protected] => ) Database_Result_Cached Object ( [_query:protected] => SELECT DISTINCT `cats_products`.`product_id`, `products`.`active`, `products`.`template_id` FROM `cats_products` JOIN `products` ON (`products`.`id` = `cats_products`.`product_id`) WHERE `products`.`variant` = 0 AND (`cats_products`.`cat_id` = 24 OR `cats_products`.`cat_id` = 167 OR `cats_products`.`cat_id` = 162 OR `cats_products`.`cat_id` = 163 OR `cats_products`.`cat_id` = 164 OR `cats_products`.`cat_id` = 165 OR `cats_products`.`cat_id` = 25 OR `cats_products`.`cat_id` = 33 OR `cats_products`.`cat_id` = 56 OR `cats_products`.`cat_id` = 47 OR `cats_products`.`cat_id` = 62 OR `cats_products`.`cat_id` = 63 OR `cats_products`.`cat_id` = 67 OR `cats_products`.`cat_id` = 71 OR `cats_products`.`cat_id` = 66 OR `cats_products`.`cat_id` = 72 OR `cats_products`.`cat_id` = 117 OR `cats_products`.`cat_id` = 123 OR `cats_products`.`cat_id` = 78 OR `cats_products`.`cat_id` = 90 OR `cats_products`.`cat_id` = 97 OR `cats_products`.`cat_id` = 98 OR `cats_products`.`cat_id` = 145 OR `cats_products`.`cat_id` = 146 OR `cats_products`.`cat_id` = 147 OR `cats_products`.`cat_id` = 148 OR `cats_products`.`cat_id` = 150 OR `cats_products`.`cat_id` = 151 OR `cats_products`.`cat_id` = 149 OR `cats_products`.`cat_id` = 152 OR `cats_products`.`cat_id` = 153 OR `cats_products`.`cat_id` = 154 OR `cats_products`.`cat_id` = 155 OR `cats_products`.`cat_id` = 156) AND `products`.`active` = 1 ORDER BY `products`.`sold` DESC LIMIT 3 [_result:protected] => Array ( [0] => Array ( [product_id] => 2543 [active] => 1 [template_id] => -11 ) [1] => Array ( [product_id] => 2490 [active] => 1 [template_id] => -11 ) [2] => Array ( [product_id] => 2387 [active] => 1 [template_id] => -11 ) ) [_total_rows:protected] => 3 [_current_row:protected] => 0 [_as_object:protected] => [_object_params:protected] => ) Moto
Po-Pá 10-18 h e-shop +420 777 143 094
+420 702 304 940
Napište nám kdykoliv! tygrsport(zav)seznam.cz

Moto

Nejprodávanější
  • Výrobci