select p.*, m.name as brand , p.name as name_en, o.id as option_id, group_concat(distinct s.t_strength separator '|,|') as strength , group_concat(distinct s.t_ring separator '|,|') as ring , group_concat(distinct s.t_length separator '|,|') as length , group_concat(distinct s.t_shape_id separator '|,|') as shape_id , group_concat(distinct json_unquote(json_extract(pp.data,'$.en'))) as shape_en, group_concat(distinct json_unquote(json_extract(pp.data,'$.sc'))) as shape_sc, group_concat(distinct json_unquote(json_extract(pp.data,'$.tc'))) as shape_tc, o.volume_unit_box as volume_unit_box, o.volume_box_pack as volume_box_pack, o.volume_pack as volume_pack, s.inventory, s.property, s.id as sku_id, s.series_id as series_id , s.inventory_base_unit, o.price_details from product_profile p left join product_option o on p.id = o.product_id left join product_sku s ON o.sku_id = s.id left join product_property pp ON pp.mg_id = s.t_shape_id AND pp.type='shape' left join product_manufacturer m ON p.brand_id=m.id where find_in_set(2,p.chs_id) and find_in_set(2,o.chs_id) and p.id='7782' AND o.id NOT IN (9918,9920,9919,9927,9928,9929,9930,9931,9932,9933,9934,9935,9936,9937,9938,9939,9940,9941,9942,9943,9944,9945,9946,9947,9391,9392,9393,9744,9395,9396,9691,9692,9693,9694,9695,9697,9698,9699,9700,9701,9702,9703,9704,9705,9706,9707,9708,9709,9710,9711,9712,9713,9714,9715,9716,9717,9718,9719,9720,9721,9722,9723,9724,9725,9726,9727,9728,9730,9731,9732,9734,9735,9736,9737,9738,9739,9740,9741,9818,9773,9774,9775,9817,9819,9777,9872,9873,9874,9875,9877,9878,9879,9880,9883,9882,9881,9900,9901,9902,9903,9904,9905,9906,9907,9908,9909,9910,9911,9912,9913,9914,9924,9915,9916,9925,9917,9983,9982,9984,9965,9966,9967,9968,9969,9970,9971,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981,10025,10039,10038,10037,10036,10026,10035,10040,10041,10042,10027,10028,10029,10043,10030,10031,10044,10045,10032,10033,10046,10050,10034,10047,10048,10049,10086,10070,10087,10088,10071,10072,10073,10074,10075,10076,10089,10090,10077,10091,10078,10079,10080,10081,10092,10082,10083,10093,10084,10094,10123,10124,10125,10127,10128,10129,10130,10131,10132,10133,10134,10136,10135,10137,10138,10139,10140,10141,10142,10143,10144,10145,10146,10147,10148,10149,10150,10151,10152,10153,10175,10176,10177,10178,10179,10180,10181,10182) group by p.id