SELECT p.id, r.parent FROM `esd7SS@x_ms2_products` AS p
LEFT JOIN `esd7SS@x_site_content` AS r ON p.id = r.id
LEFT JOIN `esd7SS@x_site_tmplvar_contentvalues` AS tv ON p.id = tv.contentid AND tv.tmplvarid = 41
WHERE
tv.value > 0
AND
(polarity = 'Обратная' OR polarity = '') AND (capacity >= 75 AND capacity <= 110) AND parent IN (3361, 3362, 3363, 3364, 3365, 3366, 3367, 3368, 3369, 3370, 3371, 3372, 3373, 3374, 3375, 3376, 3377, 3378, 3379, 3380, 3381, 3382, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3396, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 4211, 4230, 4231, 4232, 4269, 4289, 4339, 4340, 4353, 4461, 4662, 4711, 4738, 4784, 4806, 4807, 4829, 4850, 4865, 5003, 5029, 5041, 5105)Array
(
[0] => Array
(
[id] => 4437
[parent] => 3367
)
[1] => Array
(
[id] => 4495
[parent] => 3367
)
[2] => Array
(
[id] => 5076
[parent] => 3367
)
[3] => Array
(
[id] => 5083
[parent] => 3367
)
[4] => Array
(
[id] => 5099
[parent] => 3367
)
[5] => Array
(
[id] => 5102
[parent] => 3367
)
[6] => Array
(
[id] => 4830
[parent] => 3374
)
[7] => Array
(
[id] => 3881
[parent] => 3385
)
[8] => Array
(
[id] => 3607
[parent] => 3397
)
[9] => Array
(
[id] => 3609
[parent] => 3397
)
[10] => Array
(
[id] => 3612
[parent] => 3397
)
[11] => Array
(
[id] => 3665
[parent] => 3397
)
[12] => Array
(
[id] => 4031
[parent] => 3397
)
[13] => Array
(
[id] => 4250
[parent] => 3397
)
[14] => Array
(
[id] => 4486
[parent] => 3397
)
[15] => Array
(
[id] => 4561
[parent] => 3397
)
[16] => Array
(
[id] => 4570
[parent] => 3397
)
[17] => Array
(
[id] => 4575
[parent] => 3397
)
[18] => Array
(
[id] => 3862
[parent] => 3407
)
[19] => Array
(
[id] => 4522
[parent] => 3411
)
[20] => Array
(
[id] => 4603
[parent] => 3411
)
[21] => Array
(
[id] => 5154
[parent] => 4339
)
[22] => Array
(
[id] => 4826
[parent] => 4806
)
[23] => Array
(
[id] => 5047
[parent] => 4806
)
[24] => Array
(
[id] => 5051
[parent] => 4806
)
[25] => Array
(
[id] => 5124
[parent] => 4806
)
[26] => Array
(
[id] => 5069
[parent] => 4807
)
[27] => Array
(
[id] => 5087
[parent] => 4807
)
[28] => Array
(
[id] => 5081
[parent] => 4865
)
[29] => Array
(
[id] => 5110
[parent] => 4865
)
[30] => Array
(
[id] => 5040
[parent] => 5029
)
)
Принимаем наличные и безналичные платежи
