pods-framework / pods

                            if ( in_array( $type, PodsForm::file_field_types() ) || 'media' == $pick_object ) {

                                $where = "`guid` = '" . pods_sanitize( $pick_value ) . "'";

                                if ( 0 < pods_absint( $pick_value ) && false !== $numeric_mode )

                                    $where = "`ID` = " . pods_absint( $pick_value );

                                $result = pods_query( "SELECT `ID` AS `id` FROM `{$wpdb->posts}` WHERE `post_type` = 'attachment' AND {$where} ORDER BY `ID`", $this );

                                if ( in_array( 'taxonomy', array( $pick_object, $related_pod[ 'type' ] ) ) ) {

                                    $where = "`t`.`name` = '" . pods_sanitize( $pick_value ) . "'";

                                    if ( 0 < pods_absint( $pick_value ) && false !== $numeric_mode )

                                        $where = "`tt`.`term_id` = " . pods_absint( $pick_value );

                                    $result = pods_query( "SELECT `t`.`term_id` AS `id` FROM `{$wpdb->term_taxonomy}` AS `tt` LEFT JOIN `{$wpdb->terms}` AS `t` ON `t`.`term_id` = `tt`.`term_id` WHERE `taxonomy` = '{$pick_val}' AND {$where} ORDER BY `t`.`term_id` LIMIT 1", $this );

                                elseif ( in_array( 'post_type', array( $pick_object, $related_pod[ 'type' ] ) ) || in_array( 'media', array( $pick_object, $related_pod[ 'type' ] ) ) ) {

                                    $where = "`post_title` = '" . pods_sanitize( $pick_value ) . "'";

                                    if ( 0 < pods_absint( $pick_value ) && false !== $numeric_mode )

                                        $where = "`ID` = " . pods_absint( $pick_value );

                                    $result = pods_query( "SELECT `ID` AS `id` FROM `{$wpdb->posts}` WHERE `post_type` = '{$pick_val}' AND {$where} ORDER BY `ID` LIMIT 1", $this );

                                elseif ( in_array( 'user', array( $pick_object, $related_pod[ 'type' ] ) ) ) {

                                    $where = "`user_login` = '" . pods_sanitize( $pick_value ) . "'";

                                    if ( 0 < pods_absint( $pick_value ) && false !== $numeric_mode )

                                        $where = "`ID` = " . pods_absint( $pick_value );

                                    $result = pods_query( "SELECT `ID` AS `id` FROM `{$wpdb->users}` WHERE {$where} ORDER BY `ID` LIMIT 1", $this );