id_type, id_brand) SELECT p2ai.id_article, p2a.id_type, p2a.id_brand FROM {$table_info} AS p2ai INNER JOIN price2_wh AS p2w ON (p2ai.id_wh=p2w.id_wh AND p2ai.is_availability = 1) INNER JOIN price2_article AS p2a ON (p2a.id_article=p2ai.id_article) WHERE $condition_field IN (" . join(', ', $whs) . ") AND p2w.internal = 1 $condition_field_ex GROUP BY p2ai.id_article; SELECT /*{$comment}*/ tarticles.*,price2_article.id_article,price2_article.id_brand,price2_article.id_group, price2_article.active,price2_article.id_type,{$table_info}.id_wh,{$table_info}.price_buy, {$table_info}.price_base,{$table_info}.price_diff,{$table_info}.avg_price,{$table_info}.price_seb, {$table_info}.currency,{$table_info}.availability,{$table_info}.id_action,price2_wh.currate_eur, price2_wh.currate_usd,price2_wh.currate_krw, price2_wh.nacenka_price_seb,price2_wh.adr, price2_wh.id_ws,price2_wh.id_type AS wh_id_type, price2_wh.smart_punkt,price2_wh.max_client_skidka, price2_article_shina.id_article as tyres_label, price2_article_wheels.id_article as whls_label, price2_article_moreinfo.price_not_up, price2_article_moreinfo.RRP_price, price2_article_moreinfo.RRP_currency, price_group_art2.no_rrp, price_group_art2.no_rrp_adr,price_group_art2.is_seb_algorithm_json, price_group_art2.koef_seb_json,price_group_art2.pricebase_basis, ac.su_exist ac_su_exist,ac.mc_exist ac_mc_exist, ac.su_id_price ac_su_id_price,ac.su_id_curprice ac_su_id_curprice, ac.su_price ac_su_price,ac.su_date1 ac_su_date1, ac.su_date2 ac_su_date2,ac.mc_id_price ac_mc_id_price, ac.mc_id_curprice ac_mc_id_curprice,ac.mc_price ac_mc_price, ac.mc_date1 ac_mc_date1, ac.mc_date2 ac_mc_date2, agc.su_exist agc_su_exist, agc.mc_exist agc_mc_exist, agc.su_id_price agc_su_id_price, agc.su_id_curprice agc_su_id_curprice, agc.su_price agc_su_price, agc.su_date1 agc_su_date1, agc.su_date2 agc_su_date2, agc.mc_id_price agc_mc_id_price, agc.mc_id_curprice agc_mc_id_curprice, agc.mc_price agc_mc_price, agc.mc_date1 agc_mc_date1, agc.mc_date2 agc_mc_date2, ga2c.su_exist ga2c_su_exist, ga2c.mc_exist ga2c_mc_exist, ga2c.su_id_price ga2c_su_id_price, ga2c.su_id_curprice ga2c_su_id_curprice, SQL: