SELECT tv97.value as product_bed_type, tv176.value as show_in_city_resource, tv10.value as product_price FROM `mfsa_site_content` AS `modResource` LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv97` ON `modResource`.`id` = `tv97`.`contentid` AND `tv97`.`tmplvarid` = 97 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv176` ON `modResource`.`id` = `tv176`.`contentid` AND `tv176`.`tmplvarid` = 176 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv10` ON `modResource`.`id` = `tv10`.`contentid` AND `tv10`.`tmplvarid` = 10 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv147` ON `modResource`.`id` = `tv147`.`contentid` AND `tv147`.`tmplvarid` = 147 JOIN `mfsa_site_tmplvar_contentvalues` `tv_res` ON tv_res.contentid = modResource.id and tv_res.tmplvarid in (147) JOIN `mfsa_site_tmplvars` `tv_obj` ON tv_obj.id = tv_res.tmplvarid WHERE  (  ( `modResource`.`deleted` = 0 AND `modResource`.`hidemenu` = 0 AND `modResource`.`published` = 1 )  AND  ( `modResource`.`template` in (16,17,18,19,20,21,22) AND (tv97.value LIKE '%Софа%') AND (CONCAT('||',tv176.value,'||') LIKE '%||Ярославль||%' OR tv176.value IS NULL OR tv176.value = '') AND `modResource`.`parent` IN (16,40,508,509,511,512,513,514,515,519,516,518,4365,4377,4257,4258,45,41,42,43,44,46,47,80,505,507,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,3243,3245,3244,3242,3508,2297,2432,2436,2434,2446,2442,2438,2295,2431,2399,2400,2454,2376,2374,2337,2402,2279,2367,2366,2393,2302,2331,2338,3520,3521,3522,3525,3526,3528,3529,2339,2340,2287,2325,2341,2395,2269,2268,2271,2278,2362,2311,2373,2318,2385,2411,2282,2329,2294,2324,2272,2273,2284,2360,2274,2412,2310,2276,2288,2392,2321,2320,3517,2275,2323,2285,2330,2332,2363,2270,2326,2309,2408,2450,2289,2304,2290,3509,3510,3511,3512,3513,3514,3515,3516,2459,2460,2461,2462,2463,2464,2465,2467,2472,2468,2470,2473,2483,2486,2487,2488,2522,2527,2532,2550,2551,2555,2559,2562,2565,2569,2572,2574,2579,2587,3264,3257,3265,3262,3258,3255,3252,3259,3253,3254,2629,2615,2614,2608,2679,2628,2678,2613,2635,2589,2634,2647,2612,2596,2605,2604,2646,2648,2622,2619,2595,2620,2621,2658,2657,2618,2594,2617,2616,2625,2655,2656,2670,2668,2610,2609,2601,2602,2630,2669,2631,2626,2667,2590,2638,2672,2671,2673,2598,2640,2652,2642,2644,2654,2653,2643,2641,2645,2651,2676,2677,2632,2591,2674,2593,2599,2600,2627,2633,2611,2639,2650,2675,2649,2597,2665,2661,2624,2663,2623,2662,2659,2664,2666,2660,2636,2606,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2726,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,3276,3268,3267,2401,2293,2355,2388,2390,2307,2283,2383,2378,2379,2308,2315,2299,2267,2387,2327,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,2328,2739,2755,2804,2743,2759,2787,2803,2806,2771,2807,2823,2826,2811,2775,2791,2380,2354,2391,2281,2783,2751,2747,2767,2779,2795,2763,2815,2805,2819,2799,2427,2277,2829,2838,2839,2830,2840,2831,2832,2833,2834,2835,2836,2837,2841,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4306,4307,4308,4309,4310,4311,4312,4313,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,470,500,501,502,503,392,459,475,479,498,488,461,4224,4223,396,398,395,393,394,400,397,399,452,468,317,476,469,405,331,453,454,456,457,523,524,522,521,520,320,324,321,327,281,330,293,318,319,322,328,329,323,325,326,528,527,526,525,342,4228,334,339,336,335,333,341,346,340,332,337,338,344,345,347,343,403,417,303,245,408,409,530,531,529,312,316,309,308,306,315,314,313,311,310,305,307,304,536,534,533,535,532,537,4260,259,260,265,275,273,268,267,263,256,257,262,251,253,246,276,255,261,248,249,266,250,270,274,277,247,254,252,271,272,278,4056,4057,4058,4059,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4088,4089,4090,4091,4092,364,385,377,414,460,424,436,487,462,481,404,441,4225,371,368,366,367,369,370,372,365,386,378,379,380,381,382,383,384,415,416,437,438,439,440,463,442,443,444,410,423,435,478,411,412,413,279,429,419,492,445,4226,4259,287,285,284,283,282,280,4119,4120,4121,4122,4123,4124,4125,4126,4127,4128,4129,4130,4131,4132,4133,4134,4135,4136,4137,4138,4139,4140,4141,4142,430,431,432,433,420,421,422,493,494,446,447,348,471,490,465,289,425,486,541,540,539,538,353,354,352,358,3045,351,349,356,355,359,357,350,472,491,466,544,543,542,4093,295,300,299,298,297,294,291,290,292,296,302,301,4094,4095,4096,4097,4098,4099,4100,4101,4102,4103,4104,4105,4106,4107,4108,4109,4110,4111,4112,4113,4114,4115,4116,4117,4118,426,427,428,482,499,373,406,360,387,464,504,474,477,489,473,448,495,480,418,407,434,467,4243,375,376,361,362,363,388,389,390,391,449,450,451,3046,496,497,4366,4367,4368,4369,4370,4372,4373,4374,4375,4376,4379,4380,4381,4382,4383,4384,4385,4386,4387,4388,4389,4390,4391,3999,3912,4000,4001,4002,4003,4004,4005,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4018,4019,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4031,4032,4033,4034,4035,4036,4037,4038,4039,4040,4041,4042,4043,4044,4045,4046,4047,4048,4049,4050,4051,4052,4053,4054,4055,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3885,3886,3887,3888,3889,3890,3891,3892,3893,3894,3895,3896,3897,3898,3899,3900,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911) AND `tv10`.`value` > '1' )  )  ORDER BY CONVERT(tv147.value, SIGNED INTEGER) ASC, tv_res.value asc 
Кровати софа в Ярославле | Купить ортопедическую кровать софу недорого в интернет магазине | цена от 12360 руб.
Сортировать:
SELECT vars1.value as delivery_par, vars2.value as delivery_gra, tv97.value as product_bed_type, tv176.value as show_in_city_resource, tv10.value as product_price FROM `mfsa_site_content` AS `modResource` LEFT JOIN `mfsa_site_content` `content2` ON modResource.parent = content2.id LEFT JOIN `mfsa_site_tmplvar_contentvalues` `vars1` ON modResource.parent = vars1.contentid AND vars1.tmplvarid = 167 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `vars2` ON content2.parent = vars2.contentid AND vars2.tmplvarid = 167 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv97` ON `modResource`.`id` = `tv97`.`contentid` AND `tv97`.`tmplvarid` = 97 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv176` ON `modResource`.`id` = `tv176`.`contentid` AND `tv176`.`tmplvarid` = 176 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv10` ON `modResource`.`id` = `tv10`.`contentid` AND `tv10`.`tmplvarid` = 10 LEFT JOIN `mfsa_site_tmplvar_contentvalues` `tv147` ON `modResource`.`id` = `tv147`.`contentid` AND `tv147`.`tmplvarid` = 147 WHERE  (  ( `modResource`.`deleted` = 0 AND `modResource`.`hidemenu` = 0 AND `modResource`.`published` = 1 )  AND  ( `modResource`.`template` in (16,17,18,19,20,21,22) AND (tv97.value LIKE '%Софа%') AND (CONCAT('||',tv176.value,'||') LIKE '%||Ярославль||%' OR tv176.value IS NULL OR tv176.value = '') AND `modResource`.`parent` IN (16,40,508,509,511,512,513,514,515,519,516,518,4365,4377,4257,4258,45,41,42,43,44,46,47,80,505,507,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,3243,3245,3244,3242,3508,2297,2432,2436,2434,2446,2442,2438,2295,2431,2399,2400,2454,2376,2374,2337,2402,2279,2367,2366,2393,2302,2331,2338,3520,3521,3522,3525,3526,3528,3529,2339,2340,2287,2325,2341,2395,2269,2268,2271,2278,2362,2311,2373,2318,2385,2411,2282,2329,2294,2324,2272,2273,2284,2360,2274,2412,2310,2276,2288,2392,2321,2320,3517,2275,2323,2285,2330,2332,2363,2270,2326,2309,2408,2450,2289,2304,2290,3509,3510,3511,3512,3513,3514,3515,3516,2459,2460,2461,2462,2463,2464,2465,2467,2472,2468,2470,2473,2483,2486,2487,2488,2522,2527,2532,2550,2551,2555,2559,2562,2565,2569,2572,2574,2579,2587,3264,3257,3265,3262,3258,3255,3252,3259,3253,3254,2629,2615,2614,2608,2679,2628,2678,2613,2635,2589,2634,2647,2612,2596,2605,2604,2646,2648,2622,2619,2595,2620,2621,2658,2657,2618,2594,2617,2616,2625,2655,2656,2670,2668,2610,2609,2601,2602,2630,2669,2631,2626,2667,2590,2638,2672,2671,2673,2598,2640,2652,2642,2644,2654,2653,2643,2641,2645,2651,2676,2677,2632,2591,2674,2593,2599,2600,2627,2633,2611,2639,2650,2675,2649,2597,2665,2661,2624,2663,2623,2662,2659,2664,2666,2660,2636,2606,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2726,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,3276,3268,3267,2401,2293,2355,2388,2390,2307,2283,2383,2378,2379,2308,2315,2299,2267,2387,2327,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,2328,2739,2755,2804,2743,2759,2787,2803,2806,2771,2807,2823,2826,2811,2775,2791,2380,2354,2391,2281,2783,2751,2747,2767,2779,2795,2763,2815,2805,2819,2799,2427,2277,2829,2838,2839,2830,2840,2831,2832,2833,2834,2835,2836,2837,2841,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4306,4307,4308,4309,4310,4311,4312,4313,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,470,500,501,502,503,392,459,475,479,498,488,461,4224,4223,396,398,395,393,394,400,397,399,452,468,317,476,469,405,331,453,454,456,457,523,524,522,521,520,320,324,321,327,281,330,293,318,319,322,328,329,323,325,326,528,527,526,525,342,4228,334,339,336,335,333,341,346,340,332,337,338,344,345,347,343,403,417,303,245,408,409,530,531,529,312,316,309,308,306,315,314,313,311,310,305,307,304,536,534,533,535,532,537,4260,259,260,265,275,273,268,267,263,256,257,262,251,253,246,276,255,261,248,249,266,250,270,274,277,247,254,252,271,272,278,4056,4057,4058,4059,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4088,4089,4090,4091,4092,364,385,377,414,460,424,436,487,462,481,404,441,4225,371,368,366,367,369,370,372,365,386,378,379,380,381,382,383,384,415,416,437,438,439,440,463,442,443,444,410,423,435,478,411,412,413,279,429,419,492,445,4226,4259,287,285,284,283,282,280,4119,4120,4121,4122,4123,4124,4125,4126,4127,4128,4129,4130,4131,4132,4133,4134,4135,4136,4137,4138,4139,4140,4141,4142,430,431,432,433,420,421,422,493,494,446,447,348,471,490,465,289,425,486,541,540,539,538,353,354,352,358,3045,351,349,356,355,359,357,350,472,491,466,544,543,542,4093,295,300,299,298,297,294,291,290,292,296,302,301,4094,4095,4096,4097,4098,4099,4100,4101,4102,4103,4104,4105,4106,4107,4108,4109,4110,4111,4112,4113,4114,4115,4116,4117,4118,426,427,428,482,499,373,406,360,387,464,504,474,477,489,473,448,495,480,418,407,434,467,4243,375,376,361,362,363,388,389,390,391,449,450,451,3046,496,497,4366,4367,4368,4369,4370,4372,4373,4374,4375,4376,4379,4380,4381,4382,4383,4384,4385,4386,4387,4388,4389,4390,4391,3999,3912,4000,4001,4002,4003,4004,4005,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4018,4019,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4031,4032,4033,4034,4035,4036,4037,4038,4039,4040,4041,4042,4043,4044,4045,4046,4047,4048,4049,4050,4051,4052,4053,4054,4055,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3885,3886,3887,3888,3889,3890,3891,3892,3893,3894,3895,3896,3897,3898,3899,3900,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911) AND `tv10`.`value` > '1' )  )  ORDER BY CONVERT(tv147.value, SIGNED INTEGER) ASC 
Кровать Райтон Отто-2 с защитной стенкой Быстрый просмотр
Кровать Райтон Отто-2 с защитной стенкой
  • Подъемный механизмНет
  • Материал каркасаМассив
  • Высота изголовья680 см.
  • Тип изголовьяДеревянное
  • Высота изножья680 см.
  • Гарантия24 мес.

12 360 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать DreamLine Тахта 3 Быстрый просмотр
Кровать DreamLine Тахта 3
  • Подъемный механизмНет
  • Материал каркасаЛДСП,МДФ
  • Гарантия24 мес.

22 050 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать DreamLine Тахта с выкатными ящиками Быстрый просмотр
Кровать DreamLine Тахта с выкатными ящиками
  • Подъемный механизмНет
  • Материал каркасаМассив
  • Высота изголовья650 см.
  • Высота изножья450 см.
  • Гарантия24 мес.

24 503 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать Орматек Bono Быстрый просмотр
Кровать Орматек Bono
  • Подъемный механизмНет
  • Высота изголовья855 см.
  • Высота изножья750 см.
  • Материал отделкиКожа,Экокожа,Ткань

26 520 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать DreamLine Тахта 2 Хит продаж Быстрый просмотр
Кровать DreamLine Тахта 2
  • Подъемный механизмНет
  • Материал каркасаМассив
  • Высота изголовья850 см.
  • Высота изножья480 см.
  • Гарантия24 мес.

29 672 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать DreamLine Тахта Бриз Быстрый просмотр
Кровать DreamLine Тахта Бриз
  • Подъемный механизмНет
  • Материал каркасаМассив
  • Высота изголовья840 см.
  • Высота изножья840 см.
  • Гарантия24 мес.

31 986 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать-тахта Орматек Lancaster Быстрый просмотр
Кровать-тахта Орматек Lancaster
  • Подъемный механизмДа
  • Высота изголовья420 см.
  • Высота изножья420 см.
  • Материал отделкиКожа,Экокожа,Ткань

38 610 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать-тахта Орматек Lancaster (цвета люкс) Быстрый просмотр
Кровать-тахта Орматек Lancaster (цвета люкс)
  • Подъемный механизмДа
  • Материал каркасаЛДСП,МДФ
  • Высота изголовья420 см.
  • Высота изножья420 см.
  • Материал отделкиКожа,Экокожа,Ткань

40 160 руб.

  • В наличии
  • Доставка транспортной компанией

Кровать DreamLine Тахта - трансформер Неаполь Быстрый просмотр
Кровать DreamLine Тахта - трансформер Неаполь
  • Подъемный механизмНет
  • Материал каркасаМассив
  • Высота изголовья850 см.
  • Высота изножья480 см.
  • Гарантия24 мес.

45 317 руб.

  • В наличии
  • Доставка транспортной компанией