string(457) "SELECT m.active_substance_id AS value_id, m.image, md.title AS name FROM syn_active_substance m LEFT JOIN syn_active_substance_to_store m2s ON (m.active_substance_id = m2s.active_substance_id) LEFT JOIN syn_product p ON (m.active_substance_id = p.active_substance_id) LEFT JOIN syn_active_substance_description md ON (m.active_substance_id = md.active_substance_id) WHERE m2s.store_id = '0' GROUP BY m.active_substance_id ORDER BY m.sort_order ASC, name ASC"
