Massive Query

gistfile1.txt

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT(sv.value) FROM signal_processor_signal_values AS sv WHERE sv.item_id = si' at line 1: SELECT `signal_processor_items`.`id` AS t0_r0, `signal_processor_items`.`processor_id` AS t0_r1, `signal_processor_items`.`created_at` AS t0_r2, `signal_processor_items`.`updated_at` AS t0_r3, `signal_processor_items`.`default` AS t0_r4, `signal_processor_items`.`paused` AS t0_r5, `signal_processor_signal_values`.`id` AS t1_r0, `signal_processor_signal_values`.`signal_id` AS t1_r1, `signal_processor_signal_values`.`value` AS t1_r2, `signal_processor_signal_values`.`created_at` AS t1_r3, `signal_processor_signal_values`.`updated_at` AS t1_r4, `signal_processor_signal_values`.`lat` AS t1_r5, `signal_processor_signal_values`.`lng` AS t1_r6, `signal_processor_signal_values`.`begin_at` AS t1_r7, `signal_processor_signal_values`.`end_at` AS t1_r8, `signal_processor_signal_values`.`activity_id` AS t1_r9, `signal_processor_signal_values`.`original_address` AS t1_r10, `signal_processor_signal_values`.`geocoded_address` AS t1_r11, `signal_processor_signal_values`.`item_id` AS t1_r12, `signal_processor_signal_values`.`ad_activity` AS t1_r13, `signal_processor_signal_values`.`gender` AS t1_r14, `signal_processor_signal_values`.`min_age` AS t1_r15, `signal_processor_signal_values`.`max_age` AS t1_r16, `signal_processor_signal_values`.`behavior_group` AS t1_r17, `signal_processor_signal_values`.`location_details` AS t1_r18, `signal_processor_signals`.`id` AS t2_r0, `signal_processor_signals`.`processor_id` AS t2_r1, `signal_processor_signals`.`name` AS t2_r2, `signal_processor_signals`.`created_at` AS t2_r3, `signal_processor_signals`.`updated_at` AS t2_r4, `signal_processor_signals`.`type` AS t2_r5, `signal_processor_signals`.`max_distance` AS t2_r6, `signal_processor_signals`.`priority` AS t2_r7, `signal_processor_signals`.`settings` AS t2_r8, `signal_values_signal_processor_items`.`id` AS t3_r0, `signal_values_signal_processor_items`.`signal_id` AS t3_r1, `signal_values_signal_processor_items`.`value` AS t3_r2, `signal_values_signal_processor_items`.`created_at` AS t3_r3, `signal_values_signal_processor_items`.`updated_at` AS t3_r4, `signal_values_signal_processor_items`.`lat` AS t3_r5, `signal_values_signal_processor_items`.`lng` AS t3_r6, `signal_values_signal_processor_items`.`begin_at` AS t3_r7, `signal_values_signal_processor_items`.`end_at` AS t3_r8, `signal_values_signal_processor_items`.`activity_id` AS t3_r9, `signal_values_signal_processor_items`.`original_address` AS t3_r10, `signal_values_signal_processor_items`.`geocoded_address` AS t3_r11, `signal_values_signal_processor_items`.`item_id` AS t3_r12, `signal_values_signal_processor_items`.`ad_activity` AS t3_r13, `signal_values_signal_processor_items`.`gender` AS t3_r14, `signal_values_signal_processor_items`.`min_age` AS t3_r15, `signal_values_signal_processor_items`.`max_age` AS t3_r16, `signal_values_signal_processor_items`.`behavior_group` AS t3_r17, `signal_values_signal_processor_items`.`location_details` AS t3_r18, `signals_signal_processor_signal_values`.`id` AS t4_r0, `signals_signal_processor_signal_values`.`processor_id` AS t4_r1, `signals_signal_processor_signal_values`.`name` AS t4_r2, `signals_signal_processor_signal_values`.`created_at` AS t4_r3, `signals_signal_processor_signal_values`.`updated_at` AS t4_r4, `signals_signal_processor_signal_values`.`type` AS t4_r5, `signals_signal_processor_signal_values`.`max_distance` AS t4_r6, `signals_signal_processor_signal_values`.`priority` AS t4_r7, `signals_signal_processor_signal_values`.`settings` AS t4_r8, `signal_processor_property_values`.`id` AS t5_r0, `signal_processor_property_values`.`item_id` AS t5_r1, `signal_processor_property_values`.`property_id` AS t5_r2, `signal_processor_property_values`.`value` AS t5_r3, `signal_processor_property_values`.`created_at` AS t5_r4, `signal_processor_property_values`.`updated_at` AS t5_r5, `signal_processor_properties`.`id` AS t6_r0, `signal_processor_properties`.`processor_id` AS t6_r1, `signal_processor_properties`.`name` AS t6_r2, `signal_processor_properties`.`default_value` AS t6_r3, `signal_processor_properties`.`created_at` AS t6_r4, `signal_processor_properties`.`updated_at` AS t6_r5, `signal_processor_properties`.`data_type` AS t6_r6, `signal_processor_properties`.`width` AS t6_r7, `signal_processor_properties`.`height` AS t6_r8, `signal_processor_properties`.`position` AS t6_r9, `signal_processor_properties`.`click_tag_number` AS t6_r10, `signal_processor_properties`.`crop_mode` AS t6_r11 FROM `signal_processor_items` LEFT OUTER JOIN `signal_processor_signal_values` ON `signal_processor_signal_values`.`item_id` = `signal_processor_items`.`id` LEFT OUTER JOIN `signal_processor_signals` ON `signal_processor_signals`.`id` = `signal_processor_signal_values`.`signal_id` LEFT OUTER JOIN `signal_processor_item_signal_values` ON `signal_processor_item_signal_values`.`item_id` = `signal_processor_items`.`id` LEFT OUTER JOIN `signal_processor_signal_values` `signal_values_signal_processor_items` ON `signal_values_signal_processor_items`.`id` = `signal_processor_item_signal_values`.`signal_value_id` LEFT OUTER JOIN `signal_processor_signals` `signals_signal_processor_signal_values` ON `signals_signal_processor_signal_values`.`id` = `signal_values_signal_processor_items`.`signal_id` LEFT OUTER JOIN `signal_processor_property_values` ON `signal_processor_property_values`.`item_id` = `signal_processor_items`.`id` LEFT OUTER JOIN `signal_processor_properties` ON `signal_processor_properties`.`id` = `signal_processor_property_values`.`property_id` WHERE (signal_processor_items.processor_id = 340) AND (signal_processor_signals.processor_id = 340 OR signal_processor_signals.processor_id IS NULL) AND (signal_processor_signal_values.begin_at > '2014-01-08 23:59:59' AND signal_processor_items.paused = false) ORDER BY SELECT(sv.value) FROM signal_processor_signal_values AS sv WHERE sv.item_id = signal_processor_item.id ORDER BY value LIMIT 1: