SELECT
q_product_filters.filter_id
FROM
q_product_features_values
LEFT JOIN q_products as products ON products.product_id = q_product_features_values.product_id
LEFT JOIN q_product_filters ON q_product_filters.feature_id = q_product_features_values.feature_id
LEFT JOIN q_product_features ON q_product_features.feature_id = q_product_features_values.feature_id
LEFT JOIN q_product_options_inventory as inventory ON inventory.product_id = products.product_id
LEFT JOIN q_companies AS companies ON companies.company_id = products.company_id
INNER JOIN q_products_categories as products_categories ON products_categories.product_id = products.product_id
INNER JOIN q_categories ON q_categories.category_id = products_categories.category_id
AND (
q_categories.usergroup_ids = ''
OR FIND_IN_SET(0, q_categories.usergroup_ids)
OR FIND_IN_SET(1, q_categories.usergroup_ids)
)
AND q_categories.status IN ('A', 'H')
WHERE
q_product_filters.filter_id IN (1, 3)
AND q_product_features_values.feature_id IN (2)
AND q_product_features_values.value = 'Y'
AND q_product_features_values.lang_code = 'en'
AND q_categories.category_id IN (
6,
7,
9,
148,
160,
169,
185,
368,
407,
426,
439,
440,
441,
444,
446,
447,
455,
456,
461,
466,
477,
520,
537,
61,
62,
149,
159,
161,
170,
186,
369,
408,
427,
442,
443,
448,
462,
467,
478,
528,
538,
63,
147,
150,
162,
168,
171,
187,
370,
409,
449,
454,
463,
468,
530,
539,
64,
151,
163,
172,
184,
189,
371,
450,
460,
464,
540,
567,
65,
152,
164,
173,
292,
372,
378,
451,
476,
541,
568,
153,
165,
174,
360,
373,
411,
452,
479,
571,
154,
166,
175,
374,
406,
453,
465,
587,
155,
167,
176,
425,
482,
536,
156,
177,
438,
495,
558,
157,
445,
563,
158,
179,
519,
570,
180,
584,
596,
367,
181,
182,
619,
183,
188,
244,
481,
518,
521,
522,
529,
531
)
AND companies.status = 'A'
AND products.company_id = 34
AND (
CASE products.tracking WHEN 'O' THEN inventory.amount > 0 WHEN 'B' THEN products.amount > 0 ELSE 1 END
)
AND (
products.usergroup_ids = ''
OR FIND_IN_SET(0, products.usergroup_ids)
OR FIND_IN_SET(1, products.usergroup_ids)
)
AND products.status IN ('A')
AND products.company_id = 34
AND q_product_features.feature_type = 'C'
GROUP BY
q_product_features_values.feature_id